Penn Computing

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

V_REG_STATUS Table - Data Element Index

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

Data element Definition
Action_Desc

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

used to populate the drop-down in Banner registration. Source field: STVRSTS_ACTION_DESC

Activity_Date

Indexed - no
Format - Date
May be Null? N

The latest date any part of this record was updated in the source. Source field: STVRSTS_ACTIVITY_DATE

Attempted_Hours_Ind

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

Indicates whether student's enrollment with this registration status is counted in their attempted hours. Source field: STVRSTS_ATTEMPT_HR_IND

Auto_Grade

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

Identifies the automatic grade assigned when the student has this registration status. Source field: STVRSTS_AUTO_GRADE

Entension_Ind

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

Indicates whether or not the registration status means the student has an extension. Source field: STVRSTS_EXTENSION_IND

Enterable_Ind

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

Indicates whether student with this registration status is allowed to enter a course. Source field: STVRSTS_ENTERABLE_IND

Gradable_Ind

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

Indicates whether student with this registration status will be graded for the course. Source field: STVRSTS_GRADABLE_IND

Include_Assess

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

Indicates whether student with this registration status is counted in course assessment. Source field: STVRSTS_INCL_ASSESS

Include_Sect_Enrl

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

Indicates whether student with this registration status is counted in course enrollment. Source field: STVRSTS_INCL_SECT_ENRL

Include_Timestatus_Ind

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

Indicates whether student's enrollment with this registration status is included in their time status calculation. Source field: STVRSTS_INCL_TMST_IND

Print_Ind

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

Print indicator. Source field: STVRSTS_SB_PRINT_IND

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

Date of the latest refresh of this warehouse table

Reg_Status_Code

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

The code for registration status of a student in a course section. Source field: STVRSTS_CODE

Reg_Status_Desc

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

Text description of the registration status code. Source field: STVRSTS_DESC

Reg_Status_Category

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

A categorization of registration status codes. R = status indicates student is registered in the course, D = status indicates student dropped course, W = status indicates student withdrew from course. Source field: STVRSTS_VOICE_TYPE

Waitlist_Ind

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

Indicates whether this registration status may be used to waitlist a student for a course. Source field: STVRSTS_WAIT_IND

Web_Ind

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

Web registration indicator. Source field: STVRSTS_WEB_IND

Withdraw_Ind

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

Indicates whether this registration status means the student has withdrawn from the course. Source field: STVRSTS_WITHDRAW_IND

V_REG_STATUS 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