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

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 Definition Database Data Type Source Name Source Column Local Source Local Target
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

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

NA

NA

NO

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

GORVISA

GORVISA_ENTRY_IND

NO

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

NA

NA

NO

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

NA

NA

NO

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

GORVISA

GORVISA_NO_ENTRIES

NO

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

GORVISA

GORVISA_PIDM

NO

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

GORVISA

GORVISA_PENT_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
VISA_EXPIRE_DATE . DATE

GORVISA

GORVISA_VISA_EXPIRE_DATE

NO

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

GORVISA

GORVISA_VISA_ISSUE_DATE

NO

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

GORVISA

GORVISA_VISS_CODE

NO

NO
VISA_ISSUING_AUTHORITY_DESC Description for the authorizing agency. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

GORVISA

GORVISA_NATN_CODE_ISSUE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

GORVISA

GORVISA_VISA_NUMBER

NO

NO
VISA_REQ_DATE Date the visa was requested by the person. DATE

GORVISA

GORVISA_VISA_REQ_DATE

NO

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

GORVISA

GORVISA_VISA_START_DATE

NO

NO
VISA_TYPE Type of visa issued to this person. For example, student, employment, visitor, etc. VARCHAR2(2)

GORVISA

GORVISA_VTYP_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NA

NA

NO

NO


Ver: