Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CHILDREN_NUMBER	Number of children recorded for this person.	NUMBER	GOBINTL	GOBINTL_CHILD_NUMBER	NO	NO
CITIZENSHIP_DESC	Citizen type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CITIZENSHIP_EDI_EQUIV	Citizenship type used for the electronic data transfer.	VARCHAR2(2)	STVCITZ	STVCITZ_EDI_EQUIV	NO	NO
CITIZENSHIP_IND	Indicates whether the person is a citizen of the institution's home country.	VARCHAR2(1)	STVCITZ	STVCITZ_CITIZEN_IND	NO	NO
CITIZENSHIP_TYPE	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(63)	SPBPERS	SPBPERS_CITZ_CODE	NO	NO
DECEASED_DATE	Date the person died.	DATE	SPBPERS	SPBPERS_DEAD_DATE	NO	NO
DECEASED_STATUS	Indicates whether a person is deceased.	VARCHAR2(1)	SPBPERS	SPBPERS_DEAD_IND	NO	NO
DURATION_OF_STAY	Indicates whether the admission or departure is for the duration of the stay.	VARCHAR2(1)	GOBINTL	GOBINTL_DURATION	NO	NO
EMPLOYMENT_TYPE	Type of employment recorded for the person.	VARCHAR2(63)	GOBINTL	GOBINTL_EMPT_CODE	NO	NO
EMPLOYMENT_TYPE_DESC	Person's type of employment description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	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
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
FOREIGN_TAX_ID	Unique identification number for tax purposes from a country outside the institution's home country.	VARCHAR2(63)	GOBINTL	GOBINTL_FOREIGN_SSN	NO	NO
FULL_NAME_LFMI	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME	NO	NO
GOVERNMENT_ID	Identification assigned by the institution's home government when the tax id is from a different government.	VARCHAR2(63)	NA	NA	NO	NO
IMMIGRATION_STATUS	Indicates whether immigration information has been received by the institution.	VARCHAR2(63)	GOBINTL	GOBINTL_I94_STATUS	NO	NO
IMMIGRATION_STATUS_DATE	Date the person was admitted to or departed the country.	DATE	GOBINTL	GOBINTL_I94_DATE	NO	NO
LAST_NAME	Person's last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
MARITAL_STATUS	Marital status code of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE	NO	NO
MARITAL_STATUS_DESC	Marital status description associated with the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MIDDLE_NAME	Person's middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
NATION_ISO_CODE	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(3)	STVNATN	STVNATN_SCOD_CODE_ISO	NO	NO
NATION_OF_BIRTH	Country code of the nation of the person's birth.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_BIRTH	NO	NO
NATION_OF_BIRTH_DESC	Nation/country of birth description for the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
NATION_OF_CITIZENSHIP2	Second country code of the nation where the person maintains citizenship.	VARCHAR2(63)	NA	NA	NO	NO
NATION_OF_CITIZENSHIP_DESC	Nation/country of citizenship description for the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
NATION_OF_CITIZENSHIP_DESC2	Country code description for the person's second nation of citizenship.	VARCHAR2(255)	NA	NA	NO	NO
NATIVE_LANGUAGE	Native language code of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_LANG_CODE	NO	NO
NATIVE_LANGUAGE_DESC	Person's native language code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
NUMBER_OF_ENTRIES	Number of entries into the country for the person.	VARCHAR2(2)	GORVISA	GORVISA_NO_ENTRIES	NO	NO
PASSPORT_CERTIF_DATE_ISSUE	Date the Passport Certification was issued to the person.	DATE	GOBINTL	GOBINTL_CERT_DATE_ISSUE	NO	NO
PASSPORT_CERTIF_DATE_RECVD	Date the Passport Certification was received by the person.	DATE	GOBINTL	GOBINTL_CERT_DATE_RECEIPT	NO	NO
PASSPORT_CERTIF_ELIG	Passport certification eligibility code of the person.	VARCHAR2(255)	GOBINTL	GOBINTL_CELG_CODE	NO	NO
PASSPORT_CERTIF_ELIG_DESC	Person's passport certification eligibility code description.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PASSPORT_CERTIF_NUMBER	Passport Certification Number of the person.	VARCHAR2(11)	GOBINTL	GOBINTL_CERT_NUMBER	NO	NO
PASSPORT_EXPIRE_DATE	Date the person's passport expires.	DATE	GOBINTL	GOBINTL_PASSPORT_EXP_DATE	NO	NO
PASSPORT_ID	Passport identification number.	VARCHAR2(63)	GOBINTL	GOBINTL_PASSPORT_ID	NO	NO
PASSPORT_ISSUE_NATION	Nation code issuing the passport of the person.	VARCHAR2(63)	GOBINTL	GOBINTL_NATN_CODE_ISSUE	NO	NO
PASSPORT_ISSUE_NATION_DESC	Nation issuing the passport description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PASSPORT_REGISTRATION_NO	Passport registration number of the person.	VARCHAR2(11)	GOBINTL	GOBINTL_REG_NUMBER	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPBPERS	SPBPERS_PIDM	NO	NO
POINT_OF_ENTRY	Point of entry code of the person.	VARCHAR2(63)	GORVISA	GORVISA_PENT_CODE	NO	NO
POINT_OF_ENTRY_DESC	International student's port of entry into the country of the institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
SIGNATURE_IND	Indicates whether a signature is on file to release of funds for the international student.	VARCHAR2(1)	GOBINTL	GOBINTL_SIGNATURE_IND	NO	NO
SPONSOR_OF_PERSON	Identifies the sponsor for an international student or staff member.	VARCHAR2(63)	GOBINTL	GOBINTL_SPON_CODE	NO	NO
SPONSOR_OF_PERSON_DESC	Person's sponsor code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SPOUSE_ACCOMPANIED_IND	Indicates whether the spouse accompanied this person entering the institution home country.	VARCHAR2(1)	GOBINTL	GOBINTL_SPOUSE_IND	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN	NO	NO
VISA_EXPIRE_DATE	Current date this person's visa expires.	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(63)	GORVISA	GORVISA_VISS_CODE	NO	NO
VISA_ISSUING_AUTHORITY_DESC	Authorizing agency description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
VISA_ISSUING_NATION	Nation or country issuing the visa to this person.	VARCHAR2(63)	GORVISA	GORVISA_NATN_CODE_ISSUE	NO	NO
VISA_ISSUING_NATION_DESC	Name of the nation or country issuing the visa.	VARCHAR2(255)	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(63)	GORVISA	GORVISA_VTYP_CODE	NO	NO
VISA_TYPE_DESC	Visa type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO

Ver: 9.2