Data element |
Definition |
Activity_Date Indexed - no Format - Date May be Null? Y | The latest date the record was 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. |
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 CONCENTRATION code. |
Coord_Multi_Degr Indexed - no
Format - Varchar2(10) May be Null? Y | Indicates student is in a coordinated multiple degree program. Values like 'Z%' or null. |
Coord_Multi_Degr_Desc Indexed - no
Format - Varchar2(30) May be Null? Y | Text description of the code in COHORT. |
Curric_Activity Indexed - no
Format - Varchar2(20) 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 warehouse table contains 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(20) 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: STVDEGC_DESC |
Degree_Order Indexed - no Format - Number May be Null? Y | Degree order number from the corresponding curriculum record. |
Deg_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, and similarly can be used to join majors to degree outcomes. 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 |
Dwld_Curric_Id Indexed - yes Format - Number May be Null? Y | Data Warehouse internal identifier for a unique curriculum for a student, based on Penn's business rules for the definition
of "degree pursual." This field does not exist in the Banner source database, nor should it be used outside of warehouse queries.
It is calculated as part of the data load, and can change, so should not ever be used as a static data point. |
Major_Desc Indexed - no
Format - Varchar2(30) May be Null? Y | Text description of the MAJOR code |
Major_Minor Indexed - yes
Format - Varchar2(4) May be Null? Y | Major (or Minor) code for this Field of Study. Source field: SORLFOS_MAJR_CODE. Source validation table: STVMAJR. Warehouse validation table: V_MAJOR_MINOR |
Major_Minor_Order Indexed - yes Format - Number May be Null? Y | Used to identify the primary major, and one or more additional concurrent majors. Aside from the Primary which is always the lowest number, the other order numbers should not be interpreted as having any rank or priority ordering.
Values: 10, 20, 30, etc.
Source: SORLFOS_PRIORITY_NO
|
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_Type Indexed - yes
Format - Varchar2(20) May be Null? Y | Field of Study type code (Major or Minor). Source field: SORLFOS_LFST_CODE. |
Maj_Min_Seq_Num Indexed - no Format - Number May be Null? Y | Internal sequence number of the field of study record. Source field: SORLFOS_SEQNO. |
Penn_Id Indexed - yes Format - Varchar2(36) May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID. |
Pidm Indexed - yes Format - Number May be Null? Y | Banner internal identification number. Source field: SHRDGMR_PIDM. |
Program_Code Indexed - no
Format - Varchar2(12) May be Null? Y | Program code from the corresponding curriculum record. Source field: SORLCUR_PROGRAM. |
Program_Desc Indexed - no
Format - Varchar2(30) May be Null? Y | Text description of the code in PROGRAM. |
Refresh_Date Indexed - no Format - Date May be Null? Y | The latest date the warehouse table was refreshed. |
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 |
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_Deg_Outcome_Major_Pk Indexed - yes
Format - Varchar2(181) May be Null? N | internal warehouse primary key. Based on PIDM, DWLD_CURRIC_ID, TERM, DEGREE_TERM_SEQNO, MAJOR_MINOR_TYPE, MAJOR_MINOR_ORDER |
Term Indexed - no
Format - Varchar2(6) May be Null? Y | Term Code. The term associated with the general student record when degree information is defaulted. Source field: SHRDGMR_TERM_CODE_STUREC. |
Term_Effective Indexed - no
Format - Varchar2(6) May be Null? Y | the term-effective for this field of study. Source: SORLFOS_TERM_CODE. |