SGHE Enterprise Data Warehouse
Banner EDW Source: GOBINTL - NULL
| Source Column |
Local Source |
Target Type |
Target |
Target Column |
Star Name |
Local Target |
| GOBINTL_CELG_CODE |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
PASSPORT_CERTIF_ELIG PASSPORT_CERTIF_ELIG PASSPORT_CERTIF_ELIG |
NA NA NA |
NO NO NO |
| GOBINTL_CERT_DATE_ISSUE |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
PASSPORT_CERTIF_DATE_ISSUE PASSPORT_CERTIF_DATE_ISSUE PASSPORT_CERTIF_DATE_ISSUE |
NA NA NA |
NO NO NO |
| GOBINTL_CERT_DATE_RECEIPT |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON PERSON_INTERNATIONAL |
PASSPORT_CERTIF_DATE_RECVD PASSPORT_CERTIF_DATE_RECVD PASSPORT_CERTIF_DATE_RECVD |
NA NA NA |
NO NO NO |
| GOBINTL_CERT_NUMBER |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
PASSPORT_CERTIF_NUMBER PASSPORT_CERTIF_NUMBER PASSPORT_CERTIF_NUMBER |
NA NA NA |
NO NO NO |
| GOBINTL_CHILD_NUMBER |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
CHILDREN_NUMBER CHILDREN_NUMBER CHILDREN_NUMBER |
NA NA NA |
NO NO NO |
| GOBINTL_DURATION |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
DURATION_OF_STAY DURATION_OF_STAY DURATION_OF_STAY |
NA NA NA |
NO NO NO |
| GOBINTL_EMPT_CODE |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
EMPLOYMENT_TYPE EMPLOYMENT_TYPE EMPLOYMENT_TYPE |
NA NA NA |
NO NO NO |
| GOBINTL_FOREIGN_SSN |
NO |
REPORTING VIEW |
PERSON_SENSITIVE PERSON_VETERAN PERSON_INTERNATIONAL PERSON PERSON_DETAIL |
FOREIGN_TAX_ID FOREIGN_TAX_ID FOREIGN_TAX_ID FOREIGN_TAX_ID FOREIGN_SSN |
NA NA NA NA NA |
NO NO NO NO NO |
| GOBINTL_I94_DATE |
NO |
REPORTING VIEW |
PERSON_SENSITIVE PERSON_DETAIL PERSON_INTERNATIONAL PERSON |
IMMIGRATION_STATUS_DATE IMMIGRATION_STATUS_DATE IMMIGRATION_STATUS_DATE IMMIGRATION_STATUS_DATE |
NA NA NA NA |
NO NO NO NO |
| GOBINTL_I94_STATUS |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL PERSON_SENSITIVE |
IMMIGRATION_STATUS IMMIGRATION_STATUS IMMIGRATION_STATUS IMMIGRATION_STATUS |
NA NA NA NA |
NO NO NO NO |
| GOBINTL_LANG_CODE |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
NATIVE_LANGUAGE NATIVE_LANGUAGE NATIVE_LANGUAGE |
NA NA NA |
NO NO NO |
| GOBINTL_NATN_CODE_BIRTH |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC GOVERNMENT_STUDENT GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT PERSON_INTERNATIONAL PERSON PERSON_DETAIL WDT_DEMOGRAPHIC GOVERNMENT_STUDENT GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT PERSON_INTERNATIONAL PERSON PERSON_DETAIL |
NATION_OF_BIRTH NATION_OF_CITIZENSHIP NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_CITIZENSHIP NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH NATION_OF_BIRTH |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA NA |
NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
| GOBINTL_NATN_CODE_ISSUE |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
PASSPORT_ISSUE_NATION PASSPORT_ISSUE_NATION PASSPORT_ISSUE_NATION |
NA NA NA |
NO NO NO |
| GOBINTL_NATN_CODE_LEGAL |
NO |
DIMENSION TABLE
REPORTING VIEW
DIMENSION TABLE
REPORTING VIEW |
WDT_DEMOGRAPHIC PERSON_DETAIL PERSON PERSON_INTERNATIONAL WDT_DEMOGRAPHIC PERSON_DETAIL PERSON PERSON_INTERNATIONAL |
NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP NATION_OF_CITIZENSHIP |
ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA |
NO NO NO NO NO NO NO NO |
| GOBINTL_PASSPORT_EXP_DATE |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
PASSPORT_EXPIRE_DATE PASSPORT_EXPIRE_DATE PASSPORT_EXPIRE_DATE |
NA NA NA |
NO NO NO |
| GOBINTL_PASSPORT_ID |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_INTERNATIONAL PERSON |
PASSPORT_ID PASSPORT_ID PASSPORT_ID |
NA NA NA |
NO NO NO |
| GOBINTL_REG_NUMBER |
NO |
REPORTING VIEW |
PERSON_INTERNATIONAL PERSON_DETAIL PERSON |
PASSPORT_REGISTRATION_NO PASSPORT_REGISTRATION_NO PASSPORT_REGISTRATION_NO |
NA NA NA |
NO NO NO |
| GOBINTL_SIGNATURE_IND |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
SIGNATURE_IND SIGNATURE_IND SIGNATURE_IND |
NA NA NA |
NO NO NO |
| GOBINTL_SPON_CODE |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
SPONSOR_OF_PERSON SPONSOR_OF_PERSON SPONSOR_OF_PERSON |
NA NA NA |
NO NO NO |
| GOBINTL_SPOUSE_IND |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
SPOUSE_ACCOMPANIED_IND SPOUSE_ACCOMPANIED_IND SPOUSE_ACCOMPANIED_IND |
NA NA NA |
NO NO NO |