| Data element |
Definition |
| Acad_Hist_Cutoff_Date Indexed - no
Format - Date
May be Null? Y | Default of the last date when student may drop a section and have it recorded with their academic history information for this part of term. Source field: SOBPTRM_ACAD_CUTOFF_DATE |
| Activity_Date Indexed - no
Format - Date
May be Null? N | The latest date this record was updated in the source. Source field: STVPTRM_ACTIVITY_DATE |
| Census_2_Date Indexed - no
Format - Date
May be Null? Y | The second census date (not curently used at Penn). Source field: SOBPTRM_CENSUS_2_DATE |
| Census_Date Indexed - no
Format - Date
May be Null? Y | The census date for the Part of Term Code. This date controls how the census date field on the Schedule Form (SSASECT) is updated. Source field: SOBPTRM_CENSUS_DATE |
| Detail_Grade_Pub_Date Indexed - no
Format - Date
May be Null? Y | Source field: SOBPTRM_DET_GRDE_PUB_DATE |
| Drop_Cutoff_Date Indexed - no
Format - Date
May be Null? Y | Default of the last date on which students may drop a section without assessing a penalty for this part of term. Source field: SOBPTRM_DROP_CUTOFF_DATE |
| Enrlmnt_Cutoff_Date Indexed - no
Format - Date
May be Null? Y | The last date on which students may enroll for a section for this part of term. Source field: SOBPTRM_ENRL_CUTOFF_DATE |
| Final_Grade_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Field used to control access to the Final Grade Worksheet page in the Faculty Web product; not currently used at Penn. Source field: SOBPTRM_FGRD_WEB_UPD_IND |
| Final_Grade_Pub_Date Indexed - no
Format - Date
May be Null? Y | Source field: SOBPTRM_FINAL_GRDE_PUB_DATE |
| Incomplete_Extension Indexed - no
Format - Date
May be Null? Y | Source field: SOBPTRM_INCOMPLETE_EXT_DATE |
| Midterm_Grade_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Field used to control access to the Mid Term Grade Worksheet page in the Faculty Web product; not currently used at Penn. Source field: SOBPTRM_MGRD_WEB_UPD_IND |
| Part_Of_Term_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | Code for the Part of Term. Source field: SOBPTRM_PTRM_CODE |
| Part_Of_Term_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the part of term code. Source field: SOBPTRM_DESC |
| Part_Of_Term_End Indexed - no
Format - Date
May be Null? Y | End date for the Part of Term. Source field: SOBPTRM_END_DATE |
| Part_Of_Term_Pk Indexed - yes
Format - Varchar2(9)
May be Null? N | internal warehouse primary key, created when row is populated: concatenation of SOBPTRM_TERM_CODE and SOBPTRM_PTRM_CODE |
| Part_Of_Term_Start Indexed - no
Format - Date
May be Null? Y | Start date for the Part of Term. Source field: SOBPTRM_START_DATE |
| Reasses_Score_Cutoff Indexed - no
Format - Date
May be Null? Y | Reassessment score cutoff date. Source field: SOBPTRM_REAS_SCORE_CUTOFF_DATE |
| Reasses_Score_Open Indexed - no
Format - Date
May be Null? Y | Reassessment score open date. Source field: SOBPTRM_REAS_SCORE_OPEN_DATE |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date of the latest refresh of this warehouse table |
| Refund_Cutoff_Date Indexed - no
Format - Date
May be Null? Y | Default of the last date when student may drop a section and still get a refund for this part of term. Source field: SOBPTRM_REFUND_CUTOFF_DATE |
| Reg_Allowed Indexed - no
Format - Varchar2(1)
May be Null? Y | Source field: SOBPTRM_REG_ALLOWED |
| Score_Cutoff_Date Indexed - no
Format - Date
May be Null? Y | Source field: SOBPTRM_CUTOFF_DATE |
| Score_Open_Date Indexed - no
Format - Date
May be Null? Y | Source field: SOBPTRM_SCORE_OPEN_DATE |
| Sect_Override_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the Start and End dates for a Part of Term can be updated on the Section Form (SSASECT). Source field: SOBPTRM_SECT_OVER_IND |
| Term_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Term code associated with the entries on the Part of Term. Source field: SOBPTRM_TERM_CODE |
| Waitlist_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Field used to control access to the Wait List Display page in the Faculty Web product; not currently used at Penn. Source field: SOBPTRM_WAITLIST_WEB_DISP_IND |
| Weeks Indexed - no
Format - Number
May be Null? Y | The number of weeks in the Part of Term on the Term. Source field: SOBPTRM_WEEKS |
