| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Date the record was created or updated in the source. Source field: SORLFOS_ACTIVITY_DATE |
| Admit_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term the student started this curriculum. SORLCUR_TERM_CODE_ADMIT. |
| Campus Indexed - no
Format - Varchar2(3)
May be Null? Y | Campus associated with the student's curriculum. Source field: SORLCUR_CAMP_CODE. Source validation table: STVCAMP. Warehouse validation table: V_CAMPUS. |
| Campus_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in CAMPUS. Source: STVCAMP_DESC. |
| Concentration Indexed - no
Format - Varchar2(4)
May be Null? Y | Concentration code, if any, associated with the Major on this record. Source field: SORLFOS_MAJR_CODE. |
| Concentration_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in CONCENTRATION. Source: STVMAJR_DESC. |
| Coord_Multi_Degr Indexed - no
Format - Varchar2(12)
May be Null? Y | Indicates student is in a coordinated multiple degree program. Values Y or null. |
| Curric_Activity Indexed - no
Format - Varchar2(15)
May be Null? Y | Curriculum activity status, reference to SOBCACT: tells if the curriculum is active or inactive. Source field: SORLCUR_CACT_CODE. |
| Curric_Current_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | CURRENT INDICATOR: The view gets only the ones with 'Y' -- indicating this is the current curriculum. |
| Curric_Priority_No Indexed - no
Format - Number
May be Null? Y | Used to identify the primary program, and one or more additional concurrent programs. Aside from the Primary, the other order numbers should not be interpreted as having any rank or priority ordering.
Values: 10, 20, 30, 40, etc. Source field: SORLCUR_PRIORITY_NO |
| Curric_Status Indexed - no
Format - Varchar2(15)
May be Null? Y | Curriculum status. This status primarily supports admissions functions. For most if not all of LEARNER records, the CSTS code will translate to "IN PROGRESS" Source field: SORLFOS_CSTS_CODE. Source validation table: STVCSTS. |
| Degree_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Degree code from the corresponding curriculum record. Source field: SORLCUR_DEGC_CODE. |
| Degree_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in DEGREE. Source: STVDEGR_DESC. |
| Degree_Order Indexed - no
Format - Number
May be Null? Y | Degree order number from the corresponding curriculum record, example 1,2,3. Derived from the curriculum priority number: the lowest priority number for a student in a term is degree order 1, the second lowest is degree order 2, etc. |
| Degree_Term_Seq_Num Indexed - no
Format - Number
May be Null? Y | Internal sequence number of the degree term record, used to join the degree term table to the major table. Source field: SORLFOS_LCUR_SEQNO. |
| Division Indexed - no
Format - Varchar2(2)
May be Null? Y | Division code from the corresponding curriculum record. Source field: SORLCUR_COLL_CODE. Source validation table: STVCOLL. Warehouse validation table: V_DIVISION. |
| Division_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in DIVISION. Source: STVCOLL_DESC.
Note: In the validation table V_DIVISION there is both a division name and a division long name. There is also a start and end date for the division long name. To get the most recent division long name, use the V_DIVISION_V view. |
| Dwld_Curric_Id Indexed - no
Format - Number
May be Null? Y | Internal number, used only in Penn's Data Warehouse. This is not stored in the source, nor should it be stored in downstream systems. Its sole purpose is to link together the student's degree term rows that all belong to the same curriculum. |
| Major_Minor Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the Major, Minor, or Concentration, for this Field of Study. Source field: SORLFOS_MAJR_CODE. Source validation table: STVMAJR. Warehouse validation table: V_MAJOR_MINOR |
| Major_Minor_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in MAJOR_MINOR. Source: STVMAJR_DESC. |
| Major_Minor_Order Indexed - no
Format - Number
May be Null? Y | Indicates the primary, secondary, tertiary major. Derived from the field of SORLFOS_PRIORITY_NO.
1,2,3,4, etc. |
| Major_Minor_Priority_No Indexed - no
Format - Number
May be Null? Y |
Source systems ordering of fields of study. Values are 10, 20, 30, ...
Source field: SORLFOS_PRIORITY_NO. |
| Major_Minor_Seq_Num Indexed - no
Format - Number
May be Null? Y | Internal sequence number of the field of study record. Source field: SORLFOS_SEQNO. |
| Major_Minor_Type Indexed - no
Format - Varchar2(15)
May be Null? Y | Field of Study type code, for example Major, Minor, Conc. Source field: SORLFOS_LFST_CODE. Source validation table: STVLFST. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID. |
| Pidm Indexed - no
Format - Number
May be Null? Y | Internal identification number. Source field: SORLFOS_PIDM |
| Program_Code Indexed - no
Format - Varchar2(12)
May be Null? Y | Program code from the corresponding curriculum record. Source field: SORLCUR_PROGRAM. Source validation table: V_PROGRAM. |
| Program_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in PROGRAM. Source: SMRPRLE_DESC.br
Note that the V_PROGRAM table has both a name and a long name for programs. The validation table also has a start and end date during which the long name is in effect. To get the most recent long name for a program, use the view V_PROGRAM_V. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this table was refreshed in the warehouse. |
| School Indexed - no
Format - Varchar2(2)
May be Null? Y | School code associated with the division code on the student's curriculum. Source field: STVCOLL_DICD_CODE. Source validation table: GTVDICD. Warehouse validation table: V_SCHOOL. |
| School_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in SCHOOL. Source: GTVDICD_DESC.
Note that the validation table V_SCHOOL has both a name and a long name. There is also a start and end date for the school long name. To get the most recent school long name, use the view V_SCHOOL_V. |
| Site Indexed - no
Format - Varchar2(3)
May be Null? Y | Site associated with the student's curriculum. Source field: SORLCUR_SITE_CODE. Source validation table: STVSITE. Warehouse validation table: V_SITE. |
| Site_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the code in SITE. Source: STVSITE_DESC. |
| St_Major_Minor_Pk Indexed - yes
Format - Varchar2(181)
May be Null? N | internal warehouse primary key, based on PIDM, DWLD_CURRIC_ID, SORLFOS_LCUR_SEQNO, TERM, LFST code and PRIORITY_NO |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term-by-term term for this field of study. Majors, minors, and concentrations (fields of study) are stored in the source system in "term-effective" records. These are converted into one record per term for each term the student is at Penn. |
| Term_Effective Indexed - no
Format - Varchar2(6)
May be Null? Y | The term-effective for this field of study. Source field: SORLFOS_TERM_CODE. |
