RETURN TO BANNER EDW META DATA REPORTS LIST
Student Star  Student Progress Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_RETENTION

Description Retention Dimension table contains indicators that identify the student's overall, student level, program and college retention status.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
NOT_RETAINED_COLLEGE_IND Indicates whether the student was not retained within college for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_COLLEGE_IND_LD Long description for the not retention within college indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_COLLEGE_IND_SD Short description for the not retention within college indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_OVERALL_IND Indicates whether the student was not retained by the institution for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_OVERALL_IND_LD Long description for the not retention indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_OVERALL_IND_SD Short description for the not retention indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_PROGRAM_IND Indicates whether the student was not retained within program for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_PROGRAM_IND_LD Long description for the not retention within program indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_PROGRAM_IND_SD Short description for the not retention within program indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_STDLEVL_IND Indicates whether the student was not retained within student level for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_STDLEVL_IND_LD Long description for the not retention within student level indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
NOT_RETAINED_STDLEVL_IND_SD Short description for the not retention within student level indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_COLLEGE_IND Indicates whether the student was retained within the same college for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_COLLEGE_IND_LD Long description for the retention within college indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_COLLEGE_IND_SD Short description for the retention within college indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_EXCLUDE_IND Indicates the student should not be included in any of the retention counts. Persons are excluded as legitimate exceptions either by a student status or enrollment status, by graduation or death. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_EXCLUDE_IND_LD Long description for the excluded retention indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_EXCLUDE_IND_SD Short description for the excluded retention indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_OVERALL_IND Indicates whether the student was retained by the institution for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_OVERALL_IND_LD Long description for the retention indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_OVERALL_IND_SD Short description for the retention indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_PROGRAM_IND Indicates whether the student was retained within the same program for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_PROGRAM_IND_LD Long description for the retention within program indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_PROGRAM_IND_SD Short description for the retention within program indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_STDLEVL_IND Indicates whether the student was retained within the same student level for the next like or sequential academic period. NUMBER

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_STDLEVL_IND_LD Long description for the retention within student level indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETAINED_STDLEVL_IND_SD Short description for the retention within student level indicator. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_KEY Key for the retention dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT PROGRESS
RETENTION_STATUS_COLLEGE Retention status that determined from the retained, not retained and excluded indicators within the college. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values. VARCHAR2(63)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_COLLEGE_LD Long description for the retention status within the college. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_COLLEGE_SD Short description for the retention status within the college. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_OVERALL Retention status that determined from the retained, not retained and excluded indicators. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values. VARCHAR2(63)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_OVERALL_LD Long description for the retention status. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_OVERALL_SD Short description for the retention status. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_PROGRAM Retention status that determined from the retained, not retained and excluded indicators within the program. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values. VARCHAR2(63)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_PROGRAM_LD Long description for the retention status within the program. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_PROGRAM_SD Short description for the retention status within the program. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_STDLEVL Retention status that determined from the retained, not retained and excluded indicators within the student level. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values. VARCHAR2(63)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_STDLEVL_LD Long description for the retention status within the student level. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
RETENTION_STATUS_STDLEVL_SD Short description for the retention status within the student level. VARCHAR2(255)

ETL GENERATED

NA

NO

NO STUDENT, STUDENT PROGRESS
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

ETL_GENERATED

NA

NA

NO

NO

NO STUDENT, STUDENT PROGRESS 

STUDENT PROGRESS

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

ETL GENERATED

ETL_GENERATED

NA

NA

NO

NO

NO STUDENT, STUDENT PROGRESS 

STUDENT PROGRESS



Ver: 9.0