Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
GOBINTL_CELG_CODE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
PASSPORT_CERTIF_ELIG PASSPORT_CERTIF_ELIG PASSPORT_CERTIF_ELIG |
NO NO NO |
NA |
GOBINTL_CERT_DATE_ISSUE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON PERSON_INTERNATIONAL |
PASSPORT_CERTIF_DATE_ISSUE PASSPORT_CERTIF_DATE_ISSUE PASSPORT_CERTIF_DATE_ISSUE |
NO NO NO |
NA |
GOBINTL_CERT_DATE_RECEIPT |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
PASSPORT_CERTIF_DATE_RECVD PASSPORT_CERTIF_DATE_RECVD PASSPORT_CERTIF_DATE_RECVD |
NO NO NO |
NA |
GOBINTL_CERT_NUMBER |
GOAINTL |
NO |
REPORTING VIEW |
PERSON_INTERNATIONAL PERSON PERSON_DETAIL |
PASSPORT_CERTIF_NUMBER PASSPORT_CERTIF_NUMBER PASSPORT_CERTIF_NUMBER |
NO NO NO |
NA |
GOBINTL_CHILD_NUMBER |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
CHILDREN_NUMBER CHILDREN_NUMBER CHILDREN_NUMBER |
NO NO NO |
NA |
GOBINTL_DURATION |
GOAINTL |
NO |
REPORTING VIEW |
PERSON_INTERNATIONAL PERSON PERSON_DETAIL |
DURATION_OF_STAY DURATION_OF_STAY DURATION_OF_STAY |
NO NO NO |
NA |
GOBINTL_EMPT_CODE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
EMPLOYMENT_TYPE EMPLOYMENT_TYPE EMPLOYMENT_TYPE |
NO NO NO |
NA |
GOBINTL_FOREIGN_SSN |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL PERSON_VETERAN PERSON_SENSITIVE |
FOREIGN_TAX_ID FOREIGN_SSN FOREIGN_TAX_ID FOREIGN_TAX_ID FOREIGN_TAX_ID |
NO NO NO NO NO |
NA |
GOBINTL_I94_DATE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_INTERNATIONAL PERSON_SENSITIVE PERSON |
IMMIGRATION_STATUS_DATE IMMIGRATION_STATUS_DATE IMMIGRATION_STATUS_DATE IMMIGRATION_STATUS_DATE |
NO NO NO NO |
NA |
GOBINTL_I94_STATUS |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_SENSITIVE PERSON_INTERNATIONAL |
IMMIGRATION_STATUS IMMIGRATION_STATUS IMMIGRATION_STATUS IMMIGRATION_STATUS |
NO NO NO NO |
NA |
GOBINTL_LANG_CODE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
NATIVE_LANGUAGE NATIVE_LANGUAGE NATIVE_LANGUAGE |
NO NO NO |
NA |
GOBINTL_NATN_CODE_BIRTH |
GOAINTL |
NO |
REPORTING VIEW |
GOVERNMENT_STUDENT GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_CITIZENSHIP NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH |
NO NO NO NO NO NO |
NA |
GOBINTL_NATN_CODE_ISSUE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
PASSPORT_ISSUE_NATION PASSPORT_ISSUE_NATION PASSPORT_ISSUE_NATION |
NO NO NO |
NA |
GOBINTL_NATN_CODE_LEGAL |
GOAINTL |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_INTERNATIONAL PERSON |
NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP |
NO NO NO |
NA |
GOBINTL_PASSPORT_EXP_DATE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
PASSPORT_EXPIRE_DATE PASSPORT_EXPIRE_DATE PASSPORT_EXPIRE_DATE |
NO NO NO |
NA |
GOBINTL_PASSPORT_ID |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
PASSPORT_ID PASSPORT_ID PASSPORT_ID |
NO NO NO |
NA |
GOBINTL_REG_NUMBER |
GOAINTL |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_INTERNATIONAL PERSON |
PASSPORT_REGISTRATION_NO PASSPORT_REGISTRATION_NO PASSPORT_REGISTRATION_NO |
NO NO NO |
NA |
GOBINTL_SIGNATURE_IND |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
SIGNATURE_IND SIGNATURE_IND SIGNATURE_IND |
NO NO NO |
NA |
GOBINTL_SPON_CODE |
GOAINTL |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON PERSON_INTERNATIONAL |
SPONSOR_OF_PERSON SPONSOR_OF_PERSON SPONSOR_OF_PERSON |
NO NO NO |
NA |
GOBINTL_SPOUSE_IND |
GOAINTL |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
SPOUSE_ACCOMPANIED_IND SPOUSE_ACCOMPANIED_IND SPOUSE_ACCOMPANIED_IND |
NO NO NO |
NA |