Composite View Source: SPRADDR

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
SPRADDR_CNTY_CODE	APAIDEN
SPRADDR_NATN_CODE	APAIDEN
SPRADDR_ASRC_CODE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_SOURCE	NA
SPRADDR_ATYP_CODE	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	ADDRESS_TYPE ADDRESS_TYPE	NA
SPRADDR_CARRIER_ROUTE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	CARRIER_ROUTE	NA
SPRADDR_CITY	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	CITY	NA
SPRADDR_CNTY_CODE	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	COUNTY COUNTY_CODE	NA
SPRADDR_CORRECTION_DIGIT	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	CORRECTION_DIGIT CORRECTION_DIGIT	NA
SPRADDR_DELIVERY_POINT	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	DELIVERY_POINT DELIVERY_POINT	NA
SPRADDR_FROM_DATE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_START_DATE	NA
SPRADDR_GST_TAX_ID	NA	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_TAX_ID	NA
SPRADDR_NATN_CODE	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	NATION NATION	NA
SPRADDR_PIDM	NA	COMPOSITE VIEW	AS_ADDRESS	ENTITY_UID	NA
SPRADDR_SEQNO	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_SEQ_NO	NA
SPRADDR_STATUS_IND	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_STATUS_IND	NA
SPRADDR_STAT_CODE	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	STATE_PROVINCE STATE_PROVINCE	NA
SPRADDR_STREET_LINE1	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE1 STREET_LINE1	NA
SPRADDR_STREET_LINE2	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE2 STREET_LINE2	NA
SPRADDR_STREET_LINE3	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE3 STREET_LINE3	NA
SPRADDR_TO_DATE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_END_DATE	NA
SPRADDR_ZIP	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS	POSTAL_CODE POSTAL_CODE	NA

Ver: 8.1