Penn Computing

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

XWALK_GTVSDAX Table - Data Element Index

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

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.

XWALK_GTVSDAX 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