Go To View:  -- Select a View -- AA_ADVANCEMENT_RATING AA_ANNUAL_GIVING AA_CAMPAIGN AA_CAMPAIGN_COMMENT AA_CAMPAIGN_DESIGNATION AA_CAMPAIGN_EXPENSE AA_CAMPAIGN_FUNDRAISER AA_CAMPAIGN_GIVING_HISTORY AA_CAMPAIGN_MAIL AA_CAMPAIGN_SOLICITATION AA_CONSTITUENT AA_CONSTITUENT_CONTACT AA_CONSTITUENT_PLAN AA_CONSTITUENT_STAFF_ASSIGN AA_CON_CONF_COMMENT_SUBJ AA_CON_ENTITY_CONF_COMMENT AA_DEGREE AA_DESIGNATION AA_DESIGNATION_ADJUSTMENT AA_DESIGNATION_ATTRIBUTE AA_DESIGNATION_CLASS_YEAR AA_DESIGNATION_COMMENT AA_DESIGNATION_COMMENT_SUBJ AA_DESIGNATION_FINAID_FUND AA_DESIGNATION_GIVING_HISTORY AA_DESIGNATION_ID AA_DONOR_CATEGORY AA_EXCLUSION AA_FUNDING_INTEREST AA_GIFT AA_GIFT_ASSOCIATED_ENTITY AA_GIFT_AUXILIARY AA_GIFT_MATCHING AA_GIFT_MEMO AA_GIFT_MULTIPLE AA_GIFT_SOCIETY AA_INTEREST AA_MAIL AA_MEMBERSHIP AA_MEMBERSHIP_DUES AA_MEMBERSHIP_INTEREST AA_ORGANIZATIONAL_CONSTITUENT AA_ORGANIZATION_CONTACT AA_ORGANIZATION_FUNDING_AREA AA_PLEDGE AA_PLEDGE_ASSOCIATED_ENTITY AA_PLEDGE_AUXILIARY AA_PLEDGE_CONDITIONAL AA_PLEDGE_INSTALLMENT AA_PLEDGE_MATCHING AA_PREVIOUS_EMPLOYMENT AA_PROJECT_INTEREST AA_PROSPECT_CONF_COMMENT AA_PROSPECT_CONF_COMMENT_SUBJ AA_PROSPECT_CONTACT_EXPENSE AA_PROSPECT_INFO AA_PROSPECT_MOVES_MANAGEMENT AA_PROSPECT_PROPOSAL AA_PROSPECT_PROPOSAL_MASTER AA_PROSPECT_PROPOSAL_PROJECT AA_PROSPECT_PROPOSAL_RESULT AA_PROSPECT_STAFF_ASSIGNMENT AA_RELATIONSHIP AA_SALUTATION AA_SOLICITOR AA_SOLICITOR_ASSIGNMENT AA_SOLICITOR_ASSIGNMENT_RESULT AA_SOLICITOR_ORGANIZATION AA_SOLICITOR_ORG_COMMENT AA_SOLICITOR_ORG_FUNDRAISER AA_SOL_ORG_FUNDRAISER_GOAL AA_SOL_ORG_GOAL AA_SPECIAL_ACTIVITY AA_SPECIAL_ACTIVITY_YEAR AA_SPECIAL_PURPOSE_GROUP AA_VALIDATION AA_YEAR_TYPE_DEFINITION AE_ACCOUNTING AE_APPROVAL_HISTORY AE_AUTHORIZATION AE_CIRC_HEADER_STEP AE_CIRC_RECIP_NOTIF AE_DELEGATE_ASSIGNMENT AE_EXPENSE_ITEM AE_EXPENSE_ITEM_TAX AE_ITINERARY AE_PORTFOLIO AE_PROFILE AE_REIMBURSEMENT AE_STATUS_HISTORY AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_INDEX AF_ACCOUNT_TYPE_ATTRIBUTES_ODS AF_ACTIVITY_ATTRIBUTES_ODS AF_ATTRIBUTE_SETS_ODS AF_BUDGET_AVAILABILITY_LEDGER AF_BUDGET_DETAIL AF_CHART_ATTRIBUTES_ODS AF_CHECKS AF_CLAUSE AF_ENCUMBRANCE AF_ENCUMBRANCE_ACCOUNTING AF_ENCUMBRANCE_LEDGER AF_ENDOWMENT AF_ENDOWMENT_ATTRIBUTES AF_ENDOWMENT_DIST AF_ENDOWMENT_MARKET_VALUES AF_ENDOWMENT_UNITS AF_FISCAL_PERIOD AF_FIXED_ASSET_ADJUSTMENT AF_FIXED_ASSET_ATTRIBUTES AF_FIXED_ASSET_DEPRECIATION AF_FIXED_ASSET_FUNDING_SOURCE AF_FIXED_ASSET_ITEM AF_FUND_ATTRIBUTES_ODS AF_FUND_HIERARCHY AF_FUND_HIERARCHY_FISCAL AF_FUND_TYPE_ATTRIBUTES_ODS AF_GENERAL_LEDGER AF_GRANT AF_GRANT_ATTRIBUTES_ODS AF_GRANT_BILLING_DETAIL AF_GRANT_DEFERRED_COST AF_GRANT_EVENT AF_GRANT_EVENT_STATUS AF_GRANT_FUND AF_GRANT_LEDGER AF_GRANT_PERSONNEL AF_INVOICE AF_INVOICE_ACCOUNTING AF_INVOICE_CHECK AF_INVOICE_ITEM AF_INVOICE_TAX_RATE AF_LOCATION_ATTRIBUTES_ODS AF_LOCATION_HIERARCHY AF_LOCATION_HIERARCHY_FISCAL AF_OPERATING_LEDGER AF_ORGANIZATION_ATTRIBUTES_ODS AF_ORGANIZATION_HIERARCHY AF_ORGN_HIERARCHY_FISCAL AF_PROGRAM_ATTRIBUTES_ODS AF_PROGRAM_HIERARCHY AF_PROGRAM_HIERARCHY_FISCAL AF_PROPOSAL AF_PURCHASE_ORDER AF_PURCHASE_ORDER_ACCOUNTING AF_PURCHASE_ORDER_ITEM AF_PURCHASE_ORDER_TAX_RATE AF_RECEIVED_ITEM AF_RETURNED_ITEM AF_TEXT AF_TRANSACTION_HISTORY AF_VALIDATION AF_VENDOR AF_VENDOR_TAXABLE_REPORTING AG_ALTERNATIVE_ID AG_COMMUNICATION AG_EVENT AG_EVENT_INVITEE AG_GEOGRAPHIC_REGION AG_GEOGRAPHIC_REGION_INST AG_INTERNET_ADDRESS AG_SDE_DATA AG_VALIDATION AN_EMPLOYEE_POSITION AN_FISCAL_YEAR AN_FMLA_LEAVE_COMMENT AN_JOB_FTE_TRACKING AN_LABOR_COST_DISTRIBUTION AN_PAYROLL_DISTRIBUTION AN_PERSONNEL_ACTION AN_PERSONNEL_ACTION_COMMENT AN_PERSONNEL_ACTION_EARNING AN_PERSONNEL_ACTION_GENERAL AN_PERSONNEL_ACTION_LABOR_DIST AN_POSITION_BUDGET AN_POSITION_DEFINITION AN_POSITION_LABOR_DISTRIBUTION AN_SALARY_RATE AN_SUPERVISOR AN_VALIDATION AP_BARGAINING_UNIT AP_BENEFICIARY_DEPENDENT AP_BENEFIT_DEDUCTION AP_CERTIFICATION AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE AP_EMPLOYEE_EARNING_CY AP_EMPLOYEE_EARNING_FY AP_FACULTY_APPOINTMENT_HISTORY AP_FACULTY_RANK_HISTORY AP_FACULTY_SABBATICAL_HISTORY AP_FAMILY_MEDICAL_LEAVE_HIST AP_HR_APPLICATION AP_HR_APPLICATION_STATUS AP_HR_REQUISITION AP_INTERVIEW AP_LEAVE_ACCRUAL AP_LEAVE_BALANCE AP_MONTHLY_DEDUCTION AP_PAST_EMPLOYMENT AP_PAYROLL_ATTENDANCE AP_PAYROLL_DEDUCTION AP_PAYROLL_DOCUMENT AP_PAYROLL_EARNING AP_PAYROLL_EMPLOYEE_POSITION AP_PAYROLL_LABOR_DIST_OVERRIDE AP_PAYROLL_TIMESHEET AP_REFERENCE AP_REVIEW AP_SKILL AP_TAX AP_VALIDATION AP_YEARLY_DEDUCTION AR_APPLICANT_NEED AR_APPLICANT_RESOURCE AR_AWARD_BY_AID_YEAR AR_AWARD_BY_FUND AR_AWARD_BY_PERSON AR_AWARD_DISBURSEMENT AR_FINAID_APPLICANT_STATUS AR_FINAID_APPLICATION1 AR_FINAID_APPLICATION2 AR_FINAID_APPLICATION3 AR_FINAID_APPLICATION4 AR_FINAID_BUDGET_COMPONENT AR_FINAID_COMMENTS AR_FINAID_ENROLLMENT AR_FINAID_FUND AR_FINAID_HOLD AR_FINAID_MESSAGE AR_FINAID_TRACKING_REQUIREMENT AR_FUND_MESSAGE_RULE AR_LOAN_AGGREGATES AR_LOAN_APPLICATION AR_LOAN_DISBURSEMENT AR_NEED_ANALYSIS_ISIR_SPEC AR_NEED_ANALYSIS_OVERRIDE AR_NEED_ANALYSIS_PROFILE_SPEC AR_SATISFACTORY_ACAD_PROGRESS AR_STUDENT_PERIOD_DEFINITION AR_USER_DEFINED_FIELDS AR_VALIDATION AR_YEAR_TYPE_DEFINITION AS_ACADEMIC_HISTORY_EVENT AS_ACADEMIC_OUTCOME AS_ACADEMIC_STANDING AS_ACTIVE_TERMS AS_ADDRESS AS_ADMINISTRATOR AS_ADMISSIONS_APPLICATION AS_ADMISSIONS_ATTRIBUTE AS_ADMISSIONS_COHORT AS_ADMISSIONS_DECISION AS_ADMISSIONS_RATING AS_ADMISSIONS_REQUIREMENT AS_ADMISSIONS_SOURCE AS_ADVISOR AS_CONTACT AS_COURSE_ATTRIBUTE AS_COURSE_CATALOG AS_COURSE_COREQ AS_COURSE_LEVEL AS_COURSE_OFFERING AS_COURSE_OFFERING_FEES AS_COURSE_PREREQ AS_COURSE_SCHEDULE AS_COURSE_SUPPLEMENTAL AS_CURRICULUM AS_CURRICULUM_FOS AS_DISABILITY_INFORMATION AS_ENROLLMENT AS_ENROLLMENT_HISTORY AS_ENROLLMENT_WITHDRAWAL AS_FACULTY AS_FACULTY_ATTRIBUTE AS_FACULTY_CONTRACT AS_FACULTY_DEPARTMENT_COLLEGE AS_FACULTY_FEEDBACK AS_FACULTY_FEEDBACK_DETAIL AS_FIELD_OF_STUDY AS_GENERAL_STUDENT AS_GENSTU_END_TERM AS_GPA_LEVEL AS_GPA_TERM AS_HOLD AS_INSTITUTION AS_INSTITUTION_CHARACTERISTIC AS_INSTITUTION_DEMOGRAPHIC AS_INSTRUCTIONAL_ASSIGNMENT AS_INTEREST AS_LEARNER_CURRICULUM_FOS AS_MEAL_ASSIGNMENT AS_MEDICAL_INFORMATION AS_MEETING_TIME AS_NONINSTRUCTIONAL_ASSIGNMENT AS_OFFERING_COREQ AS_OFFERING_GRADE_MODE AS_OFFERING_GRADE_TYPE AS_OFFERING_PREREQ AS_ORGANIZATION_ENTITY AS_OUTCOME_HONOR_DEPT AS_OUTCOME_HONOR_INST AS_PERSON AS_PHONE_ASSIGNMENT AS_PREVIOUS_DEGREE AS_PREVIOUS_EDUCATION_HSCH AS_PREVIOUS_EDUCATION_PCOL AS_PRE_STUDENT AS_RACE AS_RECRUITMENT_ATTRIBUTE AS_RECRUITMENT_COHORT AS_RECRUITMENT_INFORMATION AS_RECRUITMENT_LEARNED AS_RECRUITMENT_SOURCE AS_ROOM_ASSIGNMENT AS_SCHEDULE_ATTRIBUTE AS_SECONDARY_SCHOOL_SUBJECT AS_SPORT AS_STUDENT_ACTIVITY AS_STUDENT_ATTRIBUTE AS_STUDENT_CLASSIFICATION AS_STUDENT_COHORT AS_STUDENT_COURSE_ATTRIBUTE AS_STUDENT_COURSE_ATTR_TRANS AS_STUDENT_COURSE_GRADE_CHG AS_STUDENT_COURSE_HISTORY AS_STUDENT_COURSE_IN_PROGRESS AS_STUDENT_COURSE_REG_AUDIT AS_STUDENT_COURSE_TRANSFER AS_STUDENT_TRANSFERRED_COURSE AS_STUDENT_WORK_EXPERIENCE AS_TELEPHONE AS_TEST AS_TRANSCRIPT_LEVEL_COMMENT AS_TRANSCRIPT_TERM_COMMENT AS_VALIDATION AS_VETERAN_CERTIFICATION AS_VISA AS_YEAR_TYPE_DEFINITION AT_ACCOUNT AT_ACCOUNT_DETAIL AT_APPLICATION_OF_PAYMENT AT_AR_DEPOSIT AT_CONTRACT AT_CONTRACT_PAYMENT_DETAIL AT_EXEMPTION AT_GRANT_ACCOUNT_DETAIL AT_GRANT_APPLICATION_PAYMENT AT_INSTALLMENT_PLAN AT_LEDGER_ACCOUNTING AT_MEMO AT_MISCELLANEOUS_TRANSACTION AT_STUDENT_TAX_NOTIFICATION AT_VALIDATION

RETURN TO COMPOSITE VIEW REPORTS LIST

Reporting View Source: WDT_WAREHOUSE_ENTITY Advancement

Banner Operational Data Store

Composite View Source: WDT_WAREHOUSE_ENTITY - NULL

Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
WAREHOUSE_ENTITY_UID
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]	TBD				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MAT_CONSTITUENT_ENTITY for the calendar year where the PRIMARY_DONOR_CATEGORY is equal to the MTVPARM extract parameter [ALUMNI_IND]
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	TBD
WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE AND EMPLOYEE CLASS = MTVPARM EXTRACT PARAMETER [STUDENT_EMPLOYEE_IND]	NA				WHEN MPT_EMPLOYEE.EMPLOYEE_STATUS = 'A' AND DECODE(MPT_EMPLOYEE, MTVPARM_EXTERNAL_CODE, 1, 0) = 1 WHERE MTVPARM_EXTERNAL_CODE = (Configured based on MPT_EMPLOYEE.EMPLOYEE_GROUP) based on [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_EMPLOYEE_IND'] THEN STUDENT_EMPLOYEE_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
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]	NA				WHEN MST_FACULTY.PERSON_UID IS NOT NULL AND DECODE(MPT_EMPLOYEE, MTVPARM_EXTERNAL_CODE, 1, 0) = 1 WHERE MTVPARM_EXTERNAL_CODE = (Configured based on MPT_EMPLOYEE.EMPLOYEE_CLASS) based on [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'ADJUNCT_FACULTY_IND'] THEN ADJUNCT_FACULTY_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE EXISTS AND EMPLOYEE_STATUS = 'A'.	NA				WHEN MPT_EMPLOYEE.EMPLOYEE_STATUS = 'A' THEN EMPLOYEE_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE WHERE THE FULL_OR_PART_TIME_IND = 'F' AND EMPLOYEE_STATUS = 'A'	NA				WHEN MPT_EMPLOYEE.EMPLOYEE_STATUS = 'A' AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'F' THEN EMPLOYEE_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MPT_EMPLOYEE WHERE THE FULL_OR_PART_TIME_IND = 'P' AND EMPLOYEE_STATUS = 'A'	NA				WHEN MPT_EMPLOYEE.EMPLOYEE_STATUS = 'A' AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'P' THEN EMPLOYEE_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
WAREHOUSE_ENTITY_UID- EDW_EMPLOYEE_EXTR.F_GET_EMPLOYEE:IF MST_FACULTY EXISTS	NA				WHEN MST_FACULTY.PERSON_UID IS NOT NULL THEN FACULTY_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
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	NA				WHEN MST_FACULTY.PERSON_UID IS NOT NULL AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'F' THEN FACULTY_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
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	NA				WHEN MST_FACULTY.PERSON_UID IS NOT NULL AND MPT_EMPLOYEE.FULL_OR_PART_TIME_IND = 'P' THEN FACULTY_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT EXISTS AND CURRENT_TIME_STATUS = MTVPARM EXTRACT PARAMETER [FULL_TIME_COURSE]	NA				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MST_ENROLLMENT where the CURRENT_TIME_STATUS is equal to the MTVPARM extract parameter [FULL_TIME_COURSE].
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	NA				IF r_retained = 1 WHEN acad_period = (MST_ENROLLMENT.ACADEMIC_PERIOD + 100) AND graduated_ind = (SELECT 1 FROM MST_ACADEMIC_OUTCOME WHERE ACADEMIC_YEAR_GRADUATION <= ACADEMIC_YEAR AND GRADUATED_IND = 'Y') AND r_excluded <> (SELECT 1 FROM MST_GENERAL_STUDENT WHERE PRIMARY_PROGRAM_IND = 'Y' AND EXISTS (FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'EXCLUSION_STATUS_CODE' AND MTVPARM_INTERNAL_CODE_2 = 'STVSTST')) AND r_excluded <> (SELECT 1 FROM MST_ENROLLMENT AND EXISTS (FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'EXCLUSION_STATUS_CODE' AND MTVPARM_INTERNAL_CODE_2 = 'STVESTS')) THEN YEAR2_RETAINED_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
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	NA				IF r_retained = 1 WHEN acad_period = (MST_ENROLLMENT.ACADEMIC_PERIOD + 200) AND graduated_ind = (SELECT 1 FROM MST_ACADEMIC_OUTCOME WHERE ACADEMIC_YEAR_GRADUATION <= ACADEMIC_YEAR AND GRADUATED_IND = 'Y') AND r_excluded <> (SELECT 1 FROM MST_GENERAL_STUDENT WHERE PRIMARY_PROGRAM_IND = 'Y' AND EXISTS (FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'EXCLUSION_STATUS_CODE' AND MTVPARM_INTERNAL_CODE_2 = 'STVSTST')) AND r_excluded <> (SELECT 1 FROM MST_ENROLLMENT AND EXISTS (FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'EXCLUSION_STATUS_CODE' AND MTVPARM_INTERNAL_CODE_2 = 'STVESTS')) THEN YEAR3_RETAINED_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
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	NA				IF r_retained = 1 WHEN acad_period = (MST_ENROLLMENT.ACADEMIC_PERIOD + 300) AND graduated_ind = (SELECT 1 FROM MST_ACADEMIC_OUTCOME WHERE ACADEMIC_YEAR_GRADUATION <= ACADEMIC_YEAR AND GRADUATED_IND = 'Y') AND r_excluded <> (SELECT 1 FROM MST_GENERAL_STUDENT WHERE PRIMARY_PROGRAM_IND = 'Y' AND EXISTS (FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'EXCLUSION_STATUS_CODE' AND MTVPARM_INTERNAL_CODE_2 = 'STVSTST')) AND r_excluded <> (SELECT 1 FROM MST_ENROLLMENT AND EXISTS (FROM MTVPARM WHERE MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'EXCLUSION_STATUS_CODE' AND MTVPARM_INTERNAL_CODE_2 = 'STVESTS')) THEN YEAR4_RETAINED_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
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'	NA				WHEN (DECODE (REGISTERED_IND, 'Y', 1, 0) FROM ACADEMIC_STUDY WHERE PRIMARY_PROGRAM_IND = 'Y' AND REGISTERED_IND = 'Y') = 1 THEN OVERALL_RET_HEADCOUNT = WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID ELSE NULL
WAREHOUSE_ENTITY_UID- EDW_ENROLL_EXTR.F_GET_ENROLLMENT:IF MST_ENROLLMENT.ENROLLED_IND EXISTS	NA				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MST_ENROLLMENT for the ACADEMIC_PERIOD.
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]	NA				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MST_GENERAL_STUDENT and MST_ENROLLMENT joined on PERSON_UID and ACADEMIC_PERIOD where the DEGREE is equal to the MTVPARM extract parameter [NON_DEGREE_ATTRIBUTE]
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]	NA				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MST_GENERAL_STUDENT and MST_ENROLLMENT joined on PERSON_UID and ACADEMIC_PERIOD where the MAJOR is equal to the MTVPARM extract parameter [STEM_PROGRAM_ATTRIBUTE]
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]	TBD				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MST_STUDENT_COURSE_ATTRIBUTE and MST_ENROLLMENT joined on PERSON_UID and ACADEMIC_PERIOD where the COURSE_ATTRIBUTE is equal to the MTVPARM extract parameter [DEV_COURSE_ATTRIBUTE]
WAREHOUSE_ENTITY_UID- EDW_FA_PSTU_EXTR.F_GET_FA_PRE_STUDENT: IF MRT_FINAID_APPLICANT_STATUS EXISTS AND FINANCIAL_AID_APPLICATION_IND = 'Y'	NA				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MRT_FINAID_APPLICANT_STATUS where the FINANCIAL_AID_APPLICATION_IND = 'Y'
WAREHOUSE_ENTITY_UID- EDW_FA_PSTU_EXTR.F_GET_FA_PRE_STUDENT:IF MRT_AWARD_BY_PERSON AND AWARD_OFFER_AMOUNT > 0	NA				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MRT_AWARD_BY_PERSON where the AWARD_OFFER_AMOUNT > 0.
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	TBD				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MST_ADMISSIONS_APPLICATION for the ACADEMIC_PERIOD with the INST_ACCEPTED_CURRENT_IND = 'Y'
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	NA				WHEN [NVL(MSKFUNC.F_GET_INQUIRER_IND(MST_ADMISSIONS_APPLICATION.PERSON_UID, MST_ADMISSIONS_APPLICATION.ACADEMIC_PERIOD),'N') THEN INQUIRED_HEADCOUNT = WAREHOUSE_ENTITY_UID
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	TBD				Count of WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID where that person has a record in MST_ADMISSIONS_APPLICATION with INST_ADMIT_ANY_TIME_IND,'N' = 'Y' THEN ADMITTED_HEADCOUNT = WAREHOUSE_ENTITY_UID
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	NA				WHEN MST_ENROLLMENT.ENROLLED_IND = 'Y' THEN ENROLLED_HEADCOUNT = WAREHOUSE_ENTITY)UID, ELSE NULL

Ver: