DataFlux Data Management Studio 2.5: User Guide
The Address Update Lookup node can accept the inputs are listed in following table:
| Index | Use |
| 0 | Addressee name |
| 1 | Address (Street address) |
| 2 | Last Line (City, state, ZIP) |
The outputs from the Address Update Lookup node are listed in following table:
| Field | ID | Use |
| ADDRESSEE | 0 | Addressee name (copied from input) |
| ADDRESS | 1 | Street address of the changed address (if found). Built from fields 11-17 |
| LASTLINE | 2 | City, State, ZIP of the changed address (if found). Built from fields 18-21 |
| URBANIZATION | 3 | Urbanization name |
| CRID | 4 | Carrier route ID of the changed address (if found) |
| DELIVPT | 5 | Delivery point of the changed address (if found) |
| DPCD | 6 | Delivery pt. check digit |
| MOVETYPE | 7 | Family, Business, Individual (F,I,B) |
| RESULT | 8 | NCOA lookup result / footnote |
| DATADATE | 9 | NCOA DVD data date |
| NCOADVDDATE | 10 | NCOA DVD release date |
| PNO | 11 | Primary street number |
| PRE | 12 | Prefix/pre-directional |
| NAM | 13 | Street name |
| SUF | 14 | Suffix |
| POS | 15 | Post-directional |
| DSC | 16 | Descriptor |
| SNO | 17 | Secondary number |
| CITY | 18 | City name |
| STAT | 19 | State abbreviation |
| FIVE | 20 | ZIP 5 |
| FOUR | 21 | ZIP +4 |
| MED | 22 | Move Effective Date |
| MED_EXCL | 23 | Address was matched but excluded from results due to M.E.D. filter: 'Y' or 'N' |
|
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfDMStd_PF_NCOA_IN_OUT.html |