RETURN TO BANNER EDW META DATA REPORTS LIST
Application Cohort Star  Recruitment Cohort Star  Student Cohort Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_COHORT

Description Cohort dimension table contains institution defined values recorded in Banner to group students within an academic period. The groups wants to track from admission to graduation.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
COHORT Cohort tracking group assigned to the application through the Administrative UI display rules. VARCHAR2(63)

STUDENT_COHORT

COHORT

NO

NO STUDENT COHORT
COHORT_INACTIVE_REASON Reason code recorded for inactivating the cohort. VARCHAR2(63)

STUDENT_COHORT

COHORT_INACTIVE_REASON

NO

NO STUDENT COHORT
COHORT_INACTIVE_REASON_LD Long description of the inactive reason. VARCHAR2(255)

STUDENT_COHORT

COHORT_INACTIVE_REASON_DESC

NO

NO STUDENT COHORT
COHORT_INACTIVE_REASON_SD Short description of the inactive reason. VARCHAR2(255)

STUDENT_COHORT

COHORT_INACTIVE_REASON_DESC

NO

NO STUDENT COHORT
COHORT_KEY Key for the cohort dimension. NUMBER

ETL_GENERATED

NA

NO

NO STUDENT COHORT
COHORT_LD Long description for the cohort tracking group. VARCHAR2(255)

STUDENT_COHORT

COHORT_DESC

NO

NO STUDENT COHORT
COHORT_REPORT_IND Indicates whether a person with this cohort should be selected for a report. VARCHAR2(63)

STUDENT_COHORT

FTE_COHORT_REPORT_IND

NO

NO STUDENT COHORT
COHORT_SD Short description for the cohort tracking group. VARCHAR2(255)

STUDENT_COHORT

COHORT_DESC

NO

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

ETL_GENERATED

NA

NO

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

ETL_GENERATED

NA

NO

NO STUDENT COHORT


Ver: 9.0