Banner EDW Source: SGRVETN

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
SGRVETN_CERT_DATE	NO	REPORTING VIEW	VETERAN_CERTIFICATION	VETERAN_CERT_ACTIVITY_DATE	NA	NO
SGRVETN_CERT_HOURS	NO	REPORTING VIEW	VETERAN_CERTIFICATION STUDENT_EXTENDED	VETERAN_CERTIFICATION_DATE VETERAN_CERTIFICATION_CREDITS	NA NA	NO NO
SGRVETN_PIDM	NO	REPORTING VIEW	VETERAN_CERTIFICATION	PERSON_UID	NA	NO
SGRVETN_TERM_CODE_VA	NO	REPORTING VIEW	VETERAN_CERTIFICATION	ACADEMIC_PERIOD	NA	NO
SGRVETN_VETC_CODE	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_DEMOGRAPHIC VETERAN_CERTIFICATION STUDENT_EXTENDED VETERAN_CERTIFICATION STUDENT STUDENT WDT_DEMOGRAPHIC VETERAN_CERTIFICATION STUDENT_EXTENDED VETERAN_CERTIFICATION STUDENT STUDENT	VETERAN_TYPE VETERAN_TYPE VETERAN_TYPE VETERAN_CERTIFICATION_CREDITS VETERAN_TYPE VETERAN_CERTIFICATION_CREDITS VETERAN_TYPE VETERAN_TYPE VETERAN_TYPE VETERAN_CERTIFICATION_CREDITS VETERAN_TYPE VETERAN_CERTIFICATION_CREDITS	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO
SGRVETN_VETC_DATE	NO	REPORTING VIEW	STUDENT STUDENT_EXTENDED	VETERAN_CERTIFICATION_DATE VETERAN_CERTIFICATION_DATE	NA NA	NO NO

Ver: 9.0