RETURN TO DIMENSION TABLE REPORTS LIST
Application Cohort Star  Recruitment Cohort Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_COHORT

Description Cohort dimension table provides cohort relevant data.

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)

ADMISSIONS_COHORT

RECRUITMENT_COHORT

COHORT

COHORT

NO

NO

NO APPLICATION COHORT 

RECRUITMENT COHORT

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

ADMISSIONS_COHORT

RECRUITMENT_COHORT

COHORT_INACTIVE_REASON

COHORT_INACTIVE_REASON

NO

NO

NO APPLICATION COHORT 

RECRUITMENT COHORT

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

ADMISSIONS_COHORT

RECRUITMENT_COHORT

COHORT_INACTIVE_REASON_DESC

COHORT_INACTIVE_REASON_DESC

NO

NO

NO APPLICATION COHORT 

RECRUITMENT COHORT

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

ADMISSIONS_COHORT

RECRUITMENT_COHORT

COHORT_INACTIVE_REASON_DESC

COHORT_INACTIVE_REASON_DESC

NO

NO

NO APPLICATION COHORT 

RECRUITMENT COHORT

COHORT_KEY Key for the cohort dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION COHORT, RECRUITMENT COHORT
COHORT_LD Long description for the cohort tracking group. VARCHAR2(255)

ADMISSIONS_COHORT

RECRUITMENT_COHORT

COHORT_DESC

COHORT_DESC

NO

NO

NO APPLICATION COHORT 

RECRUITMENT COHORT

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

ADMISSIONS_COHORT

ETL GENERATED

COHORT_REPORT_IND

NA

NO

NO

NO APPLICATION COHORT 

RECRUITMENT COHORT

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

ADMISSIONS_COHORT

RECRUITMENT_COHORT

COHORT_DESC

COHORT_DESC

NO

NO

NO APPLICATION COHORT 

RECRUITMENT COHORT

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

ETL GENERATED

NA

NO

NO APPLICATION COHORT, RECRUITMENT COHORT
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO APPLICATION COHORT, RECRUITMENT COHORT


Ver: 8.1