Penn Computing

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

ST_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

The latest date the record was updated in Banner. Source: SGRCHRT_ACTIVITY_DATE

Cohort

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

Code for the cohort assigned to the student. Students can be assigned to cohorts at any time, and can be in multiple cohorts. Cohorts tend to change less often than attributes, that is, they tend to span multiple terms or even the entire time a student is in a specific program. Cohorts can be used to find students in coordinated multiple degree programs, or students' graduation class, or students in some online programs, or whether the student is a veteran, etc. Source: SGRCHRT_CHRT_CODE. Banner validation table: STVCHRT. Warehouse validation table: V_COHORT

Cohort_Desc

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

Description of the cohort code. Source: STVCHRT_DESC

Penn_ID

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

Penn's identity management system's identification number. Source: SPRIDEN_ID

Pidm

Indexed - no
Format - Number
May be Null? Y

Banner internal identification number. Source: SGRCHRT_PIDM

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The latest date the record was refreshed in the warehouse

Status

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

Not currently used at Penn. Source: SGRCHRT_ACTIVE_IND

St_Cohort_Pk

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

internal warehouse primary key. based on PIDM, TERM, and CHRT_CODE

Term

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

Term in which this cohort is associated with the student. In the warehouse, cohorts are stored term-by-term.

Term_Effective

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

Term in which the student's cohort went into effect. In Banner, cohorts are stored term-effective. In the warehouse, cohorts are stored term-by-term, but the effective term is provided for reference.

ST_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