RETURN TO DIMENSION TABLE REPORTS LIST
Financial Aid Pre-Student Star Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_PRE_STUDENT_STATUS

Description Pre-Student Status Dimension table provides information on the processing steps completed for those applying to study at the institution. This information includes inquired, applied, admitted, accepted and enrolled. 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
ACCEPTED_IND Indicates when an offer of employment was accepted by the applicant. VALUES will be yes or no. The HR_APPLICATION_STATUS reporting view will show this information. VARCHAR2(63)

ADMISSIONS_APPLICATION

APPL_ACCEPT_ANY_TIME_IND

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

ADMITTED_IND Indicates whether or not a person was offered admission to the institution and should count as admitted. VARCHAR2(63)

ADMISSIONS_APPLICATION

INST_ADMIT_ANY_TIME_IND

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

APPLIED_IND Indicates if an application was received by the fact there is information in the HR_APPLICATION reporting view. VALUES will be yes or no. Calculated. VARCHAR2(63)

ADMISSIONS_APPLICATION

FUNCTION

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

ENROLLED_IND Indicates whether or not the student has a 'Y' on their ENROLLMENT ODS reporting view. The enrolled indicator was determined by the logic in the ERP system and based on the specific course status within the academic period or sub-academic period. VARCHAR2(63)

ADMISSIONS_APPLICATION

ENROLLED_IND

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

INQUIRED_IND Indicates whether or not a person should count as a prospect and is set to Yes when there is an entry for the person in the RECRUITMENT_INFORMATION ODS reporting view for the time dimension. VARCHAR2(63)

ADMISSIONS_APPLICATION

FUNCTION

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

PRE_STUDENT_STATUS_KEY Key for the pre-student status dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, 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

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, RECRUITING AND ADMISSION



Ver: 3.1