Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_VISA

Description Source composite view contains data from the visa and international student data in the source system.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
CURRENT_DATE   System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DOMAIN_VALUE   Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

ENTRY_IND   Indicates whether the visa authorizes the person to enter the institution's home country. VARCHAR2(1)  

GORVISA

GORVISA_ENTRY_IND

MIF_DESC   Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)  

NA

NA

MIF_VALUE   Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)  

NA

NA

NUMBER_OF_ENTRIES   Number of entries into the country for the person. VARCHAR2(2)  

GORVISA

GORVISA_NO_ENTRIES

PERSON_UID   System generated, unique, internal identification number assigned to this person. NUMBER(8)  

GORVISA

GORVISA_PIDM

POINT_OF_ENTRY   Point of entry code of the person. VARCHAR2(3)  

GORVISA

GORVISA_PENT_CODE

POINT_OF_ENTRY_DESC   Description for the port of entry code. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

VISA_EXPIRE_DATE   DATE  

GORVISA

GORVISA_VISA_EXPIRE_DATE

VISA_ISSUE_DATE   Most recent date this person's visa was issued. DATE  

GORVISA

GORVISA_VISA_ISSUE_DATE

VISA_ISSUING_AUTHORITY   Agency location or other identifier for the authorization for this visa. VARCHAR2(6)  

GORVISA

GORVISA_VISS_CODE

VISA_ISSUING_AUTHORITY_DESC   Description for the authorizing agency. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

VISA_ISSUING_NATION   Nation or country issuing the visa to this person. VARCHAR2(5)  

GORVISA

GORVISA_NATN_CODE_ISSUE

VISA_ISSUING_NATION_DESC   Name of the nation or country issuing the visa. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

VISA_NUMBER   Government issued unique identification number assigned to this visa. VARCHAR2(18)  

GORVISA

GORVISA_VISA_NUMBER

VISA_REQ_DATE   Date the visa was requested by the person. DATE  

GORVISA

GORVISA_VISA_REQ_DATE

VISA_START_DATE   Current visa initial valid or begin date for this person. DATE  

GORVISA

GORVISA_VISA_START_DATE

VISA_TYPE   Identifies the type of visa issued to this person. May be student, employment, visitor, etc. VARCHAR2(2)  

GORVISA

GORVISA_VTYP_CODE

VISA_TYPE_DESC   Description for the type of visa for this person. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE   Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: