Banner EDW Source: APRADEG

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
APRADEG_ACYR_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEG_YEAR DEGREE DEGREE_SLOT DEGREE_SLOT DEGREE_SLOT	ADVANCEMENT_DEG_YEAR ACADEMIC_YEAR ACADEMIC_YEAR_1 ACADEMIC_YEAR_3 ACADEMIC_YEAR_2	ADVANCEMENT DEGREE NA NA NA NA	NO NO NO NO NO
APRADEG_ACYR_CODE_BULLETIN	NO	REPORTING VIEW	DEGREE	BULLETIN_YEAR	NA	NO
APRADEG_CAMP_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEGREE DEGREE	DEGREE_CAMPUS CAMPUS	ADVANCEMENT DEGREE NA	NO NO
APRADEG_COLL_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEGREE DEGREE_SLOT DEGREE_SLOT DEGREE DEGREE_SLOT	DEGREE_COLLEGE COLLEGE_1 COLLEGE_3 COLLEGE COLLEGE_2	ADVANCEMENT DEGREE NA NA NA NA	NO NO NO NO NO
APRADEG_COMMENTS	NO	DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEG_COMMENTS COMBINED_ACADEMIC_OUTCOME DEGREE	DEGREE_COMMENT DEGREE_COMMENT DEGREE_COMMENT	ADVANCEMENT DEGREE NA NA	NO NO NO
APRADEG_DATE	NO	FACT TABLE REPORTING VIEW	WFT_ADVANCEMENT_DEGREE DEGREE_SLOT DEGREE_SLOT DEGREE_SLOT	DEGREE_DATE DEGREE_DATE_2 DEGREE_DATE_3 DEGREE_DATE_1	ADVANCEMENT DEGREE NA NA NA	NO NO NO NO
APRADEG_DEGC_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEGREE DEGREE_SLOT DEGREE_SLOT DEGREE_SLOT	DEGREE DEGREE_1 DEGREE_3 DEGREE_2	ADVANCEMENT DEGREE NA NA NA	NO NO NO NO
APRADEG_DEPT_CODE	NO	REPORTING VIEW	DEGREE	DEPARTMENT1	NA	NO
APRADEG_DEPT_CODE_2	NO	REPORTING VIEW	DEGREE	DEPARTMENT2	NA	NO
APRADEG_HOND_CODE_1	NO	REPORTING VIEW	DEGREE	DEPARTMENT_HONOR1	NA	NO
APRADEG_HOND_CODE_2	NO	REPORTING VIEW	DEGREE	DEPARTMENT_HONOR2	NA	NO
APRADEG_HOND_CODE_3	NO	REPORTING VIEW	DEGREE	DEPARTMENT_HONOR3	NA	NO
APRADEG_HOND_CODE_4	NO	REPORTING VIEW	DEGREE	DEPARTMENT_HONOR4	NA	NO
APRADEG_HOND_CODE_5	NO	REPORTING VIEW	DEGREE	DEPARTMENT_HONOR5	NA	NO
APRADEG_HONR_CODE	NO	REPORTING VIEW	DEGREE_SLOT DEGREE_SLOT DEGREE DEGREE_SLOT	HONOR1_1 HONOR1_2 HONOR1 HONOR1_3	NA NA NA NA	NO NO NO NO
APRADEG_HONR_CODE_2	NO	REPORTING VIEW	DEGREE	HONOR2	NA	NO
APRADEG_HONR_CODE_3	NO	REPORTING VIEW	DEGREE	HONOR3	NA	NO
APRADEG_HONR_CODE_4	NO	REPORTING VIEW	DEGREE	HONOR4	NA	NO
APRADEG_HONR_CODE_5	NO	REPORTING VIEW	DEGREE	HONOR5	NA	NO
APRADEG_MAJR_CODE_CONC_1	NO	REPORTING VIEW	DEGREE	FIRST_CONCENTRATION	NA	NO
APRADEG_MAJR_CODE_CONC_2	NO	REPORTING VIEW	DEGREE	SECOND_CONCENTRATION	NA	NO
APRADEG_MAJR_CODE_CONC_3	NO	REPORTING VIEW	DEGREE	THIRD_CONCENTRATION	NA	NO
APRADEG_MAJR_CODE_CONC_4	NO	REPORTING VIEW	DEGREE	SECOND_MAJOR_CONC_1	NA	NO
APRADEG_MAJR_CODE_CONC_5	NO	REPORTING VIEW	DEGREE	SECOND_MAJOR_CONC_2	NA	NO
APRADEG_MAJR_CODE_CONC_6	NO	REPORTING VIEW	DEGREE	SECOND_MAJOR_CONC_3	NA	NO
APRADEG_MAJR_CODE_MINR_1	NO	DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_DEG_MINR DEGREE	ADVANCEMENT_DEG_MINR FIRST_MINOR	ADVANCEMENT DEG MINR NA	NO NO
APRADEG_MAJR_CODE_MINR_2	NO	REPORTING VIEW	DEGREE	SECOND_MINOR	NA	NO
APRADEG_PIDM	NO	REPORTING VIEW	DEGREE DEGREE_SLOT	PERSON_UID PERSON_UID	NA NA	NO NO
APRADEG_SBGI_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_ADVANCEMENT_INSTITUTION DEGREE_SLOT DEGREE_SLOT DEGREE DEGREE_SLOT	ADVANCEMENT_INSTITUTION INSTITUTION_2 INSTITUTION_3 INSTITUTION INSTITUTION_1	ADVANCEMENT DEGREE NA NA NA NA	NO NO NO NO NO
APRADEG_SEQ_NO	NO	FACT TABLE REPORTING VIEW	WFT_ADVANCEMENT_DEGREE DEGREE	DEGREE_SEQEUENCE_NUMBER DEGREE_NUMBER	ADVANCEMENT DEGREE NA	NO NO

Ver: 9.0