Go To View:  -- Select a View -- ACADEMIC_HISTORY_EVENT ACADEMIC_OUTCOME ACADEMIC_OUTCOME_SLOT ACADEMIC_STUDY ACADEMIC_STUDY_EXTENDED ACCOUNT_ATTRIBUTES ACCOUNT_HIERARCHY ACCOUNT_HIERARCHY_FISCAL ACCOUNT_INDEX ACCOUNT_TYPE_ATTRIBUTES ACTIVITY ACTIVITY_ATTRIBUTES ADDRESS ADDRESS_BY_RULE ADDRESS_CURRENT ADDRESS_PREFERRED ADMINISTRATOR ADMISSIONS_APPLICATION ADMISSIONS_ATTRIBUTE ADMISSIONS_COHORT ADMISSIONS_DECISION ADMISSIONS_DECISION_SLOT ADMISSIONS_RATING ADMISSIONS_REQUIREMENT ADMISSIONS_SOURCE ADMISSIONS_SOURCE_SLOT ADVANCEMENT_RATING ADVANCEMENT_RATING_SLOT ADVISOR ADVISOR_SLOT ALTERNATIVE_ID ANNUAL_GIVING ANNUAL_GIVING_SLOT APPLICANT_NEED APPLICANT_PERIOD_STATUS APPLICANT_RESOURCE APPLICATION_OF_PAYMENT APPL_OF_PAY_DETAIL_ACCOUNTING ATTRIBUTE_SETS AUDIT_COURSE_NEEDED AUDIT_STUDENT_BLOCK AUDIT_STUDENT_COURSE AUDIT_STUDENT_NON_COURSE AUTHORIZATION AUTHORIZATION_ACCOUNTING AUTHORIZATION_APPROVAL_HISTORY AUTHORIZATION_ITEM AUTHORIZATION_ITEM_TAX AUTHORIZATION_ITINERARY AUTHORIZATION_STATUS_HISTORY AWARD_BY_AID_YEAR AWARD_BY_FUND AWARD_BY_PERSON AWARD_DISBURSEMENT BARGAINING_UNIT BARG_UNIT_SLOT BENEFICIARY_DEPENDENT BENEFICIARY_SLOT BENEFIT_DEDUCTION BLOCK_REGISTRATION_COURSE BUDGET_AVAILABILITY_LEDGER BUDGET_DETAIL BUDGET_REQUEST_TEXT CALENDAR_DATE_HIERARCHY CAMPAIGN CAMPAIGN_COMMENT CAMPAIGN_DESIGNATION CAMPAIGN_EXPENSE CAMPAIGN_FUNDRAISER CAMPAIGN_GIVING_HISTORY CAMPAIGN_MAIL CAMPAIGN_SOLICITATION CERTIFICATION CERTIFICATION_SLOT CHART_ATTRIBUTES COMBINED_ACADEMIC_OUTCOME COMMUNICATION COMMUNICATION_SLOT CONSTITUENT CONSTITUENT_CONF_COMMENT CONSTITUENT_CONF_COMMENT_SUBJ CONSTITUENT_CONTACT CONSTITUENT_ENTITY CONSTITUENT_PLAN CONSTITUENT_STAFF_ASSIGN CONTACT CONTACT_SLOT CONTRACT CONTRACT_PAYMENT_DETAIL COURSE_ATTRIBUTE COURSE_ATT_SLOT COURSE_CATALOG COURSE_COREQ COURSE_LEVEL COURSE_LEVEL_SLOT COURSE_OFFERING_FEES COURSE_PREREQ COURSE_PREREQ_COMBINED COURSE_SCHEDULE COURSE_SCHEDULE_SLOT CROSS_REFERENCE_SLOT CURRENT_EMPLOYMENT DEGREE DEGREE_SLOT DELEGATE_ASSIGNMENT DEPOSIT DESIGNATION DESIGNATION_ACCOUNTING DESIGNATION_ADJUSTMENT DESIGNATION_ATTRIBUTE DESIGNATION_CLASS_YEAR DESIGNATION_COMMENT DESIGNATION_COMMENT_SUBJ DESIGNATION_FINAID_FUND DESIGNATION_GIVING_HISTORY DESIGNATION_ID DONOR_CATEGORY DONOR_CATEGORY_SLOT EMPLOYEE EMPLOYEE_EARNING_CY EMPLOYEE_EARNING_FY EMPLOYEE_POSITION EMPLOYMENT_HISTORY EMPL_EARN_CY_SLOT ENCUMBRANCE ENCUMBRANCE_ACCOUNTING ENCUMBRANCE_LEDGER ENCUMBRANCE_TEXT ENDOWMENT_ATTRIBUTES ENDOWMENT_DISTRIBUTION ENDOWMENT_SUMMARIZED_UNITS ENDOWMENT_UNITS ENROLLMENT ENROLLMENT_WITHDRAWAL EVENT EVENT_INVITEE EXCEPTION_APPLIED EXCEPTION_DETAIL EXCLUSION EXCLUSION_SLOT EXEMPTION FACULTY FACULTY_APPOINTMENT_HISTORY FACULTY_ATTRIBUTE FACULTY_ATT_SLOT FACULTY_DEPARTMENT_COLLEGE FACULTY_FEEDBACK FACULTY_FEEDBACK_DETAIL FACULTY_RANK_HISTORY FACULTY_SABBATICAL_HISTORY FACULTY_TRACKING FAMILY_MEDICAL_LEAVE_HISTORY FIELD_OF_STUDY FINAID_APPLICANT_STATUS FINAID_BUDGET_COMPONENT FINAID_BUDGET_COMP_SLOT FINAID_COMMENTS FINAID_ENROLLMENT FINAID_FUND FINAID_HOLD FINAID_MESSAGE FINAID_TRACKING_REQUIREMENT FIXED_ASSET_ACCOUNTING_HISTORY FIXED_ASSET_ACCOUNTING_SOURCE FIXED_ASSET_ADJUSTMENT FIXED_ASSET_ADJUSTMENT_TEXT FIXED_ASSET_ATTRIBUTES FIXED_ASSET_DEPRECIATED_ITEM FIXED_ASSET_FUNDING_SOURCE FIXED_ASSET_ITEM FIXED_ASSET_TEXT FMLA_LEAVE_COMMENT FOAPAL_NO_ATTRIBUTES FUNDING_INTEREST FUNDING_INTEREST_SLOT FUND_ATTRIBUTES FUND_HIERARCHY FUND_HIERARCHY_FISCAL FUND_MESSAGE_RULE FUND_TEXT FUND_TYPE_ATTRIBUTES GENERAL_LEDGER GEOGRAPHIC_REGION GEOGRAPHIC_REGION_INSTITUTION GIFT GIFT_ASSOCIATED_ENTITY GIFT_AUXILIARY GIFT_MATCHING GIFT_MATCHING_DETAIL GIFT_MATCHING_TRANSACTION GIFT_MEMO GIFT_MULTIPLE GIFT_SOCIETY GIFT_SOCIETY_SLOT GIFT_TRANSACTION GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_ADMISSIONS GOVERNMENT_COURSE GOVERNMENT_FA_FUND GOVERNMENT_FINANCIAL_AID GOVERNMENT_STUDENT GPA GPA_BY_LEVEL GPA_BY_TERM GRANT_APPLIED_PAYMENTS GRANT_ATTRIBUTES GRANT_BILLING_DETAIL GRANT_DEFERRED_COST GRANT_EVENT GRANT_EVENT_STATUS GRANT_FUND GRANT_FUND_SLOT GRANT_LEDGER GRANT_PERSONNEL GRANT_RECEIVABLE_ACCT_DETAIL GRANT_TEXT GRANT_VIEW HOLD HOLD_SLOT HR_APPLICATION HR_APPLICATION_STATUS HR_APPL_STAT_SLOT HR_REQUISITION INSTALLMENT_PLAN INSTITUTION INSTITUTION_CHARACTERISTIC INSTITUTION_DEMOGRAPHIC INSTRUCTIONAL_ASSIGNMENT INSTRUCT_ASSIGN_SLOT INST_CHARACTERISTIC_SLOT INTEREST INTEREST_SLOT INTERNET_ADDRESS INTERNET_ADDRESS_CURRENT INTERVIEW INTERVIEW_SLOT INVOICE INVOICE_ACCOUNTING INVOICE_ACCOUNTING_TAX_RATE INVOICE_CHECK INVOICE_ITEM INVOICE_ITEM_ACCOUNTING INVOICE_TAX_RATE INVOICE_TAX_RATE_SLOT INVOICE_TEXT JOURNAL_VOUCHER_TEXT LABOR_COST_DISTRIBUTION LEAVE_ACCRUAL LEAVE_BALANCE LEAVE_BALANCE_SLOT LOAN_AGGREGATES LOAN_APPLICATION LOAN_DISBURSEMENT LOCATION_ATTRIBUTES LOCATION_HIERARCHY LOCATION_HIERARCHY_FISCAL MAIL MAIL_SLOT MEAL_ASSIGNMENT MEDICAL_INFORMATION MEDICAL_INFORMATION_SLOT MEETING_TIME MEETING_TIME_SLOT MEMBERSHIP MEMBERSHIP_INTEREST MEMO MISCELLANEOUS_TRANSACTION MONTHLY_DEDUCTION MONTHLY_DEDUCT_SLOT MPV_ACADEMIC_STANDING MPV_ADVISOR_NAME MPV_ALL_PROGRAM MPV_AUDIT MPV_BLOCK_TYPE MPV_GEOGRAPHIC_DIVISION MPV_PROGRAM MPV_REGISTRATION_PLAN MPV_REGISTRATION_PLAN_COURSE MPV_STUDENT_CLASSIFICATION MPV_STUDENT_POPULATION NEED_ANALYSIS NEED_ANALYSIS_DEMOGRAPHIC NEED_ANALYSIS_FEDERAL_METHOD NEED_ANALYSIS_INST_METHOD NEED_ANALYSIS_ISIR_SPECIFIC NEED_ANALYSIS_OVERRIDE NEED_ANALYSIS_PROFILE_SPECIFIC NONINSTRUCT_ASSIGN_SLOT NON_INSTRUCTIONAL_ASSIGNMENT NON_YEAR_USER_DEFINED_FIELDS OFFERING_COREQ OFFERING_GRADE_TYPE OFFERING_PREREQ OPERATING_LEDGER ORGANIZATIONAL_CONSTITUENT ORGANIZATION_ATTRIBUTES ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ORGANIZATION_ENTITY ORGANIZATION_ENTITY_ADDRESS ORGANIZATION_FUNDING_AREA ORGANIZATION_HIERARCHY ORGANIZATION_HIERARCHY_FISCAL OUTCOME_DEPARTMENTAL_HONOR OUTCOME_HONOR OUTCOME_INSTITUTIONAL_HONOR PAST_EMPLOYMENT_SLOT PAYROLL_ATTENDANCE PAYROLL_DEDUCTION PAYROLL_DISTRIBUTION PAYROLL_DOCUMENT PAYROLL_EARNING PAYROLL_EMPLOYEE_POSITION PAYROLL_LABOR_DIST_OVERRIDE PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET PERIOD_BUDGET_COMPONENT PERSON PERSONNEL_ACTION PERSONNEL_ACTION_COMMENT PERSONNEL_ACTION_EARNING PERSONNEL_ACTION_GENERAL PERSONNEL_ACTION_LABOR_DIST PERSON_ADDRESS PERSON_DETAIL PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON_SENSITIVE_RACE PERSON_SENSITIVE_RACE_SLOT PERSON_VETERAN PHONE_ASSIGNMENT PLAN_TEMPLATE_COURSE PLEDGE PLEDGE_ASSOCIATED_ENTITY PLEDGE_AUXILIARY PLEDGE_CONDITIONAL PLEDGE_INSTALLMENT PLEDGE_MATCHING PLEDGE_MATCHING_TRANSACTION PLEDGE_TRANSACTION PORTFOLIO PORTFOLIO_SUMMARY POSITION_BUDGET POSITION_DEFINITION POSITION_LABOR_DISTRIBUTION POSN_LABOR_DIST_SLOT PREVIOUS_DEGREE PREVIOUS_EDUCATION PREVIOUS_EDUCATION_ATTENDANCE PREVIOUS_EDUCATION_SLOT PRE_STUDENT PROFILE_DEFAULT_ACCOUNTING PROGRAM_ATTRIBUTES PROGRAM_HIERARCHY PROGRAM_HIERARCHY_FISCAL PROJECTED_SEATS_NEEDED PROJECT_INTEREST PROPOSAL PROPOSAL_TEXT PROSPECT_CONFIDENTIAL_COMMENT PROSPECT_CONF_COMMENT_SUBJ PROSPECT_CONTACT_EXPENSE PROSPECT_CONTACT_STAFF PROSPECT_INFO PROSPECT_MOVES_MANAGEMENT PROSPECT_PROPOSAL PROSPECT_PROPOSAL_MASTER PROSPECT_PROPOSAL_PROJECT PROSPECT_PROPOSAL_RESULT PROSPECT_STAFF_ASSIGNMENT PURCHASE_ORDER PURCHASE_ORDER_ACCOUNTING PURCHASE_ORDER_ITEM PURCHASE_ORDER_ITEM_ACCOUNTING PURCHASE_ORDER_ITEM_SUMMARY PURCHASE_ORDER_ITEM_TEXT PURCHASE_ORDER_TAX_RATE PURCHASE_ORDER_TEXT RECEIVABLE_ACCOUNT RECEIVABLE_ACCOUNTING RECEIVABLE_ACCOUNT_DETAIL RECEIVABLE_SUMMARY RECEIVED_ITEM RECEIVED_ITEM_TEXT RECRUITMENT_ATTRIBUTE RECRUITMENT_COHORT RECRUITMENT_INFORMATION RECRUITMENT_LEARNED RECRUITMENT_SOURCE RECRUITMENT_SOURCE_SLOT REFERENCE REFERENCE_SLOT REGISTRATION_PLAN REGISTRATION_PLAN_COURSE REIMBURSEMENT REIMBURSEMENT_ACCOUNTING REIMBURSEMENT_APPROVAL_HISTORY REIMBURSEMENT_ITEM REIMBURSEMENT_ITEM_TAX REIMBURSEMENT_ITINERARY REIMBURSEMENT_STATUS_HISTORY RELATIONSHIP REQUIREMENT_SLOT RETURNED_ITEM RETURNED_ITEM_TEXT REVIEW REVIEW_SLOT ROOM_ASSIGNMENT SALUTATION SATISFACTORY_ACAD_PROGRESS SCHEDULE_ATTRIBUTE SCHEDULE_OFFERING SECONDARY_SCHOOL_SUBJECT SKILL SKILL_SLOT SOLICITATION SOLICITOR_ASSIGNMENT SOLICITOR_ASSIGNMENT_RESULT SOLICITOR_ORGANIZATION SOLICITOR_ORGANIZATION_COMMENT SOLICITOR_ORGANIZATION_GOAL SOLICITOR_ORG_FUNDRAISER SOLICITOR_ORG_FUNDRAISER_GOAL SPECIAL_ACTIVITY SPECIAL_ACTIVITY_SLOT SPECIAL_ACTIVITY_YEAR SPECIAL_ACTIVITY_YEAR_SLOT SPECIAL_PURPOSE_GROUP SPECIAL_PURPOSE_SLOT SPORT SPORT_SLOT STUDENT STUDENT_ACTIVITY STUDENT_ATTRIBUTE STUDENT_ATTRIBUTE_SLOT STUDENT_COHORT STUDENT_COHORT_SLOT STUDENT_COURSE STUDENT_COURSE_ATTRIBUTE STUDENT_COURSE_ATT_SLOT STUDENT_COURSE_GRADE_CHANGE STUDENT_COURSE_REG_AUDIT STUDENT_EXTENDED STUDENT_TAX_NOTIFICATION STUDENT_TRANSFERRED_COURSE STUDENT_WORK_EXPERIENCE SUPPLEMENTAL_DATA SUPPLEMENTAL_DATA_SLOT TAX TELEPHONE TELEPHONE_CURRENT TEST TEST_PERCENTILE TEST_SLOT TRACKING_REQUIREMENT_SLOT TRANSACTION_HISTORY TRANSCRIPT_COMMENT TRAVEL_AND_EXPENSE_PROFILE USER_DEFINED_FIELDS VALIDATION VENDOR VENDOR_TAXABLE_REPORTING VENDOR_TEXT VENDOR_TYPE VETERAN_CERTIFICATION VISA VISA_CURRENT WCV_EXTR_COURSE_DETAILS WCV_EXTR_INSTITUTION_DETAILS WCV_EXTR_PERSON_DETAILS WCV_EXTR_STUD_CLASSIFICATION YEARLY_DEDUCTION YEAR_TYPE_DEFINITION

RETURN TO REPORTING VIEW REPORTS LIST

Composite View Source: WDT_WAREHOUSE_ENTITY Advancement Reporting View Meta Data Reports

Banner Operational Data Store

Reporting 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: 9.1