| 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 |
|
|
|
|
|