Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SPRTELE Student Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: SPRTELE - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
SPRTELE_ADDR_SEQNO SPATELE

REPORTING VIEW

TELEPHONE_CURRENT

TELEPHONE

ADDRESS_NUMBER

ADDRESS_NUMBER

NA
SPRTELE_ATYP_CODE SPATELE

REPORTING VIEW

TELEPHONE

TELEPHONE_CURRENT

ADDRESS_TYPE

ADDRESS_TYPE

NA
SPRTELE_COMMENT SPATELE

REPORTING VIEW

TELEPHONE

TELEPHONE_CURRENT

ADDRESS_PREFERRED

PHONE_COMMENT

PHONE_COMMENT

PHONE_COMMENT

NA
SPRTELE_CTRY_CODE_PHONE TBD

REPORTING VIEW

TELEPHONE

TELEPHONE_CURRENT

ORGANIZATION_CONTACT

ADDRESS_PREFERRED

ORGANIZATION_CONTACT

COUNTRY_CODE

COUNTRY_CODE

PHONE_COUNTRY_CODE

COUNTRY_CODE

FAX_COUNTRY_CODE

 
SPRTELE_INTL_ACCESS SPATELE

REPORTING VIEW

TELEPHONE

TELEPHONE_CURRENT

ADDRESS_PREFERRED

PHONE_INTL_ACCESS

PHONE_INTL_ACCESS

PHONE_INTL_ACCESS

NA
SPRTELE_PHONE_AREA SPATELE

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

GRANT_PERSONNEL

TELEPHONE

ORGANIZATION_CONTACT

PHONE_ASSIGNMENT

ORGANIZATION_CONTACT

TELEPHONE_CURRENT

ADDRESS_PREFERRED

ORGANIZATION_CONTACT_SLOT

PHONE_AREA_1

PHONE_AREA

PHONE_AREA

PHONE_AREA

PHONE_AREA

FAX_AREA

PHONE_AREA

PHONE_AREA

PHONE_AREA_2

NA
SPRTELE_PHONE_EXT SPATELE

REPORTING VIEW

ORGANIZATION_CONTACT

TELEPHONE

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ADDRESS_PREFERRED

GRANT_PERSONNEL

TELEPHONE_CURRENT

FAX_EXT

PHONE_EXT

PHONE_EXT_2

PHONE_EXT

PHONE_EXT_1

PHONE_EXT

PHONE_EXT

PHONE_EXT

NA
SPRTELE_PHONE_NUMBER SPATELE

REPORTING VIEW

TELEPHONE

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ADDRESS_PREFERRED

TELEPHONE_CURRENT

ORGANIZATION_CONTACT

GRANT_PERSONNEL

PHONE_NUMBER

PHONE_NUMBER_1

PHONE_NUMBER

PHONE_NUMBER_2

PHONE_NUMBER

PHONE_NUMBER

FAX_NUMBER

PHONE_NUMBER

NA
SPRTELE_PIDM NA       NA
SPRTELE_PRIMARY_IND SPATELE

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE_CURRENT

TELEPHONE

PHONE_PRIMARY_IND

PHONE_PRIMARY_IND

PHONE_PRIMARY_IND

NA
SPRTELE_SEQNO SPATELE

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

NA
SPRTELE_STATUS_IND SPATELE

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_STATUS_IND

PHONE_STATUS_IND

PHONE_STATUS_IND

NA
SPRTELE_TELE_CODE SPATELE

REPORTING VIEW

PERSON

TELEPHONE_CURRENT

VENDOR

ORGANIZATION_ENTITY

TELEPHONE

VENDOR

ADDRESS_PREFERRED

PHONE_TYPE

PHONE_TYPE

REMIT_TO_PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

ORDER_FROM_PHONE_TYPE

PHONE_TYPE

NA
SPRTELE_UNLIST_IND SPATELE

REPORTING VIEW

PERSON

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT

ADDRESS_PREFERRED

TELEPHONE_CURRENT

ORGANIZATION_ENTITY

VENDOR

TELEPHONE

VENDOR

PHONE_UNLIST_IND

FAX_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

ORDER_FROM_PHONE_UNLIST_IND

PHONE_UNLIST_IND

REMIT_TO_PHONE_UNLIST_IND

NA


Ver: 9.0