Reporting View Source: SPRTELE

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: SPRTELE Student Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SPRTELE_ADDR_SEQNO	SPATELE	REPORTING VIEW	TELEPHONE_CURRENT TELEPHONE	ADDRESS_NUMBER ADDRESS_NUMBER	NA
SPRTELE_ATYP_CODE	SPATELE	REPORTING VIEW	TELEPHONE ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU TELEPHONE_CURRENT ADVANCEMENT_ADDRESS_SLOT_KSU	ADDRESS_TYPE AUXILLARY_PHONE_TYPE AUXILLARY2_PHONE_TYPE ADDRESS_TYPE AUXILLARY2_PHONE_TYPE	NA
SPRTELE_COMMENT	SPATELE	REPORTING VIEW	TELEPHONE TELEPHONE_CURRENT ADDRESS_PREFERRED	PHONE_COMMENT PHONE_COMMENT PHONE_COMMENT	NA
SPRTELE_CTRY_CODE_PHONE	TBD	REPORTING VIEW	TELEPHONE TELEPHONE_CURRENT ADDRESS_PREFERRED	COUNTRY_CODE COUNTRY_CODE COUNTRY_CODE
SPRTELE_INTL_ACCESS	SPATELE	REPORTING VIEW	TELEPHONE TELEPHONE_CURRENT ADDRESS_PREFERRED	PHONE_INTL_ACCESS PHONE_INTL_ACCESS PHONE_INTL_ACCESS	NA
SPRTELE_PHONE_AREA	SPATELE	REPORTING VIEW	ORGANIZATION_CONTACT_SLOT TELEPHONE GRANT_PERSONNEL ORGANIZATION_CONTACT PHONE_ASSIGNMENT TELEPHONE_CURRENT ADDRESS_PREFERRED ORGANIZATION_CONTACT_SLOT	PHONE_AREA_1 PHONE_AREA PHONE_AREA PHONE_AREA PHONE_AREA PHONE_AREA PHONE_AREA PHONE_AREA_2	NA
SPRTELE_PHONE_EXT	SPATELE	REPORTING VIEW	TELEPHONE ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ADDRESS_PREFERRED GRANT_PERSONNEL TELEPHONE_CURRENT	PHONE_EXT PHONE_EXT_2 PHONE_EXT PHONE_EXT_1 PHONE_EXT PHONE_EXT PHONE_EXT	NA
SPRTELE_PHONE_NUMBER	SPATELE	REPORTING VIEW	TELEPHONE ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ORGANIZATION_CONTACT_SLOT ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ORGANIZATION_CONTACT_SLOT ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ORGANIZATION_CONTACT ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_PREFERRED ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU TELEPHONE_CURRENT ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU GRANT_PERSONNEL ADVANCEMENT_ADDRESS_SLOT_KSU	PHONE_NUMBER ADDL_PHONE_NOADDR_2 ADDL_PHONE_NOADDR_6 AUXILLARY_PHONE PHONE_FORMAT_1 PHONE_FORMAT_3 PHONE_FORMAT_6 ADDL_PHONE_NOADDR_4 PHONE_NUMBER_1 ADDL_PHONE_NOADDR_3 ADDL_PHONE_NOADDR_5 PHONE_NUMBER_2 PHONE_FORMAT_2 PHONE_FORMAT_4 ADDL_PHONE_NOADDR_1 PHONE_FORMAT_5 PHONE_NUMBER ADDL_PHONE_NOADDR_4 AUXILLARY_PHONE PHONE_FORMAT_4 PHONE_FORMAT_6 PHONE_NUMBER ADDL_PHONE_NOADDR_5 ADDL_PHONE_NOADDR_6 PHONE_NUMBER AUXILLARY2_PHONE ADDL_PHONE_NOADDR_1 PHONE_NUMBER PHONE_FORMAT_2	NA
SPRTELE_PIDM	NA				NA
SPRTELE_PRIMARY_IND	SPATELE	REPORTING VIEW	ADDRESS_PREFERRED TELEPHONE_CURRENT ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU TELEPHONE ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU ADDRESS_SLOT_KSU ADVANCEMENT_ADDRESS_SLOT_KSU	PHONE_PRIMARY_IND PHONE_PRIMARY_IND PHONE_PRIMARY_IND_1 PHONE_PRIMARY_IND_5 PHONE_PRIMARY_IND_2 PHONE_PRIMARY_IND ADDL_PHONE_NOADDR_PRIM_IND_3 PHONE_PRIMARY_IND_6 ADDL_PHONE_NOADDR_PRIM_IND_1 ADDL_PHONE_NOADDR_PRIM_IND_2 ADDL_PHONE_NOADDR_PRIM_IND_5 PHONE_PRIMARY_IND_4 ADDL_PHONE_NOADDR_PRIM_IND_4 ADDL_PHONE_NOADDR_PRIM_IND_5 ADDL_PHONE_NOADDR_PRIM_IND_6 PHONE_PRIMARY_IND_3 AUXILLARY2_PHONE_PRIMARY_IND PHONE_PRIMARY_IND_2 PHONE_PRIMARY_IND_6 AUXILLARY_PHONE_PRIMARY_IND AUXILLARY_PHONE_PRIMARY_IND	NA
SPRTELE_SEQNO	SPATELE	REPORTING VIEW	ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT	PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER PHONE_SEQ_NUMBER	NA
SPRTELE_STATUS_IND	SPATELE	REPORTING VIEW	ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT	PHONE_STATUS_IND PHONE_STATUS_IND PHONE_STATUS_IND	NA
SPRTELE_TELE_CODE	SPATELE	REPORTING VIEW	PERSON TELEPHONE_CURRENT VENDOR ORGANIZATION_ENTITY TELEPHONE VENDOR ADDRESS_PREFERRED	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	PERSON ADDRESS_PREFERRED TELEPHONE_CURRENT ORGANIZATION_CONTACT ORGANIZATION_ENTITY VENDOR TELEPHONE VENDOR	PHONE_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND PHONE_UNLIST_IND ORDER_FROM_PHONE_UNLIST_IND PHONE_UNLIST_IND REMIT_TO_PHONE_UNLIST_IND	NA

Ver: 8.4.1