SGHE Enterprise Data Warehouse
Banner EDW Source: WDT_WAREHOUSE_ENTITY - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| WAREHOUSE_ENTITY_UID |
NO |
FACT TABLE |
WFT_ADVANCEMENT_ACTIVITY WFT_PROSPECT |
ENTITY_UID PROSPECT_COUNT |
ADVANCEMENT ACTIVITY PROSPECT |
NO NO |
| WAREHOUSE_ENTITY_UID- EDW_ADV_GIFT_EXTR.F_GET_ADVANCEMENT_GIFT : IF MAT_CONSTITUENT_ENTITY FOR THE CALENDAR YEAR AND PRIMARY_DONOR_CATEGORY = MTVPARM EXTRACT PARAMETER [ALUMNI_IND] |
NO |
FACT TABLE |
WFT_ADVANCEMENT_GIFT |
ALUMNI_HEADCOUNT |
ADVANCEMENT GIFT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMIS SION:IF NVL( MST_ADMISSIONS_APPLICATION') = 'Y' THEN APPLICANT_HEADCOUNT := WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UI D |
NO |
FACT TABLE |
WFT_RECRUITING_AND_ADMISSION |
APPLICANT_HEADCOUNT |
RECRUITING AND ADMISSION |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE AND EMPLOYEE CLASS = MTVPARM EXTRACT PARAMETER [STUDENT_EMPLOYEE_IND] |
NO |
FACT TABLE |
WFT_EMPLOYEE |
STUDENT_EMPLOYEE_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE AND EMPLOYEE CLASS IS EQUAL TO THE MTVPARM EXTRACT PARAMETER [ADJUNCT_FACULTY_IND] |
NO |
FACT TABLE |
WFT_EMPLOYEE |
ADJUNCT_FACULTY_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE EXISTS AND EMPLOYEE_STATUS = 'A'. |
NO |
FACT TABLE |
WFT_EMPLOYEE |
EMPLOYEE_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE WHERE THE FULL_OR_PART_TIME_IND = 'F' AND EMPLOYEE_STATUS = 'A' |
NO |
FACT TABLE |
WFT_EMPLOYEE |
FULL_TIME_EMPLOYEE_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE WHERE THE FULL_OR_PART_TIME_IND = 'P' AND EMPLOYEE_STATUS = 'A' |
NO |
FACT TABLE |
WFT_EMPLOYEE |
PART_TIME_EMPLOYEE_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MST_FACULTY EXISTS |
NO |
FACT TABLE |
WFT_EMPLOYEE |
FACULTY_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MST_FACULTY EXISTS AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'F" AND JOIN ON PERSON_UID |
NO |
FACT TABLE |
WFT_EMPLOYEE |
FULL_TIME_FACULTY_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MST_FACULTY EXISTS AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'P" AND JOIN ON PERSON_UID |
NO |
FACT TABLE |
WFT_EMPLOYEE |
PART_TIME_FACULTY_HEADCOUNT |
EMPLOYEE |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT EXISTS AND CURRENT_TIME_STATUS = MTVPARM EXTRACT PARAMETER [FULL_TIME_COURSE] |
NO |
FACT TABLE |
WFT_ENROLLMENT |
FULL_TIME_ENROLLED_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND NO MTVPARM EXTRACT PARAMETER ['EXCLUSION_STATUS_CODE'] FOR YEAR2, ACADEMIC_PERIOD+ 100 |
NO |
FACT TABLE |
WFT_ENROLLMENT |
YEAR2_RETAINED_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND NO MTVPARM EXTRACT PARAMETER ['EXCLUSION_STATUS_CODE'] FOR YEAR3, ACADEMIC_PERIOD+ 200 |
NO |
FACT TABLE |
WFT_ENROLLMENT |
YEAR3_RETAINED_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND NO MTVPARM EXTRACT PARAMETER ['EXCLUSION_STATUS_CODE'] FOR YEAR4, ACADEMIC_PERIOD+ 300 |
NO |
FACT TABLE |
WFT_ENROLLMENT |
YEAR4_RETAINED_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT JOIN PERSON_UID AND ACADEMIC_PERIOD MST_GENERAL_STUDENT WHEN PRIMARY_PROGRAM_IND = 'Y' AND REGISTERED_IND = 'Y' |
NO |
FACT TABLE |
WFT_ENROLLMENT |
OVERALL_RET_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT.ENROLLED_IND EXISTS |
NO |
FACT TABLE |
WFT_ENROLLMENT |
ENROLLED_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_GENERAL_STUDENT AND MST_ENROLLMENT EXIST AND JOIN PERSON_UID AND ACADEMIC_PERIOD AND DEGREE = MTVPARM EXTRACT PARAMETER [NON_DEGREE_ATTRIBUTE] |
NO |
FACT TABLE |
WFT_ENROLLMENT |
NON_DEGREE_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_GENERAL_STUDENT AND MST_ENROLLMENT EXIST JOIN PERSON_UID AND ACADEMIC_PERIOD AND MAJOR = MTVPARM EXTRACT PARAMETER [STEM_PROGRAM_ATTRIBUTE] |
NO |
FACT TABLE |
WFT_ENROLLMENT |
STEM_PROGRAM_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_STUDENT_COURSE_ATTRIBUTE AND MST_ENROLLMENT JOIN ON PERSON_UID AND ACADEMIC_PERIOD EXISTS AND COURSE_ATTRIBUTE = MTVPARM EXTRACT PARAMETER [DEV_COURSE_ATTRIBUTE] |
NO |
FACT TABLE |
WFT_ENROLLMENT |
DEVELOPMENTAL_COURSE_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_FA_PSTU_EXTR.F_GET_FA_PRE_STUDENT: IF MRT_FINAID_APPLICANT_STATUS EXISTS AND FINANCIAL_AID_APPLICATION_IND = 'Y' |
NO |
FACT TABLE |
WFT_ENROLLMENT |
FINAID_APPLICANT_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_FA_PSTU_EXTR.F_GET_FA_PRE_STUDENT:IF MRT_AWARD_BY_PERSON AND AWARD_OFFER_AMOUNT > 0 |
NO |
FACT TABLE |
WFT_ENROLLMENT |
FINAID_OFFER_HEADCOUNT |
ENROLLMENT |
NO |
| WAREHOUSE_ENTITY_UID- EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMIS SION:IF [NVL( MST_ADMISSIONS_APPLICATION.APPL_ACCEPT_A NY_TIME_IND,'N')] = 'Y' THEN ACCEPTED_HEADCOUNT = WAREHOUSE_ENTITY_UID |
NO |
FACT TABLE |
WFT_RECRUITING_AND_ADMISSION |
ACCEPTED_HEADCOUNT |
RECRUITING AND ADMISSION |
NO |
| WAREHOUSE_ENTITY_UID- EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMIS SION:IF [NVL( MST_ADMISSIONS_APPLICATION.INQUIRER_IND) ] = 'Y' THEN INQUIRED_HEADCOUNT = WAREHOUSE_ENTITY_UID |
NO |
FACT TABLE |
WFT_RECRUITING_AND_ADMISSION |
INQUIRED_HEADCOUNT |
RECRUITING AND ADMISSION |
NO |
| WAREHOUSE_ENTITY_UID- EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMIS SION:IF [NVL( MST_ADMISSIONS_APPLICATION.INST_ADMIT_AN Y_TIME_IND,'N')] = 'Y' THEN ADMITTED_HEADCOUNT = WAREHOUSE_ENTITY_UID |
NO |
FACT TABLE |
WFT_RECRUITING_AND_ADMISSION |
ADMITTED_HEADCOUNT |
RECRUITING AND ADMISSION |
NO |
| WAREHOUSE_ENTITY_UID- EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMIS SION:IF [NVL( MST_ENROLLMENT.ENROLLED_IND,'N')] = 'Y' THEN ENROLLED_HEADCOUNT = WAREHOUSE_ENTITY_UID |
NO |
FACT TABLE |
WFT_RECRUITING_AND_ADMISSION |
ENROLLED_HEADCOUNT |
RECRUITING AND ADMISSION |
NO |