Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: GOBINTL Common
SGHE Banner Operational Data Store Composite View Source: GOBINTL - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
GOBINTL_CELG_CODE GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_CERTIF_ELIG

NA
GOBINTL_CERT_DATE_ISSUE GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_CERTIF_DATE_ISSUE

NA
GOBINTL_CERT_DATE_RECEIPT GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_CERTIF_DATE_RECVD

NA
GOBINTL_CERT_NUMBER GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_CERTIF_NUMBER

NA
GOBINTL_CHILD_NUMBER GOAINTL COMPOSITE VIEW

AS_PERSON

CHILDREN_NUMBER

NA
GOBINTL_DURATION GOAINTL COMPOSITE VIEW

AS_PERSON

DURATION_OF_STAY

NA
GOBINTL_EMPT_CODE GOAINTL COMPOSITE VIEW

AS_PERSON

EMPLOYMENT_TYPE

NA
GOBINTL_FOREIGN_SSN GOAINTL COMPOSITE VIEW

AS_PERSON

FOREIGN_SSN

NA
GOBINTL_I94_DATE GOAINTL COMPOSITE VIEW

AS_PERSON

IMMIGRATION_STATUS_DATE

NA
GOBINTL_I94_STATUS GOAINTL COMPOSITE VIEW

AS_PERSON

IMMIGRATION_STATUS

NA
GOBINTL_LANG_CODE GOAINTL COMPOSITE VIEW

AS_PERSON

NATIVE_LANGUAGE

NA
GOBINTL_NATN_CODE_BIRTH GOAINTL COMPOSITE VIEW

AS_PERSON

NATION_OF_BIRTH

NA
GOBINTL_NATN_CODE_ISSUE GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_ISSUE_NATION

NA
GOBINTL_NATN_CODE_LEGAL GOAINTL COMPOSITE VIEW

AS_PERSON

NATION_OF_CITIZENSHIP

NA
GOBINTL_PASSPORT_EXP_DATE GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_EXPIRE_DATE

NA
GOBINTL_PASSPORT_ID GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_ID

NA
GOBINTL_PIDM NA       NA
GOBINTL_REG_NUMBER GOAINTL COMPOSITE VIEW

AS_PERSON

PASSPORT_REGISTRATION_NO

NA
GOBINTL_SIGNATURE_IND GOAINTL COMPOSITE VIEW

AS_PERSON

SIGNATURE_IND

NA
GOBINTL_SPON_CODE GOAINTL COMPOSITE VIEW

AS_PERSON

SPONSOR_OF_PERSON

NA
GOBINTL_SPOUSE_IND GOAINTL COMPOSITE VIEW

AS_PERSON

SPOUSE_ACCOMPANIED_IND

NA


Ver: