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 TELEPHONE_CURRENT	ADDRESS_TYPE ADDRESS_TYPE	NA
SPRTELE_COMMENT	SPATELE	REPORTING VIEW	TELEPHONE_CURRENT ADDRESS_PREFERRED TELEPHONE	PHONE_COMMENT PHONE_COMMENT PHONE_COMMENT	NA
SPRTELE_CTRY_CODE_PHONE	TBD	REPORTING VIEW	ORGANIZATION_CONTACT ORGANIZATION_CONTACT ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT	PHONE_COUNTRY_CODE FAX_COUNTRY_CODE COUNTRY_CODE COUNTRY_CODE COUNTRY_CODE
SPRTELE_INTL_ACCESS	SPATELE	REPORTING VIEW	ADDRESS_PREFERRED TELEPHONE TELEPHONE_CURRENT	PHONE_INTL_ACCESS PHONE_INTL_ACCESS PHONE_INTL_ACCESS	NA
SPRTELE_PHONE_AREA	SPATELE	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	NA
SPRTELE_PHONE_EXT	SPATELE	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	NA
SPRTELE_PHONE_NUMBER	SPATELE	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	NA
SPRTELE_PIDM	NA				NA
SPRTELE_PRIMARY_IND	SPATELE	REPORTING VIEW	TELEPHONE ADDRESS_PREFERRED TELEPHONE_CURRENT	PHONE_PRIMARY_IND PHONE_PRIMARY_IND 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	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	NA
SPRTELE_UNLIST_IND	SPATELE	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	NA

Ver: 8.5