RETURN TO DIMENSION TABLE REPORTS LIST
Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_STUDENT_APPLICATION

Description Student Application Dimension table provides information for the individual that has completed an admission application. This will be the data on the admission application record that identifies the cohort, applicant type and student population to which this person is to be tracked. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADMISSIONS_POPULATION Identifies the type of admission the applicant is seeking or granted (e.g. early admit, regular admit, mature admit, special admit, etc.) VARCHAR2(63)

ADMISSIONS_APPLICATION

ADMISSIONS_POPULATION

NO

NO

RECRUITING AND ADMISSION

ADMISSIONS_POPULATION_LD Long description for the admission population code. VARCHAR2(255)

ADMISSIONS_APPLICATION

ADMISSIONS_POPULATION_DESC

NO

NO

RECRUITING AND ADMISSION

ADMISSIONS_POPULATION_SD Short description for the admission population code. VARCHAR2(255)

ADMISSIONS_APPLICATION

ADMISSIONS_POPULATION_DESC

NO

NO

RECRUITING AND ADMISSION

CAMPUS Identifies the campus to that the student is assigned as the home campus. VARCHAR2(63)

ADMISSIONS_APPLICATION

CAMPUS

NO

NO

RECRUITING AND ADMISSION

CAMPUS_LD Long description for the campus. VARCHAR2(255)

ADMISSIONS_APPLICATION

CAMPUS_DESC

NO

NO

RECRUITING AND ADMISSION

CAMPUS_SD Short description for the campus. VARCHAR2(255)

ADMISSIONS_APPLICATION

CAMPUS_DESC

NO

NO

RECRUITING AND ADMISSION

COHORT Indicates the active student cohort for the student at time of graduation. VARCHAR2(63)

ADMISSIONS_COHORT

COHORT

NO

NO

RECRUITING AND ADMISSION

COHORT_LD Long description of the admission cohort assigned. VARCHAR2(255)

ADMISSIONS_COHORT

COHORT_DESC

NO

NO

RECRUITING AND ADMISSION

COHORT_SD Short description of the admission cohort assigned. VARCHAR2(255)

ADMISSIONS_COHORT

COHORT_DESC

NO

NO

RECRUITING AND ADMISSION

COUNTY_ADMIT County associated with the person's address at the time of admission to the academic study. Important for some institutions, for understanding enrollment patterns or for governmental reporting. When this is relevant it is taken from the Admissions Application reporting view. VARCHAR2(63)

ADMISSIONS_APPLICATION

COUNTY_ADMIT

NO

NO

RECRUITING AND ADMISSION

COUNTY_ADMIT_LD County description at the time of admission. When this is relevant it is taken from the Admissions Application reporting view. VARCHAR2(255)

ADMISSIONS_APPLICATION

COUNTY_ADMIT_DESC

NO

NO

RECRUITING AND ADMISSION

COUNTY_ADMIT_SD County short description at the time of admission. VARCHAR2(255)

ADMISSIONS_APPLICATION

COUNTY_ADMIT_DESC

NO

NO

RECRUITING AND ADMISSION

FIRST_CONTACT First type of contact made with the institution. Usually either by telephone or the internet or at a career night at the secondary institution. VARCHAR2(63)

PRE_STUDENT

FIRST_CONTACT

NO

NO

RECRUITING AND ADMISSION

FIRST_CONTACT_LD Long description of the first type of contact with the institution. VARCHAR2(255)

PRE_STUDENT

FIRST_CONTACT_DESC

NO

NO

RECRUITING AND ADMISSION

FIRST_CONTACT_SD Short description of the first type of contact with the institution. VARCHAR2(255)

PRE_STUDENT

FIRST_CONTACT_DESC

NO

NO

RECRUITING AND ADMISSION

INTENDED_TIME_STATUS Indicates the intended time status of full-time or part-time. VARCHAR2(63)

ADMISSIONS_APPLICATION

INTENDED_TIME_STATUS

NO

NO

RECRUITING AND ADMISSION

INTENDED_TIME_STATUS_LD Intended time status long description that is either Full-time or Part-time. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

INTENDED_TIME_STATUS_SD Intended time status short description that is either Full-time or Part-time. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO

RECRUITING AND ADMISSION

NATION_ADMIT Nation associated with the person's address at the time of admission to the academic study. Important for some institutions, for understanding enrollment patterns or for governmental reporting. When this is relevant it is taken from the Admissions Application reporting view. VARCHAR2(63)

ADMISSIONS_APPLICATION

NATION_ADMIT

NO

NO

RECRUITING AND ADMISSION

NATION_ADMIT_LD Long description at the time of admission. When this is relevant it is taken from the Admissions Application reporting view. VARCHAR2(255)

ADMISSIONS_APPLICATION

NATION_DESC_ADMIT

NO

NO

RECRUITING AND ADMISSION

NATION_ADMIT_SD Short description defined in the cleansing process. When this is relevant it is taken from the Admissions Application reporting view. VARCHAR2(63)

ADMISSIONS_APPLICATION

NATION_DESC_ADMIT

NO

NO

RECRUITING AND ADMISSION

PRIMARY_SOURCE Source identified by the person at their first contact with the institution as having referred the person to this institution. Usually either the secondary or post-secondary school or newspaper advertisement. VARCHAR2(63)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE

NO

NO

RECRUITING AND ADMISSION

PRIMARY_SOURCE_LD Long description or name of the primary source of referral to the institution. VARCHAR2(255)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE_DESC

NO

NO

RECRUITING AND ADMISSION

PRIMARY_SOURCE_SD Short description or name of the primary source of referral to the institution. VARCHAR2(255)

RECRUITMENT_INFORMATION

PRIMARY_SOURCE_DESC

NO

NO

RECRUITING AND ADMISSION

RESIDENCY Residency code for the student identifying the type of charges the student will incur. VARCHAR2(63)

ADMISSIONS_APPLICATION

RESIDENCY

NO

NO

RECRUITING AND ADMISSION

RESIDENCY_LD Long description for the residency code. VARCHAR2(255)

ADMISSIONS_APPLICATION

RESIDENCY_DESC

NO

NO

RECRUITING AND ADMISSION

RESIDENCY_SD Short description for the residency code. VARCHAR2(255)

ADMISSIONS_APPLICATION

RESIDENCY_DESC

NO

NO

RECRUITING AND ADMISSION

STATE_PROVINCE_ADMIT State/Province associated with the person's address at the time of admission to the academic study. Important for some institutions, for understanding enrollment patterns or for governmental reporting. When this is relevant it is taken from the Admission VARCHAR2(63)

ADMISSIONS_APPLICATION

STATE_ADMIT

NO

NO

RECRUITING AND ADMISSION

STATE_PROVINCE_ADMIT_LD State or Province long description at the time of admission. When this is relevant it is taken from the Admissions Application reporting view. VARCHAR2(255)

ADMISSIONS_APPLICATION

STATE_DESC_ADMIT

NO

NO

RECRUITING AND ADMISSION

STATE_PROVINCE_ADMIT_SD State or Province short description at the time of admission. VARCHAR2(255)

ADMISSIONS_APPLICATION

STATE_DESC_ADMIT

NO

NO

RECRUITING AND ADMISSION

STUDENT_APPLICATION_KEY Key for the student application dimension. NUMBER

ETL GENERATED

NA

NO

NO

RECRUITING AND ADMISSION

STUDENT_POPULATION Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, transfer, continuing, etc. VARCHAR2(63)

ADMISSIONS_APPLICATION

STUDENT_POPULATION

NO

NO

RECRUITING AND ADMISSION

STUDENT_POPULATION_LD Long description for student population code. VARCHAR2(255)

ADMISSIONS_APPLICATION

STUDENT_POPULATION_DESC

NO

NO

RECRUITING AND ADMISSION

STUDENT_POPULATION_SD Short description for student population code. VARCHAR2(255)

ADMISSIONS_APPLICATION

STUDENT_POPULATION_DESC

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



Ver: 3.1