Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SPRTELE Student Reporting View Meta Data Reports
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



REPORTING VIEW

TELEPHONE_CURRENT

TELEPHONE

TELEPHONE_CURRENT

TELEPHONE

ADDRESS_NUMBER

ADDRESS_NUMBER

ADDRESS_NUMBER

ADDRESS_NUMBER

NA
SPRTELE_ATYP_CODE SPATELE

REPORTING VIEW

TELEPHONE

TELEPHONE_CURRENT

ADDRESS_TYPE

ADDRESS_TYPE

NA
SPRTELE_COMMENT SPATELE

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_COMMENT

PHONE_COMMENT

PHONE_COMMENT

NA
SPRTELE_CTRY_CODE_PHONE TBD

REPORTING VIEW

ORGANIZATION_CONTACT

ADDRESS_PREFERRED

TELEPHONE

ORGANIZATION_CONTACT

TELEPHONE_CURRENT

PHONE_COUNTRY_CODE

COUNTRY_CODE

COUNTRY_CODE

FAX_COUNTRY_CODE

COUNTRY_CODE

 
SPRTELE_INTL_ACCESS SPATELE

REPORTING VIEW

TELEPHONE_CURRENT

ADDRESS_PREFERRED

TELEPHONE

PHONE_INTL_ACCESS

PHONE_INTL_ACCESS

PHONE_INTL_ACCESS

NA
SPRTELE_PHONE_AREA SPATELE

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
SPRTELE_PHONE_EXT SPATELE

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
SPRTELE_PHONE_NUMBER SPATELE

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
SPRTELE_PIDM NA       NA
SPRTELE_PRIMARY_IND SPATELE

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_PRIMARY_IND

PHONE_PRIMARY_IND

PHONE_PRIMARY_IND

NA
SPRTELE_SEQNO

REPORTING VIEW




REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE_CURRENT

TELEPHONE

ADDRESS_PREFERRED

TELEPHONE_CURRENT

TELEPHONE

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

 
SPRTELE_STATUS_IND

REPORTING VIEW




REPORTING VIEW

TELEPHONE

ADDRESS_PREFERRED

TELEPHONE_CURRENT

TELEPHONE

ADDRESS_PREFERRED

TELEPHONE_CURRENT

PHONE_STATUS_IND

PHONE_STATUS_IND

PHONE_STATUS_IND

PHONE_STATUS_IND

PHONE_STATUS_IND

PHONE_STATUS_IND

 
SPRTELE_TELE_CODE SPATELE

REPORTING VIEW








REPORTING VIEW

ORGANIZATION_ENTITY

PERSON

VENDOR

TELEPHONE

TELEPHONE_CURRENT

VENDOR

ADDRESS_PREFERRED

ORGANIZATION_ENTITY

PERSON

VENDOR

TELEPHONE

TELEPHONE_CURRENT

VENDOR

ADDRESS_PREFERRED

PHONE_TYPE

PHONE_TYPE

REMIT_TO_PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

ORDER_FROM_PHONE_TYPE

PHONE_TYPE

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

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


Ver: 9.1