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 Local Source Target Type Target Target Column Local Target Calculation Formula
SPRTELE_ADDR_SEQNO SPATELE NO

REPORTING VIEW

TELEPHONE_CURRENT

TELEPHONE

ADDRESS_NUMBER

ADDRESS_NUMBER

NO

NO

NA
SPRTELE_ATYP_CODE SPATELE NO

REPORTING VIEW

TELEPHONE

TELEPHONE_CURRENT

ADDRESS_TYPE

ADDRESS_TYPE

NO

NO

NA
SPRTELE_COMMENT SPATELE NO

REPORTING VIEW

TELEPHONE_CURRENT

ADDRESS_PREFERRED

TELEPHONE

PHONE_COMMENT

PHONE_COMMENT

PHONE_COMMENT

NO

NO

NO

NA
SPRTELE_CTRY_CODE_PHONE TBD NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_COUNTRY_CODE

FAX_COUNTRY_CODE

COUNTRY_CODE

COUNTRY_CODE

COUNTRY_CODE

NO

NO

NO

NO

NO

 
SPRTELE_INTL_ACCESS SPATELE NO

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_INTL_ACCESS

PHONE_INTL_ACCESS

PHONE_INTL_ACCESS

NO

NO

NO

NA
SPRTELE_PHONE_AREA SPATELE NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT

TELEPHONE

ORGANIZATION_CONTACT_SLOT

PHONE_ASSIGNMENT

TELEPHONE_CURRENT

GRANT_PERSONNEL

ORGANIZATION_CONTACT_SLOT

ADDRESS_PREFERRED

FAX_AREA

PHONE_AREA

PHONE_AREA

PHONE_AREA_2

PHONE_AREA

PHONE_AREA

PHONE_AREA

PHONE_AREA_1

PHONE_AREA

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPRTELE_PHONE_EXT SPATELE NO

REPORTING VIEW

ORGANIZATION_CONTACT

ADDRESS_PREFERRED

ORGANIZATION_CONTACT_SLOT

GRANT_PERSONNEL

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

TELEPHONE_CURRENT

TELEPHONE

FAX_EXT

PHONE_EXT

PHONE_EXT_1

PHONE_EXT

PHONE_EXT_2

PHONE_EXT

PHONE_EXT

PHONE_EXT

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPRTELE_PHONE_NUMBER SPATELE NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

TELEPHONE

TELEPHONE_CURRENT

ORGANIZATION_CONTACT

GRANT_PERSONNEL

ADDRESS_PREFERRED

ORGANIZATION_CONTACT_SLOT

PHONE_NUMBER

PHONE_NUMBER_1

PHONE_NUMBER

PHONE_NUMBER

FAX_NUMBER

PHONE_NUMBER

PHONE_NUMBER

PHONE_NUMBER_2

NO

NO

NO

NO

NO

NO

NO

NO

NA
SPRTELE_PIDM NA NO         NA
SPRTELE_PRIMARY_IND SPATELE NO

REPORTING VIEW

TELEPHONE

ADDRESS_PREFERRED

TELEPHONE_CURRENT

PHONE_PRIMARY_IND

PHONE_PRIMARY_IND

PHONE_PRIMARY_IND

NO

NO

NO

NA
SPRTELE_SEQNO SPATELE NO

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

NO

NO

NO

NA
SPRTELE_STATUS_IND SPATELE NO

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

TELEPHONE_CURRENT

PHONE_STATUS_IND

PHONE_STATUS_IND

PHONE_STATUS_IND

NO

NO

NO

NA
SPRTELE_TELE_CODE SPATELE NO

REPORTING VIEW

VENDOR

PERSON

TELEPHONE

TELEPHONE_CURRENT

VENDOR

ADDRESS_PREFERRED

ORGANIZATION_ENTITY

ORDER_FROM_PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

REMIT_TO_PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

NO

NO

NO

NO

NO

NO

NO

NA
SPRTELE_UNLIST_IND SPATELE NO

REPORTING VIEW

ORGANIZATION_ENTITY

ORGANIZATION_CONTACT

TELEPHONE_CURRENT

ADDRESS_PREFERRED

VENDOR

ORGANIZATION_CONTACT

PERSON

TELEPHONE

VENDOR

PHONE_UNLIST_IND

FAX_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

REMIT_TO_PHONE_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

ORDER_FROM_PHONE_UNLIST_IND

NO

NO

NO

NO

NO

NO

NO

NO

NO

NA


Ver: 9.2