Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_ACADEMIC_EVENT Table . Tables and Data Elements . Pennant Student Records Home Data Warehouse Home

ST_ACADEMIC_EVENT 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 last date any part of this record was updated in the source. Source field: SHREVNT_ACTIVITY_DATE.

Additional_Desc

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

Additional description of the event, entered only if the event code is 999.. Source field: SHREVNT_DESC.

Effective_Date

Indexed - no
Format - Date
May be Null? Y

Effective Date. Date on which event may print on students transcript. Source field: SHREVNT_EFFECTIVE_DATE.

Event_Code

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

Event Code. Transcript event code associated with the student. Source field: SHREVNT_EVEN_CODE.

Event_Desc

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

Text desciption of the student Event code. Source field: STVEVEN_DESC.

Event_Term

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

Free format field used to indicate the term in which this Event was put on the student's record. Source field: SHREVNT_GRADE.

Orig_Code

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

Originator Code. Originator code of person/office who entered the event code. Source field: SHREVNT_ORIG_CODE.

Orig_Desc

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

Text desciption of the Originator code. Source field: STVORIG_DESC.

Penn_Id

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

Penn's identity management system identification number. Source field: SPRIDEN_ID.

Pidm

Indexed - yes
Format - Number
May be Null? Y

Internal identification number. Source field: SHREVNT_PIDM.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The last date the table was refreshed in the warehouse

St_Academic_Event_Pk

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

internal warehouse primary key, based on PIDM, EVENT_CODE, ORIG_CODE, STUDENT_LEVEL, STATUS_OR_CRSE, EVENT_TERM, EFFECTIVE_DATE, ACTIVITY_DATE

Status_Or_Crse

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

Free format field used to indicate Status or Course. Source field: SHREVNT_DECISION.

Student_Level

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

Level Code. Students transcript level for the event.. Source field: SHREVNT_LEVL_CODE.

Student_Level_Desc

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

Text desciption of the Student Level code. Source field: STVLEVL_DESC.

ST_ACADEMIC_EVENT Table . Tables and Data Elements . 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