| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date this record was updated in the source. Source field: STVEVEN_ACTIVITY_DATE. |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | definition pending |
| 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. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date of the latest refresh of this warehouse table |
| Transcript_Disp_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates the information about the academic event should print on the student's transcript. Source field: STVEVEN_TRANS_IND. |
| Transcript_Event_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | Code for the academic or transcript event. Source field: STVEVEN_CODE.
Note: not all events are "transcript events" -- see the column Transcript_Disp_Ind. |
| Transcript_Event_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the event associated with the Transcript Event Code, for example Phi Beta Kappa, or Order of the Coif, etc. Source field: STVEVEN_DESC. |
| Transcript_Event_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | Custom long descriptive text of the transcript event code. Source field: UP_ST_UP_S_BANNER_LONG_DESC. LONG_DESC |
| V_Transcript_Event_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | internal warehouse primary key, based on event code and long description start term |
