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_DETAIL PERSON 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 PERSON_INTERNATIONAL PERSON_DETAIL |
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_INTERNATIONAL PERSON PERSON_DETAIL |
PASSPORT_CERTIF_NUMBER PASSPORT_CERTIF_NUMBER PASSPORT_CERTIF_NUMBER |
NA NA NA |
NO NO NO |
| GOBINTL_CHILD_NUMBER |
NO |
REPORTING VIEW |
PERSON PERSON_INTERNATIONAL PERSON_DETAIL |
CHILDREN_NUMBER CHILDREN_NUMBER CHILDREN_NUMBER |
NA NA NA |
NO NO NO |
| GOBINTL_DURATION |
NO |
REPORTING VIEW |
PERSON_INTERNATIONAL PERSON PERSON_DETAIL |
DURATION_OF_STAY DURATION_OF_STAY DURATION_OF_STAY |
NA NA NA |
NO NO NO |
| GOBINTL_EMPT_CODE |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
EMPLOYMENT_TYPE EMPLOYMENT_TYPE EMPLOYMENT_TYPE |
NA NA NA |
NO NO NO |
| GOBINTL_FOREIGN_SSN |
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 |
NA NA NA NA NA |
NO NO NO NO NO |
| GOBINTL_I94_DATE |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_INTERNATIONAL PERSON_SENSITIVE 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_SENSITIVE PERSON_INTERNATIONAL |
IMMIGRATION_STATUS IMMIGRATION_STATUS IMMIGRATION_STATUS IMMIGRATION_STATUS |
NA NA NA NA |
NO NO NO NO |
| GOBINTL_LANG_CODE |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
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 PERSON_DETAIL PERSON_INTERNATIONAL WDT_DEMOGRAPHIC GOVERNMENT_STUDENT GOVERNMENT_ACADEMIC_OUTCOME GOVERNMENT_STUDENT PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
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 NATION_OF_BIRTH NATION_OF_CITIZENSHIP 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_INTERNATIONAL PERSON WDT_DEMOGRAPHIC PERSON_DETAIL PERSON_INTERNATIONAL PERSON |
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 PERSON_INTERNATIONAL PERSON_DETAIL |
PASSPORT_ID PASSPORT_ID PASSPORT_ID |
NA NA NA |
NO NO NO |
| GOBINTL_PIDM |
NO |
|
|
|
|
|
| GOBINTL_REG_NUMBER |
NO |
REPORTING VIEW |
PERSON_DETAIL PERSON_INTERNATIONAL 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_DETAIL PERSON PERSON_INTERNATIONAL |
SPONSOR_OF_PERSON SPONSOR_OF_PERSON SPONSOR_OF_PERSON |
NA NA NA |
NO NO NO |
| GOBINTL_SPOUSE_IND |
NO |
REPORTING VIEW |
PERSON PERSON_DETAIL PERSON_INTERNATIONAL |
SPOUSE_ACCOMPANIED_IND SPOUSE_ACCOMPANIED_IND SPOUSE_ACCOMPANIED_IND |
NA NA NA |
NO NO NO |