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 TELEPHONE_CURRENT ADDRESS_PREFERRED	PHONE_COMMENT PHONE_COMMENT PHONE_COMMENT	NA
SPRTELE_CTRY_CODE_PHONE	TBD	REPORTING VIEW	TELEPHONE TELEPHONE_CURRENT ORGANIZATION_CONTACT ADDRESS_PREFERRED ORGANIZATION_CONTACT	COUNTRY_CODE COUNTRY_CODE PHONE_COUNTRY_CODE COUNTRY_CODE FAX_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 GRANT_PERSONNEL TELEPHONE ORGANIZATION_CONTACT PHONE_ASSIGNMENT ORGANIZATION_CONTACT TELEPHONE_CURRENT ADDRESS_PREFERRED ORGANIZATION_CONTACT_SLOT	PHONE_AREA_1 PHONE_AREA PHONE_AREA PHONE_AREA PHONE_AREA FAX_AREA PHONE_AREA PHONE_AREA PHONE_AREA_2	NA
SPRTELE_PHONE_EXT	SPATELE	REPORTING VIEW	ORGANIZATION_CONTACT TELEPHONE ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ADDRESS_PREFERRED GRANT_PERSONNEL TELEPHONE_CURRENT	FAX_EXT PHONE_EXT PHONE_EXT_2 PHONE_EXT PHONE_EXT_1 PHONE_EXT PHONE_EXT PHONE_EXT	NA
SPRTELE_PHONE_NUMBER	SPATELE	REPORTING VIEW	TELEPHONE ORGANIZATION_CONTACT_SLOT ORGANIZATION_CONTACT ORGANIZATION_CONTACT_SLOT ADDRESS_PREFERRED TELEPHONE_CURRENT ORGANIZATION_CONTACT GRANT_PERSONNEL	PHONE_NUMBER PHONE_NUMBER_1 PHONE_NUMBER PHONE_NUMBER_2 PHONE_NUMBER PHONE_NUMBER FAX_NUMBER PHONE_NUMBER	NA
SPRTELE_PIDM	NA				NA
SPRTELE_PRIMARY_IND	SPATELE	REPORTING VIEW	ADDRESS_PREFERRED TELEPHONE_CURRENT TELEPHONE	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	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 ORGANIZATION_CONTACT ORGANIZATION_CONTACT ADDRESS_PREFERRED TELEPHONE_CURRENT ORGANIZATION_ENTITY VENDOR TELEPHONE VENDOR	PHONE_UNLIST_IND FAX_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: 9.0