RETURN TO BANNER EDW META DATA REPORTS LIST
Retention Multi Year Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_RETENTION_MULTI_YEAR

Description Retention Multi Year fact table provides data to determine the yearly retention status and number of years it took the student to complete outcome requirements to be used to determine headcounts and calculate retention and graduation rates.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_PERIOD_FRSTATTEND_KEY Key for the academic time dimension. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
GRADUATION_MULTI_YEAR_KEY Key for graduation multi year dimension. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
RETENTION_MULTI_YEAR_KEY Key for the retention multi year dimension. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
STUDENT_LEVEL Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

STUDENT

STUDENT_LEVEL

NO

NO RETENTION MULTI YEAR
STUDENT_LEVEL_KEY Key for the student level dimension. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR


Ver: 9.0