| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
ENTRY_IND
 | 
Entry Indicator 
 | 
Indicates whether the visa authorizes the person to enter the institution's home country.
 | 
VARCHAR2(1)
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_ENTRY_IND
 
 | 
| 
ID
 | 
ID
 | 
Person's or organization's current identification number.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
MULTI_SOURCE
 | 
Multi Source 
 | 
Institution value for the record when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(63)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
Institution description when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
NAME
 | 
Name
 | 
Name of the person (last name, first name, middle initial) or organization.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 MGKFUNC.F_GET_PERSON_INFO
 
 | 
| 
NUMBER_OF_ENTRIES
 | 
Number Of Entries 
 | 
Number of entries into the country for the person.
 | 
VARCHAR2(2)
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_NO_ENTRIES
 
 | 
| 
PERSON_UID
 | 
Person UID 
 | 
System generated, unique, internal identification number assigned to this person.
 | 
NUMBER
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_PIDM
 
 | 
| 
POINT_OF_ENTRY
 | 
Point Of Entry 
 | 
Point of entry code of the person.
 | 
VARCHAR2(63)
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_PENT_CODE
 
 | 
| 
POINT_OF_ENTRY_DESC
 | 
Point Of Entry Description 
 | 
Port of entry code description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
VISA_EXPIRE_DATE
 | 
Visa Expire Date 
 | 
Current date this person's visa expires.
 | 
DATE
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_VISA_EXPIRE_DATE
 
 | 
| 
VISA_ISSUE_DATE
 | 
Visa Issue Date 
 | 
Most recent date this person's visa was issued.
 | 
DATE
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_VISA_ISSUE_DATE
 
 | 
| 
VISA_ISSUING_AUTHORITY
 | 
Visa Issuing Authority 
 | 
Agency location or other identifier for the authorization for this visa.
 | 
VARCHAR2(63)
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_VISS_CODE
 
 | 
| 
VISA_ISSUING_AUTHORITY_DESC
 | 
Visa Issuing Authority Description 
 | 
Description of the agency that authorized the person's visa.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
VISA_ISSUING_NATION
 | 
Visa Issuing Nation 
 | 
Nation or country issuing the visa to this person.
 | 
VARCHAR2(63)
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_NATN_CODE_ISSUE
 
 | 
| 
VISA_ISSUING_NATION_DESC
 | 
Visa Issuing Nation Description 
 | 
Nation or country description that issued the visa.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
VISA_NUMBER
 | 
Visa Number 
 | 
Government issued unique identification number assigned to this visa.
 | 
VARCHAR2(18)
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_VISA_NUMBER
 
 | 
| 
VISA_REQ_DATE
 | 
Visa Req Date 
 | 
Date the visa was requested by the person.
 | 
DATE
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_VISA_REQ_DATE
 
 | 
| 
VISA_START_DATE
 | 
Visa Start Date 
 | 
Current visa initial valid or begin date for this person.
 | 
DATE
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_VISA_START_DATE
 
 | 
| 
VISA_TYPE
 | 
Visa Type 
 | 
Identifies the type of visa issued to this person. May be student, employment, visitor, etc.
 | 
VARCHAR2(63)
 | 
 
 | 
 GORVISA
 
 | 
 GORVISA_VTYP_CODE
 
 | 
| 
VISA_TYPE_DESC
 | 
Visa Type Description 
 | 
Recorded visa type description. For example, student, a work or spouse visa, etc.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 |