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_ASRC_CODE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_SOURCE	NA
SPRADDR_ATYP_CODE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AS_ADDRESS	ADDRESS_TYPE ADDRESS_TYPE	NA
SPRADDR_CARRIER_ROUNT	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CARRIER_ROUTE
SPRADDR_CARRIER_ROUTE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AS_ADDRESS	CARRIER_ROUTE CARRIER_ROUTE
SPRADDR_CITY	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	CITY CITY CITY CITY CITY CITY CITY CITY	NA
SPRADDR_CNTY_CODE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	COUNTY_CODE COUNTY COUNTY_CODE COUNTY COUNTY_CODE COUNTY COUNTY_CODE COUNTY
SPRADDR_CORRECTION_DIGIT	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT CORRECTION_DIGIT
SPRADDR_COUNTY	SPAIDEN
SPRADDR_DELIVERY_POINT	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT 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_HOUSE_NUMBER	TBD	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	HOUSE_NUMBER HOUSE_NUMBER HOUSE_NUMBER HOUSE_NUMBER
SPRADDR_NATN_CODE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	NATION NATION NATION NATION NATION NATION NATION NATION	NA
SPRADDR_PIDM	NA	COMPOSITE VIEW	AS_ADDRESS	ENTITY_UID	NA
SPRADDR_SEQNO	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AS_ADDRESS	ADDRESS_SEQ_NO ADDRESS_SEQ_NO	NA
SPRADDR_STATUS_IND	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	CONTACT_ADDRESS_STATUS_IND ADDRESS_STATUS_IND CONTACT_ADDRESS_STATUS_IND ADDRESS_STATUS_IND
SPRADDR_STAT_CODE	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE
SPRADDR_STREET_LINE1	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1	NA
SPRADDR_STREET_LINE2	FTMFMGR	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2
SPRADDR_STREET_LINE3	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3
SPRADDR_STREET_LINE4	SPAIDEN	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4
SPRADDR_TO_DATE	SPAIDEN	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_END_DATE	NA
SPRADDR_ZIP	FTMFMGR	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE POSTAL_CODE
STVCNTY_DESC	SPAIDEN
STVSTAT_DESC	SPAIDEN

Ver: