Banner EDW Source: SPRTELE

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
SPRTELE_ADDR_SEQNO	NO	FACT TABLE REPORTING VIEW FACT TABLE REPORTING VIEW	WFT_PHONE TELEPHONE_CURRENT TELEPHONE WFT_PHONE TELEPHONE_CURRENT TELEPHONE	PHONE_ADDRESS_SEQNO ADDRESS_NUMBER ADDRESS_NUMBER PHONE_ADDRESS_SEQNO ADDRESS_NUMBER ADDRESS_NUMBER	PHONE NA NA PHONE NA NA	NO NO NO NO NO NO
SPRTELE_ATYP_CODE	NO	REPORTING VIEW	TELEPHONE TELEPHONE_CURRENT	ADDRESS_TYPE ADDRESS_TYPE	NA NA	NO NO
SPRTELE_COMMENT	NO	REPORTING VIEW	ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT	PHONE_COMMENT PHONE_COMMENT PHONE_COMMENT	NA NA NA	NO NO NO
SPRTELE_CTRY_CODE_PHONE	NO	REPORTING VIEW	ORGANIZATION_CONTACT ADDRESS_PREFERRED TELEPHONE ORGANIZATION_CONTACT TELEPHONE_CURRENT	PHONE_COUNTRY_CODE COUNTRY_CODE COUNTRY_CODE FAX_COUNTRY_CODE COUNTRY_CODE	NA NA NA NA NA	NO NO NO NO NO
SPRTELE_INTL_ACCESS	NO	REPORTING VIEW	TELEPHONE_CURRENT ADDRESS_PREFERRED TELEPHONE	PHONE_INTL_ACCESS PHONE_INTL_ACCESS PHONE_INTL_ACCESS	NA NA NA	NO NO NO
SPRTELE_PHONE_AREA	NO	REPORTING VIEW	GRANT_PERSONNEL TELEPHONE ORGANIZATION_CONTACT_SLOT PHONE_ASSIGNMENT ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ADDRESS_PREFERRED ORGANIZATION_CONTACT TELEPHONE_CURRENT	PHONE_AREA PHONE_AREA PHONE_AREA_2 PHONE_AREA PHONE_AREA_1 FAX_AREA PHONE_AREA PHONE_AREA PHONE_AREA	NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO
SPRTELE_PHONE_EXT	NO	REPORTING VIEW	GRANT_PERSONNEL ADDRESS_PREFERRED ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT TELEPHONE TELEPHONE_CURRENT ORGANIZATION_CONTACT	PHONE_EXT PHONE_EXT PHONE_EXT_1 PHONE_EXT PHONE_EXT_2 PHONE_EXT PHONE_EXT FAX_EXT	NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO
SPRTELE_PHONE_NUMBER	NO	REPORTING VIEW	TELEPHONE_CURRENT ORGANIZATION_CONTACT_SLOT GRANT_PERSONNEL TELEPHONE ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT ADDRESS_PREFERRED	PHONE_NUMBER PHONE_NUMBER_2 PHONE_NUMBER PHONE_NUMBER PHONE_NUMBER_1 FAX_NUMBER PHONE_NUMBER PHONE_NUMBER	NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO
SPRTELE_PIDM	NO
SPRTELE_PRIMARY_IND	NO	REPORTING VIEW	ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT	PHONE_PRIMARY_IND PHONE_PRIMARY_IND PHONE_PRIMARY_IND	NA NA NA	NO NO NO
SPRTELE_SEQNO	NO	FACT TABLE REPORTING VIEW FACT TABLE REPORTING VIEW	WFT_PHONE ADDRESS_PREFERRED TELEPHONE_CURRENT TELEPHONE WFT_PHONE ADDRESS_PREFERRED TELEPHONE_CURRENT TELEPHONE	PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER	PHONE NA NA NA PHONE NA NA NA	NO NO NO NO NO NO NO NO
SPRTELE_STATUS_IND	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_PHONE_TYPE TELEPHONE ADDRESS_PREFERRED TELEPHONE_CURRENT WDT_PHONE_TYPE TELEPHONE ADDRESS_PREFERRED TELEPHONE_CURRENT	PHONE_STATUS PHONE_STATUS_IND PHONE_STATUS_IND PHONE_STATUS_IND PHONE_STATUS PHONE_STATUS_IND PHONE_STATUS_IND PHONE_STATUS_IND	COMMITTEE, MAILING LIST, PHONE NA NA NA COMMITTEE, MAILING LIST, PHONE NA NA NA	NO NO NO NO NO NO NO NO
SPRTELE_TELE_CODE	NO	DIMENSION TABLE REPORTING VIEW DIMENSION TABLE REPORTING VIEW	WDT_PHONE_TYPE ORGANIZATION_ENTITY PERSON VENDOR TELEPHONE TELEPHONE_CURRENT VENDOR ADDRESS_PREFERRED WDT_PHONE_TYPE ORGANIZATION_ENTITY PERSON VENDOR TELEPHONE TELEPHONE_CURRENT VENDOR ADDRESS_PREFERRED	PHONE_TYPE PHONE_TYPE PHONE_TYPE REMIT_TO_PHONE_TYPE PHONE_TYPE PHONE_TYPE ORDER_FROM_PHONE_TYPE PHONE_TYPE PHONE_TYPE PHONE_TYPE PHONE_TYPE REMIT_TO_PHONE_TYPE PHONE_TYPE PHONE_TYPE ORDER_FROM_PHONE_TYPE PHONE_TYPE	COMMITTEE, MAILING LIST, PHONE NA NA NA NA NA NA NA COMMITTEE, MAILING LIST, PHONE NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
SPRTELE_UNLIST_IND	NO	REPORTING VIEW	TELEPHONE ORGANIZATION_CONTACT VENDOR VENDOR ADDRESS_PREFERRED ORGANIZATION_ENTITY TELEPHONE_CURRENT ORGANIZATION_CONTACT PERSON	PHONE_UNLIST_IND FAX_UNLIST_IND REMIT_TO_PHONE_UNLIST_IND ORDER_FROM_PHONE_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND	NA NA NA NA NA NA NA NA NA	NO NO NO NO NO NO NO NO NO

Ver: 9.0