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

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

AS_TELEPHONE

PHONE_ADDRESS_SEQ_NO

NA
SPRTELE_ATYP_CODE SPATELE COMPOSITE VIEW

AS_TELEPHONE

PHONE_ADDRESS_TYPE

NA
SPRTELE_COMMENT SPATELE COMPOSITE VIEW

AS_TELEPHONE

PHONE_COMMENT

NA
SPRTELE_CTRY_CODE_PHONE TBD COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AA_ORGANIZATION_CONTACT

AS_TELEPHONE

PHONE_COUNTRY_CODE

FAX_COUNTRY_CODE

COUNTRY_CODE

 
SPRTELE_INTL_ACCESS SPATELE COMPOSITE VIEW

AS_TELEPHONE

PHONE_INTL_ACCESS

NA
SPRTELE_PHONE_AREA SPATELE COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AA_ORGANIZATION_CONTACT

AS_TELEPHONE

FAX_AREA

PHONE_AREA

PHONE_AREA

NA
SPRTELE_PHONE_EXT SPATELE COMPOSITE VIEW

AS_TELEPHONE

AA_ORGANIZATION_CONTACT

AA_ORGANIZATION_CONTACT

PHONE_EXT

FAX_EXT

PHONE_EXT

NA
SPRTELE_PHONE_NUMBER SPATELE COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_TELEPHONE

AA_ORGANIZATION_CONTACT

FAX_NUMBER

PHONE_NUMBER

PHONE_NUMBER

NA
SPRTELE_PIDM NA COMPOSITE VIEW

AS_TELEPHONE

ENTITY_UID

NA
SPRTELE_PRIMARY_IND SPATELE COMPOSITE VIEW

AS_TELEPHONE

PHONE_PRIMARY_IND

NA
SPRTELE_SEQNO SPATELE COMPOSITE VIEW

AS_TELEPHONE

PHONE_SEQ_NUMBER

NA
SPRTELE_STATUS_IND SPATELE COMPOSITE VIEW

AS_TELEPHONE

PHONE_STATUS_IND

NA
SPRTELE_TELE_CODE SPATELE COMPOSITE VIEW

AS_TELEPHONE

PHONE_TYPE

NA
SPRTELE_UNLIST_IND SPATELE COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

AS_TELEPHONE

AA_ORGANIZATION_CONTACT

PHONE_UNLIST_IND

PHONE_UNLIST_IND

FAX_UNLIST_IND

NA


Ver: