Record Layout

Record Layout - DBF File

* CASS^TM * NCOA^LinkTM * DPV^TM *

We have added 138 columns to your original input.

The 'Final Address' appendage represents the result of the last process that updated or standardized your address. If we were unable to ZIP+4^® code the input address, the 'Final Address' will contain our best effort at standardizing the original address. However, if the ZIP+4^® code is blank, always use your original address fields. In these cases, the address standardization process may be unable to recognize all the address elements, and therefore may not return a complete standardized address.

When a change has occurred, the new address information will also be found in the 'New' fields. (If no change, these fields are blank). In the 'Standard' address fields is address information that met the standardization criteria or was standardized. If the original address information could not be standardized, the original address will be in the standardized address field. However, if the ZIP+4^® code is blank, always use your original address fields. In these cases the address standardization process may be unable to recognize all the address elements, and therefore may not return a complete standardized address.

Please take extreme caution in comparing and matching your job number, file description, as well as the enclosed layout and your original dump and layout. We have checked the work, but recommend that you check it as well.

LIABILITY NOTICE

Anchor shall not be liable to client for the complete accuracy of all data examined and/or altered, nor from any loss or injury arising out of or caused, in whole or in part, by Anchor's negligent acts or omissions in procuring, compiling, collecting, processing, communicating, or delivering the data mentioned herein, directly or indirectly to client. Anchor's sole liability and client's sole remedy, regardless of the form of legal action taken by client, whether in tort or contract, shall not exceed the refund of the amounts, if any, paid by client. Client agrees Anchor shall not be liable for lost profits or any indirect, incidental, special, or consequential damages, even if advised of the possibility of such damages.

The aforementioned paragraph is extracted from the terms and conditions in the 'Processing Acknowledgement Form' that must be signed by all clients prior to the commencement of services. By signing that form the client acknowledges and accepts all the terms and conditions stated therein. Anchor may modify any or all terms and conditions of service by posting any such changes on its web site at www.anchorcomputer.com.

Thank you for your business

If you have any questions, please contact our client services department:

631-293-6100

888-728-6262

E@anchorcomputer.com

Layout Rpt page 1

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

FIELD DESCRIPTION	COLUMN NAME	LENGTH


Original input record	ORIG_REC





Anchor Job Number	ACI_JOBNUM	3
Anchor Sequence Number	ACI_SEQ	9
Reserved	STD_LOTNUM	4
Reserved	STD_LOTCODE	1
City (Confirmed / Corrected)	STD_CITY	15
State (Confirmed / Corrected)	STD_STATE	2
Zip Code^® (Confirmed / Corrected)	STD_ZIP	5
Zip + 4^® Code	STD_ZIP4	4
Delivery Point Barcode	STD_DPBC	3
Car-rt Code	STD_CARRT	4



Zip Correction Action Code	STD_ZCAC	1

CodeKey:	A - The ZIP Code^® was altered
	B - No match was available and original ZIP Code^® was invalid
	C - The original ZIP Code^® was confirmed
	O - The original ZIP Code^® was kept because no address match was found

Anchor COA Index

NCO_COAIND

*The use of these Anchor generated fields is described in detail in Anchor's NCOA^LinkTM user manual.*
CodeKey:	1 - Moved, New Address Provided, Action code Equals to I, or M, or O
	2 - Did Not Match NCOA^Link Database, Action code Equals to C
	3 - Probably Not Moved, Action code Equal to B and Return Code Equal to 4, 6, 7, 8, 9, 10, 12, 13, 17, 18, or 20
	4 - Probably Moved, Action code Equal to B and Return Code Equal to 11, 15, or 16
	5 - Moved, No Forwarding Address Provided, Action code Equals to F, or G, or K, or P

Address Type Code

STD_ADDTYP

CodeKey:	F - Firm Delivery	S - Street Address
	R - Rural Route or Hwy Contract	P - PO Box
	G - General Delivery	Blank - No Match Determined
	H - High Rise

Action Code

NCOA_ACTION

CodeKey:	B - Possible Mover, See NCOA^LinkTM Return Codes	K - No Fowarding Address
	C - No Match	O - Business Move
	I - Individual New Address	G - P.O. Box Closed
	F - Foreign Move	P - Moved, Primary Address Unconfirmed
	M - Family Move

Layout Rpt page 2

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

ADDRESS STANDARDIZATION:
FIELD DESCRIPTION	COLUMN NAME	LENGTH



ADDRESS FIELDS
Street Address	STD_ADDR	50
Secondary Address	STD_SECNUM	8
Secondary Address Designator (see last pg)	STD_SECDES	4
Urbanization	STD_URB	28
Reserved	RES_4	2
Private Mailbox	STD_PMB	12




FOOTNOTE FIELDS
City/State Corrected ('B' = Yes / blank otherwise)	STD_FTNT_B	1
Secondary Number Missing ('H' = Yes / blank otherwise)	STD_FTNT_H	1
Delivery Address Component, add/delete/change ('L' = Yes / blank otherwise)	STD_FTNT_L	1
Street Name Spelling Changed ('M' = Yes / blank otherwise)	STD_FTNT_M	1
Delivery Address Standardized ('N' = Yes / blank otherwise)	STD_FTNT_N	1
Invalid Secondary Number ('S' = Yes / blank otherwise)	STD_FTNT_S	1
LACS Indicator ('L' = Yes / blank otherwise)	LACS_IND	1
Reserved	RES_5	1

Layout Rpt page 3

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

FIELD DESCRIPTION	COLUMN NAME	LENGTH
NCOA^Link:




NEW NCOA^Link ADDRESS
Street Address	NCO_ADDR	50
Secondary Address Number	NCO_SECNUM	8
Secondary Address Designator (see last pg)	NCO_SECDES	4
New Urbanization	NCO_URB	28
Reserved	NCO_RESRV1	14
Reserved	NCO_LOTNUM	4
Reserved	NCO_LOTCOD	1
Reserved	NCO_RESRV2	3
New city name^**	NCO_CITY	13
Reserved	NCO_RESRV3	2
New state (Abbreviated)	NCO_STATE	2
New ZIP^® code	NCO_ZIP	5
New ZIP + 4^®	NCO_ZIP4	4
New Delivery Point Barcode	NCO_DPBC	3
New Corrected Carrier Route Code	NCO_CARRT	4




Effective date of move (YYYYMM)	NCO_MOVEDT	6
Type of Move	NCO_MVTYPE	1

CodeKey:	I - Individual Match Logic Used
	F - Family Match Logic Used
	B - Business Match Logic Used

Match NCOA^LinkTM Return Code (see next pg)	NCO_FOOTNT	2
Name Used For Match (Business or individual, only present on match)	NCO_NAME	40
Reserved	RES_6	10

** The Postal Service only provides a 13 character city field which may represent a standardized abbreviated version.

Layout Rpt page 4

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

NCOALINK RETURN CODE DESCRIPTIONS




FORWARDABLE MOVERS
A - COA Match, New Address Is furnished.
91 - COA Match, Secondary Number Dropped From COA.
92 - COA Match, Secondary Number Dropped From Input Address.

NON-FORWARDABLE MOVERS
01 - Found COA, Foreign Move.
02 - Found COA, Moved Left No Forwarding Address.
03 - Found COA, Box Closed No Order.
05 - Found COA, 11-digit DPBC is ambiguous for New Address.
14 - Found COA, New Address Would Not Convert to a Deliverable One.
19 - Found COA, New Address Not ZIP + 4^® Codeable.

POSSIBLE MOVERS
04 - Cannot Match COA, Input record is Missing Secondary Number & First Name Does Not Match.
06 - Cannot Match COA, Individual Move, Multiple Match because Middle Name or Initial Does Not Match.
07 - Cannot Match COA, Individual Move, Multiple Match because Gender Does Not Match.
08 - Cannot Match COA, The Input record matched to two Master File records that have different New Addresses.
09 - Cannot Match COA, Family Match, Master File record is from a High-rise address ZIP+4 coded to the building default and First Name does not match.
10 - Cannot Match COA, Family Match, Master File record is from a Rural Route or Highway Contract Route address ZIP+4 coded to the route default and First Name does not match.
11 - Cannot Match COA, Individual Match, Master File record has insufficient First Name information.
12 - Found COA, Middle Name or Initial does not match, First Name, Surname, and Address matched.
13 - Found COA, Gender Test Failed, First Name, Surname, and Address matched.
15 - Found COA, Individual Match, Input record does not contain First Name or contains First Initial only, Surname and Address matched.
16 - Found COA, Surname and Address matched, match is prohibited based on 1 of the following reasons: 1) First Name matched, but there is a conflicting Secondary Address information on the Input and Master File records. 2) Input record with Secondary Address Information matched to Master File record without Secondary Address and First Name does not match.
17 - Found COA, Input First Name is different or not sufficient enough to produce a match.
18 - Cannot Match COA, Family Match, General Delivery, First Name does not match.
20 - Cannot Match COA, Multiple Master File records with different New Addresses were potential matches.

MISCELLANEOUS
00 - No Match.
66 - Match to Daily Deletes File.

Layout Rpt page 5

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

DPV^TM
FIELD DESCRIPTION	CODE	COLUMN NAME	LENGTH

DPV:
Matched to ZIP + 4^® Record	'AA'	DPV_AA	2
Non-match to ZIP + 4^®	'A1'	DPV_A1	2
Alias Street Name Matched to Base Street Name	'A2'	DPV_A2	2
Matched to Alternate Record	'A3'	DPV_A3	2
Matched to Small Town Default	'A4'	DPV_A4	2
Matched to Unique Zip Default	'A5'	DPV_A5	2
Matched to an HDA Record	'A6'	DPV_A6	2
Address Rejected due to EWS	'A7'	DPV_A7	2
DPV^TM Match on All Components	'BB'	DPV_BB	2
No DPV^TM Match on Any Components	'B1'	DPV_B1	2
DPV^TM Match on Primary Number but Not Secondary	'CC'	DPV_CC	2
Corrected City Name and/or State Info	'D'	DPV_D	1
Input City Name was Non-mailing, and was corrected	'D1'	DPV_D1	2
Corrected Primary Address	'E'	DPV_E	1
Corrected Primary Address Component	'E1'	DPV_E1	2
Corrected Primary Street Name	'E2'	DPV_E2	2
Primary Address Standardized	'E3'	DPV_E3	2
Corrected Secondary Address Data	'F'	DPV_F	1
Out of Range Alias Match	'G4'	DPV_G4	2
Zip Code^® Changed	'H'	DPV_H	1
Zip Code^® Added	'H1'	DPV_H1	2
Failed to Match Last Line of Address	'J'	DPV_J	1
Multiple-match in Primary Address Field	'K'	DPV_K	1
Multiple-match due to Missing or Incorrect Directionals	'K1'	DPV_K1	2
Multiple-match due to Missing or Incorrect Suffix	'K2'	DPV_K2	2
Multiple-match in Secondary Address Field	'L'	DPV_L	1
Missing Street Number	'M1'	DPV_M1	2
Address Not Found	'M2'	DPV_M1	2
No Such Primary Number	'M3'	DPV_M3	2
Firm Name Not Matched	'M4'	DPV_M4	2
Missing Secondary Address Number on High-rise Match	'N1'	DPV_N1	2
Secondary Number Not Found	'N2'	DPV_N2	2
(DPV continued next page)

Layout Rpt page 6

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

FIELD DESCRIPTION	CODE	COLUMN NAME	LENGTH

DPV: (continued)
Missing RR/HC Box Number	'P1'	DPV_P1	2
RR/HC Box Number Not Found	'P2'	DPV_P2	2
Missing PO Box Number	'Q1'	DPV_Q1	2
PO Box Number Not Found	'Q2'	DPV_Q2	2
DPV-CMRA Match	'RR'	DPV_RR	2
DPV-CMRA, No Secondary Match	'R1'	DPV_R1	2
ZIPMOVE Match	'Z0'	DPV_Z0	2
ZIPMOVE Non-match due to Component Change	'Z1'	DPV_Z1	2
ZIPMOVE Non-match due to Invalid New ZIP + 4^®	'Z2'	DPV_Z2	2
DPV^TM Match Code (Y = DPV^TM Match)	'Y'	DPV_MCODE	1
Invalid RR/ HC/ PO BOX Number	'P3'	DPV_P3	2
Z4 Match Flag		DPV_Z4MF	1

Match Flag:

1 - Match Assisted by Input ZIP + 4^® ('X1' Footnote Returned)

DPV^TM Match Footnote

DPV_MFNT

Footnote:	BB	- Match to DPV^TM on all components
	CC	- Match to DPV^TM File. Secondary Addr present but not used
	N1	- Match to DPV^TM File. Address is missing Secondary Addr Component
	F1	- Match to DPV^TM File. Military Address
	G1	- Match to DPV^TM File. General Delivery
	U1	- Match to DPV^TM File. Unique ZIP Code^®

Reserved		DPV_RSRV1	4
DSF: (option not selected, DSF^{2 TM} positions will remain blank)
DSF^{2 TM} Residential Flag	'Y'	DSF_RESFLG	1
DSF^{2 TM} Business Flag	'Y'	DSF_BUSFLG	1
DSF^{2 TM} Drop Flag	'Y'	DSF_DRPFLG	1
DSF^{2 TM} Drop Count		DSF_DRPCNT	6
DSF^{2 TM} Throwback Flag	'Y'	DSF_TBKCNT	1
DSF^{2 TM} Seasonal Flag	'Y'	DSF_SEASON	1
DSF^{2 TM} Vacant Flag	'Y'	DSF_VACANT	1
DSF^{2 TM} Delivery Type Code		DSF_DELTYP	1

CodeKey:

- Curb

- NDCBU

- Central

- Doorslot

DSF^{2 TM} LACS Flag	'Y'	DSF_LACS	1
DSF^{2 TM} No-Stats-Available Flag	'Y'	DSF_NOSTAT	1
(DPV continued next page)

Layout Rpt page 7

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

FIELD DESCRIPTION	CODE	COLUMN NAME	LENGTH

DPV: (continued)
Anchor Deliverability Index Score		DPV_ADI	2

Index Score:	1	- Footnote 'BB', 'CC', 'N1', 'F1', 'G1', or 'U1' matched (as well as 'AA').
	1V	- Footnote 'BB', 'CC', 'N1', 'F1', 'G1', or 'U1' matched (as well as 'AA'), but Vacant. For DSF^{2 TM} only.
	1S	- Footnote 'BB', 'CC', 'N1', 'F1', 'G1', or 'U1' matched (as well as 'AA'), but Seasonal. For DSF^{2 TM} only.
	1R	- Footnote 'BB', 'CC', 'N1', 'F1', 'G1', or 'U1' matched (as well as 'AA', 'RR', 'R1'). Address is CMRA.
	2	- Footnote 'AA' matched (but did not match to 'BB', 'CC', 'N1', 'F1', 'G1', or 'U1').
	3	- Footnote 'A1', and possibly footnotes not represented within criteria for scores '4' or '5'.
	4	- Footnote 'A1', as well as one of footnotes 'K1', 'K2'.
	5	- Footnote 'A1', as well as one of footnotes 'J', 'K', 'M1', 'M2', 'Q1', 'Q2', 'Z1', 'Z2'.

DSF^{2 TM} Delivery Type Summary Code

DSF_TYPSUM

Summary Code:	A	- Residential Delivery Curb
	AV	- Residential Delivery Curb - Vacant
	B	- Residential Delivery NDCBU
	BV	- Residential Delivery NDCBU - Vacant
	C	- Residential Delivery Central
	CV	- Residential Delivery Central - Vacant
	D	- Residential Delivery Doorslot
	DV	- Residential Delivery Doorslot - Vacant
	I	- Business Delivery Curb
	IV	- Business Delivery Curb - Vacant
	J	- Business Delivery NDCBU
	JV	- Business Delivery NDCBU - Vacant
	K	- Business Delivery Central
	KV	- Business Delivery Central - Vacant
	L	- Business Delivery Doorslot
	LV	- Business Delivery Doorslot - Vacant
	M	- Business Delivery Unknown Delivery Type
	MV	- Business Delivery Unknown Delivery Type - Vacant
	Q	- Educational Delivery Curb
	QV	- Educational Delivery Curb - Vacant
	R	- Educational Delivery NDCBU
	RV	- Educational Delivery NDCBU - Vacant
	S	- Educational Delivery Central
	SV	- Educational Delivery Central - Vacant
	T	- Educational Delivery Doorslot
	TV	- Educational Delivery Doorslot - Vacant
	U	- Educational Delivery Unknown Delivery Type
	UV	- Educational Delivery Unknown Delivery Type - Vacant

DSF^{2 TM} Educational Flag	'Y'	DSF_EDUFLG	1
Reserved		DSF_RSRV1	7

DSF^{2 TM} Pseudo Delivery Sequence Number		DSF_DEL_SQ	4
(DPV continued next page)

Layout Rpt page 8

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

FIELD DESCRIPTION	CODE	COLUMN NAME	LENGTH

DPV: (continued)
DSF^{2 TM} Address Unit Type		DSF_UN_TYP	1

Unit Type:	B	- Business
	C	- CMRA
	P	- PO Box
	S	- SFDU
	M	- MFDU
	U	- Unknown


ZIP+4 Related:
Record Type Code	ZP4_RECTYP	1

CodeKey:

- Street

- Firm

- Highrise

- PO Box

- General Delivery

- Rural Route or Highway Contract

County Code	ZP4_COUNTY	3
Congressional District Number	ZP4_CDN	2

Layout Rpt page 9

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

FIELD DESCRIPTION	COLUMN NAME	LENGTH

FINAL ADDRESS:




Full Address	FIN_ADDR	50
House Number	FIN_HSENUM	10
PreDirection	FIN_PREDIR	2
Street Name	FIN_STREET	28
Street Suffix	FIN_SUFFIX	4
PostDirection	FIN_PSTDIR	2
Secondary Address Designator (see last pg)	FIN_SECDES	4
Secondary Address Value	FIN_SECNUM	8
PO Box Description	FIN_PODES	6
PO Number	FIN_PONUM	10
RR/HC Number	FIN_RRNUM	10
RR/HC Box	FIN_RRBOX	10
City	FIN_CITY	13
State	FIN_STATE	2
Zip Code^®	FIN_ZIP	5
Zip + 4^® Code	FIN_ZIP4	4
Delivery Point Barcode	FIN_DPBC	3
Carrier Route	FIN_CRRT	4
Reserved	FIN_LOTNUM	4
Reserved	FIN_LOTCOD	1
Urbanization	FIN_URB	28
Private Mailbox Number	FIN_PMB	12
Reserved	FIN_RESRV1	1
Reserved	FIN_RESRV2	9
Secondary Address Indicator^*	FIN_SCDIND	1

If set to 'X', to avoid truncation of the Secondary Address, the Secondary Address has not been appended to
the Full Address field. In this case, the Secondary Address can be obtained from the Secondary Address
Designator, and Secondary Address Value fields. This flag will also be set to 'X' if both a Secondary Address
and Private Mailbox Number could not be appended to the Full Address field. In cases where only the PMB
could not be applied to the Full Address, this flag will be set to 'P'.

Layout Rpt page 10

Job:	dbf01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - DBF File (cont'd)

SECONDARY ADDRESS DESIGNATOR DESCRIPTIONS

Abbreviation	Descriptor	Abbreviation	Descriptor



APT	Apartment	PIER	Pier
BSMT	Basement	REAR	Rear
BLDG	Building	RM	Room
DEPT	Department	SIDE	Side
FL	Floor	SLIP	Slip
FRNT	Front	STOP	Stop
HNGR	Hanger	STE	Suite
LBBY	Lobby	TRLR	Trailer
LOT	Lot	UNIT	Unit
LOWR	Lower	#	Unknown
OFC	Office	UPPR	Upper
PH	Penthouse

Layout Rpt page 11