Penn Computing

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

V_PROGRAM Table - Data Element Index

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

Data element Definition
Acad_Prog_Type

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

Defines the Type of Program for reporting purposes, used in the "Count Students As..." reports in the Data Warehouse.  Source field:  SORXREF_BANNER_VALUE

Acad_Prog_Type_Desc

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

Text description of the Academic Program Type. Source field:  SORXREF_DESC.

Activity_Date

Indexed - no
Format - Date
May be Null? Y

Last date the record was entered or updated in the source. Source field: SMRPRLE_ACTIVITY_DATE.

Campus

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

Campus associated with this program. Source field: SMRPRLE_CAMP_CODE.

Course_Level

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

Level associated with courses in this program. Source field: SMRPRLE_LEVL_CODE.

Credential_Ind

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

Indicates whether the program leads to the award of a credential or not. Values are 'CRDNTIAL' (Credential-granting program) or  NON_CRED (not a credential-granting program). Source field: SORXREF_EDI_QLFR.

Curriculum_Ind

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

Curriculum indicator. Source field: SMRPRLE_CURR_IND.

Curr_Rule_Ind

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

Curriculum rule indicator. Source field: SMRPRLE_CURR_RULE_IND.

Custom_Id

Indexed - no
Format - Number
May be Null? Y

description tbd

Degree

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

Degree associated with this program. Source field: SMRPRLE_DEGC_CODE.

Degree_Seeking_Ind

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

Indicates whether students in the program are seeking a degree.  A degree is a type of credential, but not all credentials are degrees.  Derived from multiple fields in SORXREF, where the program has a credential indication of "CRDNTIAL' and the program type is in 'Prof-Oth Degree','PhD-ResearchMas', or 'Traditional UG'.

Division

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

Division associated with this program. Source field: SMRPRLE_COLL_CODE.

Locked_Ind

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

Source field: SMRPRLE_LOCKED_IND.

Long_Desc_End_Term

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

The latest term the long description for the code is in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.END_TERM

Long_Desc_Start_Term

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

The earliest term the long description for the code was in effect. Source field: UP_ST_UP_S_BANNER_LONG_DESC.START_TERM.

Program_Code

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

Code for the Program. Source field: SMRPRLE_PROGRAM.

Program_Desc

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

Descriptive text title of the Program. Source field: SMRPRLE_PROGRAM_DESC.

Program_Desc_Long

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

Custom long descriptive text of the program code. Source field: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date this table in the warehouse was last refreshed.

Student_Level

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

Level associated with students in this program. Source field: SMRPRLE_LEVL_CODE_STU.

V_Program_Pk

Indexed - yes
Format - Varchar2(70)
May be Null? N

internal warehouse primary key

Web_Ind

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

Source field: SMRPRLE_WEB_IND.

V_PROGRAM 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