| 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. |
