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

SGHE Banner Operational Data Store
Composite View Target: AP_BENEFICIARY_DEPENDENT_KSU

Target Column Business Definition Database Data Type Source Name Source Column
BENEFIT_GROUP   VARCHAR2(0)    
BENFICIARY_UID   NUMBER(8)    
BIRTH_DATE   DATE    
CARRIER   VARCHAR2(3)    
CARRIER_LONG_DESC   VARCHAR2(30)    
CARRIER_SHORT_DESC   VARCHAR2(30)    
COVERAGE_BEGIN_DATE   DATE    
COVERAGE_END_DATE   DATE    
COVERAGE_OPTION   VARCHAR2(0)    
COVERAGE_OPTION_DESC   VARCHAR2(0)    
DOMAIN_VALUE   VARCHAR2(6)    
FIRST_NAME   VARCHAR2(15)    
GENDER   VARCHAR2(1)    
LAST_NAME   VARCHAR2(30)    
LOAD_DATE   DATE    
MIDDLE_INITIAL   VARCHAR2(15)    
MIF_DESC   VARCHAR2(30)    
MIF_VALUE   VARCHAR2(6)    
OTHER_COVERAGE_IND   VARCHAR2(1)    
PERSON_UID   NUMBER(8)    
RELATIONSHIP   VARCHAR2(1)    
RELATIONSHIP_DESC   VARCHAR2(30)    
SEQUENCE_NUMBER   NUMBER(2)    
TAX_ID   VARCHAR2(9)    
ZONE_VALUE   VARCHAR2(6)    


Ver: