Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_STUDY_KEY	Key for the academic study dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
ACCEPTED_HEADCOUNT	Accepted Count is the number of applications where there is an admissions decision with an student accepts indicator = Y (STVAPDC_STDN_ACC_IND). Note: a person with more than one application with an institution accepted decision so they will be in this count more than once.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMISSION:IF [NVL(MST_ADMISSIONS_APPLICATION.APPL_ACCEPT_ANY_TIME_IND,'N')] = 'Y' THEN ACCEPTED_HEADCOUNT = WAREHOUSE_ENTITY_UID	NO	NO	RECRUITING AND ADMISSION
ADMITTED_HEADCOUNT	Count of all persons that have been offered admission by the institution, identified by an admissions decision for the application that has an indicator of institution accepts.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMISSION:IF [NVL(MST_ADMISSIONS_APPLICATION.INST_ADMIT_ANY_TIME_IND,'N')] = 'Y' THEN ADMITTED_HEADCOUNT = WAREHOUSE_ENTITY_UID	NO	NO	RECRUITING AND ADMISSION
AGE	Calculated by a function that subtracts the birth date from the load date.	NUMBER	PERSON	FUNCTION	NO	NO	RECRUITING AND ADMISSION
APPLICANT_HEADCOUNT	Count of all persons that have submitted an application for admission to the institution.	NUMBER	WDT_WAREHOUSE_ENTITY	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_UID	NO	NO	RECRUITING AND ADMISSION
COHORT_KEY	Key for the cohort dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
CONTACT_KEY	Key for the contact dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
EMPLOYMENT_HISTORY_KEY	Key for the employment history dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
ENROLLED_HEADCOUNT	Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount.	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMISSION:IF [NVL(MST_ENROLLMENT.ENROLLED_IND,'N')] = 'Y' THEN ENROLLED_HEADCOUNT = WAREHOUSE_ENTITY_UID	NO	NO	RECRUITING AND ADMISSION
FINAL_DEGREE_IND	Final degree indicator.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
FINANCIAL_AID_STATUS_KEY	Key for the financial aid status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
INQUIRED_HEADCOUNT	Count of recruit records for the person in the academic period. Note: there may be multiples of each for a person through time or within an academic period..	NUMBER	WDT_WAREHOUSE_ENTITY	WAREHOUSE_ENTITY_UID-EDW_REC_ADMS_EXTR.F_GET_RECRUITING_ADMISSION:IF [NVL(MST_ADMISSIONS_APPLICATION.INQUIRER_IND)] = 'Y' THEN INQUIRED_HEADCOUNT = WAREHOUSE_ENTITY_UID	NO	NO	RECRUITING AND ADMISSION
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
PERSON_UID	System internally generated ID to uniquely identify the person.	NUMBER	ADMISSIONS_APPLICATION	PERSON_UID	NO	NO	RECRUITING AND ADMISSION
POSTAL_KEY	Key for the postal dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
POST_SECONDARY_SCHOOL_KEY	Key for the post secondary school dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
PRE_STUDENT_KEY	Key for the pre-student dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
PRE_STUDENT_STATUS_KEY	Key for the pre-student status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
PS_INSTITUTION_KEY	Key for the post secondary school dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
SECONDARY_SCHOOL_GPA	Person's secondary institution average or GPA.	NUMBER	PRE_STUDENT	SECONDARY_SCHOOL_REPORTED_GPA	NO	NO	RECRUITING AND ADMISSION
SECONDARY_SCHOOL_KEY	Key for the secondary school dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
SEQUENCE_NUMBER	Student application sequence number.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
SS_INSTITUTION_KEY	Key for the secondary school dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
STUDENT_APPLICATION_KEY	Key for the student application dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
STUDENT_KEY	Key for the Student dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION
TEST1_SCORE	Test 1 Score for the person and student level as defined by the institution in the EDW Extract Parameter. This score is to be used in calculating the average test score for all admitted students who have taken this test.	NUMBER	FUNCTION	MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]	NO	NO	RECRUITING AND ADMISSION
TEST2_SCORE	Test 2 Score for the person and student level as defined by the institution in the EDW Extract Parameter. This score is to be used in calculating the average test score for all admitted students who have taken this test.	NUMBER	FUNCTION	MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]	NO	NO	RECRUITING AND ADMISSION
TEST3_SCORE	Test 3 Score for the person and student level as defined by the institution in the EDW Extract Parameter. This score is to be used in calculating the average test score for all admitted students who have taken this test.	NUMBER	FUNCTION	MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]	NO	NO	RECRUITING AND ADMISSION
TEST4_SCORE	Test 4 Score for the person and student level as defined by the institution in the EDW Extract Parameter. This score is to be used in calculating the average test score for all admitted students who have taken this test.	NUMBER	FUNCTION	MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]	NO	NO	RECRUITING AND ADMISSION
TEST5_SCORE	Test 5 Score for the person and student level as defined by the institution in the EDW Extract Parameter. This score is to be used in calculating the average test score for all admitted students who have taken this test.	NUMBER	FUNCTION	MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]	NO	NO	RECRUITING AND ADMISSION
TEST6_SCORE	Test 6 Score for the person and student level as defined by the institution in the EDW Extract Parameter. This score is to be used in calculating the average test score for all admitted students who have taken this test.	NUMBER	FUNCTION	MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]	NO	NO	RECRUITING AND ADMISSION
TEST7_SCORE	Test 7 Score for the person and student level as defined by the institution in the EDW Extract Parameter. This score is to be used in calculating the average test score for all admitted students who have taken this test.	NUMBER	FUNCTION	MAX(MST_TEST.TEST_SCORE) WHERE [MTVPARM_INTERNAL_CODE_GROUP = 'EDW EXTRACT PARAMETERS' AND MTVPARM_INTERNAL_CODE = 'STUDENT_LEVEL_GROUP_TESTS'] AND [MTVPARM_INTERNAL_CODE = 'TEST' AND MTVPARM_EXTERNAL_CODE = MST_TEST.TEST]	NO	NO	RECRUITING AND ADMISSION
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECRUITING AND ADMISSION

Ver: 9.0