Composite View Source: SPRTELE

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SPRTELE Student

**SGHE Banner Operational Data Store**
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	AS_TELEPHONE AA_ORGANIZATION_CONTACT AA_ORGANIZATION_CONTACT	COUNTRY_CODE PHONE_COUNTRY_CODE FAX_COUNTRY_CODE
SPRTELE_INTL_ACCESS	SPATELE	COMPOSITE VIEW	AS_TELEPHONE	PHONE_INTL_ACCESS	NA
SPRTELE_PHONE_AREA	SPATELE	COMPOSITE VIEW	AS_TELEPHONE AA_ORGANIZATION_CONTACT AA_ORGANIZATION_CONTACT	PHONE_AREA PHONE_AREA FAX_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	PHONE_NUMBER PHONE_NUMBER FAX_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	FAX_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND	NA

Ver: