Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CHILDREN_NUMBER	Children Number	Number of children recorded for this person.	NUMBER	GOBINTL	GOBINTL_CHILD_NUMBER
CITIZENSHIP_DESC	Citizenship Description	Citizen type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CITIZENSHIP_EDI_EQUIV	Citizenship Edi Equiv	Citizenship type used for the electronic data transfer.	VARCHAR2(2)	STVCITZ	STVCITZ_EDI_EQUIV
CITIZENSHIP_IND	Citizenship Indicator	Indicates whether the person is a citizen of the institution's home country.	VARCHAR2(1)	STVCITZ	STVCITZ_CITIZEN_IND
CITIZENSHIP_TYPE	Citizenship Type	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(63)	SPBPERS	SPBPERS_CITZ_CODE
DECEASED_DATE	Deceased Date	Date the person died.	DATE	SPBPERS	SPBPERS_DEAD_DATE
DECEASED_STATUS	Deceased Status	Indicates whether a person is deceased.	VARCHAR2(1)	SPBPERS	SPBPERS_DEAD_IND
DURATION_OF_STAY	Duration Of Stay	Indicates whether the admission or departure is for the duration of the stay.	VARCHAR2(1)	GOBINTL	GOBINTL_DURATION
EMPLOYMENT_TYPE	Employment Type	Type of employment recorded for the person.	VARCHAR2(63)	GOBINTL	GOBINTL_EMPT_CODE
EMPLOYMENT_TYPE_DESC	Employment Type Description	Person's type of employment description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ENTRY_IND	Entry Indicator	Indicates whether the visa authorizes the person to enter the institution's home country.	VARCHAR2(1)	GORVISA	GORVISA_ENTRY_IND
FIRST_NAME	First Name	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME
FOREIGN_TAX_ID	Foreign Tax ID	Unique identification number for tax purposes from a country outside the institution's home country.	VARCHAR2(63)	GOBINTL	GOBINTL_FOREIGN_SSN
FULL_NAME_LFMI	Full Name Last, First, Middle Initial	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME
GOVERNMENT_ID	Government ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(63)	NA	NA
IMMIGRATION_STATUS	Immigration Status	Indicates whether immigration information has been received by the institution.	VARCHAR2(63)	GOBINTL	GOBINTL_I94_STATUS
IMMIGRATION_STATUS_DATE	Immigration Status Date	Date the person was admitted to or departed the country.	DATE	GOBINTL	GOBINTL_I94_DATE
LAST_NAME	Last Name	Person's last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME
MARITAL_STATUS	Marital Status	Marital status code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE
MARITAL_STATUS_DESC	Marital Status Description	Marital status description associated with the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MIDDLE_NAME	Middle Name	Person's middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
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
NATION_EDI_EQUIVALENT	Nation Edi Equivalent	EDI equivalent code used for electronic transfer of country information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(2)	STVNATN	STVNATN_EDI_EQUIV
NATION_ISO_CODE	Nation ISO Code	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(3)	STVNATN	STVNATN_SCOD_CODE_ISO
NATION_OF_BIRTH	Nation Of Birth	Country code of the nation of the person's birth.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_BIRTH
NATION_OF_BIRTH_DESC	Nation Of Birth Description	Nation/country of birth description for the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
NATION_OF_CITIZENSHIP	Nation Of Citizenship	Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_LEGAL
NATION_OF_CITIZENSHIP2	Nation Of Citizenship 2	Second country code of the nation where the person maintains citizenship.	VARCHAR2(63)	NA	NA
NATION_OF_CITIZENSHIP_DESC	Nation Of Citizenship Description	Nation/country of citizenship description for the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
NATION_OF_CITIZENSHIP_DESC2	Nation Of Citizenship Description 2	Country code description for the person's second nation of citizenship.	VARCHAR2(255)	NA	NA
NATIVE_LANGUAGE	Native Language	Native language code of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_LANG_CODE
NATIVE_LANGUAGE_DESC	Native Language Description	Person's native language code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
NUMBER_OF_ENTRIES	Number Of Entries	Number of entries into the country for the person.	VARCHAR2(2)	GORVISA	GORVISA_NO_ENTRIES
PASSPORT_CERTIF_DATE_ISSUE	Passport Certif Date Issue	Date the Passport Certification was issued to the person.	DATE	GOBINTL	GOBINTL_CERT_DATE_ISSUE
PASSPORT_CERTIF_DATE_RECVD	Passport Certif Date Received	Date the Passport Certification was received by the person.	DATE	GOBINTL	GOBINTL_CERT_DATE_RECEIPT
PASSPORT_CERTIF_ELIG	Passport Certif Elig	Passport certification eligibility code of the person.	VARCHAR2(255)	GOBINTL	GOBINTL_CELG_CODE
PASSPORT_CERTIF_ELIG_DESC	Passport Certif Elig Description	Person's passport certification eligibility code description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
PASSPORT_CERTIF_NUMBER	Passport Certif Number	Passport Certification Number of the person.	VARCHAR2(11)	GOBINTL	GOBINTL_CERT_NUMBER
PASSPORT_EXPIRE_DATE	Passport Expire Date	Date the person's passport expires.	DATE	GOBINTL	GOBINTL_PASSPORT_EXP_DATE
PASSPORT_ID	Passport ID	Passport identification number.	VARCHAR2(63)	GOBINTL	GOBINTL_PASSPORT_ID
PASSPORT_ISSUE_NATION	Passport Issue Nation	Nation code issuing the passport of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_ISSUE
PASSPORT_ISSUE_NATION_DESC	Passport Issue Nation Description	Nation issuing the passport description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PASSPORT_REGISTRATION_NO	Passport Registration Number	Passport registration number of the person.	VARCHAR2(11)	GOBINTL	GOBINTL_REG_NUMBER
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPBPERS	SPBPERS_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	International student's port of entry into the country of the institution.	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
SIGNATURE_IND	Signature Indicator	Indicates whether a signature is on file to release of funds for the international student.	VARCHAR2(1)	GOBINTL	GOBINTL_SIGNATURE_IND
SPONSOR_OF_PERSON	Sponsor Of Person	Identifies the sponsor for an international student or staff member.	VARCHAR2(63)	GOBINTL	GOBINTL_SPON_CODE
SPONSOR_OF_PERSON_DESC	Sponsor Of Person Description	Person's sponsor code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SPOUSE_ACCOMPANIED_IND	Spouse Accompanied Indicator	Indicates whether the spouse accompanied this person entering the institution home country.	VARCHAR2(1)	GOBINTL	GOBINTL_SPOUSE_IND
TAX_ID	Tax ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN
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	Authorizing agency description.	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	Name of the nation or country issuing 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	Type of visa issued to this person. For example, student, employment, visitor, etc.	VARCHAR2(63)	GORVISA	GORVISA_VTYP_CODE
VISA_TYPE_DESC	Visa Type Description	Visa type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC

Ver: 9.2