Record Layout

Record Layout - Excel File

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

We have added 138 fields to your original input. The new number of fields is 154.

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:	xls01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - Excel File (cont'd)

FIELD DESCRIPTION	FIELD	MAX LENGTH


Original input record	A - P

Anchor Job Number	Q	3
Anchor Sequence Number	R	9
Reserved	S	4
Reserved	T	1
City (Confirmed / Corrected)	U	15
State (Confirmed / Corrected)	V	2
Zip Code^® (Confirmed / Corrected)	W	5
Zip + 4^® Code	X	4
Delivery Point Barcode	Y	3
Car-rt Code	Z	4



Zip Correction Action Code	AA	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

*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^LinkTM 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

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

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:	xls01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - Excel File (cont'd)

ADDRESS STANDARDIZATION:
FIELD DESCRIPTION	FIELD	MAX LENGTH



ADDRESS FIELDS
Street Address	AE	50
Secondary Address	AF	8
Secondary Address Designator (see last pg)	AG	4
Urbanization	AH	28
Reserved	AI	2
Private Mailbox	AJ	12




FOOTNOTE FIELDS
City/State Corrected ('B' = Yes / blank otherwise)	AK	1
Secondary Number Missing ('H' = Yes / blank otherwise)	AL	1
Delivery Address Component, add/delete/change ('L' = Yes / blank otherwise)	AM	1
Street Name Spelling Changed ('M' = Yes / blank otherwise)	AN	1
Delivery Address Standardized ('N' = Yes / blank otherwise)	AO	1
Invalid Secondary Number ('S' = Yes / blank otherwise)	AP	1
LACS Indicator ('L' = Yes / blank otherwise)	AQ	1
Reserved	AR	1

Layout Rpt page 3

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

APPENDIX

Record Layout - Excel File (cont'd)

FIELD DESCRIPTION	FIELD	MAX LENGTH
NCOA^LinkTM:



NEW NCOA^LinkTM ADDRESS
Street Address	AS	50
Secondary Address Number	AT	8
Secondary Address Designator (see last pg)	AU	4
New Urbanization	AV	28
Reserved	AW	14
Reserved	AX	4
Reserved	AY	1
Reserved	AZ	3
New city name^**	BA	13
Reserved	BB	2
New state (Abbreviated)	BC	2
New ZIP^® code	BD	5
New ZIP + 4^®	BE	4
New Delivery Point Barcode	BF	3
New Corrected Carrier Route Code	BG	4




Effective date of move (YYYYMM)	BH	6
Type of Move	BI	1

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

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

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

Layout Rpt page 4

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

APPENDIX

Record Layout - Excel 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:	xls01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - Excel File (cont'd)

DPV^TM
FIELD DESCRIPTION	CODE	FIELD	MAX LENGTH

DPV:
Matched to ZIP + 4^® Record	'AA'	BM	2
Non-match to ZIP + 4^®	'A1'	BN	2
Alias Street Name Matched to Base Street Name	'A2'	BO	2
Matched to Alternate Record	'A3'	BP	2
Matched to Small Town Default	'A4'	BQ	2
Matched to Unique Zip Default	'A5'	BR	2
Matched to an HDA Record	'A6'	BS	2
Address Rejected due to EWS	'A7'	BT	2
DPV^TM Match on All Components	'BB'	BU	2
No DPV^TM Match on Any Components	'B1'	BV	2
DPV^TM Match on Primary Number but Not Secondary	'CC'	BW	2
Corrected City Name and/or State Info	'D'	BX	1
Input City Name was Non-mailing, and was corrected	'D1'	BY	2
Corrected Primary Address	'E'	BZ	1
Corrected Primary Address Component	'E1'	CA	2
Corrected Primary Street Name	'E2'	CB	2
Primary Address Standardized	'E3'	CC	2
Corrected Secondary Address Data	'F'	CD	1
Out of Range Alias Match	'G4'	CE	2
Zip Code^® Changed	'H'	CF	1
Zip Code^® Added	'H1'	CG	2
Failed to Match Last Line of Address	'J'	CH	1
Multiple-match in Primary Address Field	'K'	CI	1
Multiple-match due to Missing or Incorrect Directionals	'K1'	CJ	2
Multiple-match due to Missing or Incorrect Suffix	'K2'	CK	2
Multiple-match in Secondary Address Field	'L'	CL	1
Missing Street Number	'M1'	CM	2
Address Not Found	'M2'	CN	2
No Such Primary Number	'M3'	CO	2
Firm Name Not Matched	'M4'	CP	2
Missing Secondary Address Number on High-rise Match	'N1'	CQ	2
Secondary Number Not Found	'N2'	CR	2
(DPV continued next page)

Layout Rpt page 6

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

APPENDIX

Record Layout - Excel File (cont'd)

FIELD DESCRIPTION	CODE	FIELD	MAX LENGTH

DPV: (continued)
Missing RR/HC Box Number	'P1'	CS	2
RR/HC Box Number Not Found	'P2'	CT	2
Missing PO Box Number	'Q1'	CU	2
PO Box Number Not Found	'Q2'	CV	2
DPV-CMRA Match	'RR'	CW	2
DPV-CMRA, No Secondary Match	'R1'	CX	2
ZIPMOVE Match	'Z0'	CY	2
ZIPMOVE Non-match due to Component Change	'Z1'	CZ	2
ZIPMOVE Non-match due to Invalid New ZIP + 4^®	'Z2'	DA	2
DPV^TM Match Code (Y = DPV^TM Match)	'Y'	DB	1
Invalid RR/ HC/ PO BOX Number	'P3'	DC	2
Z4 Match Flag		DD	1

Match Flag:

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

DPV^TM Match Footnote

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

DSF: (option not selected, DSF^{2 TM} positions will remain blank)
DSF^{2 TM} Residential Flag	'Y'	DG	1
DSF^{2 TM} Business Flag	'Y'	DH	1
DSF^{2 TM} Drop Flag	'Y'	DI	1
DSF^{2 TM} Drop Count		DJ	6
DSF^{2 TM} Throwback Flag	'Y'	DK	1
DSF^{2 TM} Seasonal Flag	'Y'	DL	1
DSF^{2 TM} Vacant Flag	'Y'	DM	1
DSF^{2 TM} Delivery Type Code		DN	1

CodeKey:

- Curb

- NDCBU

- Central

- Doorslot

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

Layout Rpt page 7

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

APPENDIX

Record Layout - Excel File (cont'd)

FIELD DESCRIPTION	CODE	FIELD	MAX LENGTH

DPV: (continued)
Anchor Deliverability Index Score		DQ	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

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'	DS	1
Reserved		DT	7

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

Layout Rpt page 8

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

APPENDIX

Record Layout - Excel File (cont'd)

FIELD DESCRIPTION	CODE	FIELD	MAX LENGTH

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

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


ZIP+4 Related:

Record Type Code

CodeKey:

- Street

- Firm

- Highrise

- PO Box

- General Delivery

- Rural Route or Highway Contract

County Code	DX	3
Congressional District Number	DY	2

Layout Rpt page 9

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

APPENDIX

Record Layout - Excel File (cont'd)

FIELD DESCRIPTION	FIELD	MAX LENGTH

FINAL ADDRESS:




Full Address	DZ	50
House Number	EA	10
PreDirection	EB	02
Street Name	EC	28
Street Suffix	ED	04
PostDirection	EE	02
Secondary Address Designator (see last pg)	EF	04
Secondary Address Value	EG	08
PO Box Description	EH	06
PO Number	EI	10
RR/HC Number	EJ	10
RR/HC Box	EK	10
City	EL	13
State	EM	02
Zip Code^®	EN	05
Zip + 4^® Code	EO	04
Delivery Point Barcode	EP	03
Carrier Route	EQ	04
Reserved	ER	04
Reserved	ES	01
Urbanization	ET	28
Private Mailbox Number	EU	12
Reserved	EV	01
Reserved	EW	09
Secondary Address Indicator^*	EX	01

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:	xls01
Date:	06/09/2005
Client:	ANCHOR COMPUTER

APPENDIX

Record Layout - Excel 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