| Data element |
Definition |
| Gtvsdax_Activity_Date Indexed - no
Format - Date
May be Null? Y | The last activity date for this row of data |
| Gtvsdax_Comments Indexed - no
Format - Varchar2(1000)
May be Null? Y | COMMENTS: Comments related to this entry. |
| Gtvsdax_Concept Indexed - no
Format - Varchar2(100)
May be Null? Y | CONCEPT: Conceptual usage grouping for this entry. |
| Gtvsdax_Data_Origin Indexed - no
Format - Varchar2(30)
May be Null? Y | DATA ORIGIN: Source system that created or updated the data. |
| Gtvsdax_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | The description of the SDA code/concept |
| Gtvsdax_External_Code Indexed - no
Format - Varchar2(15)
May be Null? Y | Banner/concept code for to be retrieved.
The following codes in Gtvsdax_External_Code indicate academic terms:
UP_CURTRM Current Academic Term
UP_HSGTRM Current Term for Housing
UP_NEXTRM Next Academic Term
UP_NXNXTRM Next Next Academic Term
UP_PPPRTRM Prev prev previous Acad Term
UP_PRPRTRM Previous previous Academic Ter
UP_PRVTRM Previous Academic Term
UP_PRYRTRM Equiv term in previous year
|
| Gtvsdax_Internal_Code Indexed - no
Format - Varchar2(10)
May be Null? Y | The pre-determined SDA retrieval code |
| Gtvsdax_Internal_Code_Group Indexed - no
Format - Varchar2(20)
May be Null? Y | The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too.
Note that for academic terms used in Pennant Student Records queries, the value in Gtvsdax_Internal_Code_Group will be 'ACADEMIC TERM' |
| Gtvsdax_Internal_Code_Seqno Indexed - no
Format - Number
May be Null? Y | The sequence number for internal codes requiring multiple values |
| Gtvsdax_Reporting_Date Indexed - no
Format - Date
May be Null? Y | The date column used for various reporting needs |
| Gtvsdax_Surrogate_Id Indexed - no
Format - Number
May be Null? Y | SURROGATE ID: Immutable unique key |
| Gtvsdax_Sysi_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | SYSTEM INDICATOR: Indicator which identifies the Banner System to which this entry belongs. |
| Gtvsdax_Sysreq_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | A Y in this field indicates that this row is required for production processing |
| Gtvsdax_Translation_Code Indexed - no
Format - Varchar2(15)
May be Null? Y | The hard-coded translation of the user defined external code, eg. Freshman, PUB for Public School, etc |
| Gtvsdax_User_Id Indexed - no
Format - Varchar2(30)
May be Null? Y | USER ID: User ID of the person who created or last updated the row. |
| Gtvsdax_Version Indexed - no
Format - Number
May be Null? Y | VERSION: Optimistic lock token. |
| Gtvsdax_Vpdi_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | VPDI CODE: Multi-entity processing code. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Last date the warehouse table was refreshed. |
| Xwalk_Gtvsdax_Pk Indexed - yes
Format - Varchar2(85)
May be Null? N | Primary key based on Internal Code Group, Internal Code Seqno, Internal_Code, and External Code. |
