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

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_STUDENT_LEVEL

Description Student Level dimension table provides information on the student levels defined by the institution.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
STUDENT_LEVEL Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

ACADEMIC_STUDY

STUDENT_LEVEL

NO

NO RETENTION MULTI YEAR
STUDENT_LEVEL_KEY Key of the Student Level dimension. NUMBER

ETL_GENERATED

NA

NO

NO RETENTION MULTI YEAR
STUDENT_LEVEL_LD Long description for the Level. VARCHAR2(255)

ACADEMIC_STUDY

STUDENT_LEVEL_DESC

NO

NO RETENTION MULTI YEAR
STUDENT_LEVEL_SD Short description for the student level. VARCHAR2(255)

ACADEMIC_STUDY

STUDENT_LEVEL_DESC

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