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. |