Banner EDW Source: GORVISA

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
GORVISA_ENTRY_IND	NO	REPORTING VIEW	PERSON_INTERNATIONAL PERSON VISA VISA_CURRENT	ENTRY_IND ENTRY_IND ENTRY_IND ENTRY_IND	NA NA NA NA	NO NO NO NO
GORVISA_NATN_CODE_ISSUE	NO	REPORTING VIEW	PERSON VISA VISA_CURRENT PERSON_INTERNATIONAL	VISA_ISSUING_NATION VISA_ISSUING_NATION VISA_ISSUING_NATION VISA_ISSUING_NATION	NA NA NA NA	NO NO NO NO
GORVISA_NO_ENTRIES	NO	REPORTING VIEW	VISA VISA_CURRENT PERSON_INTERNATIONAL PERSON	NUMBER_OF_ENTRIES NUMBER_OF_ENTRIES NUMBER_OF_ENTRIES NUMBER_OF_ENTRIES	NA NA NA NA	NO NO NO NO
GORVISA_PENT_CODE	NO	REPORTING VIEW	PERSON_INTERNATIONAL VISA_CURRENT PERSON VISA	POINT_OF_ENTRY POINT_OF_ENTRY POINT_OF_ENTRY POINT_OF_ENTRY	NA NA NA NA	NO NO NO NO
GORVISA_PIDM	NO	REPORTING VIEW	VISA_CURRENT VISA	PERSON_UID PERSON_UID	NA NA	NO NO
GORVISA_VISA_EXPIRE_DATE	NO	REPORTING VIEW	PERSON_INTERNATIONAL GOVERNMENT_STUDENT VISA PERSON VISA_CURRENT	VISA_EXPIRE_DATE VISA_EXPIRE_DATE VISA_EXPIRE_DATE VISA_EXPIRE_DATE VISA_EXPIRE_DATE	NA NA NA NA NA	NO NO NO NO NO
GORVISA_VISA_ISSUE_DATE	NO	REPORTING VIEW	PERSON_INTERNATIONAL VISA PERSON VISA_CURRENT	VISA_ISSUE_DATE VISA_ISSUE_DATE VISA_ISSUE_DATE VISA_ISSUE_DATE	NA NA NA NA	NO NO NO NO
GORVISA_VISA_NUMBER	NO	REPORTING VIEW	VISA_CURRENT PERSON VISA PERSON_INTERNATIONAL	VISA_NUMBER VISA_NUMBER VISA_NUMBER VISA_NUMBER	NA NA NA NA	NO NO NO NO
GORVISA_VISA_REQ_DATE	NO	REPORTING VIEW	PERSON PERSON_INTERNATIONAL VISA VISA_CURRENT	VISA_REQ_DATE VISA_REQ_DATE VISA_REQ_DATE VISA_REQ_DATE	NA NA NA NA	NO NO NO NO
GORVISA_VISA_START_DATE	NO	REPORTING VIEW	GOVERNMENT_STUDENT PERSON_INTERNATIONAL VISA_CURRENT PERSON VISA	VISA_START_DATE VISA_START_DATE VISA_START_DATE VISA_START_DATE VISA_START_DATE	NA NA NA NA NA	NO NO NO NO NO
GORVISA_VISS_CODE	NO	REPORTING VIEW	PERSON_INTERNATIONAL VISA_CURRENT PERSON VISA	VISA_ISSUING_AUTHORITY VISA_ISSUING_AUTHORITY VISA_ISSUING_AUTHORITY VISA_ISSUING_AUTHORITY	NA NA NA NA	NO NO NO NO
GORVISA_VTYP_CODE	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_DEMOGRAPHIC GOVERNMENT_STUDENT VISA VISA_CURRENT PERSON_INTERNATIONAL PERSON WDT_DEMOGRAPHIC GOVERNMENT_STUDENT VISA VISA_CURRENT PERSON_INTERNATIONAL PERSON	VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE VISA_TYPE	ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA ANALYZE FUNDRAISING, CONSTITUENT ENTITY, MANAGE PROSPECT PIPELINE, RELATIONSHIP, RQPP ENTITY NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO

Ver: 9.0