Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_MAJOR_MINOR Table . Pennant Student Records Home . Data Warehouse Home

ST_MAJOR_MINOR Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

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_Catalog_Term

Indexed - no
Format - Varchar2(6)
May be Null? Y

The associated catalog term for the major or minor listed. Source field: SORLFOS_CATALOG_TERM.� Source validation table:� STVTERM. Warehouse validation table: V_TERM

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.

ST_MAJOR_MINOR Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania