Composite View Source: SPRADDR

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: SPRADDR Travel And Expense

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
SPRADDR_CNTY_CODE	APAIDEN
SPRADDR_NATN_CODE	APAIDEN
SPRADDR_ASRC_CODE	SPAIDEN	AS_ADDRESS	ADDRESS_SOURCE
SPRADDR_ATYP_CODE	SPAIDEN	AA_ORGANIZATION_CONTACT AS_ADDRESS	ADDRESS_TYPE ADDRESS_TYPE
SPRADDR_CARRIER_ROUTE	SPAIDEN	AS_ADDRESS	CARRIER_ROUTE
SPRADDR_CITY	SPAIDEN	AS_ADDRESS AS_ADDRESS AS_ADDRESS	CITY CITY CITY
SPRADDR_CNTY_CODE	FTMFMGR	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	COUNTY_CODE COUNTY COUNTY_CODE COUNTY COUNTY_CODE COUNTY
SPRADDR_CORRECTION_DIGIT	SPAIDEN	AA_ORGANIZATION_CONTACT AS_ADDRESS	CORRECTION_DIGIT CORRECTION_DIGIT
SPRADDR_DELIVERY_POINT	SPAIDEN	AS_ADDRESS AA_ORGANIZATION_CONTACT	DELIVERY_POINT DELIVERY_POINT
SPRADDR_FROM_DATE	SPAIDEN	AS_ADDRESS	ADDRESS_START_DATE
SPRADDR_GST_TAX_ID	NA	AS_ADDRESS	ADDRESS_TAX_ID
SPRADDR_HOUSE_NUMBER	TBD	AS_ADDRESS	HOUSE_NUMBER
SPRADDR_NATN_CODE	SPAIDEN	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	NATION NATION NATION NATION NATION NATION
SPRADDR_PIDM	NA	AS_ADDRESS	ENTITY_UID
SPRADDR_SEQNO	SPAIDEN	AS_ADDRESS	ADDRESS_SEQ_NO
SPRADDR_STATUS_IND	SPAIDEN	AS_ADDRESS	ADDRESS_STATUS_IND
SPRADDR_STAT_CODE	SPAIDEN	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
SPRADDR_STREET_LINE1	FTMFMGR	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
SPRADDR_STREET_LINE2	FTMFMGR	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
SPRADDR_STREET_LINE3	SPAIDEN	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3
SPRADDR_STREET_LINE4	NULL	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4
SPRADDR_TO_DATE	SPAIDEN	AS_ADDRESS	ADDRESS_END_DATE
SPRADDR_ZIP	SPAIDEN	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

Ver: 8.3