RETURN TO FACT TABLE REPORTS LIST
Recruiting And Admission Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_RECRUITING_AND_ADMISSION

Description Recruiting and Admission Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person per time frame per application.

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

AGE Calculated by a function that subtracts the birth date from the load date. NUMBER

PERSON

FUNCTION

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

FINANCIAL_AID_STATUS_KEY Key for the financial aid status dimension. NUMBER

ETL GENERATED

NA

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

POST_SECONDARY_SCHOOL_KEY Key for the post secondary 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

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

ADMISSIONS_APPLICATION

SEQUENCE_NUMBER

NO

NO

RECRUITING AND ADMISSION

STUDENT_APPLICATION_KEY Key for the student application 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

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

RECRUITING AND ADMISSION



Ver: 3.1