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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

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

NA

NA

 
ENTRY_IND Indicates whether the visa authorizes the person to enter the institution's home country.    

GORVISA

GORVISA_ENTRY_IND

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
NUMBER_OF_ENTRIES Number of entries into the country for the person.    

GORVISA

GORVISA_NO_ENTRIES

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

GORVISA

GORVISA_PIDM

 
POINT_OF_ENTRY Point of entry code of the person.    

GORVISA

GORVISA_PENT_CODE

 
POINT_OF_ENTRY_DESC Description for the port of entry code.    

FUNCTION

GOKODSF.F_GET_DESC

 
VISA_EXPIRE_DATE    

GORVISA

GORVISA_VISA_EXPIRE_DATE

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

GORVISA

GORVISA_VISA_ISSUE_DATE

 
VISA_ISSUING_AUTHORITY Agency location or other identifier for the authorization for this visa.    

GORVISA

GORVISA_VISS_CODE

 
VISA_ISSUING_AUTHORITY_DESC Description for the authorizing agency.    

FUNCTION

GOKODSF.F_GET_DESC

 
VISA_ISSUING_NATION Nation or country issuing the visa to this person.    

GORVISA

GORVISA_NATN_CODE_ISSUE

 
VISA_ISSUING_NATION_DESC Name of the nation or country issuing the visa.    

FUNCTION

GOKODSF.F_GET_DESC

 
VISA_NUMBER Government issued unique identification number assigned to this visa.    

GORVISA

GORVISA_VISA_NUMBER

 
VISA_REQ_DATE Date the visa was requested by the person.    

GORVISA

GORVISA_VISA_REQ_DATE

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

GORVISA

GORVISA_VISA_START_DATE

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

GORVISA

GORVISA_VTYP_CODE

 
VISA_TYPE_DESC Description for the type of visa for this person.    

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

 


Ver: 8.3