HomeMy WebLinkAbout20230661.tiffRESOLUTION
RE: APPROVE LICENSE AGREEMENT FOR QUARTERLY CENSUS EMPLOYMENT AND
WAGE (QCEW) MICRO DATA, AND CERTIFICATION FOR ACCESS TO PERSONAL
IDENTIFYING INFORMATION (PII), AND AUTHORIZE CHAIR TO SIGN AND SUBMIT
ELECTRONICALLY
WHEREAS, the Board of County Commissioners of Weld County, Colorado, pursuant to
Colorado statute and the Weld County Home Rule Charter, is vested with the authority of
administering the affairs of Weld County, Colorado, and
WHEREAS, the Board has been presented with a License Agreement for Quarterly
Census Employment and Wage (QCEW) Micro Data, and the Certification for Access to Personal
Identifying Information (PII) between the County of Weld, State of Colorado, by and through the
Board of County Commissioners of Weld County, on behalf of the Department of Human Services,
Division of Employment Services, and the Colorado Department of Labor and Employment, with
further terms and conditions being as stated in said license agreement and certification, and
WHEREAS, after review, the Board deems it advisable to approve said license agreement
and certification, copies of which are attached hereto and incorporated herein by reference.
NOW, THEREFORE, BE IT RESOLVED by the Board of County Commissioners of Weld
County, Colorado, that the License Agreement for Quarterly Census Employment and Wage
(QCEW) Micro Data, and the Certification for Access to Personal Identifying Information (PII)
between the County of Weld, State of Colorado, by and through the Board of County
Commissioners of Weld County, on behalf of the Department of Human Services, Division of
Employment Services, and the Colorado Department of Labor and Employment, be, and hereby
are, approved.
BE IT FURTHER RESOLVED by the Board that the Chair, be, and hereby is, authorized
to electronically sign and submit said license agreement and certification.
Cc:NSD
03/17/23
2023-0661
HR0095
LICENSE AGREEMENT FOR QUARTERLY CENSUS EMPLOYMENT AND WAGE (QCEW)
MICRO DATA, AND CERTIFICATION FOR ACCESS TO PERSONAL IDENTIFYING
INFORMATION (PII)
PAGE 2
The above and foregoing Resolution was, on motion duly made and seconded, adopted
by the following vote on the 8th day of March, A.D., 2023.
BOARD OF COUNTY COMMISSIONERS
WELD COUNTY, COLORADO
ATTEST: ,r„d�.�iy c uello;tA
Weld County Clerk to the Board
Coun y A 'orney
Date of signature: o3/It/23
Mikes man, Chai
2023-0661
HR0095
CorrlvacltWlo-1iz
PRIVILEGED AND CONFIDENTIAL
MEMORANDUM
DATE: February 28, 2023
TO: Board of County Commissioners — Pass -Around
FR: Jamie Ulrich, Director, Human Services
RE: Quarterly Census of Employment Wages (QCEW)
License Agreement with the Colorado Department
of Labor and Employment (CDLE)
Please review and indicate if you would like a work session prior to placing this item on the Board's
agenda.
Request Board Approval of the Department's Quarterly Census of Employment Wages (QCEW) License
Agreement with the Colorado Department of Labor and Employment (CDLE). Since 2019 the Department
has entered into a Quarterly Census of Employment Wages (QCEW) License Agreement for Micro Data with the
Colorado Department of Labor and Employment (CDLE) which allows access to economic development data. This
data is made available only to government entities and is received quarterly from the State. The intent is to share
the data pulled with Upstate Colorado Economic Development (Upstate) to further drive the economic
development of Weld County, as agreed in the MOU known as Tyler ID 2019-2444, between Upstate and the
Department. The Department is once again requesting to enter into a new Agreement with CDLE to be able to
continue to use the data. The License Agreement is non -financial, and the term of the agreement will be for one
year from the effective date and shall automatically renew for additional one (1) year periods for up to five (5)
years.
I do not recommend a Work Session. I recommend approval of this Agreement and authorize the Chair to sign the
Data Sharing and License Agreement and Exhibit A electronically via DocuSign.
Perry L. Buck, Pro-Tem
Mike Freeman, Chair
Scott K. James
Kevin D. Ross
Lori Same
Schedule
Work Session
Other/Comments:
Pass -Around Memorandum; February 28, 2023 — CMS ID 6712
Page 1
2023-0661
0O
STATE OF COLORADO DATA SHARING AND
LICENSE AGREEMENT
COVER PAGE
Transferring Agency
Colorado Department of Labor and Employment
Agreement Number
CRN# 7781
Recipient
Employment Services of Weld County
Agreement Performance Beginning Date
The Effective Date
Initial Agreement Expiration Date
One (1) year from the Effective Date
Agreement Authority
C.R.S. § 8-1-107, C.R.S. § 8-1-112.
Agreement Purpose
The purpose of the Agreement is for the Transferring Agency to provide Quarterly Census of Employment Wages "QCEW"
wage and employment data from Colorado employers to the Recipient.
Exhibits and Order of Precedence
The following Exhibits and attachments are included with this Agreement:
1. Exhibit A — PII Certification
In the event of a conflict or inconsistency between this Agreement and any Exhibit or attachment, such conflict or
inconsistency shall be resolved by reference to the documents in the following order of priority:
1. The main body of this Agreement.
2. Exhibit A, PII Certification
Principal Representatives
For the Transferring Agency: For the Recipient:
Michelle Morelli Mike Freeman, Chair, Board of County Commissioners, Weld
County, Colorado
Colorado Department of Labor and Employment Employment Services of Weld County
633 17th SL 315 North l lth Avenue
Suite 600 Building B
Denver, CO 80202 Greeley, CO 80631
Michelle.morelli@state.co.us bocc-contracts@co.weld.co.us
THE REMAINDER OF THIS PAGE IS INTENTIONALLY LEFT BLANK
DocuSign Envelope ID: 65B7979C-8C79-430A-A7D0-69F5F8CEE445
SIGNATURE PAGE
THE PARTIES HERETO HAVE EXECUTED THIS AGREEMENT
Each person signing this Contract represents and warrants that he or she is duly authorized to execute this Contract
and to bind the Party authorizing his or her signature.
RECIPIENT
Employment Services of Weld County
DocuSigned by:
Mitt, FSat,
By: Mike Freeman, Chair,Tocarcro7faiinty Commissioners,
Weld County, Colorado
3/10/2023
Date:
TRANSFERRING AGENCY
STATE OF COLORADO
Jared S. Polis, Governor
Colorado Department of Labor and Employment
Joe M. Barela, Executive Director
-MuuSigned by:
By: Darcy R. Kennedy, Deputy Executive Director
Colorado Division of Labor and Employment
3/12/2023
Date:
In accordance with §24-30-202, C.R.S., this Contract is not valid until signed and dated below by the State Controller or an
authorized delegate.
By:
STATE CONTROLLER
Robert Jaros, CPA, MBA, JD
DocuSigned by:
Du2A3 wv6�F ...
Paulina Debora, State ontrofler Delegate
Effective Date: 3/14/2023
THE REMAINDER OF THIS PAGE IS INTENTIONALLY LEFT BLANK
2
Data Sharing Agreement
This Data Sharing and License Agreement ("Agreement") is entered into by and between the State of
Colorado (the "State") acting by and through the Colorado Department of Labor and Employment
("Transferring Agency"), for the use and benefit of the Transferring Agency, having an address at 633
17th Street, Suite 600 Denver, CO 80202 and Employment Services of Weld County ("Recipient" or
"Organization"), whose principal office is located at 315 North 11th Avenue, Building B, Greeley, CO
80631. Transferring Agency and Recipient are each individually a "Party" and together the "Parties."
Whereas, Transferring Agency is an agent of the United States Bureau of Labor Statistics ("BLS") for the
purposes of collecting and securing Quarterly Census of Employment Wages ("QCEW") wage and
employment data from Colorado employers and is authorized to issue a non-exclusive license for this
information to public and non-public entities provided that the information is adequately secured from
non -authorized access or publication.
Whereas, Transferring Agency is charged with, among other duties, producing the QCEW report
mandated by BLS. The report summarizes employment, total wages, taxable wages, and contributions
information for approximately 205,000 employers subject to Colorado Unemployment Insurance laws
under the Colorado Employment Security Act, publishes a variety of reports about the Colorado
economy, and provides guidance and professional advice for other labor market information program
state operations and other data users. See C.R.S. § 8-1-107, C.R.S. § 8-1-112.
Whereas, Recipient is the One -Stop Operator and the American Job Center ("AJC") that serves business
and job seekers alike. Under the Workforce Innovation and Opportunity Act ("WIOA"), Recipient assists
the Workforce Development Board with the local plan, workforce research and regional labor market
analysis, employer engagement, among other roles.
Whereas, Recipient seeks to obtain State data from Transferring Agency to assist local businesses with
retention and expansion, providing data to ensure competitive employment and wages, which requires
access to expanded North American Industry Classification System ("NAICS") industry information. The
expanded information ensures that the regional/local plan identifies key industries in Weld County and
how Recipient will utilize Federal funding to provide education and training to job seekers and connect
them to businesses to ensure a thriving economy. While Recipient utilizes a variety of labor market
information tools, QCEW is the most comprehensive data allowing the AJC to provide quality customer
service to businesses.
Now, therefore, in consideration of the mutual promises contained herein, the sufficiency of which each
Party hereby acknowledges as adequate, the Parties agree as follows:
1. Defined Terms.
a) "Anonymized Data" means Data that has been properly De -identified.
b) "CIPSEA" means the Confidential Information Protection and Statistical Efficiency Act, 44
#U.S.C. ch. 35, subch. I § 3501, et seq., which protects identifiable information collected by
federal agencies for exclusively statistical purposes under a pledge of confidentiality. CIPSEA
requires informed consent to use or disclose protected information for non -statistical purposes.
Restricted non -statistical uses include "administrative, regulatory, law enforcement, adjudicatory,
or other purpose that affects the rights, privileges, or benefits of a particular identifiable" person
or organization as well as disclosures under the Freedom of Information Act. CIPSEA also
3
authorizes data sharing between the Bureau of the Census, the Bureau of Economic Analysis
("BEA"), and the BLS for statistical purposes.
c) "CORA" means the Colorado Open Records Act, § 24-72-200.1, et seq., C.R.S.
d) "Covered Entity" shall have the same meaning as the term "covered entity" at 45 C.F.R. 160.103.
e) "Data" means the information described in Appendix A.
f) "Data Breach" means an event resulting in an unauthorized access, use, exposure, disclosure,
exfiltration, or loss of Data.
g) "De -identified" means the removal of all PII from the Data so that the remaining information
does not identify an individual and there is no reasonable basis to believe that the information can
be used to identify an individual.
h) "Destroy" means to remove Data from Recipient's systems, paper files, records, databases, and
any other media regardless of format, in accordance with the standard detailed in the OIT
Security Policies.
i) "Incident" means an event that results in or constitutes an imminent threat of the unauthorized
access, use, loss, disclosure, modification, disruption, or destruction of communication and
information resources of the State.
j) "OIT" means the Governor's Office of Information Technology.
k) "OIT Security Policies" means the security policies established by OIT to secure information held
by State Agencies, which are available at: hops://oit.colorado.gov/standards-policies-
guides/technical-standards-policies.
1) "PII" means personally identifiable information, including information that can reasonably be
used to identify, contact or locate an individual, either alone or in combination with other
information.
2. Sharing of Data. Transferring Agency will share the Data with Recipient using a secure method
agreed to by the Parties and in accordance with the OIT Security Policies.
3. Data Use and Restrictions. Transferring Agency hereby grants Recipient a limited, revocable right
to use the Data solely for purposes defined in Section 4.g. below ("Purpose").
4. Disclosure to Third Parties. Recipient shall not sell, lease, rent, loan, transfer, distribute, alter, mine
or disclose the Data, including but not limited to, metadata and Anonymized Data, with any third
party without prior written consent from Transferring Agency.
a) Restrictions on Access. Recipient shall not disclose the Data to anyone other than Recipient's
personnel and contractors who have a need to know or access the Data in order to support the
Purpose.
b) Contractors. Recipient will not share the Data with any third parties without Transferring
Agency's prior written approval, which may be received by email. Recipient agrees that any
contractors or third parties that are authorized to access the Data must be subject to terms that are
as restrictive as the terms contained in this Agreement.
4
c) Data Security Requirements. Recipient agrees to secure and protect the Data against any
unauthorized use or access in accordance with the most recent version of the OIT Security
Policies.
d) Storage of Data. Recipient agrees to: (i) use, hold, and maintain the Data in compliance with any
and all applicable laws and regulations, (ii) store the Data only in facilities located within the
United States, and (iii) maintain the Data in a secure environment in accordance with the OIT
Security Policies.
e) Destruction of Data. Upon Transferring Agency's request, Recipient shall Destroy or return any
Data in its possession, pursuant to Transferring Agency's instructions, in accordance with OIT
Security Policies. Upon Transferring Agency's request, Recipient shall certify in writing that it
has Destroyed the Data within thirty (30) days of Recipient's receipt of Transferring Agency's
request.
f) Reservation of Rights. Except for the rights explicitly granted under this Agreement, Recipient
is not granted any rights in and to the Data, including, but not limited to any Anonymized Data.
Purpose - Research, Analytics and Published Materials. Recipient may use the Data to run
internal analytics and investigational protocols, and create reports for its internal use only, and
only to the extent such activities align with the Purpose. Prior to publishing, to the extent the
Purpose includes the need to publish materials that are based on or include the Data, Recipient
may publish and share the results of such research or analytics, provided that such reports include
only Anonymized Data and are given prior written approval by the Transferring Agency in order
to ensure that such publication meets the threshold for its suppression policies. The Parties may
also work together to publish joint reports, as well as publish Anonymized Data on public
dashboards. Furthermore, Recipient shall not publish, sell, or disclose the data, or any part
thereof, to the extent that the information published of any area, industry, Federal Department or
Federal Agency level contains fewer than three (3) reporting units (as defined in C.R.S. 8-70-
103(9), 1987 Rep. Vol., as amended), or eighty percent (80%) of the total employment of the
applicable reporting level is made up by a single reporting unit.
h) Linking Data to other Datasets. Transferring Agency agrees that Recipient may include the
Data with data from other sources in carrying out the Purpose. Once included, Transferring
Agency agrees that the Data will be integrated into Recipient's databases. Recipient agrees that
such combined datasets will treat and safeguard the Data in accordance with all applicable laws.
5. Security Incident and Data Breach.
a) Incident Response. If Recipient becomes aware of an Incident, Recipient shall use commercially
reasonable practices to fully investigate and resolve the Incident and take steps to prevent
developments that may result in the Incident becoming a Data Breach in accordance with all
applicable privacy and security laws.
b) Data Breach Response. Immediately upon becoming aware of a suspected or actual Data
Breach, Recipient shall: (i) notify Transferring Agency of the Data Breach in writing, (ii) start a
full investigation into the Data Breach, (iii) cooperate fully with Transferring Agency's
investigation of and response to the Data Breach, and (iv) use commercially reasonable efforts to
prevent any further Data Breach in accordance with applicable privacy and security laws. If
notification of the Data Breach is required pursuant to applicable law, Recipient shall coordinate
g)
5
with Transferring Agency in delivering such notifications and shall be responsible for all costs
associated with such notification. In the event the Parties determine that Recipient should deliver
the necessary notifications, Recipient shall obtain Transferring Agency's prior written approval of
the notifications prior to distributing such notifications.
c) Data Breach Report. If Transferring Agency reasonably determines that a Data Breach has
occurred, then Transferring Agency may request that Recipient submit a written report, and any
supporting documentation, identifying (i) the nature of the Data Breach including the dates of the
Data Breach, when Recipient discovered the Data Breach, and number of impacted individuals,
(ii) the steps Recipient has executed to investigate the Data Breach, (iii) what Data or PII was
used or disclosed, (iv) who or what was the cause of the Data Breach, (v) what Recipient has
done or shall do to remediate any deleterious effect of the Data Breach, and (vi) what corrective
action Recipient has taken or shall take to prevent a future Incident or Data Breach. Recipient
shall deliver the report within seven (7) days of Transferring Agency's request of the report. If the
Recipient learns of more information necessary for understanding the nature of the Data Breach,
risk to the Data, remediation efforts, or notification requirements after submitting the report,
Recipient shall update Transferring Agency without delay.
d) Effect of Data Breach. Transferring Agency may terminate this Agreement immediately, at its
sole discretion, upon the occurrence of a Data Breach. In addition, Transferring Agency may
restrict Recipient's access to the Data and require Recipient to suspend all work involving the
Data, pending the investigation and successful resolution of any Data Breach.
e) Liability for Data Breach. Without limiting any other remedies Transferring Agency may have
under law or equity, Recipient shall reimburse Transferring Agency in full for all costs, including
but not limited to, payment of legal fees, audit costs, fines, and other imposed fees arising out of
or relating to a Data Breach that Transferring Agency actually incurs. All responsibilities of
Recipient under this Section 5 shall be completed by Recipient at Recipient's sole cost, without
any right of reimbursement, set-off, payment, or remuneration of any kind from Transferring
Agency.
6. Term and Termination.
a) The "Term" of this Agreement shall be one (1) year from the Effective Date set forth on the
Signature Page unless terminated sooner pursuant to the terms herein. At the end of the Term, this
Agreement shall automatically renew for additional one (1) year periods for up to five (5) years
unless either Party provides the other Party with written notice of its intent to terminate this
Agreement sixty (60) days prior to expiration of the then -current Term.
b) Transferring Agency may suspend its performance or terminate this Agreement immediately
upon written notice to Recipient in the event of Recipient's breach of any of its obligations under
Sections 3 or 4. Transferring Agency may cancel this Agreement upon thirty (30) days' written
notice to the other Party for any reason or no reason. In the event that this Agreement is canceled
or terminated, any data in the possession of or accessible to Recipient, in whatever format it may
be stored, accessed or maintained, shall remain subject to the terms and conditions of this
Agreement.
7. Financial Understanding
6
a) Recipient shall pay the total non-refundable payment due within thirty (30) days of receipt of the
information. If payment is not received by the Transferring Agency during this period, the
Transferring Agency shall invoice the Recipient, and Recipient shall immediately pay, the total
amount specified in this Section 7 plus a billing fee calculated at the greater of eighteen percent
per annum of the total amount due or twenty-five and no/100 dollars ($25.00). If the fee is not
paid within the above specified time, Recipient shall immediately return all data to the
Transferring Agency and the Transferring Agency reserves the right to prohibit the receipt of
future data until the balance is paid in full.
b) Data Provided:
Report Description
Report Period
Amount
TOTAL AMOUNT DUE
WITHIN 30 -DAYS OF
INVOICE RECEIPT
*ALL FEES ARE NON-
REFUNDABLE
$0.00
c) Data Requests and Invoicing. Recipient shall submit each Data Request by sending an email to
cdle_gcew_datarequests@state.co.us. Requests must be received at least 7 calendar days before a
QCEW Data Release Date and contain which quarter(s) of data are being requested, which
county(ies) are being requested, and at least two email addresses of where the data are to be sent.
QCEW Data Release Dates can be found on the LMI Gateway website:
https://www.colmigateway.com/. Transferring Agency will send Recipient a link to the Data via
email. Recipient must promptly download and save Data. Recipient may submit an unlimited
number of Data Requests during the term of this Agreement. Transferring Agency will invoice
Recipient separately for each Data Request in the amount of $230.00. Transferring Agency will
invoice Recipient for each Data Request after transmission of the Data.
d) Payment. Recipient shall submit payment of each invoice within 30 days of invoice receipt in
accordance with the instructions provided on the invoice.
8. Dispute Resolution. In the event of a dispute related to this Agreement, the Parties' Executive
Directors shall have ten (10) business days to resolve the dispute. If this fails, both Parties shall
submit the matter in writing to the Executive Director of the Department of Personnel and
Administration, or their delegate for final resolution. The Parties agree to engage in this process if
either Party loses funding to transfer or process the Data in accordance with this Agreement in order
to determine how cost should be covered or if this Agreement should be terminated prior to the
expiration of the Term.
9. General Provisions.
a) Amendment. The Parties may only amend this Agreement in a writing signed by both Parties.
b) Assignment. Recipient's rights and obligations under this Agreement are personal and Recipient
may not transfer or assign its rights without Transferring Agency's prior, written consent. Any of
Recipient's attempts at assignment or transfer without such consent shall be void. If Transferring
Agency approves any assignment or transfer of Recipient's rights and obligations, this Agreement
will continue to govern such rights and obligations.
7
c) Counterparts. The Parties may execute this Agreement in multiple, identical, or original
counterparts, each of which shall be deemed to be an original, but all of which, taken together,
shall constitute one and the same agreement.
d) Entire Understanding. This Agreement, including, but not limited to, the recitals, which are
incorporated into this Agreement by reference, represents the complete integration of all
understandings between the Parties related to the data sharing. All prior representations and
understandings related to the data sharing, oral or written, are merged into this Agreement. Prior
or contemporaneous additions, deletions, or other changes to this Agreement shall not have any
force or effect whatsoever, unless embodied herein.
e) Severability. The invalidity or unenforceability of any provision of this Agreement shall not
affect the validity or enforceability of any other provision of this Agreement, which shall remain
in full force and effect, provided that the Parties can continue to perform their obligations under
this Agreement in accordance with the intent of this Agreement.
f) Survival. Sections 1, 3, 4, 6 and 7 of this Agreement, as well as any other provisions that by their
nature should survive, shall survive any termination of this Agreement.
Waiver. A Party's failure or delay in exercising any right, power, or privilege under this
Agreement, whether explicit or by lack of enforcement, shall not operate as a waiver, nor shall
any single or partial exercise of any right, power, or privilege preclude any other or further
exercise of such right, power, or privilege.
h) Legal Requests. Transferring Agency acknowledges and agrees that Recipient, or its contractors,
may be required to share the Data to respond to a subpoena, court order, open records request or
valid legal request (each a "Legal Request"). To the extent permitted by law, Recipient will refer
the Legal Request to Transferring Agency of any disclosure of the Data so that Transferring
Agency may seek a protective order at its own cost.
i) CORA. The Parties agree to coordinate if either agency receives a CORA request for data that is
subject to this Agreement. CORA requests are time sensitive and must be referred to the Parties
within one (1) business day to meet statutory open records requirements. To the extent not
prohibited by applicable law, this Agreement may be subject to public release through CORA.
Any data requested through a CORA request that is otherwise protected under CIPSEA shall be
protected and not open to release.
Third -Party Beneficiaries. No third party shall be able to enforce or have the benefit of any of
the provisions of this Agreement.
k) Consents and Compliance with Law. Each Party shall comply with (i) all applicable federal and
State laws, rules, and regulations, that apply to their obligations under the Agreement
(collectively, "Laws"); and (ii) shall obtain all necessary consents to transfer and use the Data for
the Purpose in accordance with such Laws. In the event a consent is revoked by an individual in
accordance with applicable Laws, the Party that receives the revocation of consent will
immediately notify the other Party of the revocation of consent. Upon receipt of a revocation of
consent, Recipient shall Destroy and cease using the Data associated with that consent from the
date Recipient receives the notice of revocation.
g)
j)
8
Appendix A
DATA TO BE SHARED
Data to be Shared
The normal data record provides all data elements available on the State's micro file for the specified
Unemployment Insurance (UI) Account Number/Reporting Unit Number (RUN) for that year and
quarter. A delete record is a special type of data record that removes all data for the specified
UI/RUN for all years and quarters. DATA ELEMENT DEFINITIONS define the data elements. A
complete Equi Database Dictionary will be provided to the Recipient upon execution of this
Agreement.
Start
End
Length
Field
Type
Data Element
1
1
1
Adm
Transaction Code
2
3
2
Adm
State FIPS Numeric Code
4
7
4
Qtr
Year
8
8
1
Qtr
Quarter
9
18
10
Adm
UI Account Number
19
23
5
Adm
Reporting Unit Number
24
32
9
Adm
EIN (Employer Identification Number)
33
42
10
—
Filler 1 (Predecessor UI Account Number)
9
43
47
5
—
Filler 2 (Predecessor Reporting Unit Number)
48
57
10
—
Filler 3 (Successor UI Account Number)
58
62
5
—
Filler 4 (Successor Reporting Unit Number)
63
97
35
Adm
Legal/Corporate Name
98
132
35
Adm
Trade Name/DBA
U/ Address Block (133-243)
133
167
35
Adm
UI Street Address --Line 1
168
202
35
Adm
UI Street Address --Line 2
203
232
30
Adm
UI Address -City
233
234
2
Adm
UI Address -State
235
239
5
Adm
UI Address--5-Digit ZIP Code
240
243
4
Adm
UI Address --ZIP Code Extension
10
Physical Location Address Block (244-354)
244
278
35
Adm
Physical Location (PLA) Street Address --Line 1
279
313
35
Adm
Physical Location (PLA) Street Address --Line 2
314
343
30
Adm
Physical Location Address (PLA)--City
344
345
2
Adm
Physical Location Address (PLA)--State
346
350
5
Adm
Physical Location Address (PLA)--5-Digit ZIP Code
351
354
4
Adm
Physical Location Address (PLA)--ZIP Code Extension
Mailing/Other Address Block (355-466)
355
389
35
Adm
Mailing/Other (MOA) Street Address --Line 1
390
424
35
Adm
Mailing/Other (MOA) Street Address --Line 2
425
454
30
Adm
Mailing/Other (MOA) Address --City
11
455
456
2
Adm
Mailing/Other (MOA) Address --State
457
461
5
Adm
Mailing/Other (MOA) Address--5-Digit ZIP Code
462
465
4
Adm
Mailing/Other (MOA) Address --ZIP Code Extension
466
466
1
Adm
Mailing/Other (MOA) Address Type
467
501
35
Adm
Reporting Unit Description
Telephone Number (502-511)
502
504
3
Adm
Phone Area Code
505
507
3
Adm
Phone Prefix
508
511
4
Adm
Phone Suffix
Setup Date (512-519)
12
512
515
4
Adm
Setup Date —Year
516
517
2
Adm
Setup Date —Month
518
519
2
Adm
Setup Date —Day
Initial Date of Liability (520-527)
520
523
4
Adm
Initial Date of Liability --Year
524
525
2
Adm
Initial Date of Liability --Month
526
527
2
Adm
Initial Date of Liability --Day
End of Liability Date (528-535)
528
531
4
Adm
End of Liability Date —Year
532
533
2
Adm
End of Liability Date —Month
534
535
2
Adm
End of Liability Date —Day
13
Reactivation Date (536-543)
536
539
4
Adm
Reactivation Date --Year
540
541
2
Adm
Reactivation Date --Month
542
543
2
Adm
Reactivation Date --Day
544
544
1
Qtr
Status Code
545
545
1
Adm
CES Indicator
546
547
2
Adm
ARS Response Code
548
551
4
Adm
ARS Refile Year
552
554
3
Adm
Old County Code
555
555
1
Adm
Old Ownership Code
556
559
4
Adm
ARS Verification Year
14
560
562
3
Adm
Old Township Code
563
567
5
Adm
Maximum Reporting Unit Number
568
568
1
Adm
MWR Mail Indicator
569
574
6
Adm
Old NAICS Code
575
575
1
Qtr
Data Source
576
576
1
QAdm
Special Indicator Code
577
580
4
Qtr
Agent Code
581
584
4
Qtr
SIC
585
590
6
Qtr
NAICS02 Code
591
596
6
Qtr
NAICS Code
597
597
1
Qtr
Ownership Code
598
598
1
Adm
Organization Type Code
599
601
3
Qtr
County Code
15
602
604
3
Qtr
Township Code
605
605
1
—
Filler
606
611
6
Qtr
First Month Employment
612
612
1
Qtr
First Month Employment Indicator
613
618
6
Qtr
Second Month Employment
619
619
1
Qtr
Second Month Employment Indicator
620
625
6
Qtr
Third Month Employment
626
626
1
Qtr
Third Month Employment Indicator
627
637
11
Qtr
Total Wages
638
638
1
Qtr
Total Wages Indicator
639
649
11
Qtr
Taxable Wages
650
658
9
Qtr
Contributions (Due)
659
659
1
Qtr
Type of Coverage Code
16
660
660
1
Qtr
MEEI Code
661
661
1
Adm
PLA Type Code
662
663
2
Qtr
First Comment Code
664
665
2
Qtr
Second Comment Code
666
667
2
Qtr
Third Comment Code
668
724
57
Qtr
Narrative Comment
725
726
2
Adm
Collection Mode Indicator
727
728
2
Qtr
ECCI
729
729
1
Adm
UI Address Type Code
730
737
8
Adm
Date PLA Changed
738
738
1
Adm
Geocoding Software
739
739
1
Adm
Geocoding Source
740
743
4
Adm
Match Code
17
744
746
3
Twice
Location Code
747
755
9
Twice
Latitude
756
766
11
Twice
Longitude
767
771
5
Twice
Year and Quarter of New Latitude and Longitude
772
776
5
Qtr
Place Code
777
778
2
Qtr
Class Code
779
793
15
Qtr
Census ID:
2 digit State code
3 digit County code
6 digit Census Tract
1 digit Census Block Group
2 digit Census Block Code
1 digit optional Block Code letter
794
797
4
—
Filler
798
798
1
Adm
Address Source Code
18
Nondisclosure/Informed Consent (799-807)
799
799
1
Adm
Nondisclosure/Informed Consent Code
800
803
4
Adm
Nondisclosure/Informed Consent Year Agreed
804
807
4
Adm
Nondisclosure/Informed Consent Year Ended
Future QCEW Contact Block (808-827)
808
811
4
Adm
Future ARS Refile Year
812
813
2
Adm
Future ARS Response Code
814
819
6
Adm
Future NAICS Code
820
822
3
Adm
Future County Code
823
825
3
Adm
Future Town Code
826
827
2
Adm
Future CMI Code
19
Wage Record Summary Information (828-844)
828
833
6
Qtr
Wage Record Count of Unique SSNs
834
844
11
Qtr
Wage Record Wages
845
849
5
Adm
Phone Extension
QCEW Contact Block (850-1049)
850
884
35
Adm
QCEW Contact (Attention Line)
885
919
35
Adm
QCEW Contact Title
920
979
60
Adm
QCEW Contact Email Address
980
989
10
Adm
QCEW Contact Fax
990
1049
60
Adm
Website Address
I
20
1050
1050
1
—
Future Use
1051
1060
10
Qtr
Largest Wage Record Recepient—Possible or Actual
Successor
1061
1066
6
Qtr
Wage Record Count to Largest Wage Record Recepient
1067
1076
10
Qtr
Largest Wage Record Contributor —Possible or Actual
Predecessor
1077
1082
6
Qtr
Wage Record Count from Largest Wage Record Contributor
1083
1088
6
Qtr
Hires
1089
1094
6
Qtr
Separations
1095
1100
6
Qtr
"New Entrants"
1101
1106
6
Qtr
"Exits"
1107
1112
6
Qtr
"Continuous Employees"
Discrepancy Information (1113-1190)
21
1113
1116
4
Adm
Fact of Discrepancy Year
1117
1118
2
Adm
Fact of Discrepancy Month
1119
1120
2
Adm
Fact of Discrepancy Control/Action Code
1121
1126
6
Adm
Fact of Discrepancy NAICS
1127
1129
3
Adm
Fact of Discrepancy County
1130
1186
57
Adm
Fact of Discrepancy Explanation
1187
1190
4
—
Filler/Future Field
TABLE FIELDS
Field Name
Field Description
TRANSCODE
Transaction Code
STATE_FIPS
State FIPS Numeric Code
YEAR
Year
QUARTER
Quarter
22
UI_ACCT_NUM
UI Account Number
RUN
Reporting Unit Number
EIN
EIN (Employer Identification Number)
FILLER1
Filler (Pred UI Account Number)
FILLER2
Filler (Pred Reporting Unit Number)
FILLER3
Filler (Succ UI Account Number)
FILLER4
Filler (Succ Reporting Unit Number)
LGLNM
Legal/Corporate Name
TRDNM
Trade Name/DBA
UI Address Block (133-243)
Ul_ADD1
UI Street Address --Line 1
UI ADD2
UI Street Address --Line 2
23
UI_CITY
UI Address —City
UI_STATE
UI Address —State
UI_ZIP
UI Address--5-Digit ZIP Code
UI_ZIP_EXT
UI Address --ZIP Code Extension
Physical Location Address Block (244-354)
PL_ADD1
Physical Location (PLA) Street Address --Line 1
PL_ADD2
Physical Location (PLA) Street Address --Line 2
PL_CITY
Physical Location Address (PLA)--City
PLA_STATE
Physical Location Address (PLA)--State
PLA_ZIP
Physical Location Address (PLA)--5-Digit ZIP Code
PLA_ZIP_EXT
Physical Location Address (PLA)--ZIP Code Extension
24
Mailing/Other Address Block (355-466)
MOA_ADD1
Mailing/Other (MOA) Street Address --Line 1
MOA_ADD2
Mailing/Other (MOA) Street Address --Line 2
MOA_CITY
Mailing/Other (MOA) Address --City
MOA_STATE
Mailing/Other (MOA) Address --State
MOA_ZIP
Mailing/Other (MOA) Address--5-Digit ZIP Code
MOA_ZIP_EXT
Mailing/Other (MOA) Address --ZIP Code Extension
MO_ADD_TYPE
Mailing/Other (MOA) Address Type
RUD
Reporting Unit Description
Telephone Number (502-511)
PH_AREA_CODE
Phone Area Code
25
PH_PREFIX
Phone Prefix
PH_SUFFIX
Phone Suffix
Setup Date (512-519)
SETUP_YEAR
Setup Date —Year
SETUP_MONTH
Setup Date —Month
SETUP_DAY
Setup Date —Day
Initial Date of Liability (520-527)
LIAB_YEAR
Initial Date of Liability --Year
LIAB_MONTH
Initial Date of Liability --Month
LIAB_DAY
Initial Date of Liability --Day
26
End of Liability Date (528-535)
EOL_YEAR
End of Liability Date —Year
EOL_MONTH
End of Liability Date —Month
EOL_DAY
End of Liability Date —Day
Reactivation Date (536-543)
REACT_YEAR
Reactivation Date --Year
REACT_MONTH
Reactivation Date --Month
REACT_DAY
Reactivation Date --Day
STATUS_CODE
Status Code
CES_IND
CES Indicator
ARS_CODE
ARS Response Code
27
ARS_RYEAR
ARS Refile Year
OCNTY
Old County Code
OOWN
Old Ownership Code
ARS_VYEAR
ARS Verification Year
OTOWN
Old Township Code
MAXRU
Maximum Reporting Unit Number
MWR_MAIL_IND
MWR Mail Indicator
ONAICS
Old NAICS Code
DATASO
Data Source
SPEC_IND
Special Indicator Code
AGENT
Agent Code
SIC
SIC
NAICS02
NAICS02 Code
28
NAICS
NAICS Code
OWN_CODE
Ownership Code
ORG_TYPE
Organization Type Code
CNTY
County Code
TOWN_CODE
Township Code
FILLER 5
Filler
M1 EMP
First Month Employment
M1EMP_IND
First Month Employment Indicator
M2EMP
Second Month Employment
M2EMP_IND
Second Month Employment Indicator
M3EMP
Third Month Employment
M3EMP_IND
Third Month Employment Indicator
TOTAL_WAGES
Total Wages
29
TOTAL_WAGES_IND
Total Wages Indicator
TAX_WAGES
Taxable Wages
CNTRB
Contributions (Due)
CVRG-CODE
Type of Coverage Code
MEEI
MEET Code
PLA_TYPE_CODE
PLA Type Code
CMNT1
First Comment Code
CMNT2
Second Comment Code
CMNT3
Third Comment Code
COM_NARR
Narrative Comment
CMI
Collection Mode Indicator
ECCI
ECCI
UI ADDR_IND
UI Address Type Code
30
PL-DATE_CHNG
Date PLA Changed
GEOSOFT
Geocoding Software
GEOSOURCE
Geocoding Source
MATCH_CODE
Match Code
LOCCODE
Location Code
LATITUDE
Latitude
LONGITUDE
Longitude
LTLNGYRQTR
Year and Quarter of New Latitude and Longitude
PLACE_CODE
Place Code
PLACE_CLASS_CODE
Class Code
CENSUS_BLCK
Census ID:
2 digit State code
3 digit County code
31
6 digit Census Tract
1 digit Census Block Group
2 digit Census Block Code
1 digit optional Block Code letter
FILLER6
Filler
ADD_SOURCE
Address Source Code
Nondisclosure/Informed Consent (799-807)
ICCD
Nondisclosure/Informed Consent Code
ICST
Nondisclosure/Informed Consent Year Agreed
ICEND
Nondisclosure/Informed Consent Year Ended
Future QCEW Contact Block (808-827)
32
F_ARS_REF_YEAR
Future ARS Refile Year
F_RES_CODE
Future ARS Response Code
F_NAICS_CODE
Future NAICS Code
F_CNTY_CODE
Future County Code
F_TOWN_CODE
Future Town Code
F_CMI_CODE
Future CMI Code
Wage Record Summary Information (828-844)
WRC
Wage Record Count of Unique SSNs
WRW
Wage Record Wages
PHN_EXT
Phone Extension
33
QCEW Contact Block (850-1049)
CONTACT_NAME
QCEW Contact (Attention Line)
CONTACT_TITLE
QCEW Contact Title
CONTACT_EMAIL
QCEW Contact Email Address
CONTACT_FAX
QCEW Contact Fax
CONTACT_WEB
Website Address
FILLER7
Future Use
LWRR_UI
Largest Wage Record Recepient—Possible or Actual Successor
LWRR
Wage Record Count to Largest Wage Record Recepient
LWRC_UI
Largest Wage Record Contributor —Possible or Actual Predecessor
LWRC
Wage Record Count from Largest Wage Record Contributor
HIRES
Hires
34
SEPARATE
Separations
ENTRANTS
"New Entrants"
EXITS
"Exits"
CONT_EMPL
"Continuous Employees"
Discrepancy Information (1113-1190)
FOD_YEAR
Fact of Discrepancy Year
FOD_MONTH
Fact of Discrepancy Month
FOD_CAC
Fact of Discrepancy Control/Action Code
FOD_NAICS
Fact of Discrepancy NAICS
FOD_CNTY
Fact of Discrepancy County
FOD_EXPLN
Fact of Discrepancy Explanation
FILLER8
Filler/Future Field
35
Authorized Personnel and Contractors
N/A
36
DocuSign Envelope ID: 65B7979C-8C79-430A-A7D0-69F5F8CEE445
Exhibit A
STATE OF COLORADO
THIRD PARTY ENTITY / ORGANIZATION CERTIFICATION FOR ACCESS
TO PII THROUGH A DATABASE OR AUTOMATED NETWORK
Mike Freeman
Pursuant to § 24-74-105, C.R.S., I, , on behalf of
County of weld, Colorado (legal name of entity / organization) (the
"Organization"), hereby certify under the penalty of perjury that the Organization
has not and will not use or disclose any Personal Identifying Information, as defined
by § 24-74-102(1), C.R.S., for the purpose of investigating for, participating in,
cooperating with, or assisting Federal Immigration Enforcement, including the
enforcement of civil immigration laws, and the Illegal Immigration and Immigrant
Responsibility Act, which is codified at 8 U.S.C. §§ 1325 and 1326, unless required to
do so to comply with Federal or State law, or to comply with a court -issued subpoena,
warrant or order.
I hereby represent and certify that I have full legal authority to execute this
certification on behalf of the Organization.
DocuSigned b,
Signature:
rhitt, Fv,ain,
g
C74DBBEIO.B.At.-.
Mike Freeman
Printed Name:
Title:
Chair
Date: 3/10/2023
Contract Form
New Corr
Ent
Re+
Entity Name* Entity ID
COLORADO DEPARTMENT OF LABOR & W00010497
EMPLOYMENT
Contract Name*
QUARTERLY CENSUS OF EMPLOYMENT WAGES (QCEW)
LICENSE AGREEMENT
Contract Status
CTB REVIEW
❑ New Entity?
Contract ID
6712
Contract Lead*
COBBXXLK
Contract Lead Email
cobbxxlk@co.weld.co.us
Parent Contract ID
Requires Board Approval
YES
Department Project #
Contract Description
LICENSE AGREEMENT FOR QUARTERLY CENSUS OF EMPLOYMENT WAGES (QCEW) WITH EMPLOYMENT SERVICES. THERE IS NO
COST ASSOCIATED WITH THE AGREEMENT. TERM: FROM EFFECTIVE DATE FOR ONE YEAR - AUTO RENEWAL YEARLY FOR UP
TO FIVE YEARS.
Contract Description 2
PA ROUTING THROUGH NORMAL APPROVAL PROCESS. ETA TO CTB 3,2/23.
Contract Type*
AGREEMENT
Amount.
$0.00
Renewabl
YES
Automatic Renewal
Grant
Department Requested BOCC Agenda Due Date
HUMAN SERVICES Date* 03/04,2023
03,0812023
Department Email
CM-
HumanServices@weldgov.co
m
meat Head Email
CM-HumanServices-
DeptHead Wsonldgoo.com
County Attorney
GENERAL COUNTY
ATTORNEY EMAIL
County Attorney Email
CM-
COUNTYATTORNEY LDG
OV.COM
Will a work sessi
NO
required?*
Does Contract require Purchasing Dept. to be included?
If this is a renewal enter previous Contract ID
If this is part of a MA enter MSA Contract ID
Note: the Previous Contract Number and Master Services Agreement Number should be left blank if those contracts are not in
OnBase
Effective Date
Review Date*
01?'08/2024
Renewal Date*
03;08/2024
Termination Notice Period
Purchasing Approved Date
Appro
Prr
Department Head
JAMIE ULRICH
DH Approved Date
03/02!2023
Fine! Approvral
BOCC Approved
BOCC Signed Date
Agenda Date
x`2023
Originator
COBBX?CLK
Committed Delivery Date
Finance Approver
CHERYL PATTELLI
Finance Approved Date
03/06/2023
Tyler Ref #
AG 030823
Expiration Date
Legal Counsel
BRUCE BARKER
Legal Counsel Approved Date
03;06?2023
Cheryl Hoffman
From:
Sent:
To:
Subject:
noreply@weldgov.com
Thursday, January 11, 2024 7:45 AM
CM-ClerktoBoard; Lesley Cobb; CM-HumanServices-DeptHead
Fast Tracked Contract ID (7757)
Contract # 7757 has been Fast Tracked to CM -Contract Maintenance.
You will be notified in the future based on the Contract information below:
Entity Name: COLORADO DEPARTMENT OF LABOR & EMPLOYMENT Contract Name: QUARTERLY CENSUS OF
EMPLOYMENT WAGES (QCEW) LICENSE AGREEMENT Contract Amount: $0.00 Contract ID: 7757 Contract Lead:
COBBXXLK
BXX LK
Department: HUMAN SERVICES
Review Date: 1/14/2025
Renewable Contract: YES
Renew Date: 3/14/2025
Expiration Date:
Tyler Ref #:
Thank -you
/./) t7757.
1
02902&-• s‘ler
/dPp0 9a�
Cheryl Hoffman
From:
Sent:
To:
Cc:
Subject:
Attachments:
Good morning CTB,
FAST TRACK ITEM:
Lesley Cobb
Thursday, January 11, 2024 7:32 AM
CTB
HS -Contract Management
FAST TRACK - CMS# 7757 Quarterly Census of Employment Wages (QCEW) License Agreement
LMI QCEW Data Sharing Agreement (e).pdf
Attached please find the Quarterly Census of Employment Wages (QCEW) License Agreement (Tyler ID# 2023-
0661). This agreement is good for five years and auto renews each year. After review, Employment Services has
confirmed no changes are needed to the agreement and it is still valid. This is reviewed on a yearly basis. This will be a
Fast Track item in CMS for tracking purposes only (CMS# 7757).
Thank you,
Lesley Cobb
Contract Management and Compliance Supervisor
Weld County Dept. of Human Services
315 N. 11th Ave., Bldg A
PO Box A
Greeley, CO 80632
S(970) 400-6512
* (970) 353-5212
cobbxxlk(c�iweld.gov
Confidentiality Notice: This electronic transmission and any attached documents or other writings are intended only for the
person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you
have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure,
copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the
named recipient is strictly prohibited.
1
Houstan Aragon
From:
Sent:
To:
Subject:
noreply@weldgov.com
Monday, January 27, 2025 11:30 AM
CM-ClerktoBoard; Windy Luna; Lesley Cobb; CM-Human5ervices-DeptHead
Fast Tracked Contract ID (9057)
Contract # 9057 has been Fast Tracked to CM -Contract Maintenance.
You will be notified in the future based on the Contract information below:
Entity Name: COLORADO DEPARTMENT OF LABOR & EMPLOYMENT Contract Name: QUARTERLY
CENSUS OF EMPLOYMENT WAGES (QCEW) LICENSE AGREEMENT Contract Amount: $0.00 Contract ID:
9057 Contract Lead: WLUNA
Department: HUMAN SERVICES e,vrivack 11)4-905i
^I' Rev•ewed
Review Date: 1/14/2026-�—
Renewable Contract: YES
Renew Date: 3/14/2026
Expiration Date:
Tyler Ref #: 20230661
Thank -you
2023—Mol
H 420M5
Houstan Aragon
From:
Sent:
To:
Cc:
Subject:
Attachments:
Good morning CTB,
Windy Luna
Monday, January 27, 2025 11:27 AM
CTB
HS -Contract Management
COMMUNICATION ITEM- FAST TRACK ITEM: QCEW License Agreement (Tyler ID#
2023-0661) (CMS# 9057)
LMI QCEW Data Sharing Agreement (e).pdf; ES No Changes.pdf
FAST TRACK ITEM:
Attached please find the Quarterly Census of Employment Wages (QCEW) License Agreement (Tyler
ID# 2023-0661). This agreement is good for five years and auto renews each year. After review,
Employment Services has confirmed no changes are needed to the agreement and it is still
valid. This is reviewed on a yearly basis. This will be a Fast Track item in CMS for tracking purposes
only (CMS# 9057). This Agreement expires on 3/14/2028.
Thank you!
Windy Luna
Contract Administrative Coordinator
Weld County Dept. of Human Services
Contract Management Team
315 N. 11th Ave., Bldg A
PO Box A
Greeley, CO 80632
(970) 400-6544
wlunaaweld.dov
Confidentiality Notice: This electronic transmission and any attached documents or other writings are intended only
for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from
disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the
communication. Any disclosure, copying, distribution or the taking of any action concerning the contents of this communication or any
attachments by anyone other than the named recipient is strictly prohibited.
Hello