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**
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	AS_ADDRESS AS_ADDRESS	ADDRESS_TYPE ADDRESS_TYPE
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	NA
SPRADDR_CITY	TBD	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
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
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	AS_ADDRESS	HOUSE_NUMBER
SPRADDR_NATN_CODE	TBD	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
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	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE STATE_PROVINCE	NA
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
SPRADDR_STREET_LINE2	SPAIDEN	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	NA
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: