Composite View Source: SPRADDR

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

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
SPRADDR_ASRC_CODE	SPAIDEN	NO	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_SOURCE	NO	NA
SPRADDR_ATYP_CODE	SPAIDEN	NO	COMPOSITE VIEW	AS_ADDRESS AS_ADDRESS	ADDRESS_TYPE ADDRESS_TYPE	NO NO	NA
SPRADDR_CARRIER_ROUNT	SPAIDEN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT	CARRIER_ROUTE	NO
SPRADDR_CARRIER_ROUTE	SPAIDEN	NO	COMPOSITE VIEW	AS_ADDRESS AS_ADDRESS	CARRIER_ROUTE CARRIER_ROUTE	NO NO
SPRADDR_CITY		NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	CITY CITY CITY CITY CITY CITY CITY CITY	NO NO NO NO NO NO NO NO
SPRADDR_CNTY_CODE	SPAIDEN	NO	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	NO NO NO NO NO NO NO NO	NA
SPRADDR_CORRECTION_DIGIT	SPAIDEN	NO	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	NO NO NO NO NO NO	NA
SPRADDR_COUNTY	SPAIDEN	NO
SPRADDR_DELIVERY_POINT	SPAIDEN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT DELIVERY_POINT	NO NO NO NO NO NO	NA
SPRADDR_FROM_DATE	SPAIDEN	NO	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_START_DATE	NO	NA
SPRADDR_GST_TAX_ID	NA	NO	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_TAX_ID	NO	NA
SPRADDR_HOUSE_NUMBER	SPAIDEN	NO	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	HOUSE_NUMBER HOUSE_NUMBER HOUSE_NUMBER HOUSE_NUMBER	NO NO NO NO
SPRADDR_NATN_CODE	SPAIDEN	NO	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	NO NO NO NO NO NO NO NO	NA
SPRADDR_PIDM	NA	NO	COMPOSITE VIEW	AS_ADDRESS	ENTITY_UID	NO	NA
SPRADDR_SEQNO	SPAIDEN	NO	COMPOSITE VIEW	AS_ADDRESS AS_ADDRESS	ADDRESS_SEQ_NO ADDRESS_SEQ_NO	NO NO	NA
SPRADDR_STATUS_IND	SPAIDEN	NO	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	NO NO NO NO	NA
SPRADDR_STAT_CODE	SPAIDEN	NO	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	NO NO NO NO NO NO NO NO	NA
SPRADDR_STREET_LINE1	FTMFMGR	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1 STREET_LINE1	NO NO NO NO NO NO NO NO
SPRADDR_STREET_LINE2	SPAIDEN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2 STREET_LINE2	NO NO NO NO NO NO NO NO	NA
SPRADDR_STREET_LINE3	SPAIDEN	NO	COMPOSITE VIEW	AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS	STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3 STREET_LINE3	NO NO NO NO NO NO NO NO
SPRADDR_STREET_LINE4	NULL	NO	COMPOSITE VIEW	AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT AS_ADDRESS AA_ORGANIZATION_CONTACT	STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4 STREET_LINE4	NO NO NO NO NO NO NO NO
SPRADDR_TO_DATE	SPAIDEN	NO	COMPOSITE VIEW	AS_ADDRESS	ADDRESS_END_DATE	NO	NA
SPRADDR_ZIP	SPAIDEN	NO	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	NO NO NO NO NO NO NO NO NO NO
STVCNTY_DESC	SPAIDEN	NO
STVSTAT_DESC	SPAIDEN	NO

Ver: