Penn Computing

University of Pennsylvania
Penn Computing << go backback
V_COHORT Table . Pennant Student Records Home . Data Warehouse Home

V_COHORT Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Activity_Date

Indexed - no
Format - Date
May be Null? Y

Last date the record was entered or updated in the source. Source field: STVCHRT_ACTIVITY_DATE

Cohort_Code

Indexed - yes
Format - Varchar2(10)
May be Null? N

Code for the student Cohort. Source field: STVCHRT_CODE

Cohort_Desc

Indexed - no
Format - Varchar2(30)
May be Null? Y

Text description of the Cohort. Source field: STVCHRT_DESC

Deg_Level

Indexed - no
Format - Varchar2(2)
May be Null? Y

Cohort Degree Level Code. Source field: STVCHRT_DLEV_CODE

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date this table in the warehouse was last refreshed.

Right2know_Ind

Indexed - no
Format - Varchar2(1)
May be Null? Y

Student Right to Know Reporting Indicator. Source field: STVCHRT_RIGHT_IND

Term_Code_100prcnt

Indexed - no
Format - Varchar2(6)
May be Null? Y

Cohort End Term that meets the 100% completion term for a cohort. Source field: STVCHRT_TERM_CODE_100PRCNT

Term_Code_End

Indexed - no
Format - Varchar2(6)
May be Null? Y

Cohort end term. Source field: STVCHRT_TERM_CODE_END

Term_Code_Start

Indexed - no
Format - Varchar2(6)
May be Null? Y

Cohort start term. Source field: STVCHRT_TERM_CODE_START

V_COHORT Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania