RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: SPRTELE Student Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: SPRTELE

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

REPORTING VIEW

TELEPHONE

ADDRESS_NUMBER

NA
SPRTELE_ATYP_CODE SPATELE

REPORTING VIEW

TELEPHONE

ADDRESS_TYPE

NA
SPRTELE_COMMENT SPATELE

REPORTING VIEW

TELEPHONE

ADDRESS_PREFERRED

PHONE_COMMENT

PHONE_COMMENT

NA
SPRTELE_INTL_ACCESS SPATELE

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

PHONE_INTL_ACCESS

PHONE_INTL_ACCESS

NA
SPRTELE_PHONE_AREA SPATELE

REPORTING VIEW

PHONE_ASSIGNMENT

ORGANIZATION_CONTACT_SLOT

TELEPHONE

ADDRESS_PREFERRED

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

PHONE_AREA

PHONE_AREA_1

PHONE_AREA

PHONE_AREA

PHONE_AREA

PHONE_AREA_2

NA
SPRTELE_PHONE_EXT SPATELE

REPORTING VIEW

ORGANIZATION_CONTACT

TELEPHONE

ORGANIZATION_CONTACT_SLOT

ADDRESS_PREFERRED

ORGANIZATION_CONTACT_SLOT

PHONE_EXT

PHONE_EXT

PHONE_EXT_2

PHONE_EXT

PHONE_EXT_1

NA
SPRTELE_PHONE_NUMBER SPATELE

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ADDRESS_PREFERRED

ORGANIZATION_CONTACT_SLOT

TELEPHONE

PHONE_NUMBER

PHONE_NUMBER_1

PHONE_NUMBER

PHONE_NUMBER_2

PHONE_NUMBER

NA
SPRTELE_PIDM NA       NA
SPRTELE_PRIMARY_IND SPATELE

REPORTING VIEW

ADDRESS_PREFERRED

TELEPHONE

PHONE_PRIMARY_IND

PHONE_PRIMARY_IND

NA
SPRTELE_SEQNO SPATELE

REPORTING VIEW

TELEPHONE

ADDRESS_PREFERRED

PHONE_SEQ_NUMBER

PHONE_SEQ_NUMBER

NA
SPRTELE_STATUS_IND SPATELE

REPORTING VIEW

TELEPHONE

ADDRESS_PREFERRED

PHONE_STATUS_IND

PHONE_STATUS_IND

NA
SPRTELE_TELE_CODE SPATELE

REPORTING VIEW

VENDOR

VENDOR

ORGANIZATION_CONTACT

ADDRESS_PREFERRED

PERSON

TELEPHONE

ORGANIZATION_ENTITY

REMIT_TO_PHONE_TYPE

ORDER_FROM_PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

PHONE_TYPE

NA
SPRTELE_UNLIST_IND SPATELE

REPORTING VIEW

TELEPHONE

ORGANIZATION_CONTACT

ORGANIZATION_ENTITY

PERSON

ADDRESS_PREFERRED

VENDOR

VENDOR

PHONE_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

PHONE_UNLIST_IND

ORDER_FROM_PHONE_UNLIST_IND

REMIT_TO_PHONE_UNLIST_IND

NA


Ver: 3.1