| Data element |
Definition |
| Acad_Yr_Order Indexed - no
Format - Number
May be Null? Y | Used to display terms in Academic Year order for the purposes of Grad Funding. 1 = Fall, 2 = Spring, 3 = Summer-1, 4 = Summer-2
Note that this does not reflect the Provost Office's definition of Academic Year. |
| Banner_Code Indexed - no
Format - Char
May be Null? Y | The two-digit term code used with the calendar year in Banner. 10 = Spring, 22 = Summer-1, 24 = Summer-2, 30 = Fall. So 201630 is Fall of 2016. |
| Calendar_Yr_Order Indexed - no
Format - Number
May be Null? Y | Used to display terms in Calendar Year order. 1 = Spring, 2 = Summer-1, 3 = Summer-2 and 4 = Fall. |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Pls_Code Indexed - no
Format - Char
May be Null? Y | The single digit term code used along with the calendar year in the PLS system. 1 = Spring, 2 = Summer-1, 3 = Summer-2 and 4 = Fall. So 20164 is Fall of 2016. |
| Pls_Term_Type Indexed - no
Format - Varchar2(8)
May be Null? Y | For the Penn Loan System (PLS), this is a two-character indicator of the part of the year.
Values:
AY = standard academic year (Fall and Spring)
SS = Summer sessions (Summer-1 and Summer-2) |
| Pls_Year_Factor Indexed - no
Format - Number
May be Null? Y | |
| Sam_Code Indexed - no
Format - Char
May be Null? Y | The one character term code used along with the calendar year in SAM. A = Summer-2, B = Fall and Spring, and C = Summer-1. So, for example, 2016C is Summer-1 of 2016. |
| Sam_Term_Flag Indexed - no
Format - Varchar2(24)
May be Null? Y | |
| Srs_Code Indexed - no
Format - Char
May be Null? Y | The onecharacter term code used along with the calendar year in SRS. A = Spring, B = Summer, C = Fall. So, for example, 2016C is Fall of 2016. |
| Start_Day Indexed - no
Format - Varchar2(28)
May be Null? Y | The day the term is considered as beginning, for the Grad Funding system's purposes. Note these dates are not the same as the term begin and end dates on the University's academic calendar. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Stop_Day Indexed - no
Format - Varchar2(28)
May be Null? Y | The day the term is considered over, for the Grad Funding system's purposes. Note these dates are not the same as the term begin and end dates on the University's academic calendar.
|
| Term_Desc Indexed - no
Format - Varchar2(60)
May be Null? Y | Text descriptive name of the acdemic term:
Fall
Spring
Summer-1
Summer-2
|
| Term_Id Indexed - yes
Format - Number
May be Null? N | File key for the GF_TERM table. |
