Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AG_DIRECT_DEPOSIT_KSU

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_TYPE   VARCHAR2(1)    
ACTIVITY_DATE   DATE    
ADDRESS_SEQUENCE_NUMBER   NUMBER(2)    
ADRESS_TYPE_CODE   VARCHAR2(2)    
AMOUNT   NUMBER(11, 2)    
AP_INDICATOR   VARCHAR2(1)    
BANK_ACCOUNT_NUMBER   VARCHAR2(17)    
BANK_ROUTING_NUMBER   VARCHAR2(9)    
DIRECT_DEPOSIT_PERCENT   NUMBER(5, 2)    
DOCUMENT_TYPE   VARCHAR2(1)    
HR_INDICATOR   VARCHAR2(1)    
LOAD_DATE   DATE    
PERSON_UID   NUMBER(8)    
PRIORITY   NUMBER(2)    
STATUS   VARCHAR2(1)    
USER_ID   VARCHAR2(30)    


Ver: