16085-CONTRACT.DOC

Maricopa County — Formal (2016-07-20)

View PDF Item 60 Meeting page

Extracted text (via pymupdf_layout) 88686 characters
SERIAL 16085-S PRINT AND MAIL TAX STATEMENTS AND VALUATION NOTICES
DATE OF LAST REVISION: July 20, 2016 CONTRACT END DATE: July 31, 2017
CONTRACT PERIOD THROUGH JULY 31, 2017
TO: All Departments
FROM: Office of Procurement Services
SUBJECT: Contract for PRINT AND MAIL TAX STATEMENTS AND VALUATION NOTICES
Attached to this letter is published an effective purchasing contract for products and/or services to be supplied to
Maricopa County activities as awarded by Maricopa County on July 20, 2016.
All purchases of products and/or services listed on the attached pages of this letter are to be obtained from the
vendor holding the contract. Individuals are responsible to the vendor for purchases made outside of contracts.
The contract period is indicated above.
BW/at
Attach
Copy to: Office of Procurement Services
Lesley Kratz, Assessor
Jon Riggins, Treasurer
(Please remove Serial 09132-S from your contract notebooks)

SERIAL 16085-S
THE MASTER'S TOUCH, LLC, 1405 N ASH ST., SPOKANE, WA 99201
COMPANY NAME: The Master's Touch, LLC
DOING BUSINESS AS (DBA) NAME:
MAILING ADDRESS: 1405 n Ash St., Spokane, WA 99201
REMIT TO ADDRESS: Same as above
TELEPHONE NUMBER: 800-301-1347
FACSIMILE NUMBER: 888-828-4659
WEB SITE: www.themasterstouch.com
REPRESENTATIVE NAME: Jim Cote'
REPRESENTATIVE TELEPHONE NUMBER: 800-301-1347
REPRESENTATIVE E-MAIL: masters@themasterstouch.com
YES NO REBATE
WILL ALLOW OTHER GOVERNMENTAL ENTITIES TO PURCHASE FROM
THIS CONTRACT:
WILL ACCEPT PROCUREMENT CARD FOR PAYMENT:
FUEL COMPRISES (if section for fuel price adjustment is 0% OF TOTAL BID AMOUNT
located in the solicitation document)
PAYMENT TERMS:
NET 30 DAYS
Printing
Printing Paper US
Paper Not POSTCARD PDF
ITEM DESCRIPTION 11"X17" 8.5"X11" Supplied Supplied 8.5"X14" 9.0 STOCK ARCHIVE
We supply We supply Paper We We supply We supply
1.0 ONE COLOR paper paper provided supply paper paper
SIMPLEX by County paper
$35.5000 /per $26.9000 /per $30.4500 $20.0000 /per $5.00 /per
1.1 1 TO 100,000 1,000 1,000 $17.9000 $26.9000 /per 1,000 1,000 1,000
$34.3500 /per $25.7500 /per $29.2500 $19.0000 /per $5.00 /per
1.2 100,001 TO 500,000 1,000 1,000 $16.7500 $25.7500 /per 1,000 1,000 1,000
$34.0000 /per $25.4000 /per $28.9000 $18.5000 /per $5.00 /per
1.3 500,001 TO 1,000,000 1,000 1,000 $16.4000 $25.4000 /per 1,000 1,000 1,000
$33.9500 /per $25.3500 /per $28.8500 $18.5000 /per $5.00 /per
1.4 1,000,001 + 1,000 1,000 $16.3500 $25.3500 /per 1,000 1,000 1,000
2.0 ONE COLOR DUPLEX
$47.1000 /per $38.5000 /per $42.0000 $25.0000 /per $5.00 /per
2.1 1 TO 100,000 1,000 1,000 $29.5000 $38.5000 /per 1,000 1,000 1,000
$45.9000 /per $37.3000 /per $40.8000 $23.5000 /per $5.00 /per
2.2 100,001 TO 500,000 1,000 1,000 $28.3000 $37.3000 /per 1,000 1,000 1,000
$45.6000 /per $37.0000 /per $40.2500 $23.0000 /per $5.00 /per
2.3 500,001 TO 1,000,000 1,000 1,000 $28.0000 $37.0000 /per 1,000 1,000 1,000
$45.5000 /per $36.9000 /per $40.4000 $22.7700 /per $5.00 /per
2.4 1,000,001 + 1,000 1,000 $27.9000 $36.9000 /per 1,000 1,000 1,000

SERIAL 16085-S
THE MASTER'S TOUCH, LLC, 1405 N ASH ST., SPOKANE, WA 99201
Printing
Printing Paper US
Paper Not POSTCARD PDF
ITEM DESCRIPTION 11"X17" 8.5"X11" Supplied Supplied 8.5"X14" 9.0 STOCK ARCHIVE
3.0 TWO COLOR SIMPLEX
$52.8000 /per $37.1000 /per $41.2500 $21.0000 /per $5.00 /per
3.1 1 TO 100,000 1,000 1,000 $28.1000 $37.1000 /per 1,000 1,000 1,000
$50.8500 /per $34.9000 /per $39.0000 $19.7500 /per $5.00 /per
3.2 100,001 TO 500,000 1,000 1,000 $26.9000 $34.9000 /per 1,000 1,000 1,000
$50.3000 /per $34.2500 /per $38.3500 $19.3000 /per $5.00 /per
3.3 500,001 TO 1,000,000 1,000 1,000 $26.2500 $34.2500 /per 1,000 1,000 1,000
$50.2000 /per $34.1000 /per $38.2000 $19.1000 /per $5.00 /per
3.4 1,000,001 + 1,000 1,000 $26.1000 $34.1000 /per 1,000 1,000 1,000
4.0 TWO COLOR DUPLEX
$78.6000 /per $49.2000 /per $54.0000 $31.4500 /per $5.00 /per
4.1 1 TO 100,000 1,000 1,000 $40.2000 $49.2000 /per 1,000 1,000 1,000
$75.8000 /per $46.6000 /per $52.1000 $27.9000 /per $5.00 /per
4.2 100,001 TO 500,000 1,000 1,000 $37.6000 $46.6000 /per 1,000 1,000 1,000
$75.0000 /per $45.8500 /per $51.6000 $26.9000 /per $5.00 /per
4.3 500,001 TO 1,000,000 1,000 1,000 $36.8500 $45.8500 /per 1,000 1,000 1,000
$74.8500 /per $45.7000 /per $51.4500 $26.7000 /per $5.00 /per
4.4 1,000,001 + 1,000 1,000 $36.7000 $45.7000 /per 1,000 1,000 1,000
5.0 FOUR COLOR SIMPLEX
$54.6000 /per $38.5000 /per $42.6500 $22.4000 /per $5.00 /per
5.1 1 TO 100,000 1,000 1,000 $29.5000 $38.5000 /per 1,000 1,000 1,000
$51.4500 /per $35.3500 /per $39.4500 $20.8000 /per $5.00 /per
5.2 100,001 TO 500,000 1,000 1,000 $26.3500 $35.3500 /per 1,000 1,000 1,000
$50.5500 /per $34.4500 /per $38.5500 $20.4000 /per $5.00 /per
5.3 500,001 TO 1,000,000 1,000 1,000 $25.4500 $34.4500 /per 1,000 1,000 1,000
$50.3500 /per $34.2500 /per $38.3500 $20.2500 /per $5.00 /per
5.4 1,000,001 + 1,000 1,000 $25.2500 $34.2500 /per 1,000 1,000 1,000
6.0 FOUR COLOR DUPLEX
$80.2500 /per $57.6500 /per $61.7500 $28.0000 /per $5.00 /per
6.1 1 TO 100,000 1,000 1,000 $48.6500 $57.6500 /per 1,000 1,000 1,000
$76.4000 /per $53.7500 /per $57.8500 $23.6000 /per $5.00 /per
6.2 100,001 TO 500,000 1,000 1,000 $44.7500 $53.7500 /per 1,000 1,000 1,000
$75.2500 /per $52.6500 /per $56.7500 $22.4000 /per $5.00 /per
6.3 500,001 TO 1,000,000 1,000 1,000 $43.6500 $52.6500 /per 1,000 1,000 1,000
$75.0000 /per $52.4000 /per $56.5000 $22.1000 /per $5.00 /per
6.4 1,000,001 + 1,000 1,000 $43.4000 $52.4000 /per 1,000 1,000 1,000
Printing
Printing Paper US
Paper Not POSTCARD
ITEM DESCRIPTION 11"X17" 8.5"X11" Supplied Supplied 8.5"X14" 9.0 STOCK
7.0 FOLDING-LETTER
$4.0000 /per $3.0000 /per $3.5000
7.1 1 TO 100,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$4.0000 /per $3.0000 /per $3.5000
7.2 100,001 TO 500,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$4.0000 /per $3.0000 /per $3.5000
7.3 500,001 TO 1,000,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$4.0000 /per $3.0000 /per $3.5000
7.4 1,000,001 + 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
7.0 FOLDING-Z FOLD
$5.5000 /per $3.0000 /per $3.5000
7.1 1 TO 100,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$5.5000 /per $3.0000 /per $3.5000
7.2 100,001 TO 500,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$5.5000 /per $3.0000 /per $3.5000
7.3 500,001 TO 1,000,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$5.5000 /per $3.0000 /per $3.5000
7.4 1,000,001 + 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000

SERIAL 16085-S
THE MASTER'S TOUCH, LLC, 1405 N ASH ST., SPOKANE, WA 99201
Printing
Printing Paper US
Paper Not POSTCARD
ITEM DESCRIPTION 11"X17" 8.5"X11" Supplied Supplied 8.5"X14" 9.0 STOCK
7.0 FOLDING-SELF MAILER (FSM)
$5.5000 /per $3.0000 /per $3.5000
7.1 1 TO 100,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$5.5000 /per $3.0000 /per $3.5000
7.2 100,001 TO 500,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$5.5000 /per $3.0000 /per $3.5000
7.3 500,001 TO 1,000,000 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
$5.5000 /per $3.0000 /per $3.5000
7.4 1,000,001 + 1,000 1,000 $3.5000 $3.0000 /per 1,000 N/A /per 1,000
8.0 INSERT STATEMENTS
$11.0000 $11.0000 /per $11.0000
8.1 1 TO 100,000 /per 1,000 1,000 $11.0000 $11.0000 /per 1,000 N/A /per 1,000
$11.0000 $11.0000 /per $11.0000
8.2 100,001 TO 500,000 /per 1,000 1,000 $11.0000 $11.0000 /per 1,000 N/A /per 1,000
$11.0000 $11.0000 /per $11.0000
8.3 500,001 TO 1,000,000 /per 1,000 1,000 $11.0000 $11.0000 /per 1,000 N/A /per 1,000
$11.0000 $11.0000 /per $11.0000
8.4 1,000,001 + /per 1,000 1,000 $11.0000 $11.0000 /per 1,000 N/A /per 1,000
9.0 ADDITIONAL MAILING STUFFER PRINTING (printing black ink)
paper paper
supplied by paper supplied paper supplied by supplied by
County by County County County
$12.6000 $7.6000 /per $7.6000
9.1 1 TO 100,000 /per 1,000 1,000 $7.6000 $7.6000 /per 1,000 N/A /per 1,000
$12.2000 $7.2000 /per $7.2000
9.2 100,001 TO 500,000 /per 1,000 1,000 $7.2000 $7.2000 /per 1,000 N/A /per 1,000
$12.1000 $7.1000 /per $7.1000
9.3 500,001 TO 1,000,000 /per 1,000 1,000 $7.1000 $7.1000 /per 1,000 N/A /per 1,000
$12.0500 $7.0500 /per $7.0500
9.4 1,000,001 + /per 1,000 1,000 $7.0500 $7.0500 /per 1,000 N/A /per 1,000
10.0 INSERT STUFFER
$1.2000 /per $1.2000 /per $1.2000
10.1 1 TO 100,000 1,000 1,000 $1.2000 $1.2000 /per 1,000 N/A /per 1,000
$1.2000 /per $1.2000 /per $1.2000
10.2 100,001 TO 500,000 1,000 1,000 $1.2000 $1.2000 /per 1,000 N/A /per 1,000
$1.2000 /per $1.2000 /per $1.2000
10.3 500,001 TO 1,000,000 1,000 1,000 $1.2000 $1.2000 /per 1,000 N/A /per 1,000
$1.2000 /per $1.2000 /per $1.2000
10.4 1,000,001 + 1,000 1,000 $1.2000 $1.2000 /per 1,000 N/A /per 1,000
US POSTCARD 9.0 STOCK
11.0 ANNUAL FORM REVISIONS/ SET-UPS
(Includes re-programming) $70.0000 /per HOUR
12.0 MAILING (Includes all costs to complete
mailing project $11,000 / per 1,000 $11.0000 / per 1,000
12.1 STANDARD ENVELOPES $23.0000 /per 1,000
12.2 DOUBLE WINDOW #10 $27.0000 /per 1,000
13.0 SPECIAL REPORTS $70.0000 /per HOUR
14.0 PICK-UP/DELIVERY OF MATERIALS $25.00 –per roundup
15.0 NCOA PROCESSING INCLUDING
FILE BACK TO COUNTY $1.7500 / per 1,000

SERIAL 16085-S
THE MASTER'S TOUCH, LLC, 1405 N ASH ST., SPOKANE, WA 99201
PRICING SHEET: NIGP CODE 96672
Terms: NET 30
Vendor Number: 2011007358 0
Certificates of Insurance Required
Contract Period: To cover the period ending July 31, 2017.

SERIAL 16085-S
PRINT AND MAIL TAX STATEMENTS AND VALUATION NOTICES
1.0 INTENT:
This Invitation for Bids is to award a contract for printing and mailing services to include; form design,
printing, presorting, data cleaning, warehousing, and mailing from electronic file transfers of the Maricopa
County Treasurer’s tax statements and the Maricopa County Assessor’s Valuation Notices. The
Contractor shall be required to prepare templates and transition services upon contract award and
prior to the current contract expiration date of June 30, 2016.
Other governmental entities under agreement with the County may have access to services provided
hereunder (see also Sections 3.10 and 3.11, below).
The County reserves the right to add additional contractors, at the County’s sole discretion, in cases where
the currently listed contractors are of an insufficient number or skill-set to satisfy the County’s needs or to
ensure adequate competition on any project or task order work.
2.0 SCOPE OF SERVICES:
2.1 QUANTITY OF MATERIAL AND DELIVERY POINTS:
One and one-half million to two million notices and statements related to personal and property
taxes printed, electronically transferred, presorted and mailed for the Maricopa County Treasurer’s
Office, located at 301 West Jefferson, Room 100, Phoenix, Arizona 85003-2199, as well as, one
and one-half million to two million Assessor Valuation related notices printed and mailed for the
Maricopa County Assessor’s Office, as covered by this Contract and subsequent purchase orders.
2.2 LOCAL FACILITIES:
The Contractor shall have ownership of printing, mailing and warehousing, and data center
operations located within Maricopa County and shall use and/or maintain them to fulfill the terms
of this Contract. Data center operations including NCOA processing may be located outside
of Maricopa County but not the United States.
2.3 DELIVERY/COMPLETION:
2.3.1 Contractor shall furnish electronic transportation of “raw data” to and from printing
location to Treasurer’s/Assessor’s Office. Delivery required by the dates listed in Section
2.5 and in adherence to contractor’s schedule submitted with the bid. Penalty for delay in
acceptable delivery time is $500.00 per day or fraction thereof.
2.3.2 Contractor shall be able to program printing from electronically transferred raw data files.
2.3.3 Confidentiality of Data: The data or any portion thereof, provided to the Contractor is for
the sole purpose of printing the valuation notices or tax statements and may NOT be used
for any other purpose or sold to third-parties by the Contractor.
2.4 SITE INSPECTION:
County reserves the right to visit printing site before making a final determination on bid.
2.5 DOCUMENT DESCRIPTIONS:
Configuration of forms is subject to change from year to year. Documents will be created by
Contractor from rough design provided by County and/or third-party design consultants.
Contractor must be capable of merging County’s raw data files with the final form(s).
2.5.1 Real Property and Personal Property: Tax Statements

SERIAL 16085-S
 Mailing Date: 1st week of September.
 Approximately 731,000 of these records will be electronically transmitted in a raw
data file named “Zips”.
 Approximately 85,000 of these records will be electronically transmitted in a raw
data file named “Multi’s”. These will require special handling (see section 2.9.1).
 Approximately 19,500 of these records will be electronically transmitted in a raw
data file named “Mortgage”. These will require special handling (see section 2.9.1).
 Approximately 7,600 of these records will be electronically transmitted in a raw data
file named “Lease”. These will require special handling (see section 2.9.1).
2.5.2 Real Property and Personal Property: Tax Information Statements
 Mailing Date: Immediately following completion of tax statement mailing in
September.
 A percentage will be preprinted with red ink designating back taxes owing.
2.5.3 Real Property: June Delinquent Tax Statements
 Mailing Date: 1st Business Day In June.
2.5.4 Personal Property: Delinquent Tax Statements
 Mailing Date: Last week of May.
2.5.5 Real Property: December Delinquent Tax Statements
 Mailing Date: 1st Business Day In December.
2.5.6 Notice of Value Statements
 Mailing Date for Real Property: Mailed annually in February; must be before March
1st..
NOTE: All valuation notices must be mailed on the same day and must have the
same postmark. County will provide specific mail date to Contractor and will
provide data based on lead time identified in solicitation.
Valuation notices are of the same general format but may contain different verbiage.
These five notices each contain three (3) electronic data files relating to the type of
mailing: D - domestic (individual letters), T - multiple property owners (numerous
notices grouped into a single mailing) and F- foreign. For postage savings, the multiple
notices should be group and mailed in the most economical process
 AMENDED NOTICE OF VALUATION (also known as Notice of Change) – These
are for new construction and revalues during the year and will have a mailing in
September. By statute, the notices need to be mailed no later than September 30th of
each year.
 MOBILE HOME NOTICE OF VALUATION - These have a single format for both
the front and back with a mailing date in June annually (approximately 50,000 –
90,000).
 PERSONAL PROPERTY NOTICE OF VALUATION - These have a single format
for both the front and back with a mailing date in August annually and must be
mailed by August 31st (approximately 40,000 – 60,000).

SERIAL 16085-S
2.5.7 BUSINESS PROPERTY STATEMENTS (FORM 520) AGRICULTURAL, LEASING
and COMMERCIAL)
Note: The above statements are processed as received, do not require letter shop
services, and are returned to Assessor.
 Commercial:
-Sort by company name sequence
-Extract multi’s from table furnished and laser print
-Extract continuations and laser print
 Mailing Date : Early January
 Additional mailing may occur in May, June, and July for new or non- returned
accounts. Printing will be approximately 5,000 per month.
2.5.8 TAX EXEMPTION/SENIOR RENEWAL FORMS ORGANIZATION (TES9); FRONT
OF EXEMPTION FORMS; SENIOR RENEWAL FORMS (LETTER) and SENIOR
RENEWAL FORM)
 Mailing Date : December
2.5.9 FIRST AND FINAL INTENT TO RECLASSIFY PROPERTY
Mailed twice a year based on agreement between County and Contractor, usually in
spring and fall with about 15,000 – 40,000 notices mailed each time.
2.6 TYPE OF PRINTING:
The Maricopa County Treasurer’s/Assessor’s Office requires that all of the above documents be
laser printed (OCR Scanable). The Treasurer’s Office requires that mailings adhere to lockbox and
branch payment requirements provided by the contracted servicing bank.
Existing information must be placed on single page documents in a manner that will allow the use
of the current window envelopes, if required (Valuation notices do not require envelopes). All
payment stubs must meet specifications for high speed check processing equipment, including
using 50-60 pound offset paper or paper as otherwise specified by Assessor/Treasurer. All
payment stubs must have straight bottom edges to meet specifications (i.e., not perforated).
County requires vendor to produce PDF of mailed valuation notices, tax statements, delinquent
mailings, and resolutions. However, County has the right to waive this requirement for each
mailing at its discretion. Notices which are self-mailers require using 70 pound offset paper or
based on current USPS standards.
2.7 ANNUAL REVISIONS:
Due to legislative changes, Department of Revenue (DOR) requirements and newly elected
officers, statement formats may change. Please submit an annual cost for statement revisions that
may occur over the life of the contract.
2.8 ADDITIONAL MAILING MATERIALS:
Supplement materials are sometimes included when sending statements. The printing agent will be
notified of additional “stuffers”. This may involve varying sizes (8 ½ x 11 Inch, 8 ½ x 5 ½ Inch,
etc.) with simplex or duplex printing. Include the cost for this service in the bid.
2.9 MAILING SERVICES
This bid will require the printing agent to provide mailing service. If a subcontractor is used for
the collating, stuffing, and mailing of printed statements, then include the cost of these services or
any related services in the bid along with the specific services provided by the subcontractor. The

SERIAL 16085-S
subcontractor shall have facilities located within Maricopa County and shall use and/or maintain
them to fulfill the subcontract.
Mailing is to be First Class United States Postal Service or Standard Mail United State Postal
Service via the most cost efficient means pursuant to current Postal Regulations in effect at the
time of mailing. Contractor must be able to qualify mail to automation Carrier Route when
possible. Contractor must be able to mail to foreign countries. Contractor must have the ability to
produce Intelligent Barcodes with a unique parcel identifier number to allow for electronic mail
tracking, NIXIE, and NCOA information. The Contractor may be USPS Certified but they
shall be able to create IMB automated full service mailings with tracing using Maricopa
County mailer ID’s. The Contractor shall have USPS PAVE certified software and have the
ability to create both First Class and Standard A full service mailings.
2.9.1 MAILING OF MULTIPLE STATEMENTS:
When ten (10) or more tax statements go to a single name and address, the Contractor
may re-sort the file, in number of documents (weight) order to maximize postage savings.
The Contractor will either hand address envelopes or pre-print pressure sensitive labels
when necessary.
*These statements are provided in distinctly separate data files for special handling which
may include UPS, Federal Express or locally available delivery means whichever is most
expedient and cost effective.
2.9.2 MAILING OF FOREIGN ADDRESSED STATEMENTS:
In the foreign mailing of documents, the vendor will need an application that locates the
“Last Line” (city, state, and zip code) to determine if the documents have a U.S. zip code
or not.
2.9.3 POSTAGE FOR MAILING STATEMENTS:
Postage funds will be provided by the Maricopa County Treasurer’s/Assessor’s Office
based on estimates by the successful bidder. A report of usage and unused balance is
required after each mailing. Vendor may use own postage meter for mailing of multiples
and County will reimburse. The Contractor shall not add a markup to the postal
charges for County reimbursement.
2.9.4 PRESORTED RATES
The successful bidder is required to have the necessary postal software to efficiently sort
mail to obtain the most effective and lowest cost mailing rates.
2.9.5 WAREHOUSING OF MAILING SUPPLIES AND MATERIAL:
The successful bidder is responsible for providing 4,000 – 5,000 sq. ft. of warehouse
space for all Treasurer mailing supplies and materials throughout the fiscal year at a no
cost or a nominal fee.
2.9.6 NATIONAL CHANGE OF ADDRESS (NCOA) STANDARDIZATION AND OTHER
DATA CLEANSING:
The winning bidder must have the capability to provide NCOA standardization and other
raw data cleansing processes for a nominal or no cost.
2.10 SUBSEQUENT PRINTING:
Subsequent printings may require added verbiage or slight format changes from their original
format Subsequent printing of these statements may be returned to the County Treasurer’s Office

SERIAL 16085-S
located at 301 West Jefferson, Phoenix, Arizona for mailing to taxpayers. The successful bidder is
responsible for compliance to delivery schedules.
The vendor is to submit a reasonable turnaround time from receipt of an electronic file transfer, to
delivery of printed products for subsequent printing with this bid. The vendor is also to state a
minimum printing and delivery cost. (Please include an option for folding, inserting and mailing
of these statements. In addition to price, please include a delivery schedule.)
2.10.1 REAL PROPERTY AND PERSONAL PROPERTY:
2.10.1.1 Resolution Reprints:
Electronic Transfer of Raw Data
Run Time: Weekly From September through July
Approximately 27 Runs
2.11 FORM DESIGN:
The Treasurer’s and Assessor’s Offices require proof copies for each item to be printed prior to the
job being printed.
Tax Bill/Valuation Notices Quantities
September to September
REAL/PERSONAL PROPERTY 2012 2013 2014 2015 Lead Time
Tax Statements 837,650 845,276 841,579 851,959 3 weeks
Tax Information Cards 725,636 675,536 698,053 710,861 3 weeks
June Delinquent Notices 146,420 121,493 111,177 111,744 2 weeks
December Delinquent Notices 32,190 26,167 22,658 21,919 2 weeks
1099 Mailing 1,625 1,481 1,036 2 weeks
Notices of Value – February 1,476,263 1,475,284 1,474,548 1,478,122 4 weeks
Notices of Value – June 84,866 84,006 83,112 79,592 2 weeks
Notices of Value - August 41,922 47,022 47,477 46,235 1 week
Notices of Value - September 11,743 15,355 22,011 34,462 1 week
PERSONAL PROPERTY
Commercial / Leasing 59,705 63,736 65,810 66,014
Tax-Exempt – Organization 3,751 3,825 3,819 3,673
Legal Class Verification 250,924 151.335 108,272 113,148
3.0 PURCHASING REQUIREMENTS:
3.1 ACCEPTANCE:
Upon delivery and successful installation, the material(s) shall be deemed accepted and the
warranty period shall begin. All documentation shall be completed prior to final acceptance.
3.2 USAGE REPORT:
The Contractor shall furnish the County a usage report upon request delineating the acquisition
activity governed by the Contract. The format of the report shall be approved by the County and
shall disclose the quantity and dollar value of each contract item by individual unit.
3.3 BACKGROUND CHECK:
Bidders/proposers need to aware that there may be multiple background checks (Sheriff’s Office,
County Attorney's Office, Courts as well as Maricopa County general government) to determine if
the respondent is acceptable to do business with the County. This applies to (but is not limited to)

SERIAL 16085-S
the company, sub-contractors and employees and the failure to pass these checks shall deem the
respondent non-responsible.
3.4 INVOICES AND PAYMENTS:
3.4.1 The Contractor shall submit one (1) legible copy of their detailed invoice before
payment(s) can be made. Incomplete invoices will not be processed. At a minimum, the
invoice must provide the following information:
• Company name, address and contact
• County bill-to name and contact information
• Contract Serial Number or
• County purchase order number
• Invoice number and date
• Payment terms
• Date of service or delivery
• Quantity (number of days or weeks)
• Contract Item number(s)
• Description of Purchase (product or services)
• Pricing per unit of purchase
• Freight (if applicable)
• Extended price
• Mileage w/rate (if applicable)
• Arrival and completion time (if applicable)
• Total Amount Due
3.4.2 Problems regarding billing or invoicing shall be directed to the using agency as listed on
the Purchase Order.
3.4.3 Payment shall be made to the Contractor by Accounts Payable through the Maricopa
County Vendor Express Payment Program. This is an Electronic Funds Transfer (EFT)
process. After Contract Award the Contractor shall complete the Vendor Registration
Form located on the County Department of Finance Vendor Registration Web Site
(http://www.maricopa.gov/Finance/Vendors.aspx).
3.4.4 Discounts offered in the contract shall be calculated based on the date a properly
completed invoice is received by the County (ROI).
3.4.5 EFT payments to the routing and account numbers designated by the Contractor will
include the details on the specific invoices that the payment covers. The Contractor is
required to discuss remittance delivery capabilities with their designated financial
institution for access to those details.
3.5 APPLICABLE TAXES:
3.5.1 Payment of Taxes: The Contractor shall pay all applicable taxes. With respect to any
installation labor on items that are not attached to real property performed by Contractor
under the terms of this Contract, the installation labor cost and the gross receipts for
materials provided shall be listed separately on the Contractor’s invoices.
3.5.2 State and Local Transaction Privilege Taxes: Maricopa County is subject to all
applicable state and local transaction privilege taxes. To the extent any state and local
transaction privilege taxes apply to sales made under the terms of this contract it is the
responsibility of the seller to collect and remit all applicable taxes to the proper taxing
jurisdiction of authority.
3.5.3 Tax Indemnification: Contractor and all subcontractors shall pay all Federal, state, and
local taxes applicable to its operation and any persons employed by the Contractor.
Contractor shall, and require all subcontractors to hold Maricopa County harmless from

SERIAL 16085-S
any responsibility for taxes, damages and interest, if applicable, contributions required
under Federal, and/or state and local laws and regulations and any other costs including
transaction privilege taxes, unemployment compensation insurance, Social Security and
Worker’s Compensation.
3.6 TAX (SERVICES):
No tax shall be levied against labor. It is the responsibility of the Contractor to determine any and
all taxes and include the same in proposal price.
3.7 TAX (COMMODITIES):
Tax shall not be levied against labor. Sales/use tax will be determined by County. Tax will not be
used in determining low price.
3.8 DELIVERY:
It shall be the Contractor’s responsibility to meet the proposed delivery requirements. Maricopa
County reserves the right to obtain services on the open market in the event the Contractor fails to
make delivery and any price differential will be charged against the Contractor.
3.9 POST AWARD MEETING:
The Contractor may be required to attend a post-award meeting with the Using Agency to discuss the
terms and conditions of this Contract. This meeting will be coordinated by the Procurement Officer of
the Contract.
3.10 STRATEGIC ALLIANCE for VOLUME EXPENDITURES ($AVE):
The County is a member of the $AVE cooperative purchasing group. $AVE includes the State of
Arizona, many Phoenix metropolitan area municipalities, and many K-12 unified school districts.
Under the $AVE Cooperative Purchasing Agreement, and with the concurrence of the successful
Respondent under this solicitation, a member of $AVE may access a contract resulting from a
solicitation issued by the County. If you do not want to grant such access to a member of $AVE,
please so state in your proposal. In the absence of a statement to the contrary, the County will
assume that you do wish to grant access to any contract that may result from this Request for
Proposal.
3.11 INTERGOVERNMENTAL COOPERATIVE PURCHASING AGREEMENTS (ICPA’s):
County currently holds ICPA’s with numerous governmental entities throughout the State of
Arizona. These agreements allow those entities, with the approval of the Contractor, to purchase
their requirements under the terms and conditions of the County Contract. Please indicate on
Attachment A, your acceptance or rejection regarding such participation of other governmental
entities. Your response will not be considered as an evaluation factor in awarding a contract.
4.0 CONTRACTUAL TERMS & CONDITIONS:
4.1 CONTRACT TERM:
This Invitation for Bid is for awarding a firm, fixed-price purchasing contract to cover a term of
one (1) year.
4.2 OPTION TO RENEW:
The County may, at its option and with the concurrence of the Contractor, renew the term of this
Contract up to a maximum of four (4) additional years, (or at the County’s sole discretion, extend
the contract on a month to month basis for a maximum of six (6) months after expiration). The
Contractor shall be notified in writing by the Office of Procurement Services of the County’s

SERIAL 16085-S
intention to renew the contract term at least thirty (60) calendar days prior to the expiration of the
original contract term.
4.3 PRICE ADJUSTMENTS:
Any requests for reasonable price adjustments must be submitted sixty (60) days prior to the
Contract expiration date. Requests for adjustment in cost of labor and/or materials must be
supported by appropriate documentation. If County agrees to the adjusted price terms, County
shall issue written approval of the change. The reasonableness of the request will be determined by
comparing the request with the Consumer Price Index or by performing a market survey.
4.4 INDEMNIFICATION:
To the fullest extent permitted by law, and to the extent that claims, damages, losses or expenses
are not covered and paid by insurance purchased by the Contractor, the Contractor shall defend
indemnify and hold harmless the County (as Owner), its agents, representatives, agents, officers,
directors, officials, and employees from and against all claims, damages, losses, and expenses
(including, but not limited to attorneys' fees, court costs, expert witness fees, and the costs and
attorneys' fees for appellate proceedings) arising out of, or alleged to have resulted from the
negligent acts, errors, omissions, or mistakes relating to the performance of this Contract.
Contractor's duty to defend, indemnify, and hold harmless the County, its agents, representatives,
agents, officers, directors, officials, and employees shall arise in connection with any claim,
damage, loss, or expense that is attributable to bodily injury, sickness, disease, death or injury to,
impairment of, or destruction of tangible property, including loss of use resulting there from,
caused by negligent acts, errors, omissions, or mistakes in the performance of this Contract, but
only to the extent caused by the negligent acts or omissions of the Contractor, a subcontractor, any
one directly or indirectly employed by them, or anyone for whose acts they may be liable,
regardless of whether or not such claim, damage, loss, or expense is caused in part by a party
indemnified hereunder.
The amount and type of insurance coverage requirements set forth herein will in no way be
construed as limiting the scope of the indemnity in this paragraph.
The scope of this indemnification does not extend to the sole negligence of County.
4.5 INSURANCE:
4.5.1 Contractor, at Contractor’s own expense, shall purchase and maintain the herein
stipulated minimum insurance from a company or companies duly licensed by the State
of Arizona and possessing a current A.M. Best, Inc. rating of B++. In lieu of State of
Arizona licensing, the stipulated insurance may be purchased from a company or
companies, which are authorized to do business in the State of Arizona, provided that
said insurance companies meet the approval of County. The form of any insurance
policies and forms must be acceptable to County.
4.5.2 All insurance required herein shall be maintained in full force and effect until all work or
service required to be performed under the terms of the Contract is satisfactorily
completed and formally accepted. Failure to do so may, at the sole discretion of County,
constitute a material breach of this Contract.
4.5.3 Contractor’s insurance shall be primary insurance as respects County, and any insurance
or self-insurance maintained by County shall not contribute to it.
4.5.4 Any failure to comply with the claim reporting provisions of the insurance policies or any
breach of an insurance policy warranty shall not affect the County’s right to coverage
afforded under the insurance policies.

SERIAL 16085-S
4.5.5 The insurance policies may provide coverage that contains deductibles or self-insured
retentions. Such deductible and/or self-insured retentions shall not be applicable with
respect to the coverage provided to County under such policies. Contractor shall be solely
responsible for the deductible and/or self-insured retention and County, at its option, may
require Contractor to secure payment of such deductibles or self-insured retentions by a
surety bond or an irrevocable and unconditional letter of credit.
4.5.6 The insurance policies required by this Contract, except Workers’ Compensation and
Errors and Omissions, shall name County, its agents, representatives, officers, directors,
officials and employees as Additional Insureds.
4.5.7 The policies required hereunder, except Workers’ Compensation and Errors and
Omissions, shall contain a waiver of transfer of rights of recovery (subrogation) against
County, its agents, representatives, officers, directors, officials and employees for any
claims arising out of Contractor’s work or service.
4.5.8 Commercial General Liability.
Commercial General Liability insurance and, if necessary, Commercial Umbrella
insurance with a limit of not less than $2,000,000 for each occurrence, $4,000,000
Products/Completed Operations Aggregate, and $4,000,000 General Aggregate Limit.
The policy shall include coverage for premises liability, bodily injury, broad form
property damage, personal injury, products and completed operations and blanket
contractual coverage, and shall not contain any provisions which would serve to limit
third party action over claims. There shall be no endorsement or modifications of the
CGL limiting the scope of coverage for liability arising from explosion, collapse, or
underground property damage.
4.5.9 Automobile Liability.
Commercial/Business Automobile Liability insurance and, if necessary, Commercial
Umbrella insurance with a combined single limit for bodily injury and property damage
of not less than $1,000,000 each occurrence with respect to any of the Contractor’s
owned, hired, and non-owned vehicles assigned to or used in performance of the
Contractor’s work or services or use or maintenance of the Premises under this Contract.
4.5.10 Workers’ Compensation.
Workers’ Compensation insurance to cover obligations imposed by federal and state
statutes having jurisdiction of Contractor’s employees engaged in the performance of the
work or services under this Contract; and Employer’s Liability insurance of not less than
$1,000,000 for each accident, $1,000,000 disease for each employee, and $1,000,000
disease policy limit.
Contractor, its contractors and its subcontractors waive all rights against Contract and its
agents, officers, directors and employees for recovery of damages to the extent these
damages are covered by the Workers’ Compensation and Employer’s Liability or
commercial umbrella liability insurance obtained by Contractor, its contractors and its
subcontractors pursuant to this Contract.
4.5.11 Certificates of Insurance.
4.5.11.1 Prior to Contract AWARD, Contractor shall furnish the County with valid and
complete certificates of insurance, or formal endorsements as required by the
Contract in the form provided by the County, issued by Contractor’s
insurer(s), as evidence that policies providing the required coverage,
conditions and limits required by this Contract are in full force and effect.
Such certificates shall identify this contract number and title.

SERIAL 16085-S
4.5.11.2 In the event any insurance policy (ies) required by this contract is (are) written
on a “claims made” basis, coverage shall extend for two years past completion
and acceptance of Contractor’s work or services and as evidenced by annual
Certificates of Insurance.
4.5.11.3 If a policy does expire during the life of the Contract, a renewal certificate
must be sent to County fifteen (15) days prior to the expiration date.
4.5.12 Cancellation and Expiration Notice.
Applicable to all insurance policies required within the Insurance Requirements of this
Contract, Contractor’s insurance shall not be permitted to expire, be suspended, be
canceled, or be materially changed for any reason without thirty (30) days prior written
notice to Maricopa County. Contractor must provide to Maricopa County, within 2
business days of receipt, if they receive notice of a policy that has been or will be
suspended, canceled, materially changed for any reason, has expired, or will be expiring.
Such notice shall be sent directly to Maricopa County Office of Procurement Services
and shall be mailed, emailed, hand delivered or sent by facsimile transmission to (320
West Lincoln Street, Phoenix, AZ 85003, Phone Number602/506-3967 /Fax Number
602/258-1573).
4.6 ORDERING AUTHORITY:
4.6.1 Any request for purchase of product(s) shall be accompanied by a valid purchase order,
issued by Office of Procurement Services, a Purchase Order issued by the using
Department or direction by a Certified Agency Procurement Aid (CAPA) with a Purchase
Card for payment.
4.7 REQUIREMENTS CONTRACT:
4.7.1 Contractors signify their understanding and agreement by signing a bid submittal, that the
Contract resulting from the bid is a requirements contract. However, the Contract does
not guarantee any minimum or maximum number of purchases will be made. It only
indicates that if purchases are made for the materials contained in the Contract, they will
be purchased from the Contractor awarded that item. Orders will only be placed when the
County identifies a need and proper authorization and documentation have been
approved.
4.7.2 County reserves the right to cancel Purchase Orders within a reasonable period of time
after issuance. Should a Purchase Order be canceled, the County agrees to reimburse the
Contractor for actual and documentable costs incurred by the Contractor in response to
the Purchase Order. The County will not reimburse the Contractor for any costs incurred
after receipt of County notice of cancellation, or for lost profits, shipment of product prior
to issuance of Purchase Order, etc.
4.7.3 Contractors agree to accept verbal notification of cancellation of Purchase Orders from
the County Procurement Officer with written notification to follow. By submitting a bid
in response to this Invitation for Bids, the Contractor specifically acknowledges to be
bound by this cancellation policy.
4.8 SUSPENSION OF WORK:
The Procurement Officer may order the Contractor, in writing, to suspend, delay, or interrupt all or
any part of the work of this contract for the period of time that the Procurement Officer determines
appropriate for the convenience of the County. No adjustment shall be made under this clause for
any suspension, delay, or interruption to the extent that performance would have been so
suspended, delayed, or interrupted by any other cause, including the fault or negligence of the
Contractor. No request for adjustment under this clause shall be granted unless the claim, in an

SERIAL 16085-S
amount stated, is asserted in writing as soon as practicable after the termination of the suspension,
delay, or interruption, but not later than the date of final payment under the contract.
4.9 STOP WORK ORDER:
The Procurement Officer may, at any time, by written order to the Contractor, require the
Contractor to stop all, or any part, of the work called for by this contract for a period of 90 days
after the order is delivered to the Contractor, and for any further period to which the parties may
agree. The order shall be specifically identified as a stop work order issued under this clause.
Upon receipt of the order, the Contractor shall immediately comply with its terms and take all
reasonable steps to minimize the incurrence of costs allocable to the work covered by the order
during the period of work stoppage. Within a period of 90 days after a stop-work is delivered to
the Contractor, or within any extension of that period to which the parties shall have agreed, the
Procurement Officer shall either—
4.9.1 Cancel the stop-work order; or
4.9.2 Terminate the work covered by the order as provided in the Default, or the Termination
for Convenience of the County, clause of this contract.
4.9.3 The Procurement Officer may make an equitable adjustment in the delivery schedule
and/or contract price, or otherwise, and the contract shall be modified, in writing,
accordingly, if the Contractor demonstrates that the stop work order resulted in an
increase in costs to the Contractor.
4.10 UNCONDITIONAL TERMINATION FOR CONVENIENCE:
Maricopa County may terminate the resultant Contract for convenience by providing sixty (60)
calendar days advance notice to the Contractor.
4.11 TERMINATION FOR DEFAULT:
The County may, by written notice of default to the Contractor, terminate this contract in whole or
in part if the Contractor fails to:
4.11.1 Deliver the supplies or to perform the services within the time specified in this contract or
any extension;
4.11.2 Make progress, so as to endanger performance of this contract; or
4.11.3 Perform any of the other provisions of this contract.
4.11.4 The County’s right to terminate this contract under these subparagraphs may be exercised
if the Contractor does not cure such failure within 10 days (or more if authorized in
writing by the County) after receipt of the notice from the Procurement Officer
specifying the failure.
4.12 STATUTORY RIGHT OF CANCELLATION FOR CONFLICT OF INTEREST:
Notice is given that pursuant to A.R.S. § 38-511 the County may cancel any Contract without
penalty or further obligation within three years after execution of the contract, if any person
significantly involved in initiating, negotiating, securing, drafting or creating the contract on
behalf of the County is at any time while the Contract or any extension of the Contract is in effect,
an employee or agent of any other party to the Contract in any capacity or consultant to any other
party of the Contract with respect to the subject matter of the Contract. Additionally, pursuant to
A.R.S § 38-511 the County may recoup any fee or commission paid or due to any person
significantly involved in initiating, negotiating, securing, drafting or creating the contract on
behalf of the County from any other party to the contract arising as the result of the Contract.

SERIAL 16085-S
4.13 OFFSET FOR DAMAGES:
In addition to all other remedies at Law or Equity, the County may offset from any money due to
the Contractor any amounts Contractor owes to the County for damages resulting from breach or
deficiencies in performance of the contract.
4.14 SUBCONTRACTING:
4.14.1 The Contractor may not assign to another Contractor or Subcontract to another party for
performance of the terms and conditions hereof without the written consent of the
County. All correspondence authorizing subcontracting must reference the Bid Serial
Number and identify the job project.
4.14.2 The Subcontractor’s rate for the job shall not exceed that of the Prime Contractor’s rate,
as bid in the pricing section, unless the Prime Contractor is willing to absorb any higher
rates. The Subcontractor’s invoice shall be invoiced directly to the Prime Contractor, who
in turn shall pass-through the costs to the County, without mark-up. A copy of the
Subcontractor’s invoice must accompany the Prime Contractor’s invoice.
4.15 AMENDMENTS:
All amendments to this Contract shall be in writing and approved/signed by both parties. Maricopa
County Office of Procurement Services shall be responsible for approving all amendments for
Maricopa County.
4.16 ADDITIONS/DELETIONS OF SERVICE:
The County reserves the right to add and/or delete materials to a Contract. If a service requirement
is deleted, payment to the Contractor will be reduced proportionately, to the amount of service
reduced in accordance with the bid price. If additional materials are required from a Contract,
prices for such additions will be negotiated between the Contractor and the County.
4.17 ACCESS TO AND RETENTION OF RECORDS FOR THE PURPOSE OF AUDIT AND/OR
OTHER REVIEW:
4.17.1 In accordance with section MCI 371 of the Maricopa County Procurement Code the
Contractor agrees to retain all books, records, accounts, statements, reports, files, and
other records and back-up documentation relevant to this Contract for six (6) years after
final payment or until after the resolution of any audit questions which could be more
than six (6) years, whichever is latest. The County, Federal or State auditors and any
other persons duly authorized by the Department shall have full access to, and the right to
examine, copy and make use of, any and all said materials.
4.17.2 If the Contractor’s books, records , accounts, statements, reports, files, and other records
and back-up documentation relevant to this Contract are not sufficient to support and
document that requested services were provided, the Contractor shall reimburse Maricopa
County for the services not so adequately supported and documented.
4.17.3 If at any time it is determined by the County that a cost for which payment has been made
is a disallowed cost, the County shall notify the Contractor in writing of the disallowance.
The course of action to address the disallowance shall be at sole discretion of the County,
and may include either an adjustment to future invoices, request for credit, request for a
check or deduction from current billings. Submitted by the Contractor by the amount of
the disallowance, or to require reimbursement forthwith of the disallowed amount by the
Contractor by issuing a check payable to Maricopa County.

SERIAL 16085-S
4.18 VALIDITY:
The invalidity, in whole or in part, of any provision of this Contract shall not void or affect the
validity of any other provision of the Contract.
4.19 RIGHTS IN DATA:
The County shall have the use of data and reports resulting from a Contract without additional cost
or other restriction except as may be established by law or applicable regulation. Each party shall
supply to the other party, upon request, any available information that is relevant to a Contract and
to the performance thereunder.
4.20 RELATIONSHIPS:
4.20.1 In the performance of the services described herein, the Contractor shall act solely as an
independent contractor, and nothing herein or implied herein shall at any time be
construed as to create the relationship of employer and employee, co-employee,
partnership, principal and agent, or joint venture between the County and the Contractor.
4.20.2 The County reserves the right of final approval on proposed staff for all Task Orders.
Also, upon request by the County, the Contractor will be required to remove any
employees working on County projects and substitute personnel based on the discretion
of the County within two business days, unless previously approved by the County.
4.21 NON-DISCRIMINATION:
CONTRACTOR agrees to comply with all provisions and requirements of Arizona Executive
Order 2009-09 including flow down of all provisions and requirements to any subcontractors.
Executive Order 2009-09 supersedes Executive order 99-4 and amends Executive order 75-5 and
may be viewed and downloaded at the Governor of the State of Arizona’s website
http://azmemory.azlibrary.gov/cdm/singleitem/collection/execorders/id/680/rec/1 which is hereby
incorporated into this contract as if set forth in full herein. During the performance of this contract,
CONTRACTOR shall not discriminate against any employee, client or any other individual in any
way because of that person’s age, race, creed, color, religion, sex, disability or national origin.
4.22 CERTIFICATION REGARDING DEBARMENT AND SUSPENSION:
4.22.1 The undersigned (authorized official signing for the Contractor) certifies to the best of his
or her knowledge and belief, that the Contractor
4.22.1.1 is not presently debarred, suspended, proposed for debarment, declared
ineligible, or voluntarily excluded from covered transactions by any Federal
Department or agency;
4.22.1.2 have not within 3-year period preceding this Contract been convicted of or
had a civil judgment rendered against them for commission of fraud or a
criminal offense in connection with obtaining, attempting to obtain, or
performing a public (Federal, State or local) transaction or contract under a
public transaction; violation of Federal or State antitrust statues or
commission of embezzlement, theft, forgery, bribery, falsification or
destruction of records, making false statements, or receiving stolen property;
4.22.1.3 are not presently indicted or otherwise criminally or civilly charged by a
government entity (Federal, State or local) with commission of any of the
offenses enumerated in paragraph (2) of this certification; and
4.22.1.4 have not within a 3-year period preceding this Contract had one or more
public transaction (Federal, State or local) terminated for cause of default.

SERIAL 16085-S
4.22.2 The Contractor agrees to include, without modification, this clause in all lower tier
covered transactions (i.e. transactions with subcontractors) and in all solicitations for
lower tier covered transactions related to this Contract.
4.23 VERIFICATION REGARDING COMPLIANCE WITH ARIZONA REVISED STATUTES §41-
4401 AND FEDERAL IMMIGRATION LAWS AND REGULATIONS:
4.23.1 By entering into the Contract, the Contractor warrants compliance with the Immigration
and Nationality Act (INA using e-verify) and all other federal immigration laws and
regulations related to the immigration status of its employees and A.R.S. §23-214(A). The
contractor shall obtain statements from its subcontractors certifying compliance and shall
furnish the statements to the Procurement Officer upon request. These warranties shall
remain in effect through the term of the Contract. The Contractor and its subcontractors
shall also maintain Employment Eligibility Verification forms (I-9) as required by the
Immigration Reform and Control Act of 1986, as amended from time to time, for all
employees performing work under the Contract and verify employee compliance using the
E-verify system and shall keep a record of the verification for the duration of the
employee’s employment or at least three years, whichever is longer. I-9 forms are available
for download at USCIS.GOV.
4.23.2 The County retains the legal right to inspect contractor and subcontractor employee
documents performing work under this Contract to verify compliance with paragraph 4.23.1
of this Section. Contractor and subcontractor shall be given reasonable notice of the
County’s intent to inspect and shall make the documents available at the time and date
specified. Should the County suspect or find that the Contractor or any of its subcontractors
are not in compliance, the County will consider this a material breach of the contract and
may pursue any and all remedies allowed by law, including, but not limited to: suspension
of work, termination of the Contract for default, and suspension and/or debarment of the
Contractor. All costs necessary to verify compliance are the responsibility of the Contractor.
4.24 CONTRACTOR LICENSE REQUIREMENT:
4.24.1 The Respondent shall procure all permits, insurance, licenses and pay the charges and
fees necessary and incidental to the lawful conduct of his/her business, and as necessary
complete any required certification requirements, required by any and all governmental or
non-governmental entities as mandated to maintain compliance with and in good standing
for all permits and/or licenses. The Respondent shall keep fully informed of existing and
future trade or industry requirements, Federal, State and Local laws, ordinances, and
regulations which in any manner affect the fulfillment of a Contract and shall comply
with the same. Contractor shall immediately notify both Office of Procurement Services
and the using agency of any and all changes concerning permits, insurance or licenses.
4.24.2 Respondents furnishing finished products, materials or articles of merchandise that will
require installation or attachment as part of the Contract, shall possess any licenses
required. A Respondent is not relieved of its obligation to posses the required licenses by
subcontracting of the labor portion of the Contract. Respondents are advised to contact
the Arizona Registrar of Contractors, Chief of Licensing, at (602) 542-1525 to ascertain
licensing requirements for a particular contract. Respondents shall identify which
license(s), if any, the Registrar of Contractors requires for performance of the Contract.
4.25 INFLUENCE:
As prescribed in MC1-1202 of the Maricopa County Procurement Code, any effort to influence an
employee or agent to breach the Maricopa County Ethical Code of Conduct or any ethical conduct,
may be grounds for Disbarment or Suspension under MC1-902.
An attempt to influence includes, but is not limited to:

SERIAL 16085-S
4.25.1 A Person offering or providing a gratuity, gift, tip, present, donation, money,
entertainment or educational passes or tickets, or any type valuable contribution or
subsidy,
4.25.2 That is offered or given with the intent to influence a decision, obtain a contract, garner
favorable treatment, or gain favorable consideration of any kind.
If a Person attempts to influence any employee or agent of Maricopa County, the Chief
Procurement Officer, or his designee, reserves the right to seek any remedy provided by the
Maricopa County Procurement Code, any remedy in equity or in the law, or any remedy provided
by this contract.
4.26 PUBLIC RECORDS:
All Offers submitted and opened are public records and must be retained by the Records Manager
at the Office of Procurement Services. Offers shall be open to public inspection after Contract
award and execution, except for such Offers deemed to be confidential by the Office of
Procurement Services. If an Offeror believes that information in its Offer should remain
confidential, it shall indicate as confidential, the specific information in its offer and submit a
statement with its offer detailing the reasons that the information should not be disclosed. Such
reasons shall include the specific harm or prejudice which may arise. The Records Manager of the
Office of Procurement Services shall determine whether the identified information is confidential
pursuant to the Maricopa County Procurement Code and the Arizona Public Records Law.

SERIAL 16085-S
EXHIBIT 3
Maricopa County Assessor’s Office
UPPS 520 Data File Layout
Updated: 12/02/2010
Owner Record (Record Type = O)
One owner record will be present of each account number. Print on upper half of 520 form.
Field Size Field Position in each record
1) Record Type 1 1
2) Account Type Code 1 2
3) Account Number 7 3-9
4) Filler 136 10-145
5) Tax Area Code Title 10 146-155
6) Tax Area Code 6 156-161
7) Account Type (Leasing -, Multiple -, Secured, Commercial, Agricultural)
13 162-174
8) Company Number (Leasing Number or Multiple Number)
5 175-179
9) Company Address Line1 42 180-221
10) Company Address Line2 42 222-263
11) Company Address Line3 42 264-305
12) Company Address Line4 42 306-347
13) Company Address Line5 42 348-389
14) Presumptive Year 4 390-393
15) Parcel Number 9 394-402
16) General Status 1 403
17) Audit Status 1 404
18) Company Location Address 45 405-449
19) Company Location City 28 450-477
20) Company Location Zip code 5 478-482
21) Appraiser Number 4 483-486
22) Filler 7 487-493
23) Carriage Return 1 494
Detail Record (Record Type = D)
One to many detail records may be present for each owner record. Print on bottom half of 520 form.
Field Size Field Position in each record
24) Record Type 1 1
25) Account Type 1 2
26) Account Number 7 3-9
27) Schedule 1 10
28) Acquisition Year 4 11-14
29) Original Cost 12 15-26
30) Assessment Class 2 27-28
31) Trending Table 2 29-30
32) Accelerated Tax Year 4 31-34
33) Filler 462 35-493
34) Carriage Return 1 494

SERIAL 16085-S
Subtotal Record (Record Type = S)
One subtotal record will be present for each schedule of the detail record.
Field Size Field Position in each record
35) Record Type 1 1
36) Subtotal Title 9 2-10
37) Subtotal Amount 12 11-22
38) Filler 471 23-493
39) Carriage Return 1 494
Grand Total Record (Record Type = T)
One grand total record will be present for each owner record.
Field Size Field Position in each record
40) Record Type 1 1
41) Grand Total Title 9 2-10
42) Grand Total Amount 12 11-22
43) Filler 474 23-493
44) Carriage Return 1 494

SERIAL 16085-S
EXHIBIT 4
Maricopa County Assessor’s Office
UPPS NOV Data File Layout
Document: X\ISD\Layouts\UB30050_NOV.DOC
Date: 06/27/2011
Record layout for UB30050.dat (UPPS Notice of Valuation files)
FIELD NAME LENGTH START/END POSITIONS
------------------ ------------ ---------------------------------
1) roll no 7 1 - 7
2) tax year 4 8 - 11
3) penalty percent 4 12 - 15
4) legal class 1 16 - 16
5) legal decimal pt 1 17 - 17
6) legal sub-class 2 18 - 19
7) FCV assessment ratio 5 20 - 24
8) LPV assessment ratio 5 25 - 29
9) tax area code 6 30 - 35
10) mail address line1 40 36 - 75
11) mail address line2 40 76 - 115
12) mail address line3 40 116 - 155
13) mail address line4 40 156 - 195
14) mail address line5 40 196 - 235
15) location address line1 53 236 - 288
16) location address line2 53 289 - 341
17) property code 1 3 342 - 344
18) fcv 1 12 345 - 356
19) fcv assessed 1 12 357 - 368
20) fcv exempt 1 12 369 - 380
21) fcv remainder 1 12 381 - 392
22) lpv 1 12 393 - 404
23) lpv assessed 1 12 405 - 416
24) lpv exempt 1 12 417 - 428
25) lpv_remainder 1 12 429 - 440
26) property code 2 3 441 - 443
27) fcv 2 12 444 - 455
28) fcv assessed 2 12 456 - 467
29) fcv exempt 2 12 468 - 479
30) fcv remainder 2 12 480 - 491
31) lpv 2 12 492 - 503
32) lpv assessed 2 12 504 - 515
33) lpv exempt 2 12 516 - 527
34) lpv_remainder 2 12 528 - 539
35) property code 3 3 540 - 542
36) fcv 3 12 543 - 554
37) fcv assessed 3 12 555 - 566
38) fcv exempt 3 12 567 - 578
39) fcv remainder 3 12 579 - 590
40) lpv 3 12 591 - 602
41) lpv assessed 3 12 603 - 614
42) lpv exempt 3 12 615 - 626
43) lpv_remainder 3 12 627 - 638
44) property code 4 3 639 - 641

SERIAL 16085-S
45) fcv 4 12 642 - 653
46) fcv assessed 4 12 654 - 665
47) fcv exempt 4 12 666 - 677
48) fcv remainder 4 12 678 - 689
49) lpv 4 12 690 - 701
50) lpv assessed 4 12 702 - 713
51) lpv exempt 4 12 714 - 725
52) lpv_remainder 4 12 726 - 737
53) property code 5 3 738 - 739
54) fcv 5 12 740 - 752
55) fcv assessed 5 12 753 - 764
56) fcv exempt 5 12 765 - 776
57) fcv remainder 5 12 777 - 788
58) lpv 5 12 789 - 800
59) lpv assessed 5 12 801 - 812
60) lpv exempt 5 12 813 - 824
61) lpv_remainder 5 12 825 - 836
62) property code 6 3 837 - 839
63) fcv 6 12 840 - 851
64) fcv assessed 6 12 852 - 863
65) fcv exempt 6 12 864 - 875
66) fcv remainder 6 12 876 - 887
67) lpv 6 12 888 - 899
68) lpv assessed 6 12 900 - 911
69) lpv exempt 6 12 912 - 923
70) lpv_remainder 6 12 924 - 935
71) total fcv 13 936 - 948
72) total fcv assessed 12 949 - 960
73) total fcv exempt 12 961 - 972
74) total fcv remainder 12 973 - 984
75) total lpv 13 985 - 997
76) total lpv assessed 12 998 - 1009
77) total lpv exempt 12 1010 - 1021
78) total lpv_remainder 12 1022 - 1033
79) account type 1 1034 - 1034
80) lessor number 5 1035 - 1039
81) multiple number 5 1040 - 1044
82) mobile home make 10 1045 - 1054
83) mobile home year 4 1055 - 1058
84) mobile home width 2 1059 - 1060
85) mobile home length 2 1061 - 1062
86) mobile home id 1 30 1063 - 1092
87) mobile home id 2 30 1093 - 1122
88) mobile home id 3 30 1123 - 1152
89) mobile home id 4 30 1153 - 1182
90) prior yr legal class 1 1183 - 1183
91) prior yr legal decimal pt 1 1184 - 1184
92) prior yr legal sub-class 2 1185 - 1186
93) prior yr asmt ratio 5 1187 - 1191
94) prior yr fcv asmt ratio 5 1192 - 1196
95) prior yr lpv asmt ratio 5 1197 - 1201
96) prior yr fcv 12 1202 - 1213
97) prior yr fcv assessed 12 1214 - 1225
98) prior yr fcv exempt 12 1226 - 1237
99) prior yr fcv remainder 12 1238 - 1249
100) prior yr lpv 12 1250 - 1261
101) prior yr lpv assessed 12 1262 - 1273
102) prior yr lpv exempt 12 1274 - 1285
103) prior yr lpv remainder 12 1286 - 1297

SERIAL 16085-S
104) prior yr mkt legal class 1 1298 - 1298
105) prior yr mkt lgl decimal pt 1 1299 - 1299
106) prior yr mkt lgl sub-class 2 1300 - 1301
107) prior yr mkt asmt ratio 5 1302 - 1306
108) prior yr mkt fcv 12 1307 - 1318
109) prior yr mkt fcv asd 12 1319 - 1330
110) prior yr mkt lpv 12 1331 - 1342
111) prior yr mkt lpv asd 12 1343 - 1354
112) prior yr senior legal class 1 1355 - 1355
113) prior yr senior lgl decimal 1 1356 - 1356
114) prior yr senior lgl sub-cls 2 1357 - 1358
115) prior yr senior asmt ratio 5 1359 - 1363
116) prior yr senior fcv 12 1364 - 1375
117) prior yr senior fcv asd 12 1376 - 1387
118) prior yr senior lpv 12 1388 - 1399
119) prior yr senior lpv asd 12 1400 - 1411
120) curr yr mkt legal class 1 1412 - 1412
121) curr yr mkt legal decimal 1 1413 - 1413
122) curr yr mkt legal sub-cls 2 1414 - 1415
123) curr yr mkt asmt ratio 5 1416 - 1420
124) curr yr mkt fcv 12 1421 - 1432
125) curr yr mkt fcv asd 12 1433 - 1444
126) curr yr mkt lpv 12 1445 - 1456
127) curr yr mkt lpv asd 12 1457 - 1468
128) curr yr senior legal class 1 1469 - 1469
129) curr yr senior lgl decimal 1 1470 - 1470
130) curr yr senior lgl sub-cls 2 1471 - 1472
131) curr yr senior asmt ratio 5 1473 - 1477
132) curr yr senior fcv 12 1478 - 1489
133) curr yr senior fcv asd 12 1490 - 1501
134) curr yr senior lpv 12 1502 - 1513
135) curr yr senior lpv asd 12 1514 - 1525

SERIAL 16085-S
EXHIBIT 5
Maricopa County Assessor’s Office
UPPS NOV Data File Layout
12/21/2007
Position
No Data Description Size Type Starting Ending Variable Name
1 County Number 2 Char 1 2 07'
2 Parcel Number 11 Char 3 13 book-map-item
3 Conto Owner's Name 40 Char 14 53 &sar_conto_name
4 Fee Owner's Name 40 Char 54 93 &sar_ownr_name
5 In-Care-Of Name 40 Char 94 133 $in_care_of
6 Street Address 40 Char 134 173 $addr1
7 Street Address - 2 40 Char 174 213 $addr2
8 City, State, Zip 40 Char 214 253 $csz
9 Country 40 Char 254 293 $cntry
10 Section or Lot 6 Char 294 299 $sect_lot
11 Township or Block 4 Char 300 303 $twns_block
12 Range or Tract 3 Char 304 306 $rng_tract
13 Legal Description - 1 52 Char 307 358 $lgl_desc1
14 Legal Description - 2 52 Char 359 410 $lgl_desc2
15 Previous (B) Land Legal Class 2 Char 411 412 $prev_b_land_lc
16 Previous (B) Land FCV 12 Number 413 424 $prev_b_land_fcv
17 Previous (B) Land Percent 4 Number 425 428 $prev_b_land_pct
18 Previous (B) Land Assessed 12 Number 429 440 $prev_b_land_assd
19 Previous (B) Impr Legal Class 2 Char 441 442 $prev_b_impr_lc
20 Previous (B) Impr FCV 12 Number 443 454 $prev_b_impr_fcv
21 Previous (B) Impr Percent 4 Number 455 458 $prev_b_impr_pct
22 Previous (B) Impr Assessed 12 Number 459 470 $prev_b_impr_assd
23 Previous (B) Total FCV Legal Class 2 Char 471 472 $prev_b_fcv_lc
24 Previous (B) Total FCV 12 Number 473 484 $prev_b_fcv
25 Previous (B) Total FCV Percent 4 Number 485 488 $prev_b_fcv_pct
26 Previous (B) Total FCV Assessed 12 Number 489 500 $prev_b_fcv_assd
27 Previous (B) Total LPV 12 Number 501 512 $prev_b_lpv
28 Previous (B) Total LPV Percent 4 Number 513 516 $prev_b_lpv_pct
29 Previous (B) Total LPV Assessed 12 Number 517 528 $prev_b_lpv_assd
30 Previous (A) Land Legal Class 2 Char 529 530 $prev_a_land_lc
31 Previous (A) Land FCV 12 Number 531 542 $prev_a_land_fcv
32 Previous (A) Land Percent 4 Number 543 546 $prev_a_land_pct
33 Previous (A) Land Assessed 12 Number 547 558 $prev_a_land_assd
34 Previous (A) Impr Legal Class 2 Char 559 560 $prev_a_impr_lc
35 Previous (A) Impr FCV 12 Number 561 572 $prev_a_impr_fcv
36 Previous (A) Impr Percent 4 Number 573 576 $prev_a_impr_pct
37 Previous (A) Impr Assessed 12 Number 577 588 $prev_a_impr_assd
38 Previous (A) Total FCV Legal Class 2 Char 589 590 $prev_a_fcv_lc
39 Previous (A) Total FCV 12 Number 591 602 $prev_a_fcv
40 Previous (A) Total FCV Percent 4 Number 603 606 $prev_a_fcv_pct

SERIAL 16085-S
41 Previous (A) Total FCV Assessed 12 Number 607 618 $prev_a_fcv_assd
42 Previous (A) Total LPV 12 Number 619 630 $prev_a_lpv
43 Previous (A) Total LPV Percent 4 Number 631 634 $prev_a_lpv_pct
44 Previous (A) Total LPV Assessed 12 Number 635 646 $prev_a_lpv_assd
45 Current (B) Land Legal Class 2 Char 647 648 $curr_b_land_lc
46 Current (B) Land FCV 12 Number 649 660 $curr_b_land_fcv
47 Current (B) Land Percent 4 Number 661 664 $curr_b_land_pct
48 Current (B) Land Assessed 12 Number 665 676 $curr_b_land_assd
49 Current (B) Impr Legal Class 2 Char 677 678 $curr_b_impr_lc
50 Current (B) Impr FCV 12 Number 679 690 $curr_b_impr_fcv
51 Current (B) Impr Percent 4 Number 691 694 $curr_b_impr_pct
52 Current (B) Impr Assessed 12 Number 695 706 $curr_b_impr_assd
53 Current (B) Total FCV Legal Class 2 Char 707 708 $curr_b_fcv_lc
54 Current (B) Total FCV 12 Number 709 720 $curr_b_fcv
55 Current (B) Total FCV Percent 4 Number 721 724 $curr_b_fcv_pct
56 Current (B) Total FCV Assessed 12 Number 725 736 $curr_b_fcv_assd
57 Current (B) Total LPV 12 Number 737 748 $curr_b_lpv
58 Current (B) Total LPV Percent 4 Number 749 752 $curr_b_lpv_pct
59 Current (B) Total LPV Assessed 12 Number 753 764 $curr_b_lpv_assd
60 Current (A) Land Legal Class 2 Char 765 766 $curr_a_land_lc
61 Current (A) Land FCV 12 Number 767 778 $curr_a_land_fcv
62 Current (A) Land Percent 4 Number 779 782 $curr_a_land_pct
63 Current (A) Land Assessed 12 Number 783 794 $curr_a_land_assd
64 Current (A) Impr Legal Class 2 Char 795 796 $curr_a_impr_lc
65 Current (A) Impr FCV 12 Number 797 808 $curr_a_impr_fcv
66 Current (A) Impr Percent 4 Number 809 812 $curr_a_impr_pct
67 Current (A) Impr Assessed 12 Number 813 824 $curr_a_impr_assd
68 Current (A) Total FCV Legal Class 2 Char 825 826 $curr_a_fcv_lc
69 Current (A) Total FCV 12 Number 827 838 $curr_a_fcv
70 Current (A) Total FCV Percent 4 Number 839 842 $curr_a_fcv_pct
71 Current (A) Total FCV Assessed 12 Number 843 854 $curr_a_fcv_assd
72 Current (A) Total LPV 12 Number 855 866 $curr_a_lpv
73 Current (A) Total LPV Percent 4 Number 867 870 $curr_a_lpv_pct
74 Current (A) Total LPV Assessed 12 Number 871 882 $curr_a_lpv_assd
75 Current Building Sqft 12 Number 883 894 $curr_sqft

SERIAL 16085-S
EXHIBIT 6
MARICOPA COUNTY ASSESSOR’S OFFICE LCV LETTERS FILE LAYOUT
This layout is good for all three letter types the LCV unit uses.
Position
No Data Description Size Type Starting Ending Variable Name
1 County Code 2 Char 1 2 Hardcoded to '07'
2 Tax Year 4 Char 3 6 $tax_yr
3 Parcel Number 11 Char 7 17 &parcel_number
4 Owner Name 45 Char 18 62 &on_ownr_name
5 In Care Of… 45 Char 63 107 &on_in_care_of_name
6 Mail Address 1 40 Char 108 147 &on_mail_addr1
7 Mail Address 2 40 Char 148 187 &on_mail_addr2
8 City, State, Zip 55 Char 188 242 $mail_csz
9 Country 40 Char 243 282 &on_mail_cntry
10 Site Address 1 65 Char 283 347 $site_addr1
11 Site Address 2 10 Char 348 357 $site_addr2
12 City, State, Zip 55 Char 358 412 $site_csz
13 Account Number 7 Char 413 419 $account_no
14 Vin Number 30 Char 420 449 $vin_no

SERIAL 16085-S
EXHIBIT 7
Treasurer Print File Documentation & Examples
Property Tax Bills
Property Tax Bill Support Files
There are three support files used in the printing of all Tax Bills: Area Code Tax Data, District Name and Lease
Company information. Typically these files will be compressed into a ZIP file and made available via FTP or even
emailed as attachments.
Area Code Tax Data
This file stores information used on all the Tax Bills. Here is the record layout:
* ***************************************************************************
* A record is written for each area code.
* A entry in the table exists for each County Wide district and each area code specific district.
* A final "TOTAL" entry in the table with rate sums.
* ***************************************************************************
01 AREA_CODE_REC.
02 AREA_CODE PIC X(6).
02 ADIST_DATA OCCURS 12 TIMES.
04 ENTRY_TYPE PIC X.
88 DIST_ENTRY VALUE "D".
88 AREA_CODE_TOTAL_ENTRY VALUE "A".
04 DIST PIC X(5).
04 DIST_NAME PIC X(30).
04 DIST_PHONE PIC X(13).
04 DIST_PRIMARY_RATE PIC ZZZZ.Z(4).
04 DIST_SECONDARY_RATE PIC ZZZZ.Z(4).
04 DIST_ABOND_RATE PIC ZZZZ.Z(4).
04 DIST_BBOND_RAT PIC ZZZZ.Z(4).
04 DIST_OVERRIDE_RATE PIC ZZZZ.Z(4).
District Name File
This file contains information specific to each taxing jurisdiction reflected on tax bills and utilized in the tax bill or
information statement layout.
01 DIST_REC.
05 DIST PIC X(5).
05 DIST_TYPE PIC X.
88 EDUC_TAX VALUE "1".
88 CITY_TAX VALUE "2".
88 COUNTY_TAX VALUE "3".
88 SPEC_DIST_TAX VALUE "4".
05 DIST_NAME PIC X(30).
05 DIST_PHONE PIC X(13).
05 DIST_URL PIC X(132).
05 DIST_LEVY PIC 9(12).
Lease Company File
This file contains information on personal property lease companies that are referenced by personal property account
bill data in the lease company tax bill category.
01 LEASE_FILE_REC.
05 LEASE_COMPANY_ID PIC 9(5).
05 LEASE_COMPANY_NAME PIC X(40).

SERIAL 16085-S
05 CONTACT_NAME PIC X(40).
05 STREET_NUM PIC X(5).
05 STREET_DIR PIC X.
05 STREET_NAME PIC X(20).
05 STREET_TYPE PIC X(2).
05 SUITE_NUM PIC X(4).
05 ADDRESS_2 PIC X(34).
05 CITY PIC X(28).
05 STATE PIC X(2).
05 ZIP_CODE PIC X(9).
05 FOREIGN_ADDR_FLG PIC X.
Property Tax Bills Data Files
The standard annual property tax billing is categorized into 5 different billing types:
 Zip-Coded Bills – These are mostly individual tax bills ordered by zip code.
 Multi-Coded Bills – Tax bills in this category have multiple bills grouped to be mailed to the same
recipient.
 Mortgage Company Bills – These are tax bills printed for mailing to a mortgage lender or bulk payer.
 Lease Company Bills – These are tax bills for personal property being paid for by a leasing company.
 Resolution Bills – These are corrected tax bills that are produced as part of the Treasurer’s resolution
processing throughout the property tax year.
For each of these categories, a pair of data files in fixed-length format are created by the Treasurer’s system. In
addition to the printed tax bill statements, PDF images of each statement are also created and provided to the
Treasurer’s Office.
There are also some other miscellaneous bill printing runs created throughout the year. Some of these additional
runs include:
 Arizona Department of Revenue (DOR) tax bills
 No-print tax bills
 Special-purpose tax bills
The record layout for each of the tax bill files follows:
Tax Bill Record 1
This describes the record format of file 1 of the two-file set for tax bills.
01 PRINTER_BILL1_REC.
02 CONTROL_FLAGS.
03 SINGLE_STUB_FLG PIC X.
88 SINGLE_STUB VALUE "Y".
03 NCOA_IGNORE_FLG PIC X.
88 NCOA_IGNORED VALUE "Y".
03 STATE_AID_FLG PIC X.
88 PRINT_STATE_AID_MSG VALUE "Y".
03 DELINQ_TAXES_FLG PIC X.
88 DELINQUENT_TAXES VALUE "Y".
03 EXEMPT_FLG PIC X.
88 FULL_EXEMPT VALUES ARE "E" "S".
88 PART_EXEMPT VALUE IS "P".

SERIAL 16085-S
03 RES_FLG PIC X.
88 PRINT_RESOLUTION_MSG VALUE "Y".
03 COUNTY_ED_FLG PIC X.
88 PRINT_COUNTY_ED_MSG VALUE "Y".
03 PREV_PARCEL_FLG PIC X.
88 NO_PREV_PARCEL VALUE "N".
88 PREV_NOT_AVAIL VALUE "X".
03 SECOND_NAME_LINE_FLG PIC X.
88 SECOND_NAME_ON_STUB VALUE "Y".
03 PREPAYMENT_FLG PIC X.
88 PREPMT VALUE "Y".
03 EVIT_FLG PIC X.
88 EVIT_SPEC_DIST VALUE "Y".
03 WESTMEC_FLG PIC X.
88 WESTMEC_SPEC_DIST VALUE "Y".
02 PARCEL_NUM.
04 PARCEL_BOOK PIC X(3).
04 PARCEL_MAP PIC X(2).
04 PARCEL_ITEM PIC X(3).
04 PARCEL_SPLIT PIC X.
02 TCD PIC X.
02 BILL_SEQUENCE_NUMBER PIC Z(6).
02 PRINT_KEY PIC X(5).
02 AREA_CODE PIC X(6).
02 LEGAL_DESCRIPTION.
04 LEGAL_LOT PIC X(4).
04 LEGAL_BLOCK PIC X(4).
04 LEGAL_TRACT PIC X(4).
04 LEGAL_DESC1 PIC X(49).
04 LEGAL_DESC2 PIC X(49).
04 FILLER PIC X(59) VALUE SPACES.
02 PERS_PROP_DATA REDEFINES LEGAL_DESCRIPTION.
04 MH_FLG PIC X.
04 MH_MODEL_YEAR PIC X(4).
04 MH_MAKE PIC X(10).
04 MH_WIDTH PIC X(2).
04 MH_LENGTH PIC X(2).
04 MH_VIN1 PIC X(30).
04 MH_VIN2 PIC X(30).
04 MH_VIN3 PIC X(30).
04 MH_VIN4 PIC X(30).
04 MH_VIN5 PIC X(30).
02 SITUS_ADDR.
04 SITUS_LINE_1 PIC X(49).
02 NAME_ADDRESS.
03 NA1.
04 NA1_TYPE PIC X.
04 NAME_LINE1 PIC X(40).
03 NA2.
04 NA2_TYPE PIC X.
04 NAME_LINE2 PIC X(40).
03 NA3.
04 NA3_TYPE PIC X.
04 NAME_LINE3 PIC X(40).
03 NA4.
04 NA4_TYPE PIC X.
04 NAME_LINE4 PIC X(40).
03 NA5.
04 NA5_TYPE PIC X.

SERIAL 16085-S
04 NAME_LINE5 PIC X(40).
03 NA6.
04 NA6_TYPE PIC X.
04 NAME_LINE6 PIC X(40).
02 PREV_VALUE_DATA.
03 PRI_LAND_VALUE PIC Z(12).
03 PRI_PERS_VALUE PIC Z(12).
03 PRI_TOT_VALUE PIC Z(12).
03 PRI_RATIO PIC Z.999.
03 PRI_LAND_ASSD_VALUE PIC Z(12).
03 PRI_PERS_ASSD_VALUE PIC Z(12).
03 PRI_TOT_ASSD_VALUE PIC Z(12).
03 PRI_EXEMPTION PIC Z(12).
03 PRI_NET_ASSD_VALUE PIC Z(12).
03 SEC_LAND_VALUE PIC Z(12).
03 SEC_PERS_VALUE PIC Z(12).
03 SEC_TOT_VALUE PIC Z(12).
03 SEC_RATIO PIC Z.999.
03 SEC_LAND_ASSD_VALUE PIC Z(12).
03 SEC_PERS_ASSD_VALUE PIC Z(12).
03 SEC_TOT_ASSD_VALUE PIC Z(12).
03 SEC_EXEMPTION PIC Z(12).
03 SEC_NET_ASSD_VALUE PIC Z(12).
02 CURR_VALUE_DATA.
03 PRI_LAND_VALUE PIC Z(12).
03 PRI_PERS_VALUE PIC Z(12).
03 PRI_TOT_VALUE PIC Z(12).
03 PRI_RATIO PIC Z.999.
03 PRI_LAND_ASSD_VALUE PIC Z(12).
03 PRI_PERS_ASSD_VALUE PIC Z(12).
03 PRI_TOT_ASSD_VALUE PIC Z(12).
03 PRI_EXEMPTION PIC Z(12).
03 PRI_NET_ASSD_VALUE PIC Z(12).
03 SEC_LAND_VALUE PIC Z(12).
03 SEC_PERS_VALUE PIC Z(12).
03 SEC_TOT_VALUE PIC Z(12).
03 SEC_RATIO PIC Z.999.
03 SEC_LAND_ASSD_VALUE PIC Z(12).
03 SEC_PERS_ASSD_VALUE PIC Z(12).
03 SEC_TOT_ASSD_VALUE PIC Z(12).
03 SEC_EXEMPTION PIC Z(12).
03 SEC_NET_ASSD_VALUE PIC Z(12).
02 SPEC_DIST_VALUE_DATA OCCURS 7 TIMES.
04 DIST PIC X(5).
04 SD_VALUE PIC X(12).
04 DIST_TYPE PIC X.
88 VALUE_DIST VALUE " ".
88 ACREAGE_DIST VALUE "A".
88 SQ_FOOTAGE_DIST VALUE "S".
88 DOLLAR_DIST VALUE "D".
02 RESOLUTION_DATA.
04 PHASE_NUM PIC 9(4) VALUE ZERO.
04 RES_NUM PIC 9(5) VALUE ZERO.
02 DELINQ_DATA.
04 GRAND_TOTAL_DUE PIC 9(16)V99.
04 PRIOR_YEARS_DUE PIC 9(16)V99.
04 PRIOR_YEARS_CNT PIC 9(2) VALUE ZERO.
04 PRIOR_YEARS_TABLE.

SERIAL 16085-S
06 PRIOR_YEAR PIC X(4)
OCCURS 10 TIMES.
Tax Bill Record 2
This describes the record format of file 2 of the two-file set for tax bills.
01 PRINTER_BILL2_REC.
02 PARCEL_NUM.
04 PARCEL_BOOK PIC X(3).
04 PARCEL_MAP PIC X(2).
04 PARCEL_ITEM PIC X(3).
04 PARCEL_SPLIT PIC X.
02 CAT1_PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT1_CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT1_TAX_PCT PIC ZZZ9.9-.
02 CAT1_CNT PIC 99.
02 CAT1_TABLE.
03 CAT1_TABLE_ITEM OCCURS 11 TIMES.
04 DIST PIC X(5).
04 PRI_SEC_FLG PIC X.
04 TAX_TYPE_FLG PIC X.
88 PRI_TAX VALUE "P".
88 BOND_TAX VALUE "B".
88 OVERRIDE_TAX VALUE "0".
88 SPEC_DIST_TAX VALUE "S".
88 EDUC_EQUAL_TAX VALUE "E".
04 CURR_RATE PIC ZZZZ.9999.
04 PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CHANGE_PCT PIC ZZZ9.9-.
02 CAT2_PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT2_CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT2_TAX_PCT PIC ZZZ9.9-.
02 CAT2_CNT PIC 99.
02 CAT2_TABLE.
03 CAT2_TABLE_ITEM OCCURS 3 TIMES.
04 DIST PIC X(5).
04 PRI_SEC_FLG PIC X.
04 TAX_TYPE_FLG PIC X.
88 PRI_TAX VALUE "P".
88 BOND_TAX VALUE "B".
88 OVERRIDE_TAX VALUE "O".
04 CURR_RATE PIC ZZZZ.9999.
04 PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CHANGE_PCT PIC ZZZ9.9-.
02 CAT3_PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT3_CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT3_TAX_PCT PIC ZZZ9.9-.
02 CAT3_CNT PIC 99.
02 CAT3_TABLE.
03 CAT3_TABLE_ITEM OCCURS 3 TIMES.
04 DIST PIC X(5).
04 PRI_SEC_FLG PIC X.
04 TAX_TYPE_FLG PIC X.
88 PRI_TAX VALUE "P".
88 BOND_TAX VALUE "B".
88 OVERRIDE_TAX VALUE "O".
04 CURR_RATE PIC ZZZZ.9999.

SERIAL 16085-S
04 PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CHANGE_PCT PIC ZZZ9.9-.
02 CAT4_PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT4_CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 CAT4_TAX_PCT PIC ZZZ9.9-.
02 CAT4_CNT PIC 99.
02 CAT4_TABLE.
03 CAT4_TABLE_ITEM OCCURS 12 TIMES.
04 DIST PIC X(5).
04 PRI_SEC_FLG PIC X.
04 CURR_RATE PIC ZZZZ.9999.
04 PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CURR_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CHANGE_PCT PIC ZZZ9.9-.
02 STATE_AID_DATA.
04 CURR_STATE_AID PIC ZZZ,ZZZ,ZZZ.ZZ-.
04 PREV_STATE_AID PIC ZZZ,ZZZ,ZZZ.ZZ-.
04 CHANGE_PCT PIC ZZZZ.Z-.
02 EAF_DATA.
04 CURR_EAF PIC ZZZ,ZZZ,ZZZ.ZZ-.
04 PREV_EAF PIC ZZZ,ZZZ,ZZZ.ZZ-.
04 CHANGE_PCT PIC ZZZZ.Z-.
02 OTHER_TAX_DATA.
03 TOT_CURR_TAX PIC Z(9).99.
03 TOT_PREV_TAX PIC Z(9).99.
03 TOTAL_TAX_CHANGE_PCT PIC ZZZ9.9-.
03 TOT_PRI_RATE PIC ZZZV999999.
03 TOT_CURR_PRI_TAX PIC Z(9).99.
03 TOT_PREV_PRI_TAX PIC Z(9).99.
03 TOT_SEC_RATE PIC ZZZV999999.
03 TOT_CURR_SEC_TAX PIC Z(9).99.
03 TOT_PREV_SEC_TAX PIC Z(9).99.
03 TAX_1ST_HALF PIC 9(9)V99.
03 TAX_2ND_HALF PIC 9(9)V99.
02 PREPMT_AMT PIC $$$$,$$$,$$$.$$.
02 STUB1_SCAN_LINE.
04 STUB1_TAX_YEAR PIC 99.
04 STUB1_ZEROS PIC 9(7).
04 STUB1_BTX_FLG PIC 9.
04 STUB1_HALF_CODE PIC 9.
04 STUB1_SCAN_WHOLE_TAX PIC 9(8)V99.
04 STUB1_SCAN_HALF_TAX PIC 9(8)V99.
04 STUB1_PARCEL1 PIC X(8).
04 STUB1_ALPHA1 PIC 99.
04 STUB1_TCD1 PIC X.
04 STUB1_SCAN_CD PIC X.
02 STUB2_SCAN_LINE.
04 STUB2_TAX_YEAR PIC 99.
04 STUB2_ZEROS PIC 9(7).
04 STUB2_BTX_FLG PIC 9.
04 STUB2_HALF_CODE PIC 9.
04 STUB2_SCAN_WHOLE_TAX PIC 9(8)V99.
04 STUB2_SCAN_HALF_TAX PIC 9(8)V99.
04 STUB2_PARCEL1 PIC X(8).
04 STUB2_ALPHA1 PIC 99.
04 STUB2_TCD1 PIC X.
04 STUB2_SCAN_CD PIC X.

SERIAL 16085-S
Information Statements
Information Statements are sent to homeowners each year whose property taxes are paid by a 3rd party such as a
mortgage lender. These statements have different content and, therefore, have a different data file format.
Here is the record layout for the Information Statement file.
Info Statement Record
01 PRINTER_INFO1_REC.
02 CONTROL_FLAGS.
03 SINGLE_STUB_FLG PIC X.
88 SINGLE_STUB VALUE "Y".
03 NCOA_IGNORE_FLG PIC X.
88 NCOA_IGNORED VALUE "Y".
03 STATE_AID_FLG PIC X.
88 PRINT_STATE_AID_MSG VALUE "Y".
03 DELINQ_TAXES_FLG PIC X.
88 DELINQUENT_TAXES VALUE "Y".
03 EXEMPT_FLG PIC X.
88 FULL_EXEMPT VALUES ARE "E" "S".
88 PART_EXEMPT VALUE IS "P".
03 RES_FLG PIC X.
88 PRINT_RESOLUTION_MSG VALUE "Y".
03 COUNTY_ED_FLG PIC X.
88 PRINT_COUNTY_ED_MSG VALUE "Y".
03 PREV_PARCEL_FLG PIC X.
88 NO_PREV_PARCEL VALUE "N".
88 PREV_NOT_AVAIL VALUE "X".
03 SECOND_NAME_LINE_FLG PIC X.
88 SECOND_NAME_ON_STUB VALUE "Y".
03 PREPAYMENT_FLG PIC X.
88 PREPMT VALUE "Y".
03 EVIT_FLG PIC X.
88 EVIT_SPEC_DIST VALUE "Y".
03 WESTMEC_FLG PIC X.
88 WESTMEC_SPEC_DIST VALUE "Y".
02 PARCEL_NUM.
04 PARCEL_BMI PIC X(8).
04 PARCEL_SPLIT PIC X.
02 TCD PIC X.
02 BILL_SEQUENCE_NUMBER PIC Z(6).
02 AREA_CODE PIC X(6).
02 LEGAL_DESCRIPTION.
04 LEGAL_LOT PIC X(4).
04 LEGAL_BLOCK PIC X(4).
04 LEGAL_TRACT PIC X(4).
04 LEGAL_DESC1 PIC X(49).
04 LEGAL_DESC2 PIC X(49).
04 FILLER PIC X(59) VALUE SPACES.
02 PERS_PROP_DATA REDEFINES LEGAL_DESCRIPTION.
04 MH_FLG PIC X.
04 MH_MODEL_YEAR PIC X(4).
04 MH_MAKE PIC X(10).
04 MH_WIDTH PIC X(2).
04 MH_LENGTH PIC X(2).
04 MH_VIN1 PIC X(30).
04 MH_VIN2 PIC X(30).
04 MH_VIN3 PIC X(30).
04 MH_VIN4 PIC X(30).
04 MH_VIN5 PIC X(30).

SERIAL 16085-S
02 NAME_ADDRESS.
03 NA1.
04 NA1_TYPE PIC X.
04 NAME_LINE1 PIC X(40).
03 NA2.
04 NA2_TYPE PIC X.
04 NAME_LINE2 PIC X(40).
03 NA3.
04 NA3_TYPE PIC X.
04 NAME_LINE3 PIC X(40).
03 NA4.
04 NA4_TYPE PIC X.
04 NAME_LINE4 PIC X(40).
03 NA5.
04 NA5_TYPE PIC X.
04 NAME_LINE5 PIC X(40).
03 NA6.
04 NA6_TYPE PIC X.
04 NAME_LINE6 PIC X(40).
02 SITUS_ADDR.
04 SITUS_LINE_1 PIC X(49).
02 VALUE_DATA.
03 PRI_VALUE PIC Z(11)9.
03 PRI_RATIO PIC Z.999.
03 PRI_ASSD_VALUE PIC Z(11)9.
03 PRI_TOT_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 SEC_VALUE PIC Z(11)9.
03 SEC_RATIO PIC Z.999.
03 SEC_ASSD_VALUE PIC Z(11)9.
03 SEC_TOT_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 TOT_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 TOT_PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 TOT_TAX_DIFF PIC ZZZ,ZZZ,ZZ9.99.
03 NA3.
04 NA3_TYPE PIC X.
04 NAME_LINE3 PIC X(40).
03 NA4.
04 NA4_TYPE PIC X.
04 NAME_LINE4 PIC X(40).
03 NA5.
04 NA5_TYPE PIC X.
04 NAME_LINE5 PIC X(40).
03 NA6.
04 NA6_TYPE PIC X.
04 NAME_LINE6 PIC X(40).
02 SITUS_ADDR.
04 SITUS_LINE_1 PIC X(49).
02 VALUE_DATA.
03 PRI_VALUE PIC Z(11)9.
03 PRI_RATIO PIC Z.999.
03 PRI_ASSD_VALUE PIC Z(11)9.
03 PRI_TOT_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 SEC_VALUE PIC Z(11)9.
03 SEC_RATIO PIC Z.999.
03 SEC_ASSD_VALUE PIC Z(11)9.
03 SEC_TOT_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 TOT_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 TOT_PREV_TAX PIC ZZZ,ZZZ,ZZ9.99.
03 TOT_TAX_DIFF PIC ZZZ,ZZZ,ZZ9.99.

SERIAL 16085-S
03 TOT_TAX_DIFF_SIGN PIC X.
88 TOT_TAX_INCREASE VALUE "+".
88 TOT_TAX_DECREASE VALUE "-".
88 TOT_TAX_SAME VALUE " ".
02 TAX_TABLE.
03 TAX_TABLE_ITEM OCCURS 30 TIMES.
04 DIST PIC X(5).
04 PREV_YEAR_TAX PIC ZZZ,ZZZ,ZZ9.99.
04 CURR_YEAR_TAX PIC ZZZ,ZZZ,ZZ9.99.
02 STATE_AID.
04 PREV_STATE_AID PIC ZZZ,ZZZ,ZZ9.99-.
04 CURR_STATE_AID PIC ZZZ,ZZZ,ZZ9.99-.
02 EAF.
04 PREV_EAF PIC ZZZ,ZZZ,ZZ9.99-.
04 CURR_EAF PIC ZZZ,ZZZ,ZZ9.99-.
02 PRIOR_YEARS_DUE PIC ZZZ,ZZZ,ZZ9.99.
02 GRAND_TOTAL_DUE PIC ZZZ,ZZZ,ZZ9.99.
02 TOTAL_LEVY_AMT PIC ZZZ,ZZZ,ZZZ,ZZ9.
Delinquent Notices
Delinquent notices are created at two different times each year. Delinquent notices for real property and personal
property are mailed in May/June. Then, a second delinquent notice for real property is produced in
November/December.
The data set for real property delinquent notices consists of three files. Two separate data sets are created – one
containing property with no other previous delinquent taxes and another containing property that has previous
delinquent taxes. The delinquent notice templates used for these two groups are slightly different.
 Tax Data File
 Name/Address File
 Legal Description File
The data set for personal property delinquent notices consists of four files. Two separate data sets are also created
for these distinguishing between property with and without prior delinquencies. The delinquent notice templates
used for these two groups are slightly different.
 Tax Data File
 Name/Address File
 Situs Address File (same record format as Legal Description File)
 Mobile Home File
Delinquent Notice Tax Record
This record format is used in the Tax Data File for both real and personal property.
01 TAX_DATA_RECORD.
02 MAILER_TAX_DATA_REC.
03 PARCEL_NUMBER.
04 PARCEL_BOOK_MAP_ITEM PIC 9(8).
04 PARCEL_SPLIT PIC X.
03 TAX_YEAR PIC 9(4).
03 TCD PIC 9.

SERIAL 16085-S
03 TAX_SALE_DATE PIC 9(6).
03 HALF_YEAR_CODE PIC X.
88 FULL_DUE VALUE IS "F".
88 HALF_DUE VALUE IS "2".
88 PARTIAL_DUE VALUE IS "P".
03 INTEREST_RATE PIC V9(4).
03 PRIMARY_VALUE PIC 9(12).
03 SECONDARY_VALUE PIC 9(12).
03 PRIOR_YEARS_FLG PIC X.
88 PRIOR_YEARS_DUE VALUE IS "Y".
88 PRIOR_YEARS_NOT_DUE VALUE IS "N".
03 TAX_AMT PIC 9(9)V9(2).
03 INTEREST_TABLE OCCURS 7 TIMES.
04 INTEREST_AMT PIC 9(6)V9(2).
03 ADVERTISING_FEE PIC 9(6)V9(2).
03 IMPOUND_AMT PIC 9(6)V9(2).
03 RES_NUM PIC 9(9).
03 RES_PHASE_NUM PIC 9(5).
03 SCAN_LINE.
04 SCAN_TAX_YEAR PIC 9(2).
04 SCAN_UPPS_DATE PIC 9(8).
04 SCAN_HALF_CODE PIC 9.
04 SCAN_TAX_AMT PIC 9(8)V9(2).
04 SCAN_HALF_TAX_AMT PIC 9(8)V9(2).
04 SCAN_PARCEL1 PIC X(8).
04 SCAN_SPLIT1 PIC 9(2).
04 SCAN_TCD1 PIC X.
04 SCAN_CD PIC X.
03 PRIOR_YEARS_AMT PIC 9(9)V9(2).
03 PRIOR_YEARS_CNT PIC 9(2).
03 PRIOR_YEARS_TABLE OCCURS 50 TIMES.
04 PRIOR_YEAR PIC 9(4).
Delinquent Notice Name/Address Record
This record format is used in the Name/Address Data File for both real and personal property.
01 NAME_ADDR_RECORD.
02 MAILER_NAME_ADDR_REC.
03 PARCEL_NUMBER.
04 PARCEL_BOOK_MAP_ITEM PIC 9(8).
04 PARCEL_SPLIT PIC X.
03 NAME_ADDR PIC X(40).
Delinquent Notice Legal Description / Situs Address Record
This record format is used for the Legal Description data file for real property delinquent notices. The same record
format is also used for the Situs Address data file in personal property delinquent notices. For the personal property
Situs Address file, the situs address information is placed in the LEGAL_DESC field within the record description
below.
01 LEGAL_DESC_RECORD.
02 MAILER_LEGAL_DESC_REC.
03 PARCEL_NUMBER.
04 PARCEL_BOOK_MAP_ITEM PIC 9(8).
04 PARCEL_SPLIT PIC X.
03 LEGAL_LOT PIC X(4).
03 LEGAL_BLOCK PIC X(4).
03 LEGAL_TRACT PIC X(3).
03 LEGAL_DESC PIC X(49).

SERIAL 16085-S
Delinquent Notices Mobile Home Record
This record format is used for the Mobile Home data file that is part of the file set for personal property delinquent
notices.
01 MOBILE_HOME_RECORD.
02 MAILER_MH_DATA_REC.
03 PARCEL_NUMBER.
04 PARCEL_BOOK_MAP_ITEM PIC 9(8).
04 PARCEL_SPLIT PIC X.
03 TAX_YEAR PIC 9(4).
03 MODEL_YEAR PIC X(4).
03 MH_MAKE PIC X(10).
03 VIN_TABLE OCCURS 6 TIMES.
04 VIN PIC X(30).
03 VIN_CNT PIC 9(2).

SERIAL 16085-S
EXHIBIT 8
MARICOPA COUNTY TREASURER’S OFFICE NCOA DATA FILE LAYOUT
NCOA Record Layout – Input
This record format is used for the NCOA file containing the original name/address data that is the input to the
NCOA processing.
01 NCOA_REC.
05 PARCEL_NUM.
10 PARCEL_BMI PIC X(8).
10 PARCEL_SPLIT PIC X.
05 NAME_1 PIC X(40).
05 NAME_2 PIC X(40).
05 ADDRESS_1 PIC X(40).
05 ADDRESS_2 PIC X(40).
05 CITY PIC X(20).
05 STATE PIC X(2).
05 ZIP_CODE PIC X(5).
05 NA_SEQ_NUM PIC 9(5).
05 NA_TIMESTAMP PIC X(22).
05 NA_SOURCE PIC X.
NCOA Record Layout – Output
This record format is used for the NCOA file returned to the Treasurer after the NCOA processing and containing
the address standardization details. Note that the original input record is represented in the first portion of the
record. The returned data is appended to the end of each record by the NCOA vendor.
01 NCOA_REC.
*
* The first 223 bytes (down to and including the ORIG_NA_TIMESTAMP field)
* is from the original data record created by the CREATE_NCOA_FILE program.
*
05 PARCEL_NUM.
10 PARCEL_BMI PIC X(8).
10 PARCEL_SPLIT PIC X.
05 ORIG_NAME_1 PIC X(40).
05 ORIG_NAME_2 PIC X(40).
05 ORIG_ADDR_1 PIC X(40).
05 ORIG_ADDR_2 PIC X(40).
05 ORIG_CITY PIC X(20).
05 ORIG_STATE PIC X(2).
05 ORIG_ZIP_CODE PIC X(5).
05 ORIG_NA_SEQ_NUM PIC 9(5).
05 ORIG_NA_TIMESTAMP PIC X(22).
*
* Return information from the NCOA vendor starts here.
*
05 DELIVER_CODE PIC X.
88 NIXIE_MATCH VALUE "N".
88 MOVE_FORWARD VALUE "M".
88 MOVE_NOFORWARD VALUE "K".
88 BOX_CLOSED VALUE "G".
88 MOVE_FOREIGN VALUE "F".
88 DCOA_MATCH VALUE "D".

SERIAL 16085-S
88 DCOA_NIXIE VALUE "E".
88 PRIMARY_ADDR_NO_DSF VALUE "P".
88 SECONDARY_ADDR_NOT_FOUND VALUE "S".
88 NO_MATCH VALUE "X".
88 SUITE_LINK_MATCH VALUE "T".
88 LACS_LINK_CONVERSION VALUE "L".
05 MOVE_TYPE PIC X.
88 INDIVIDUAL_MOVE VALUE "I".
88 FAMILY_MOVE VALUE "F".
88 BUSINESS_MOVE VALUE "B".
88 UNKNOWN_DCOA VALUE "U".
05 FOREIGN_FLG PIC X.
88 FOREIGN VALUE "F".
88 NOT_FOREIGN VALUE " ".
05 MOVE_EFFECTIVE_DATE.
10 MOVE_EFFECTIVE_YEAR PIC XXXX.
10 MOVE_EFFECTIVE_MONTH PIC XX.
05 STD_COMPANY_NAME PIC X(40).
05 NEW_ADDRESS PIC X(58).
05 NEW_PRIMARY_NUMBER PIC X(10).
05 NEW_PRE_DIRECTIONAL PIC X(2).
05 NEW_PRIMARY_STREET PIC X(28).
05 NEW_ADDRESS_SUFFIX PIC X(4).
05 NEW_POST_DIRECTIONAL PIC X(2).
05 NEW_UNIT_DESIGNATOR PIC X(4).
05 NEW_UNIT_DESIGNATOR_VALUE PIC X(8).
05 NEW_URBANIZATION PIC X(28).
05 NEW_CITY PIC X(13).
05 NEW_STATE PIC X(2).
05 NEW_ZIP_CODE PIC X(5).
05 NEW_ZIP_CODE_4 PIC X(4).
05 NEW_DELIVERY_POINT_CODE PIC X(3).
05 NEW_CARRIER_ROUTE PIC X(4).
05 NEW_ZIP_CODE_4_LEVEL_MATCH PIC X.
05 OLD_ADDRESS_EDITED PIC X(58).
05 OLD_PRIMARY_NUMBER PIC X(10).
05 OLD_PRE_DIRECTIONAL PIC X(2).
05 OLD_PRIMARY_STREET PIC X(28).
05 OLD_ADDRESS_SUFFIX PIC X(4).
05 OLD_POST_DIRECTIONAL PIC X(2).
05 OLD_UNIT_DESIGNATOR PIC X(4).
05 OLD_UNIT_DESIGNATOR_VALUE PIC X(8).
05 OLD_URBANIZATION PIC X(28).
05 OLD_CITY PIC X(13).
05 OLD_STATE PIC X(2).
05 OLD_ZIP_CODE PIC X(5).
05 OLD_ZIP_CODE_4 PIC X(4).
05 OLD_DELIVERY_POINT_CODE PIC X(3).
05 OLD_CARRIER_ROUTE PIC X(4).
05 OLD_SUPPRESSION_FLG PIC X.
05 OLD_ZIP_CODE_4_LEVEL_MATCH PIC X.
05 ZIP_MATCH_RESULTS_CODE PIC X.
05 ZIP_4_MATCH_RESULTS_CODE PIC X.
05 NIXIE_FOOTNOTES PIC X(32).
05 LACS_RESULT_CODE PIC X.
05 LACS_CONVERSION_DATE.
10 LACS_CONVERSION_YEAR PIC X(4).
10 LACS_CONVERSION_MONTH PIC X(2).
05 LACS_MATCHING_RECORD_TYPE PIC X(2).

SERIAL 16085-S
05 NIXIE_GROUP_CODE PIC X.
05 LOT_SEQ_NUM PIC X(4).
05 LOT_SORT_NUM PIC X(2).
05 LOT_ASC_DESC_INDICATOR PIC X.
05 DPV_FLG PIC X.
05 COMMERCIAL_MAIL_FLG PIC X.
05 DPV_CODES PIC X(8).
05 FILLER PIC X(7).
Updated: 2/26/2016