Penn Computing

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

CRSE_SECT_RSTR_CLAS 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

The latest date the Course Classification Restriction information was updated in the source table SSRRCLS.

Classification

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

Code of a student classification for which registration restrictions exist. The INCL_EXCL_IND field specifies whether the classification is to be included or excluded. Source field: SSRRCLS_CLAS_CODE. Source validation table: STVCLAS. Data Warehouse validation table: V_CLASS.

Classification_Desc

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

Description of the Classification Code. Source: STVCLAS_CODE

Course_Id

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

Concatenation of the subject area and course number

Course_Num

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

Course Number of the course section. See also Course_Id and Section _Id

Crn

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

Course Reference Number for the course section in which there is a student classification restriction. Source: SSRRCLS_CRN

Crse_Sect_Rstr_Clas_Pk

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

internal primary key based on TERM_CODE, CRN, REC_TYPE, CLAS_IND, CLAS_CODE

Incl_Excl_Ind

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

Indicator for whether the student classification codes entered should be included or excluded in restricting the course. Valid values are: I - Include, E - Exclude. Source: SSRRCLS_CLAS_IND

Record_Type

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

Indicator for whether the record contains a student classification indicator or a student classification code. Valid values are: 1 - Student classification indicator, 2 - Student classification code. Source: SSRRCLS_REC_TYPE.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this warehouse table was refreshed.

Section_Id

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

Concatenation of the subject area, course number and section number

Section_Num

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

Section Number of the course section. See also Section_Id

Subject

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

Subject Area of the course section. See also Course_Id and Section _Id

Term

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

Term in which the student classification restriction is in effect, for the specified course section. Source: SSRRCLS_TERM_CODE

CRSE_SECT_RSTR_CLAS 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