Penn Computing

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

ST_DEGREE_TERM_FLAT_MV Table - Data Element Index

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

Data element Definition
Admit_Term_1

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

The first term that the student was in this curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.ADMIT_TERM

Admit_Term_2

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

The first term that the student was in this curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.ADMIT_TERM

Admit_Term_3

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

The first term that the student was in this curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.ADMIT_TERM

Admit_Term_4

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

The first term that the student was in this curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.ADMIT_TERM

Attribute_Codes

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

A grouping of attribute codes associated with a given term for the student. Seperated by commas.

Campus_1

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

Campus associated with the student curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS

Campus_2

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

Campus associated with the student curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS

Campus_3

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

Campus associated with the student curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS

Campus_4

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

Campus associated with the student curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS

Campus_Desc_1

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

Campus description associated with the student curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS_DESC

Campus_Desc_2

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

Campus description associated with the student curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS_DESC

Campus_Desc_3

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

Campus description associated with the student curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS_DESC

Campus_Desc_4

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

Campus description associated with the student curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CAMPUS_DESC

Catalog_Term_1

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

The catalog term for the student degree. Program /Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CATALOG_TERM

Catalog_Term_2

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

The catalog term for the student degree. Program /Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CATALOG_TERM

Catalog_Term_3

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

The catalog term for the student degree. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CATALOG_TERM

Catalog_Term_4

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

The catalog term for the student degree. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CATALOG_TERM

Classification

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

Student classification calculated from total earned credits. This includes institutional credits along with transfer credits. Originally from: DWNGSS_PS.ST_TERM.ST_CLASSIFICATION

Cohort_Codes

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

A grouping of cohort codes associated with a given term for the student. Seperated by commas.

Concentration_1_1

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

If a concentration exists. Concentration tied to major code 1. Program/Degree 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_1_2

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

If a concentration exists. Concentration tied to major code 1. Program/Degree 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_1_3

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

If a concentration exists. Concentration tied to major code 1. Program/Degree 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_1_4

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

If a concentration exists. Concentration tied to major code 1. Program/Degree 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_2_1

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

If a concentration exists. Concentration tied to major code 2. Program/Degree 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_2_2

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

If a concentration exists. Concentration tied to major code 2. Program/Degree 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_2_3

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

If a concentration exists. Concentration tied to major code 2. Program/Degree 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_2_4

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

If a concentration exists. Concentration tied to major code 2. Program/Degree 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_3_1

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

If a concentration exists. Concentration tied to major code 3. Program/Degree 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_3_2

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

If a concentration exists. Concentration tied to major code 3. Program/Degree 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_3_3

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

If a concentration exists. Concentration tied to major code 3. Program/Degree 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_3_4

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

If a concentration exists. Concentration tied to major code 3. Program/Degree 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_4_1

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

If a concentration exists. Concentration tied to major code 4. Program/Degree 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_4_2

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

If a concentration exists. Concentration tied to major code 4. Program/Degree 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_4_3

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

If a concentration exists. Concentration tied to major code 4. Program/Degree 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Concentration_4_4

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

If a concentration exists. Concentration tied to major code 4. Program/Degree 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.CONCENTRATION

Credential_Ind_1

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

Code that describes if program is considered credential seeking. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CREDENTIAL_IND

Credential_Ind_2

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

Code that describes if program is considered credential seeking. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CREDENTIAL_IND

Credential_Ind_3

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

Code that describes if program is considered credential seeking. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CREDENTIAL_IND

Credential_Ind_4

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

Code that describes if program is considered credential seeking. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CREDENTIAL_IND

Curric_Grad_This_Term_1

Indexed - no
Format - Char (1)
May be Null? Y

Indicator if program/degree 1 graduated this term. Originally from DWNGSS_PS.ST_DEGREE_TERM.CURRIC_GRAD_THIS_TERM.

Curric_Grad_This_Term_2

Indexed - no
Format - Char (1)
May be Null? Y

Indicator if program/degree 2 graduated this term. Originally from DWNGSS_PS.ST_DEGREE_TERM.CURRIC_GRAD_THIS_TERM.

Curric_Grad_This_Term_3

Indexed - no
Format - Char (1)
May be Null? Y

Indicator if program/degree 3 graduated this term. Originally from DWNGSS_PS.ST_DEGREE_TERM.CURRIC_GRAD_THIS_TERM.

Curric_Grad_This_Term_4

Indexed - no
Format - Char (1)
May be Null? Y

Indicator if program/degree 4 graduated this term. Originally from DWNGSS_PS.ST_DEGREE_TERM.CURRIC_GRAD_THIS_TERM.

Curric_On_Leave_This_Term_1

Indexed - no
Format - Char (1)
May be Null? Y

Indicates the student is on leave for this curriculm this term. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CURRIC_ON_LEAVE_THIS_TERM

Curric_On_Leave_This_Term_2

Indexed - no
Format - Char (1)
May be Null? Y

Indicates the student is on leave for this curriculm this term. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CURRIC_ON_LEAVE_THIS_TERM

Curric_On_Leave_This_Term_3

Indexed - no
Format - Char (1)
May be Null? Y

Indicates the student is on leave for this curriculm this term. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CURRIC_ON_LEAVE_THIS_TERM

Curric_On_Leave_This_Term_4

Indexed - no
Format - Char (1)
May be Null? Y

Indicates the student is on leave for this curriculm this term. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.CURRIC_ON_LEAVE_THIS_TERM

Degree_Code_1

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

Degree code on the students curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_CODE

Degree_Code_2

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

Degree code on the students curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_CODE

Degree_Code_3

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

Degree code on the students curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_CODE

Degree_Code_4

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

Degree code on the students curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_CODE

Degree_Desc_1

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

Degree description. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_DESC

Degree_Desc_2

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

Degree description. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_DESC

Degree_Desc_3

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

Degree description. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_DESC

Degree_Desc_4

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

Degree description. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_DESC

Degree_Level_1

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

The level associated with degree code 1. Originally DWNGSS_PS.ST_DEGREE_TERM.DEGREE_LEVEL.

Degree_Level_2

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

The level associated with degree code 2. Originally DWNGSS_PS.ST_DEGREE_TERM.DEGREE_LEVEL.

Degree_Level_3

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

The level associated with degree code 3. Originally DWNGSS_PS.ST_DEGREE_TERM.DEGREE_LEVEL.

Degree_Level_4

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

The level associated with degree code 4. Originally DWNGSS_PS.ST_DEGREE_TERM.DEGREE_LEVEL.

Degree_Seeking_1

Indexed - no
Format - Char (1)
May be Null? Y

Indicator showing that the program is considered degree seeking. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_SEEKING_IND

Degree_Seeking_2

Indexed - no
Format - Char (1)
May be Null? Y

Indicator showing that the program is considered degree seeking. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_SEEKING_IND

Degree_Seeking_3

Indexed - no
Format - Char (1)
May be Null? Y

Indicator showing that the program is considered degree seeking. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_SEEKING_IND

Degree_Seeking_4

Indexed - no
Format - Char (1)
May be Null? Y

Indicator showing that the program is considered degree seeking. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DEGREE_SEEKING_IND

Dissertation_Term_Count

Indexed - no
Format - Number (22)
May be Null? Y

Indicates number of terms a student was on dissertation. Originally from: DWNGSS_PS.ST_TERM.DISSERTATION_TERM_COUNT

Division_1

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

Division code on the students curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION

Division_2

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

Division code on the students curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION

Division_3

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

Division code on the students curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION

Division_4

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

Division code on the students curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION

Division_Desc_1

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

Division description on the students curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION_DESC

Division_Desc_2

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

Division description on the students curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION_DESC

Division_Desc_3

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

Division description on the students curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION_DESC

Division_Desc_4

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

Division description on the students curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.DIVISION_DESC

Dual_Degree_Cohort

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

If a student is part of a dual degree program, the cohort they belong to is listed here. Originally from: DWNGSS_PS.ST_COHORT.COHORT

Dual_Degree_Cohort_Desc

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

The description of the dual degree cohort that the student is part of. Originally from: DWNGSS_PS.ST_COHORT.COHORT_DESC

Dual_Joint_Sub_Desc

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

Description that indicates the student is in some type of multiple overlapping curriculum this term. Originally from: DWNGSS_PS.ST_TERM.DUAL_JOINT_SUB_DESC

Dual_Joint_Sub_Ind

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

Code that indicates the student is in some type of multiple overlapping curriculum this term. Originally from: DWNGSS_PS.ST_TERM.DUAL_JOINT_SUB_IND

Dwld_Curric_Id_1

Indexed - no
Format - Number (22)
May be Null? Y

Internal number, used only in Penns 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 degree term rowas that belong to the same curriculum. Program/Degree 1. Originally from: DWNGSS_PS.ST_DEGREE_TERM.DWLD_CURRIC_ID

Dwld_Curric_Id_2

Indexed - no
Format - Number (22)
May be Null? Y

Internal number, used only in Penns 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 degree term rowas that belong to the same curriculum. Program/Degree 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.DWLD_CURRIC_ID

Dwld_Curric_Id_3

Indexed - no
Format - Number (22)
May be Null? Y

Internal number, used only in Penns 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 degree term rowas that belong to the same curriculum. Program/Degree 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.DWLD_CURRIC_ID

Dwld_Curric_Id_4

Indexed - no
Format - Number (22)
May be Null? Y

Internal number, used only in Penns 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 degree term rowas that belong to the same curriculum. Program/Degree 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.DWLD_CURRIC_ID

Enrolled_This_Term

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

Y/N indicator that shows if the student is continuously enrolled for the term. The difference between the REGISTERED_THIS_TERM and ENROLLED_THIS_TERM is that if a student registered for courses and participated but then withdrew from all courses, the ENROLLED_THIS_TERM indicator is listed as a N.

Exit_Action_1

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

The exit action code for the term. Noe that the graduation is not considered an exit action. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION

Exit_Action_2

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

The exit action code for the term. Noe that the graduation is not considered an exit action. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION

Exit_Action_3

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

The exit action code for the term. Noe that the graduation is not considered an exit action. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION

Exit_Action_4

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

The exit action code for the term. Noe that the graduation is not considered an exit action. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION

Exit_Action_Desc_1

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

The exit action description for the term. Noe that the graduation is not considered an exit action. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION_DESC

Exit_Action_Desc_2

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

The exit action description for the term. Noe that the graduation is not considered an exit action. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION_DESC

Exit_Action_Desc_3

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

The exit action description for the term. Noe that the graduation is not considered an exit action. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION_DESC

Exit_Action_Desc_4

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

The exit action description for the term. Noe that the graduation is not considered an exit action. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_ACTION_DESC

Exit_Date_1

Indexed - no
Format - Date (7)
May be Null? Y

Date the student exited from this curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_DATE

Exit_Date_2

Indexed - no
Format - Date (7)
May be Null? Y

Date the student exited from this curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_DATE

Exit_Date_3

Indexed - no
Format - Date (7)
May be Null? Y

Date the student exited from this curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_DATE

Exit_Date_4

Indexed - no
Format - Date (7)
May be Null? Y

Date the student exited from this curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_DATE

Exit_Reason_1

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

The exit reason code associated with the exit action for degree/program 1 within term code.

Exit_Reason_2

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

The exit reason code associated with the exit action for degree/program 2 within term code.

Exit_Reason_3

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

The exit reason code associated with the exit action for degree/program 3 within term code.

Exit_Reason_4

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

The exit reason code associated with the exit action for degree/program 4 within term code.

Exit_Reason_Desc_1

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

The exit reason description associated with the exit action for degree/program 1 within term code.

Exit_Reason_Desc_2

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

The exit reason description associated with the exit action for degree/program 2 within term code.

Exit_Reason_Desc_3

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

The exit reason description associated with the exit action for degree/program 3 within term code.

Exit_Reason_Desc_4

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

The exit reason description associated with the exit action for degree/program 4 within term code.

Exit_Term_1

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

Term the student exicited this curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_TERM

Exit_Term_2

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

Term the student exicited this curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_TERM

Exit_Term_3

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

Term the student exicited this curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_TERM

Exit_Term_4

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

Term the student exicited this curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXIT_TERM

Exp_Grad_Date_1

Indexed - no
Format - Date (7)
May be Null? Y

Expected graduation date for program/degree 1. Primary degee. Originally from: DWNGSS_PS.ST_DEGREE_TERM. EXP_GRAD_DATE

Exp_Grad_Date_2

Indexed - no
Format - Date (7)
May be Null? Y

Expected graduation date for Program/Degree 2. Primary degee. Originally from: DWNGSS_PS.ST_DEGREE_TERM. EXP_GRAD_DATE

Exp_Grad_Date_3

Indexed - no
Format - Date (7)
May be Null? Y

Expected graduation date for Program/Degree 3. Primary degee. Originally from: DWNGSS_PS.ST_DEGREE_TERM. EXP_GRAD_DATE

Exp_Grad_Date_4

Indexed - no
Format - Date (7)
May be Null? Y

Expected graduation date for Program/Degree 4. Primary degee. Originally from: DWNGSS_PS.ST_DEGREE_TERM. EXP_GRAD_DATE

Exp_Grad_Term_1

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

Expected graduation term for program/degree 1. Primary degree Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_DEGREE_TERM

Exp_Grad_Term_2

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

Expected graduation term for Program/Degree 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_DEGREE_TERM

Exp_Grad_Term_3

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

Expected graduation term for Program/Degree 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_DEGREE_TERM

Exp_Grad_Term_4

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

Expected graduation term for Program/Degree 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_DEGREE_TERM

Exp_Return_Date_1

Indexed - no
Format - Date (7)
May be Null? Y

Date the student expects to return to this curriculm. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_DATE

Exp_Return_Date_2

Indexed - no
Format - Date (7)
May be Null? Y

Date the student expects to return to this curriculm. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_DATE

Exp_Return_Date_3

Indexed - no
Format - Date (7)
May be Null? Y

Date the student expects to return to this curriculm. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_DATE

Exp_Return_Date_4

Indexed - no
Format - Date (7)
May be Null? Y

Date the student expects to return to this curriculm. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_DATE

Exp_Return_Term_1

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

Term the student exicited this curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_TERM

Exp_Return_Term_2

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

Term the student exicited this curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_TERM

Exp_Return_Term_3

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

Term the student exicited this curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_TERM

Exp_Return_Term_4

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

Term the student exicited this curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.EXP_RETURN_TERM

Fulltime_Parttime

Indexed - no
Format - Char (1)
May be Null? Y

Code computed from the Time Status indiating whether the student is full time or not this term. Originally from: DWNGSS_PS.ST_TERM.FULLTIME_PARTIME

Graduation_Date_1

Indexed - no
Format - Date (7)
May be Null? Y

Graduation date for a student with program 1. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_DATE

Graduation_Date_2

Indexed - no
Format - Date (7)
May be Null? Y

Graduation date for a student with program 2. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_DATE

Graduation_Date_3

Indexed - no
Format - Date (7)
May be Null? Y

Graduation date for a student with program 3. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_DATE

Graduation_Date_4

Indexed - no
Format - Date (7)
May be Null? Y

Graduation date for a student with program 4. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_DATE

Graduation_Status_1

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

Graduation status code associated with program 1. This status will indicate if the degree was awareded, if the student applied for graduation, etc. It could be blank for students who have not taken any action for graduation. Primary degree. Originally from: DWGNSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS

Graduation_Status_2

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

Graduation status code associated with program 2. This status will indicate if the degree was awareded, if the student applied for graduation, etc. It could be blank for students who have not taken any action for graduation. Originally from: DWGNSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS

Graduation_Status_3

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

Graduation status code associated with program 3. This status will indicate if the degree was awareded, if the student applied for graduation, etc. It could be blank for students who have not taken any action for graduation. Originally from: DWGNSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS

Graduation_Status_4

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

Graduation status code associated with program 4. This status will indicate if the degree was awareded, if the student applied for graduation, etc. It could be blank for students who have not taken any action for graduation. Originally from: DWGNSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS

Graduation_Status_Desc_1

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

Graduation status description with program 1. Primary degree Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS_DESC

Graduation_Status_Desc_2

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

Graduation status description with program 2. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS_DESC

Graduation_Status_Desc_3

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

Graduation status description with program 3. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS_DESC

Graduation_Status_Desc_4

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

Graduation status description with program 4. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_STATUS_DESC

Graduation_Term_1

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

Graduation term for a student with program 1. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_TERM

Graduation_Term_2

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

Graduation term for a student with program 2. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_TERM

Graduation_Term_3

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

Graduation term for a student with program 3. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_TERM

Graduation_Term_4

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

Graduation term for a student with program 4. Originally from: DWNGSS_PS.ST_DEGREE_OUTCOME.GRADUATION_TERM

Major_1_1

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

Major code 1 for program 1. Primary major for primary program. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_1_2

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

Major code 1 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_1_3

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

Major code 1 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_1_4

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

Major code 1 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_2_1

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

Major code 2 for program 1. Second major within primary program. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_2_2

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

Major code 2 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_2_3

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

Major code 2 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_2_4

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

Major code 2 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_3_1

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

Major code 3 for program 1. Third major within primary program. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_3_2

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

Major code 3 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_3_3

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

Major code 3 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_3_4

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

Major code 3 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_4_1

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

Major code 4 for program 1. Fourth major within primary program. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_4_2

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

Major code 4 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_4_3

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

Major code 4 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_4_4

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

Major code 4 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Major_Desc_1_1

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

Major description 1 for program 1. Primary major for primary program Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_1_2

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

Major description 1 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_1_3

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

Major description 1 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_1_4

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

Major description 1 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_2_1

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

Major description 2 for program 1. Second major within primary program. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_2_2

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

Major description 2 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_2_3

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

Major description 2 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_2_4

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

Major description 2 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_3_1

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

Major description 3 for program 1. Third major within primary program. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_3_2

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

Major description 3 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_3_3

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

Major description 3 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_3_4

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

Major description 3 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_4_1

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

Major description 4 for program 1. Fourth major within primary program. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_4_2

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

Major description 4 for program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_4_3

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

Major description 4 for program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Major_Desc_4_4

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

Major description 4 for program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR_DESC

Minor_1_1

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

Minor 1 associated with program 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_1_2

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

Minor 1 associated with program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_1_3

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

Minor 1 associated with program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_1_4

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

Minor 1 associated with program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_2_1

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

Minor 2 associated with program 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_2_2

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

Minor 2 associated with program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_2_3

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

Minor 2 associated with program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_2_4

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

Minor 2 associated with program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_3_1

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

Minor 2 associated with program 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_3_2

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

Minor 2 associated with program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_3_3

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

Minor 2 associated with program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_3_4

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

Minor 2 associated with program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_4_1

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

Minor 3 associated with program 1. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_4_2

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

Minor 3 associated with program 2. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_4_3

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

Minor 3 associated with program 3. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Minor_4_4

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

Minor 3 associated with program 4. Originally from: DWNGSS_PS.ST_MAJOR_MINOR.MAJOR_MINOR

Mv_Refresh_Date

Indexed - no
Format - Date (7)
May be Null? Y

A date that indicates when the materialized view was last refreshed. Originally from: SYSDATE

Next_Next_Term

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

Term code that represents the next-next term.

Next_Next_Term_Reg

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

A Y/N indicator that shows if a student is registered for the next-next term.

Next_Term

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

Term code that represents next term after the term record.

Next_Term_Reg

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

A Y/N indicator that shows if a student is registered for courses for the next term.

On_Dissertation

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

Indicator showing that the student is on dissertation for the term. Originally from: DWNGSS_PS.ST_TERM.ON_DISSERTATION

On_Masters_Thesis

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

Indicates if a student is working on their masters thesis for the term. Originally from: DWNGSS_PS.ST_TERM.ON_MASTERS_THESIS

Penn_Classification

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

Student classification for credits at Penn as identified in their term attributes. Originally from: DWNGSS_PS.ST_TERM.PENN_CLASSIFICATION

Penn_Id

Indexed - yes
Format - Varchar2 (36)
May be Null? Y

Penns identity management systems ID. Originally from DWNGSS_PS.ST_DEGREE_TERM.

Phd_Term_1

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

Number of terms that the student is working on their PHD for program/degree 1. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM

Phd_Term_2

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

Number of terms that the student is working on their PHD for program/degree 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM

Phd_Term_3

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

Number of terms that the student is working on their PHD for program/degree 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM

Phd_Term_4

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

Number of terms that the student is working on their PHD for program/degree 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM

Phd_Term_Desc_1

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

A description of the attribute code used to discribe the number of terms a student has been working on their PHD for program/degree 1. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM_DESC

Phd_Term_Desc_2

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

A description of the attribute code used to discribe the number of terms a student has been working on their PHD for program/degree 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM_DESC

Phd_Term_Desc_3

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

A description of the attribute code used to discribe the number of terms a student has been working on their PHD for program/degree 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM_DESC

Phd_Term_Desc_4

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

A description of the attribute code used to discribe the number of terms a student has been working on their PHD for program/degree 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PHD_TERM_DESC

Pidm

Indexed - no
Format - Number (22)
May be Null? Y

Banner internal identification number. Originally from DWNGSS_PS.ST_DEGREE_TERM.

Program_Code_1

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

The program code associated with the student curriculum. Program/Degree 1. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_CODE

Program_Code_2

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

The program code associated with the student curriculum. Program/Degree 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_CODE

Program_Code_3

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

The program code associated with the student curriculum. Program/Degree 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_CODE

Program_Code_4

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

The program code associated with the student curriculum. Program/Degree 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_CODE

Program_Desc_1

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

The program description associated with the student curriculum. Program/Degree 1. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_DESC

Program_Desc_2

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

The program description associated with the student curriculum. Program/Degree 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_DESC

Program_Desc_3

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

The program description associated with the student curriculum. Program/Degree 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_DESC

Program_Desc_4

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

The program description associated with the student curriculum. Program/Degree 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.PROGRAM_DESC

Rate_Code

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

Code for the rate to be used by the billing team. Originally from: DWNGSS_PS.ST_TERM.RATE_CODE

Rate_Desc

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

Descirption for the rate to be used by the billing team. Originally from: DWNGSS_PS.ST_TERM.RATE_DESC

Registered_Credit_Bu

Indexed - no
Format - Number (22)
May be Null? Y

Number of Banner creidt units a student is registered for the term. Originally from: DWNGSS_PS.ST_TERM.REGISTERED_CREDIT_BU

Registered_This_Term

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

Y/N indicator that indicates if a student was ever regsitered and attended a course for the term.

Residency

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

Code used by the School of Veterinary Medicine to determine residency. Originally from: DWNGSS_PS.ST_TERM.RESIDENCY

Residency_Desc

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

Description used by the School of Veterinary Medicine to determine residency. Originally from: DWNGSS_PS.ST_TERM.RESIDENCY_DESC

School_1

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

School code associated with the division code on the students curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL

School_2

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

School code associated with the division code on the students curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL

School_3

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

School code associated with the division code on the students curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL

School_4

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

School code associated with the division code on the students curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL

School_Desc_1

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

School description associated with the division code on the students curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL_DESC

School_Desc_2

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

School description associated with the division code on the students curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL_DESC

School_Desc_3

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

School description associated with the division code on the students curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL_DESC

School_Desc_4

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

School description associated with the division code on the students curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SCHOOL_DESC

Site_1

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

Site associated with the students curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE

Site_2

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

Site associated with the students curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE

Site_3

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

Site associated with the students curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE

Site_4

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

Site associated with the students curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE

Site_Desc_1

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

Site description with the students curriculum. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE_DESC

Site_Desc_2

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

Site description with the students curriculum. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE_DESC

Site_Desc_3

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

Site description with the students curriculum. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE_DESC

Site_Desc_4

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

Site description with the students curriculum. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.SITE_DESC

Student_Level_1

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

The level associated with the degree code. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.STUDENT_LEVEL

Student_Level_2

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

The level associated with the degree code. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.STUDENT_LEVEL

Student_Level_3

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

The level associated with the degree code. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.STUDENT_LEVEL

Student_Level_4

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

The level associated with the degree code. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.STUDENT_LEVEL

Student_Status

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

The student status for the term. Originally from DWNGSS_PS.ST_TERM.

Student_Status_Desc

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

The description of the student status for the term. Originally from DWNGSS_PS.ST_TERM.

Student_Type

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

Student type code that indicates the student type for the term. The student type may change from term-to-term based on the record from the source field. Originally from: DWNGSS_PS.ST_TERM.STUDENT_TYPE

Student_Type_Desc

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

A description of the student type for a given term. Originally from: DWNGSS_PS.ST_TERM.STUDENT_TYPE_DESC

Term

Indexed - yes
Format - Varchar2 (24)
May be Null? Y

Term code associated with record. Originally from DWNGSS_PS.ST_DEGREE_TERM.

Term_Attempted_Credit_1

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits for program/degree 1. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_ATTEMPTED_CREDITS.

Term_Attempted_Credit_2

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits for program/degree 2. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_ATTEMPTED_CREDITS.

Term_Attempted_Credit_3

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits for program/degree 3. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_ATTEMPTED_CREDITS.

Term_Attempted_Credit_4

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits for program/degree 4. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_ATTEMPTED_CREDITS.

Term_Attempted_Credit_Bu_1

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits in Banner units for program/degree 1. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PSST_.DEGREE_TERM.TERM_ATTEMPTED_CREDITS_BU.

Term_Attempted_Credit_Bu_2

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits in Banner units for program/degree 2. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PSST_.DEGREE_TERM.TERM_ATTEMPTED_CREDITS_BU.

Term_Attempted_Credit_Bu_3

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits in Banner units for program/degree 3. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PSST_.DEGREE_TERM.TERM_ATTEMPTED_CREDITS_BU.

Term_Attempted_Credit_Bu_4

Indexed - no
Format - Number (22)
May be Null? Y

Term attempted credits in Banner units for program/degree 4. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PSST_.DEGREE_TERM.TERM_ATTEMPTED_CREDITS_BU.

Term_Cumulative_Gpa_1

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative GPA by Program 1 level. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUMULATIVE_GPA

Term_Cumulative_Gpa_2

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative GPA by Program 2 level. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUMULATIVE_GPA

Term_Cumulative_Gpa_3

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative GPA by Program 3 level. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUMULATIVE_GPA

Term_Cumulative_Gpa_4

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative GPA by Program 4 level. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUMULATIVE_GPA

Term_Cum_Earned_Credit_1

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned credit units up to term code. Program 1. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT

Term_Cum_Earned_Credit_2

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned credit units up to term code. Program 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT

Term_Cum_Earned_Credit_3

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned credit units up to term code. Program 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT

Term_Cum_Earned_Credit_4

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned credit units up to term code. Program 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT

Term_Cum_Earned_Credit_Bu_1

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned Banner credit units up to term code. Program 1. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT_BU

Term_Cum_Earned_Credit_Bu_2

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned Banner credit units up to term code. Program 2. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT_BU

Term_Cum_Earned_Credit_Bu_3

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned Banner credit units up to term code. Program 3. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT_BU

Term_Cum_Earned_Credit_Bu_4

Indexed - no
Format - Number (22)
May be Null? Y

Cumulative earned Banner credit units up to term code. Program 4. Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_CUM_EARNED_CREDIT_BU

Term_Earned_Credit_1

Indexed - no
Format - Number (22)
May be Null? Y

Term earned redits for program/degree 1. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS.

Term_Earned_Credit_2

Indexed - no
Format - Number (22)
May be Null? Y

Term earned redits for program/degree 2. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS.

Term_Earned_Credit_3

Indexed - no
Format - Number (22)
May be Null? Y

Term earned redits for program/degree 3. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS.

Term_Earned_Credit_4

Indexed - no
Format - Number (22)
May be Null? Y

Term earned redits for program/degree 4. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS.

Term_Earned_Credit_Bu_1

Indexed - no
Format - Number (22)
May be Null? Y

Term earned credits in Banner units for program/degree 1. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS_BU.

Term_Earned_Credit_Bu_2

Indexed - no
Format - Number (22)
May be Null? Y

Term earned credits in Banner units for program/degree 2. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS_BU.

Term_Earned_Credit_Bu_3

Indexed - no
Format - Number (22)
May be Null? Y

Term earned credits in Banner units for program/degree 3. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS_BU.

Term_Earned_Credit_Bu_4

Indexed - no
Format - Number (22)
May be Null? Y

Term earned credits in Banner units for program/degree 4. This is for the term and not the cumulative attempted credits. Originally from DWNGSS_PS.ST_DEGREE_TERM.TERM_EARNED_CREDITS_BU.

Term_Entry_Action_1

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

Admit code or entering action for this term. Program/Degree 1 Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_ENTRY_ACTION

Term_Entry_Action_2

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

Admit code or entering action for this term. Program/Degree 2 Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_ENTRY_ACTION

Term_Entry_Action_3

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

Admit code or entering action for this term. Program/Degree 3 Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_ENTRY_ACTION

Term_Entry_Action_4

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

Admit code or entering action for this term. Program/Degree 4 Originally from: DWNGSS_PS.ST_DEGREE_TERM.TERM_ENTRY_ACTION

Term_Gpa_1

Indexed - no
Format - Number (22)
May be Null? Y

Term GPA for program/degree 1. This is not a cumulative GPA. Originally from DWNGSS_PS.ST_DEGREE_TERM

Term_Gpa_2

Indexed - no
Format - Number (22)
May be Null? Y

Term GPA for program/degree 2. This is not a cumulative GPA. Originally from DWNGSS_PS.ST_DEGREE_TERM

Term_Gpa_3

Indexed - no
Format - Number (22)
May be Null? Y

Term GPA for program/degree 3. This is not a cumulative GPA. Originally from DWNGSS_PS.ST_DEGREE_TERM

Term_Gpa_4

Indexed - no
Format - Number (22)
May be Null? Y

Term GPA for program/degree 4. This is not a cumulative GPA. Originally from DWNGSS_PS.ST_DEGREE_TERM

Time_Status

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

Code for students time status, for example, FT, HT, 3Q, etc. Originally from: DWNGSS_PS.ST_TERM.TIME_STATUS

Time_Status_Desc

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

Description of a student time status that explains the time status codes. Originally from: DWNGSS_PS.ST_TERM.TIME_STATUS_DESC

ST_DEGREE_TERM_FLAT_MV 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