HomeMy WebLinkAboutResolutions - 2020.07.02 - 33394MISCELLANEOUS RESOLUTION #20231 July 2, 2020
BY: Commissioner Penny Luebs, Chairperson, Health, Satety and Human Services Committee
IN RE: PUBLIC SERVICESICOMMUNITY CORRECTIONS DIVISION - AUTHORIZATION OF THE
CRIMINAL JUSTICE ADMINISTRATIVE RECORDS SYSTEM PROJECT (CJARS) DATA TRANSFER
AGREEMENT
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS the Criminal Justice Administrative Records System Project ("CJARS") was established at the
University of Michigan to improve public administration of the criminal justice system in the United States by
collecting criminal justice administrative data from state and local agencies, including arrest records, court
proceedings, incarceration records, and other sanction files; and
WHEREAS the State of Michigan lacks criminal justice data consolidation and systems as it relates to
following criminal episodes from arrest to final resolution; and
WHEREAS the lack of this historical data is an obstacle in evaluating programming and case outcomes,
and
WHEREAS the University of Michigan and the US Census Bureau have developed a partnership where
data can be linked with survey and administrative records from many social and economic domains, and
WHEREAS entities that submit data receive reports using this linked data to determine different measures
of recidivism as well as non -criminal justice outcomes such as employment and educational achievement;
and
WHEREAS the Michigan Department of Corrections and the State Court Administrator's Office have
already supplied the CJARS project with data, and
WHEREAS the County's Community Corrections Division has data that may be useful to the CJARS project
and is interested in sharing data with the University of Michigan to use for the CJARS project; and
WHEREAS by providing specified data of the County's Community Corrections Division to the CJARS
project, the County's Community Corrections Division will receive reports from the CJARS project that will
provide the County with a better understanding of the County's offender population, the efficacy of our
programs and gaps in services and programming, and
WHEREAS the University of Michigan will work with the County to develop new views of the data to meet
specific requirements and will determine where data is missing or inconsistent in order to increase the
usability of the data, and
WHEREAS the statistical reports are aggregated and will not show individual level reporting thereby
protecting personally identifying information (1311), and
WHEREAS the University of Michigan, through the CJARS project, will pay the County's cost of data
extraction and other related costs; and
WHEREAS the Community Corrections Division and Department of Information Technology, with the
assistance of Corporation Counsel, has negotiated the attached Data Transfer Agreement with the
University of Michigan regarding the CJARS project; and
WHEREAS the Community Corrections Division and Department of Information Technology recommends
approval of the attached Data Transfer Agreement with the University of Michigan regarding the CJARS
project.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners hereby approves
the attached Data Transfer Agreement with the University of Michigan regarding the CJARS project and
authorizes the Chairperson of the Board of Commissioners to execute the agreement with the University of
Michigan.
BE IT FURTHER RESOLVED that a copy of such signed agreement shall be provided to the Elections
Division of the Oakland County Clerk for transmission to the Office of the Great Seal of Michigan.
BE IT FURTHER RESOLVED that no budget amendment is recommended at this time.
HEALTH, SAFETY AND HUMAN SERVICES COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Miller absent.
Chairperson, on behalf of the Health, Safety and Human Services Committee, I move the adoption of the
foregoing resolution. 11, j
Commissioner Penny Luebs, District #16
Chairperson, Health, Safety and Human
Services Committee
THE CRIMINAL .1USTIC'E ADMINISTRATIVE RECORDS SYS'T'EM PROJECT
(CJARS)
DATA TRANSFER AGREEMENT
This Transfer Agreement ("Agreement") is made by and between the County of Oakland,
Michigan, by and through its Conuntmity Corrections Division ("Transferor"), and the Regents
of the University of Michigan, a Michigan Constitutional corporation ("Michigan"). Throughout
this Agreement, Transferor and Michigan are individually referred to as "Party" and collectively
as "Parties."
A. BACKGROUND
The Criminal Justice Adm inistralive Records System project ('('JARS") was established at the
University of Michigan to improve public administration of the criminal justice system in the
United States by collecting criminal justice administrative data from stale and local agencies,
including arrest records, court proceedings. incarceration records, and other sanction Files ("Data").
Michigan will make the Data available to the U.S. Census Bureau ("Census Bureau") to enable
the Data to he linked to confidential employment, program participation, and survey records held
at the U.S. Census Bureau in order to create an integrated de -identified dataset that follows each
oflenderthrough each criminal episode,from arrest throughexit hromthe criminal justice system
("CJARS Database").
In consideration of the mutual promises below, the undersigned parties agree as follows:
B. SCOPE OF AGREEMENT
'Chis Agreement sets the terms and conditions by which Transferor will transfer the Data
described in Exhibit A to Michigan and Michigan's obligations and rights to receive, process,
use, and distribute the Data for research purposes.
C. TRANSFEROR OBLIGATIONS
Transferor agrees:
I . Any Data provided to Michigan by Transferor were, to the best of Transferor's knowledge
and belief, collected pursuant to and in accordance with any applicable lows, regulations and
policies.
?. To provide the Data, as applicable, to Michigan, in accordance with mutually agreed
specifications as articulated in Exhibit A.
3. That Transferor has the authority to make the Data available to Michigan and hereby grants
Michigan explicit permission to:
a. Integrate the Data with data From other Sources and from the Census Bureau lar research
purposes.
b, link the Data to public and restricted clata sources for the purposes of report production;
including reports to Transieror on the composition and outcomes of your caseload.
Details shall include standardized criminaljustice measures, like recidivism, defined as
re -arrest, re -charge, re -conviction, and re -incarceration over a one (I ), three (3) and live
(5) year follow-up period (lo the extent permitted by data limitations), as well as non-
justice metrics such as employment and other labor market activity, family status, and
participation in government programs;
c. Make the CJARS Database available to individuals who are given Special Sworn Statrl5,
as defined by the Census Bureau Research Data Center Researcher Handbook and
authorized by Title 13 U.S.C. 23(c), by the US government; and
d. Use the Data for research purposes and publish the results of the research, provided no
personally identifiable data is disclosed or any "Transferor specific data, orjudicial officer
specific data, if such are substantially likely to lead to identification of the Transteror or
judicial officer without Transferor's and CJARS' prior written consent to such research
project proposal, is disclosed in any publication; and
e. Atter obtaining the express written permission from Transferor, make processed data
from Data of Transferor, which shall not include Pit as defined below, available to other
data providers from the Slate of Michigan pursuant to an agreement at least as restrictive
as the obligations of this Agreement and provided the other data providers from the State
of Michigan are under the same obligation.
D. MICHIGAN OBLIGATIONS
Michigan agrees to:
1. Use or disclose Data solely as described in this Agreement.
2. Maintain the security and confidentiality of Data by storing it on a filly encrypted (at rest and
in transit), dedicated physical server based on the Federal Bureau of Investigation's Criminal
Justice Information Services ("CJIS") most current Security Policy, which may be
amencled/updated from time to time, to the extent allowed by state law, by securelyhansferring
the Data to the Census Bureau, and requiring that the Census Bureau protect it according to
applicable federal security standards, and by allowing only individuals who have been cleared
for Special Sworn Status by the U.S. Federal Government and been given specific authorization
to access the CJARS Database, Michigan shall comply with the most current version of the
CJIS Security Policy in all other respects, which may be amended/updated from time to time.
3. To promptly report to the Transferor any unauthorized use or disclosure of Data of which
Michigan becomes aware. Michigan will review any suspected unauthorized use or disclosure
of Data and take reasonable corrective action to eliminate or contain continued unauthorized
use or disclosure. Except as required by law, Michigan will not provide notice directly to
individuals whose personally identifiable information was improperly used or disclosed to
regulatory agencies, or other entities. without prior written permission from Transferor. If
Michigan uses or possess Transferor's PII (defined in Exhibit E) or Criminal Justice
Information (herein aher "CJ1' and means the information covered by the C'JIS Security
Policy), Michigan shall follow the procedures and requirements in Exhibit E (which is attached
and incorporated into this Agreement), Appendix F (which is attached and incorporated into
this Agreement), and any other applicable provisions in this Agreement governing the
unauthorized access, disclosure, or theft of Data, including Pill and CJI.
d. Release the Data to the U.S. Census Bureau subject to the terms of the executed agreement
attached as Exhibit B to this Agreement.
5. Provide reports to the SC'AU from processed data using Data trout Transferor and other
permissible data providers in the State of Michigan, upon reasonable, prior written notice to
be not more than quarterly.
6. Provide the Transferor an atn Ual confidential report on the composition and outcomes of its
caseload or as reasonably requested by Transferor and agreed to by Michigan.
7. Michigan warrants it has completed the "T'ransferor's security questionnaire. Each year of this
Agreement, prior to the anniversary date of this Agreement and upon receiving Transferor's
security questionnaire, Michigan shall provide the Transferor with complete answers to the
Transferor's security questionnaire.
L. TERM AND TERMINATION
I. Teivn: This Agreement and any amendments shall be effective when executed by both Parties
with resolutions passed by the governing bodies of each Party except as othervvise specified
below. The approval and terms of this Agreement and any amendments, except as specified
below, shall be entered in the official minutes of the governing bodies of each Party. An
executed copy of this Agreement and any amendments shall be tiled by the Oakland County
Clerk with the Secretary of State. Unless extended by an amendment, this Agreement shall
remain in effect for five (5) years from the date the Agreement is completely executed by all
Parties or until cancelled or terminated by any of the Parties pursuant to the terms of the
Agreement.
2. Termination /in ('ause: Transferor may terminate this Agreement upon breach by Michigan
by providing written notice of breach and thirty (30) clays to cure such breach. Upon the end
of the thirty days, if such breach has not been cured, Transferor may terminate this Agreement
effective immediately upon such written notice.
3. Termhunion,jin, C'onrcnicnce: Either Party may terminate this Agreement, for any reason or
not reason, upon ninety (90) days written notice to the other Party,
4. E/jectofTermination:
a. l IPon expiration or termination of this Agreement, the Parties agree that Michigan shall, at
Michigan's expense, remove any identifying elements from the Data in Michigan's
possession and send it statement certifying the de -identification of the Data to the
Transteror within 30 days after the de -identification. The Transferor agrees that Michigan
may retain the de -identified Data for continued research use, by itself or by authorized
users, and that Data provided to the Census Bureau will likewise be de -identified and
personally identifiable information destroyed after their use for data linkages necessary to
conduct LIARS. Michigan agrees that all obligations hereunder shall survive termination
for as long as Michigan retains such de -identified Data in its possession.
5. Siopension of Providing Data. Transferor, through its Manager of Community Corrections,
may immediately suspend providing Data to Michigan for any ofthe following reasons: (i) requests
by law enforcement or other governmental agencies: (ii) engagement by Michigan in fraudulent or
illegal activities relating to this Agreement or the Data: (iii) breach of the terms and conditions of
this Agreement: or (iv) unexpected technical or security issues. The Transferor's right to suspend
providing Data is in addition to the right to terminate or cancel this Agreement. "Transferor shall
not incur any penalty, expense or liability if providing Data is suspended.
P. MISCELLANEOUS
I. Amendment: The Parties may amend this Agreement from time to time. All amendments to
this Agreement must be in writing and signed by the Parties.
2, C'omplianec urilh Lrnrs: The Parties will at all times comply with all applicable provisions of
state and federal laws and regulations.
3. Disclaimer: THE PARTIES UNDERSTAND THE DATA IS PROVIDED "AS IS".
NEITHER PARTY MAKES ANY REPRESENTATIONS OR EX'T'ENDS ANY
WARRANTIES OF ANY BIND, EITHER EXPRESSED OR IMPLIED. THERE ARE NO
EXPRESS OR IMPLIED WARRANTIES OF MERCHANTABILITY OR FI'TNFSS FOR A
PARTICULAR PURPOSE.
4. (hrnevship and bticllecnad Propeo,v: The Data are the property of the Transferor. Michigan
will not. by this Agreement, acquire any intellectual property rights in Data. 'Transferor
acknowledges and agrees that it does not by this agreement acquire any intellectual property
rights in the future inventions or discoveries made by Michigan or users using Data provided
by the Transferor.
5. Relationship of'the Parlics: Each Party to this Agreement is an independently contracting
party. Nothing in this Agreement will constitute, be construed, or create an employment
relationship, a partnership, or a joint venture among any of the Parties.
6. ,Assignment: Successors and ,Assigns: Neither Party may assign its rights or cause to be
assumed its obligations hereunder without the prior written consent of the other Party, which
consent will not be unreasonably withheld or delayed. Subject to the foregoing, this
Agreement will apply to, be binding in all respects upon and inure to the benefit of the Parties
hereto and their respective successors and approved assigns.
7. Fxeculion of Agveemew: This Agreement may be executed in two or more counterparts, each
of which will be deemed to be an original copy and all of which, when taken together, will be
deemed to constitute one and the same agreement. The exchange of copies of the Agreement
and of signature pages by facsimile or electronic transmission will constitute effective
execution and delivery of this Agreement as to the Parties hereto and may be used in lieu of
the original Agreement for all purposes. Signatures of the Parties transmitted by facsimile will
be deemed to be their original signatures for all purposes.
8. Neither Party will use the name of the other Party, nor any member of the other Party's staff,
in any advertising, news release or other promotional activity without the prior written
approval of an authorized representative of the other Party.
9, Each Party shall be responsible for any Claims made against that Party by a third party, and fur
the acts or omissions of its employees and agents arising under or related to this Agreement,
to the extent allowed by Michigan law. For the purposes of this Agreement, "Claims" means
any alleged losses, claims, complaints, demands for relief or damages, lawsuits, causes of
action, proceedings, judgments, deficiencies, liabilities, penalties, litigation, costs, and
expenses, including, but not limited to, reimbursement for reasonable attorney fees, witness
fees, court costs, investigation expenses, litigation expenses, amounts paid in settlement, and/or
Other amounts or liabilities of any kind which are incurred by or asserted against Transferor or
Michigan, or fur which Transferor or Michigan may become legally and/or contractually
obligated to pay or defend against, whether direct, indirect or consequential, whether based
upon any alleged violation of the federal or the state constitution, any federal or state statute,
rule, regulation, or any alleged violation of federal or state common law, whether any such
claims are brought in law or equity, tort, contract, or otherwise, and/or whether commenced or
threatened.
10. Except as provided in this Agreement, in any Claim that may arise from the performance of
this Agreement, each Party shall seek its own legal representation and bear the costs associated
With such representation, includingjudgments and attorney fees.
11. Except as otherwise provided for in this Agreement, neither Party shall have any right under
this Agreement or under any other legal principle to be indemnified or reimbursed by the other
Party or any of its agents in connection with any Claim.
12. Michigan shall be solely responsible for all costs, tines and fees associated with any misuse by
its employees and agents of the Data provided by'fransferor.
13, 'This Agreement does not, and is not intended to, impair, divest, delegate or contravene anv
constitutional, statutory, and/or other legal right, privilege, power. obligation, duty, or
immunity of the Parties. Nothing in this Agreement shall be construed as a waiver of
governmental immunity for either Party.
14. Except as provided otherwise in this Agreement, neither Party shall be liable to the other Party
or any other person, for any consequential, incidental, direct, indirect, special, and punitive or
other damages arising out of this Agreement.
15. Except as provided for the benefit of the Parties, this Agreement does not and is not intended
to create any obligation, duty, promise. contractual right or benefit, right to indemnification,
right to subrogation, and/or any other right in favor of any other person or entity.
16. Absent a written waiver, no act, failure, or delay by a Party to pursue or enforce any rights or
remedies under this Agreement shall constitute a waiver of those rights with regard to any
existing or subsequent breach of this Agreement. No waiver of any term, condition, or
provision of this Agreement, whether by conduct or otherwise, in one or more instances shall
be deerned or construed as a continuing waiver of any term, condition, or provision of this
Agreement. No waiver by either Party shall subsequently affect its right to require strict
performance of this Agreement.
17. Notwithstanding any other term or provision of this Agreement, neither Party shall be liable to
the other for any failure of performance hereunder if such failure is due to any cause beyond
the reasonable control of that Party and that Party cannot reasonably accommodate or mitigate
the effects of any such cause. Such cause shall include, without limitation, acts of God, fire,
explosion, vandalism, national emergencies, insurrections, riots, wars, strikes, IOCI,OntS, work
stoppages, other labor difficulties, or any law. order, regulation, direction, action. or request of
the United States government or of any other government. Reasonable notice shall be given
to the affected Party of any such event.
18. This Agreement shall be governed and construed in accordance with the laws of the State of
Michigan without regard for principles of choice of law. Any claims, demands, or actions
arising from this Agreement shall be brought in the applicable courts of the State of Michigan.
19. Invoice and payment instructions are described in Exhibit C. Notwithstanding any other term
and condition in this Agreement, if Transferor pursues ally legal action in any court to secure
its payment under this Agreement, Michigan agrees to pay all costs and expenses, including
attorney fees mid court costs, incurred by Transferor in the collection of any amount owed by
Michigan.
20. Any request by either Party for additional data beyond the Data listed herein or services to be
provided under this Agreement shall be subject to additional charges to be paid by the
requesting Party.
21. Michigan shall provide Transferor a copy of any proposed research proposal that seeks to
perform analysis based solely From the Data or Data merged with other data from the State of
Michigan or data not from the State of Michigan that will isolate results specifically to the
State of Michigan, and will publicly associate these findings with Transferor or the State of
Michigan no less than thirty (30) days prior to Michigan's approval decision of the proposal
5
for review and comment. Transferor shall notify Michigan of any objections to the research
Proposal during such thirty (30) days and Michigan shall issue a partial or full rejection to the
proposal as consistent with Transferor's objections.
22. As described in Exhibit D, personally identifying information ("PII") will be maintained by
Michigan and the Census Bureau securely and confidentially. Access to I'll will be given only
to authorized Michigan and Census Bureau employees needing it for purposes of matching
cases. Once matched, the data will be anonymized and de -identified. For the purposes of this
Agreement, PII means names, clay of birth (age will not he considered I'll), addresses, phone
numbers, driver's license number, Social Security Number, criminal tracking number,
transaction control number, any other included local, state or tcderal identifiers, and
"Personally identifying information" and "Personal information" as those terms are defined in
MCL 445.63.
23. Euirr .Igreenrcnl This Agreement constitutes the entire agreement between the Parties with
respect to the subject matter hereof, and supersedes and replaces all prior agreements,
understandings, commitments, communications, and representations made between the
Parties, whether written or oral, with respect to the subject matter hereof.
24. Severahrlirtc If any provision of this Agreement is declared invalid or unenforceable, such
provision will be limited and construed so as to make it enforceable or, it such limitation or
construction is not possible, such provisions will be stricken from the Agreement. In such
event" all other provisions will remain in full force and effect. unless such enforcement would
be inconsistent with the purposes of this Agreement.
25. Notices: Legal notices or matters of a contractual nature arising out of the terms and conditions
of this Agreement may be directed to:
MICI I IGAN:
University of Michigan
Office of Research K Sponsored Projects
3003 S. State St. I" Floor Wolverine Tower
Ann Arbor, nil 48109
Altim Patrick Woods
pajtvoodsq Unich.edu
734.764.8566
TRANSFEROR:
IN WITNESS WHEREOF, the parties have executed this Agreement on the date of the last
signature below:
IN WITNESS WHEREOF, Eric S. Ward, Project Representative. hereby
acknowledges that he/she has been authorized by a resolution of the Regents of
University of Michigan to execute this Agreement on behalf of the Regents of
University of Michigan and hereby accepts and binds the Regents of University of
Michigan to the terms and conditions of this Agreement.
EXECUTED:
Eric S. Ward
DATE:
Project Representative, Office of Research and Sponsored Projects
The Regents of the University of Michigan
IN WITNESS WHEREOF, David T. Woodward, Chairperson, Oakland County Board
of Commissioners, hereby acknowledges that he has been authorized by a resolution
of the Oakland County Board of Commissioners to execute this Agreement on behalf
of Oakland County, and hereby accepts and binds Oakland County to the terms and
conditions of this Agreement.
EXECI iTFD: DATE:
David T. Woodward, Chairperson
Oakland Countv Board of Conunissioners
WITNESSED: DATE:
Oakland County Board of Commissioners
County of Oakland
Exhibit A
Data and Data Transfer Specifications
The following are the requested tables from the Judicial Data Warehouse:
Tables
Attributes
Case Key "fable
(All)
Court Case Table
(All)
Case Party Table
(All)
Name Table
(All)
Alternate Name Table
(All)
Criminal Offense Table
(All)
Address Table
(All)
Address Link Table
(All)
Assessment Table
(All)
Payment Table
(All)
Sentence Table
(All)
Alternate Name Ref
(All)
Assess CD Ref
(All)
Attorney Ref
Attorney Type, BAR Number, Firm Name,
First —Name _ First, Last_Name_Only, Court 1,
Court 2, Court 3, Court 4
Case Type Ref
(All)
Confinement Loc Ref
(All)
County Ref
(All)
Court Ref
ID Code—Court, Court Type, Court—Name,
Address ID
Disposition Ref
(All)
.Judge Ref
(All)
Local Offense Code Ref
(All)
Party'Type Ref
(All)
Payment Type Ref
(All)
Police Agency Ref
(All)
Sentence Flag Ref
(All)
Sentence Type Ref
(All)
SOS Code Ref
(All)
State Offense Code Ref
(All)
8
Selection Criteria is:
• Criminal Case "I'ypes.
Case Type
AR
AX
EX
FC
FD
Fit
F1
FT
FY
IOD
IOM
OT
SD
ISM
ST
Case Type Name
Criminal Appeals
Extradition/Detainer
Extradition/Detainer
Capital Felonies
Felony Drunk Driving
Noncapital Felonies
Juvenile Felonies
Felony Traffic
Felony Criminal
Ordinance Misdemeanor Drunk Driving
Ordinance Misdemeanor Criminal
Ordinance Misdemeanor Traffic
Statute Misdemeanor Drunk Driving
Statute Misdemeanor Criminal
Statute Misdemeanor Traffic
• Public, Non -Public, Expunged, and Removed Cases
• All filing years included
The data will be provided through Oakland County's OCMove SFTP Portal. An account will be
created for one internal Oakland County user as well as one external Michigan user in order to
access the tile. which will be encrypted. The data will be formatted in a pipe delimited ".cvs"
File format. Each table will include column headers in the first row. Data will be accompanied by
relevant data documentation including variable labels and formals.
9
Exhibit B
UNIV1.1611Y01 MICHIGAN
UM -PI Niched Mudler,S,nilh
ConlmaPureiwse Onicr. 3004425034
Rcvnd July 5.2017
PURCHASE SERVICE AGREEMENT
BETWEEN
THE REGENTS OW"I+HIE UNIVERSITY OF MICHIGAN
AND
U.S. CENSUS BUREAU
0094.2017.006
1. PARTIES AND PURPOSE
A. This Fixed Price PURCHASE SERVICE AGREEMENT for research services ("Agreement) is
made in Ann Arbor, Michigan between the Regents of the University of Michigan ("Michigan", a
Michigan Constitutional Corporation, Ann Arbor, Michigan and the U.S. Census Bureau ("Census"),
through which Michigan will pay the Census Bureau for statistical research services. Michigan and
the Census Bureau can be referred to individually as a "Pany" or collectively as the "Parties".
B. Michigan is a recipient of a Laura and John Arnold Foundation Grant (hereinafter referred to as
"Prime Award") for support of a project entitled the Criminal Justice Administrative Records Syslem
(C'JARS) Pilot ("Project'), and the Census Bureau agrees to participate in the project as set forth in
this Agreement for the consideration stated herein.
2. DEFINITIONS
"Census Bureau Data" mean any data obtained from databases housed by the Census Bureau that is
not Michigan Data.
"CJARS Database" means the Michigan Information linked to the Census Bureau Data.
"Data Provider" means state and local agencies who have transferred data to Michigan for purposes
of the Project.
"Michigan Data" means information and data obtained from Data Providers or developed or derived
by Michigan.
"Michigan Dataset" means a subset of Michigan Data.
"PII" moans personally identifiable data about an individual.
"Title 13 Data" means data collected or obtained by Census that identi0es a particular establishment
or individual and that Census is aeyuitod to maintain in confidence under Title 13, Section 9 of the
US Code.
10
UNIVE1611Y OF MICHIGAN
UM -el M¢Lael hiurlice-Sm lh
CunwuPu¢h�,c (INn 3004435034
R -kW July 5 2017
3. AUTHORITY
A. Til is agreement is authorized by and Census Bureau has programmatic authority pursuant to 17
U.S.C. § 8(b), which provides that the Census Bureau "may furnish copies of tabulations and other
statistical materials which do not disclose the information reported by, or on behall'of, any particular
respondent,' and "may make special statistical compilations and surveys, for departments, agencies,
and establishments of the Federal Government, the government of the District of Columbia, the
government of any possession or area (including political subdivisions thereof) ... State or local
agencies, or other public and private persons and agencies, upon payment of the actual or estimated
cost of such work."
B. The person siyming on behalf of The Regents of Michigan of Michigan certifies by signing below
lie/she has the authority to enter into this Agreement as delegated by the Executive Vice President for
Business and Finance and Chief Financial Officer under Regent Bylaw 3.07 though the Associate
Vice President for Finance and through the Director of Procurement Services (See:
httn://nrocurement.umich.edu/sites/default/files/table 1 -u -
❑l business and finance authority clelegalions.ndfJ Michigan's Principal Investigator, as defined
below, is not authorized to amend or alter this Agreement. Any such amendments or alterations must
be approved by the written mutual agreement of authorized representatives of the Parties hereto.
4, CONFIDENTIALITY
A. Should Michigan require direct access to Title 13 data to assist in the planning, data collection,
data analysis, or production of final products, those staff members are required to obtain the Census
Bureau Special Swom Status pursuant to 13 U.S.C. § 23(c). Any access to such Title 13 Census
Bureau Data at Michigan's facility is subject to prior approval by the Census Bureau's Data
Stewardship Executive Policy Committee upon assurance that the facility and information technology
security meet the Census Bureau requirements,
B. The Census Bureau shall keep confidential and not disclose to third Parties any Michigan Data
provided or made available to Census by Michigan under [his Agreement, except as otherwise
provided herein. Only the Census Bureau Personnel with it need to know may have access to or use
of Michigan Data,
C. Notwithstanding (he foregoing, nothing in this Agreement shall in any way limit the ability of
Michigan to comply with any laws or legal processes concerning disclosures by public bodies. The
Parties acknowledge that any responses, materials, correspondence or documents provided to and io
possession of Michigan may be subject to disclosure to (bird parties ander the Michigan Freedom of
Infornation Act ("Act") and compliance with that Act or any other applicable law will not constitute
a breach or dreatened breach of this Agreement by Michigan. Michigan acknowledges that some
responses, materials, correspondence or documents provided to Michigan by Census may be exempt
from disclosure under the Act or under applicable state or federal laws. Census will not be providing
UNIVEVSlITOf: MICHIGAN
um -P11 Midud M.81l -S, Ah
CouWd Nn W,e ONv, 3004435034
RevbN rely 5.2017
Michigan with any confidential data for purposes of the CJARS project. Accessibility to the CJARS
Database, with no Personally-ldentiflahle Information (Pit), will be provided only to individuals with
Special Sworn Status (SSS). The parties agree that data or records solely in the possession of Census
is not subject to Michigan's state Freedom of information Act requirements. To the greatest extent
permitted by Michigan law, this agreement will not be read to conflict with federal Freedom of
Information Act law.
S. TERMS AND CONDITIONS
A, The focus of this work is to improve the utility of certain data resources, specifically microdata
products from criminal justice agencies for the Criminal Justice Administrative Records System
(('JARS). Prepared data files from the (JARS Database will be made available to qualified
researchers conducting approved projects at Census Bureau Research Data Center (RDC), The data
prepared for these RUC projects will facilitate the linkage of records from research institution data to
Census Bureau Data including the Longitudinal Employer -Household Dynamics infrastructure,
federal program participation files, and Census survey microdata that have unique identification
codes constructed by the same Census process. None of the work under this agreement or
products/deliverables created mrd provided under this agreement shall be used for enforcement
purposes. All work, including products and deliverables, must serve statistical purposes only.
B. Michigan will:
Provide Census with Michigan Data as microdata from criminal justice agencies participating in
the CJARS initiative, by CD/DVD or using the Census Secure Data Transfer (CSDT) server.
Each Michigan Dataset will be accompanied by a record layout containing variable information
including names, labels, width, and format.
• Provide points of contact within the Michigan Population Studies Center ("PSC") for data transfer
and reporting of security incidents.
C. Census will:
• Notify PSC staff when the transfer of the Michigan Data is completed successfully or whether
transfer cannot be carried out.
• Transmit and store data in accordance with applicable federal policies and standards.
• Prepare CJARS Datasets from criminal justice agencies for use by RDC researchers. This
preparation will include receipt and documentation of the raw Michigan Data files from the PSC,
replacement of Pit with unique identification codes, and creation of datasets.
Generate statistical products based on the CJARS Database to be provided to PSC for use in
reports to state and local agencies that have provided data to Michigan. Generation of statistical
products will include automated disclosure review processing and secure transfer of the
aggregated statistics to PSC. These products will not include any wnfidonlial data.
Make the CJARS Database available through Census RDC's for access by researchers to conduct
projects approved by Michigan and the Census Bureau.
• Store original and prepared CJARS Database files on secure Census Bureau servers located at the
12
UNIVURSIIY01 MICHIGAN
uM-PI. &Whni M.'[W -snth
('nmmvvPumM1mc ON¢r' 2004435034
asvi3O ail, i. 21117
Census Bureau's Bowie Computing Center.
• Provide access to the CJARS Database and Michigan Data only to data processing staff and to
qualified researchers working on RDC projects approved by Michigan and the Census Bureau.
Qualified researchers may include the Census Bureau cmplovees and contractors, and external
researchers who have obtained the Census Bureau Special Sworn Status and are working on
approved projects in a Census RDC All who will have access to these data will be swom to 13
U,S.C. confidentiality.
• To the extent permitted by law, destroy any PII included in or derived from the CJARS Database
or Michigan Data as required by Michigan contracts with Data Providers.
• To the extent permitted by late, destroy any PR included in or derived from the CJARS Database
or Michigan Data at the termination of the Agreement.
D. Michigan and Census will jointly:
• Request permission to use and access to federally held criminal justice data including the National
Corrections Repotting Program (NCRP) from the Bureau of Justice Statistics (BJS), the Federal
Bureau of Prisons' data from the U.S. Bureau of Prisons (BOP), and Public Access to Court
Electronic Records (PACER) from the Administrative Office of the United States Courts (AO).
• Request permission to use and access to datasets including the Longitudinal Employer -Household
Dynamics infrastructure from its Census Bureau information owner, IRS tax records from the
Internal Revenue Service (IRS), federal program participation tiles from its respective owners,
and Census Bureau Data including survey microdata from their respective Census Bureau
information owners for the purpose of generating statistical products.
E. Progress will be monitored by regular conference calls between project contacts named in
Puragraph 10 of this Agreement.
F. Census acknowledges that obligations described above continue for the entire period of Agreement
unless otherwise agreed by the Parties. The Census Bureau will achieve full cost recovery for the
goods and services it is providing under this Agreement. Census acknowledges that $170,000 is
estimated to be the fill amount needed for the tasks described herein.
& TRANSFER OF FUNDS
Michigan agrees to pay the Census Bureau $170,000 over the course of the Agreement, which ends
August 31, 2021. In advance of deliverables, Michigan shall make automatic payments to the Census
Bureau as follows upon confirmation that Project work continues to progress in accordance with
Section 5, Terms and Conditions and that the Census Bureau is not otherwise in breach of this
Agreement:
I Dare I Dollar Amount
When sited $_63,750
Aagusl3t 2017 -.- -$21,250
Novmnbcr 30, 2017 _--- - $21;2511 1
13
UNIVERSITYOF MICHIGAN
UM4I. Miulwd Muellorsmith
CahmcRochl9COrde, 3009435034
RevinN July $, 2017
F6tunry28, 2015 _ S21,2501
May_31y 2018 $21250
August 31, 2n18 ------ -- - -$27,2501
I Total $170,000
KmIComumeilae
rde M@ranc Number
OW4d017L06
PMJmt Numha
8910"
Estimated Toni Cans
S170,000
rimol V.,
200
Pedodofraronnowc
Fmm: Detcoll Pnntm Nave sigtud
To: Autus131,2021
Us Census Burton
Tina nt, Account Symbol 013 %4512 000
ALC 13A4-0OOI
nmioc� EVcwu Tyrn Cade COLL
Business Parma Nawous, 929955393
Caama Wlnaoe. Bayldon COW 1
Oma Sunders Jr.
U'S Caws Burton
Cher, Accounts Recnrehe Bmrch
CE RIQrIN2Ki10
4600 Silver Hill Mod
Width an, nC 20231
UniyuAry of MIchisho FI41t1195 CootaA;
Drnms1 Pauyweh, MBA
Pmonemmt Subennuset Adounistretar
Uo,conly of Ml<hl9an
UBicc of Conraut Admmnanlmn
5052 Whvmnu To.
3003 Scats state Sect
AM Asa , Mtchgon 48109-1287
lcl,bone, 73491o,3%S
Fun i llenmmLmuiAou
7. PUBLICATIONS
A. The Census Bureau shall have the right to publish and/or publicly present ("Publish") results
("Project Results") obtained from its access to and use of the OARS Database after Michigan's
Principal Investigator has first Published its Project Results or after the GAITS database is made
14
U VIVERSITY Iii' MICHIGAN
nM -Yl WNW MuANr3anh
Cnmaul.Pm�haee ONn 3004435034
RmnN h1, 5,±111'7
available to researchers not nffiliatrd with the Census Bureau through the. Census Reseorch Data
Centers, whichever is later. Exceptions would arise where the data plays a small or indirect role in a
larger report. In those cases, Michigan may authorize earlier publication. Nothing in this section
restriets Census from complying with the federal Freedom of information Aet law.
B. Census may also publish reports about the services being performed by Census under this
Agreement that are not dependent on use or disclosure of the OARS Database.
C. Census will submit a copy of any proposed publication to Michigan's Principal Investigator for
review and comment sixty (60) days prior to publication and will seriously consider any comments
received.
D. The Census Bureau will not Publish results derived from Michigan Data without prior written
permission of Michigan. Nothing In this section restricts Census from complying with the federal
Freedom of Information Act law.
E, Criteria for authorship of any publication ansing from the Project will be determined in accordance
with accepted academic practice based upon substantial contribution to the design, analysis,
interpretation of Project Results, drafting and/or materially revising any manuseript(s) derived from
the Project.
F. None of the work under this agreement or products/deliverables created and provided under this
agreement shall be used for enforcement purposes, All work, products, and deliverables most serve
statistical purposes only.
B. PUBLICITY
Neilhe Party will use the name of the other either expressly or by implication, in any news, publicity
release, or other promotional fashion without the express written approval of the other. Either Party
may withhold its consent in its absolute discretion. The Parties acknowledge that a minimum of ten
(10) business days is required to consider any request for consent.
9. Working Relationship
No Party has the authority to bind any other Party in contract or to incur any debts or obligations on
behalf of any other Party, and no Party (including any employee or other representative of a Party
with responsibility for Project matters shall take any action that attempts or purports to bard any other
Petty in contract or to incur any debts or obligations on behalf of any other Putty, without the affected
Party's prior written approval.
10. CONTACTS
The contacts for exchanging Project information of each Party to this Agreement are:
IS
UNIVEINIYOF MICHIGAN
uM-PI', Miclwei Muellepsmuh
Cual.aTtue wse ONer 3004435034
Re%IseJ July 5. 21,17
The Census Bureau:
Dr. Quentin Brummet
Chief, Experiments and Innovation
Center for Administrative Records Research and Applications
U.S. Census Bureau, 4600 Silver Hill Road
Phone: 301.763-5939
Email: Quentin.O.Brummetoycensus.gov
University of Michigan:
Dr. Michael Mueller -Smith
Population Studies Center and Department of Economics
University of Michigan
Email: mymts@umich.edu
Office: (734) 763.3221
Mobile: (410) 218-3189
The Parties agree that if there is a change regarding the Information in this section, the Party making
the change will notify the other Party in writing of such change.
11. DURATION OF AGREEMENT, AMENDMENT'S AND MODIFICATIONS
Tlms Agreement will become effective when signed by all Parties. The Agreement will terminate on
August 31, 2021 but may be amended at any time by mutual consent of the Parties. The Parties will
review this Agreement at least once every three years to determine whether it should be revised,
renewed, or canceled. Any Party may terminate this Agreement by providing thirty (30) day's written
notice to the other Party. This Agreement is subject to the availability of funds.
12. MAINTENANCE, RETURN OR DESTRUCTION OF DATA.
A. To the extent permitted by law, Census Bureau agrees to indefinitely maintain the CJARS
Database and provide availability to it by researchers through the RDCs as described herein, If
Census Bureau is unable of or unwilling to continue to provide such maintenance and access it will
notify Michigan and Michigan will provide instructions to the Census Bureau about disposition of the
CJARS Database which will include transfer to Michigan or to another catity. To the extent
permitted by law, the Census Bureau will comply with such instnlctions.
B. To the extent permitted by law, at any time and upon Michigan's written request, the Census
Bureau shall promptly return, within ten (10) business days, all originals and copies of Michigan
Data, whether in printed or electronic form, including backups and archived data. In lieu of a return
of Michigan Data, with Michigan's written consent, the Census Bureau, to the extent permitted by
law, shall promptly destroy all originals and copies of Michigan Data, will in printed or electronic
16
UNIVURSIIYCff MICIiR;AN
UM -P) Michael Mnellersmnh
Qaa.a Puml,.0den 3004435034
R ,i,cl lulr 5, 210
firm, including backups mid archived data in accordance with industry standards and (lee federal
government's best practices.
13. RESOLUTION OF DISAGREEMENTS
Should disagreement arise on the interpretation of the provisions of this Agreement, or amendments
and/or revisions thereto, that camrot be resolved at the operating level, the areata) of disagreement
shall be stated in writing by each Patty and presented to the other Party for consideration, If
agreement on interpretation is not reached within thirty days, the Parties shall forward the written
presentation of the disagreement to respective higher officials for appropriate resolution.
14. TERMINATION COST
If Michigan terminates this Agreement, the Census Bureau will make no further commitments under
this Agreement and will take all teasonable actions to cancel outstanding obligations. Michigan shall
reimburse the Census Bureau costs incurred prior to cancellation of the order plus any allowable
reasonable termination costs, up to the total payment amount provided for under this Agreement.
Payments to the Census Bureau shall not exceed the total cost in Section 6, above. All excess funds
paid by Michigan shall be returned to Michigan promptly following termination.
15. AUDIT REPORTS
To the extent permitted by law, all financial records and reports that relate to this Agreement shall be
retained by the Census Bureau for periodic examinations of records throughout the term of the
Agreement and for a period of three (3) years after its termination by representatives of Michigan
and/or its independent auditors during normal business hours.
16. ASSIGNMENT
The Census Bureau may not subcontract, assign or transfer this Agreement or any interest or claim
under this Agreement without prior written approval of Michigan. Notwithstanding any consent by
Michigan to any assignment, the Census Bureau shall at all times remain hound to all promises and
performances, however described, as are required of it under the Agreement unless specifically
released from the requirements, in writing, by Michigan.
17. NO THIRD PARTY RIGHTS
Nothing in this Agreement shall be construed as creating or giving rise to any rights in third Parties or
persons other than the named Parties to this Agreement.
1@. NOTICE
17
UNIVERSIIY01: MICIMAN
UM-I'l Michell Mmller-Sniih
CM.vp.¢ha¢order 3004436034
Revaul M, 5, 3017
Any notice, to either Party must he In writing, signed by the Party giving it, and served to the
addresses shown immediately after the signatures (or to such other addressee. as may be Inter
designated by written notice) by personal delivery, email or other verifiable electronic
communication, recognized overnight courier service, or by the United States mail, first-class,
certifier) or registered, postage prepaid, return receipt request c. All such notices shall be effective
when received, but in no event later than three (3) days after mailing.
19. SIIRVIVEARILI'I'Y
Provisions surviving termination or expiration of this Agreement are those which on their face affect
rights and obligations after termination or expiration and also include provisions concerning
publication, publicity, confidentiality, and maintenance, of data.
20. SEVERABILITY
The terns of this Agreement are severable. If any tern or provision is declared by a U.S. Federal
court of competent jurisdiction to be illegal, void, or unenforceable, the remainder of the provisions
shall continue to be valid and enforceable.
21. EXECUTION
This Agreement may be executed in several originals, which together constitute but one and the same
Agreement. The Parties agree that a signature affixed to any one of the originals and delivered by
facsimile or email shall be valid, binding, and enforceable. The Parties acknowledge and agree that
this Agreement has been mutually discussed, negotiated, and drafted by the Parties.
22. WAIVER
No delay or omission by either Party to exercise any right or remedy under this Agreement shall be
construed to be either acquiescence or the waiver of the ability to exercise any right or reme ly in the
future.
23. PRINCIPAL INVESTIGATOR
Michigan's Principal Investigator is Michael Mueller -Smith.
[This space is intentionally left blank. Signatures follow on the neat page.]
18
UNIVEWSIIY pP MICHIGAN
VATI Mi.hclnlucll<r.smilh
CnnwWPunhme Under 3004436094
R,,,,W July 5. 21117
This Agreement is executed and effective as of the date of the most recent signature below.
U,S. CENSUS BUREAU I
r
✓j . ki fI t 7 I f 1 j
Amy O'Hara ^�� DATE
Center for Administrative Records Research and Applications
Division Chief
FOR THE REGENTS OF MICHIGAN OF MICHIGAN
onoe.2Oy 7.07.1 by/D4
e5n1n7
is 04 00
one.
Acrobat version sz'
ywa4., MUA
n o.zu July 10, 2017
Dennis J. i'nszywak, MBA DATE
Procurement Subcontract Administrator
Sponsored Programs
Office of Contract Administration
Notices to the Census Bureau Notices to Michigan
University of Michigan
Office of Contract Adminisnation
5000 Wolverine Tower
3003 South State Street
Ann Arbor, Michigan 48109-1287
And copy to: subcuntracts@umich,edu
10
19
Exhibit C
Invoices and Payment
Invoices
After each successful extraction of data, Transferor will invoice Michigan for the costs
associated with Transferor providing the Data to Michigan. 'fYansferor must submit each invoice
as reasonably specified by Michigan. Invoices should be mailed to:
Population Studies Center
Attn: Carol Lowen
University of Michigan
426 Thompson St
Ann Arbor. MI 48106-1348
as well as emailed to ebowenwkimieh.edu, ciars-statfiirumiell.edu, and m:*msuR uuichxdu.
Each invoice Must:
- Include the number of hOUPS of work performed and the applicable hourly hilling tate
- Any other applicable costs (e.g., materials, etc.)
Payment
Invoices are due and payable by Michigan within 60 calendar days atter receipt.
K11
Exhibit D
Access to and Location of Personally Identifying Information in CJAR4
PII PRESENT
0
r.i.in ir:..l. ln•,'L,i :,r Aqe Q e�-t
Ol
tin
C
r
CZARS Secure Data Enclave (SDE) Server
Anonymized Division PII Divisi.on >
� N
C Statistical N
Access: SOE-approved Access: P11 -approved p
Reports CARS staff OARS staff �^
.=r
/ \ O
Relational Dntabnne { PII Roster
x Research Data crnlrus [horst C
Center Servers P'LJ: 5erver•> N
Access: C
N Approved Census vt
o Bureau staff, and
PfI-approved Ccn°.us C
Approved external
•o researchers with 6ureen t.�ff
`._.' special Sworn status O
Proposal Review-)
W
(b m
Won -C
JARS t�D
publications S7
i � N
t �
NO PII PRESENT
21
Exhibit F
REQUIREMENTS FOR MICHIGAN REGARDING ACCESS AND USE
OF TRANSFEROR'S PII (Personally Identifiable Information)
This Exhibit governs the requirements for Michigan regarding its access, use, and storage of
Transferor's PII.
1. DEFINITIONS
1.1 Security Breach means the unauthorized access, acquisition, theft, or disclosure of
Transferor's PII.
1.2 PIl (Personally Identifiable Information) has the meaning provided in this Agreemcm.
1.3 Transferor's PH means PII that is provided by Transferor to Michigan pursuant to this
Agreement.
2. OBLIGATIONS
2.1 Michigan shall not use ur disclose `Transferor"s PH other than as permitted or required by
this Agreement or as required by law.
2.2 Michigan shall implement administrative, physical, and technical safeguards (including
written policies and procedures) that reasonably and appropriately protect the
confidentiality, integrity, and availability of 1311 that it creates, receives, maintains or
transmits on behalf of the Transferor.
2.3 Michigan shall mitigate, to the extent practicable, any harmful effect known to Michigan
of the use or disclosure of I'll in violation of law or this Agreement.
2.4 If Michigan or Michigan's employees or agents discover a Security Breach, Michigan
shall notify the Transferor without unreasonable delay, but no later than within forty-
eight (48) hours of discovery. For this purpose, "discovery" means the first clay on which
the Security Breach is known to Michigan or Michigan's employee or agents or should
have been known by exercising reasonable diligence. Michigan shall be deemed to have
knowledge of a Security Breach if the Security Breach is known or should have been
known by exercising reasonable diligence by any person, other than the person
connnitling the Security Breach. The notification to the Transferor shall include the
following: (a) describe the Security Breach in general terms; (b) describe the type of
personal information that is the subject of the Security Breach; (c) identify each
individual whose Pll has been breached or has reasonably believed to have been
breached; (d) describe in general terms, what Michigan has done to prevent additional
Security Breaches; and (e) provide any other available information in Michigan or
subcontractor's possession that may be necessary to comply with Security Breach
notification laws.
2.5 if the Transferor determines it will provide the notice of the Security Breach to the affected
individuals and/or to governmental authorities, Michigan shall pay the'franstcror for: (a)
its costs in notifying the affected individuals: (b) the cost of third -party credit and identify
monitoring services to each of the affected individuals with compromised I'll for no less
than twenty -lour (24) months following the date of notification to each individual; and (c)
22
costs associated with the Security Breach, including but not limited to any costs incurred by
the Transferor in investigating and resolving the Security Breach, including reasonable fees
associated with such investigation and resolution. Michigan shall pay Transferor for the
applicable costs described above within thirty (3(1) clays of receipt of an itemization of costs
incurred by the Transteror because of the Security Breach.
2.6 Within ten (10) calendar days of its discovery of the Security Breach, Michigan shall
provide the Transferor with a detailed plan describing the measures Michigan will
undertake to prevent a future Security Breach. The Transferor shall have the right to
audit, inspect and test Michigan's new safeguards put in place because of the Security
Breach.
23
Appendix F
FRDIRAL BUREAU OF INVESTIGATION
CRIMINAL JUSTICE, INFORMATION SERVICES
SECURITY ADDENDUM
Legal Authority for and Purpose trod Genesis of the
Security At[dendum
Iradilionally, law cnforcctnent and other criminal justice agencies have been
responsible for the confidentiality of their information. Accordingly, until mid -1999, the
Code of Federal Regulatinns'I'itie 28, Part 20, subpart,C, and the National Crime Information
Center (NC'IC) policy paper approved December 6, 1982, required that the management and
exchange of criminal justice information be perforated by a criminal justice agencv or, in
certain circumstances, by a noncriminal justice agency under the management control of a
criminal justice agency.
In light of the increasing desire of governmental agencies to contract with private
entities to Perform ridminisn:atiou of erinninnl justice functions, the Pltl sought and obtained
approval from the (Jnitod States Department orJustice (DOJ) to permit such privatizalino of
traditional law enforcement functions under certain controlled circumstances. In file Fcdural
Register of May 10, 1999, the FBI published a Notice of Proposed Rulemaking,
announcilig as follows:
I. Access to CHIZI [Criminal History Record Information) and I ec aucd
information, Subject to Appropriate Controls, by a Privale Contractor Pursuant
to a Specific Agreement with an Authorized Govenmiental Agency To Perform
an Administration of Criminal Justice Function (Privatization). Section 534 of
title 28 of the United States Code authorizes the Attorney Genera( to exchange
identification, criminal identification, crime, and other records for the official
use of authorized officials of the rederal government, the states, cities, and
penal and other institutions. This statute also provides, however, that such
exchanges are subject to cancollalion if dissemination is ntatle outside the
receiving departments or related agencies. Agencies authorized access to
C91R1 traditionally have been hesitant to disclose that information, even in
furtherance ofauthorized criminaljustice functions, to anyone other [hall actual
agency employees lest such disclosure be viewed as unauthorized. [n recent
year's, however, governmental agencies seeking greater efficiency and
economy have become increasingly interested ill obtaining support services for
the administration of criminal justice tion the private sector. With the
concurrence of the FBI's Criminal Justice Information Services (CJIS)
Advisory I'obey Board, the DO.1 has concluded that disclosures to private
persons and entities providing support services for criminal justice agencies
may, when subjecl to appropriate controls, properly be viewed as permissible
disclosures for purposes of compliance with 28 U.S.C. 534.
We are therefore proposing to revise 28 CPI( 20.33(x)(7) to provide
express authority for such arrangements. The proposed authority is similar to
the authority that already exists in 28 CPR 20.21(0)(3) for stale and local CURL
systems. Provision of CHRI wider this authority would only be permitted
pursuant to a specific agreement with an authorized governmental agency for
the purpose of providing services for the administration of criminal justice.
Theagreement wouldbe required to incorporate it security addendum approved
by the Director of the FBI (acting for the Attorney General). T'he security
06/05/2017 H-7.
(also. urs DOC 081.105.6
addendum would specifically Otaborize access to CHR I, limit the use of the
information to the specific purposes for which it is being provided, ensure the
scetnity and confidentiality ol'the infortnaliou consistent Ivith applicable haws
and regulations, provide for sanctions, and contain such other provisions as (lie
Director oIthe FBl(actirig forthe AttorneyGen eral)mayrequire. Thesecurity
addendum, buttressed by ongoing audit programsfaoboth the FBI and the
sponsoring governmental agency, will provide an appropriate balance between
the benefits of privatization, protection of individual privacy interests, and
preservation of the security of the FBI's CTIRI systems.
The FBI will develop a security addendum to be made available to
interested govemmen(al agencies. We anticipate that the security addendum
will include physical and personnel security constraints historically required
by NCIC security practices and other progranunatic requirements, together
with personal integrity and electronic security provisions comparable to those
in NCIC User Agreements between (he FBI and criminal justice agencies, and
in existing Management Control Agreements between criminal justice
agencies and noncriminal justice governmental entities. The security
addendum will snake clear that access to CHRI will be limited to (hose officers
and employees of the private contractor or its subcontractor who require the
information to properly perfomn services for the sponsoring governmental
agency, and that the service provider may not access, modify, use, or
disseminate such information for inconsistent or unauthorized purposes.
Consistent with such intent, Title 29 of the Codc of Federal Regulations (C'.F.R.) was
amended to read:
§ 20.33 Dissemination oferin i nal history record information.
a) Criminal history record information contained in the Interstate
Identification Index (III) System and the Fingerprint Identification Records
System (FIRS) may be made available:
1) To criminal justice agencies for criminal justice purposes, which
purposes include the sneering of employees or applicants for
employment hired by criminal justice agencies.
2) To noncriminal justice governmental agencies performing criminal
justice dispatching functions or data processing/information services
for criminal justice agencies; and
3) To private contractors pursuant to a specific agreement with an agency
identified in paragraphs (a)(t) or (a)(G) of this section and for the
purpose of providing serines for the administration of criminal justice
pursuant to that agreement, The agncement must incorporate a security
addendum approved by the Attorney General of the United States,
which shall specifically authorize access to criminal history record
inf'orntation, limit the use of the information to the purposes for which
it is provided, ensure the sccnrily and confidentiality of 111e information
consistent with these teguhdions, provide For sanctions, and contain
such other provisions as (Le Atk>mcy C crural may require. Thr. power
06v'05l2017 11-3
CJISDdTS-DOr' 0$140-5.6
and authority of the .attorney General hereunder shall be exercised by
the FBI Director (or the Director's designee).
This Security Addendum, appended to trod incotporuted by reference in a
government -private sector contract entered into for such purpose, is intended to insure that
the benefits of privatization arc riot attained with any accompanying degradation in the
security of the national system of criminal records accessed by the contracting private party.
This Sectu'ity Addendum addresses both concerns for personal integrity and electronic
securi ty evhich have hcen adch cssed in previously executed user agreements and managemen t
control agreements.
A govormaent agency may privatize fimctious traditionally performed by criminal
,justice agencies (or noncriminal justice agencies acting under a management control
agreement), subject to the terins of this Sacurity Addendum. Ifprivatized, access by a private
contractor's personnel to NCIC data and other C.11S information is restricted to only that
necessary to perlbnn the privatized tasks consistent with the government agency's function
and the focus of the contract. If privatized the contractor may trot access, modify, use or
ihmci tinate such data in any manner not expressly authorized by the govemnient agency in
eon;ultation with the FBI.
(16,052017
CnSn-rrs uoc-08140s.6
Lb
1+4
FY,DERAL BUREAU OF INvEs, GA'1'lON
CIR-11MINAL MSTICE INFORMATION SERVICES
SECURiTV ADDENDUM
T'he goal of this document is to augment the CJIS Security Policy to ensure adequate
security is provided for criminal justice systerns while (1) under the control or management of
a private entity or (2) connectivity to FBI CUTS Systems has been provided to a private entity
(contractor), Adequate security is defined in Office of Management and Budget Circular A-
130 as "security commensurate with the risk and magnitude ofharm resulting from the loss,
misuse, or unauthorized access to or modification of information."
'fhc intent of this Security Addendum is to require that the Conhnctor maintain a
security program consistent with federal and state laws, regulations, and standards (including
the CJIS Security Policy in effect when the contract is executed), as well as with policies and
standards established by the Criminal Justice Lnformalion Services (CJTS) Advisory Policy
Board (APB).
This Security Addendum identifies the duties and responsibilities with respect to the
installation and maintenance of adequate internal controls within the contractual relationship so
that the security and integrity of the FBI's information resources are not compromised. l'he
security program shall include consideration of personnel security, site security, system
security, and data security, and technical security.
The provisions of this SccurityAddcrldium apply to all personnel, systems, notworks and
support facilities supporting and/or acting on behalf of the government agency,
L00 Definitions
1.01 Contracting Government Agency (CGA) - the government agency, whether a Criminal
Justice Agency ora Noncriminal Justice Agency, which enters into an agreement with a private
contractor subject to this Security Addendum,
1.02 Contractor - a private business, organization or individual which has entered into an
agreement for the administration of criminal justice with a Criminal Justice Agency or a
Noncriminal Justice Agency.
2,00 Responsibilities of file Contracting Government Agency
2.01 The CGA will ensure that each Contractor employee receives a copy of the Security
Addendum and the CJIS Security Polity and executes an acknowledgment of such receipt and
the contents of' the Security Addendum. The signed acknowledgments shall remain in the
possession of the CGA and available for auditpurposcm The acknowledgement may be signed
by hand or via digital signature (see glossary for deforihou of digital signature).
3.00 Responsibilities ofthe Contractor.
J.01 I'hc Contractor will maintain a security program consistent with federal and state laws,
regulations, and standards (including [lie CJIS Security Policy in effect when the contract is
executed and all subsequent versions), as well as with policies and standards established by the
Criminal .Just ice hilbrnration Services (CJIS) Advisory Policy Board (APB).
40 Security Violations,
06/05/2017 11-5
(7JISI)ATS-DOC 0Y140 5.6
4.01 The CGA must report security violations to the CJIS Systems Officer (CSO) and the
Director, PBI, along with indications of actions taken by the CGA and Contractor.
4.02 Security, violations can justify termination of the appended agreement.
4.03 upon notification, the FBI reserves the right to:
a, Investigate or decline to investigate any report of unauthorized use;
b. Suspend or terminate access and services, including teleconunmications links. The
FBI will provide the CSO with timely written notice of the suspension. Access and
services will be reinstated only after satisfactory assurances have been provided to
the FBI by the CGA and Contractor. Upon termination, the Contractor's records
containing CHRI must be deleted or retuned to the CGA.
5.00 Audit
5.01 The FBI is authorized to perform a final audit of the Contractor's systems after
termination of the Security Addendum,
6.00 Scope and Authority
6.01 This Security Addendum does not confer, grant, or authorize any rights, privileges, or
obligations on any persons other than the Contractor, CGA, CIA (where applicable), CSA, and
FBI.
6.02 The following documents are incorporated by reference and made part of this
agreement: (1) the Security Addendum; (2) the NCIC 2000 Operating Manual; (3) the CJIS
Security Policy; and (4) Title 28, Code of Federal Regulations, Part 20. The parties are also
subject to applicable federal and state laws and regulations.
6,03 The terms set forth in this document do not constitute the sole understanding by and
between the parties hereto; rather they augment the provisions of the CUTS Security Policy to
provide a minimum basis for the security of the system and contained information and it is
understood that there may be terms and conditions of the appended Agreement which impose
more stringent requirements upon the Contractor.
6.04 This Security Addendum may only be modified by the FBI, and may not be modified
by the patties to the appended Agreement without the consent of the FBI.
6.05 All notices and correspondence shall be forwarded by First Class mail to:
Information Security Officer
Criminal Justice information Services Division, FBI
1000 Custerilollow Road
Clat ksburg, West Virginia 26306
28
Include
All Client Data
• Demographic table
o DO Not include the SID Number
o Do Not
include the FBI Number
o Do Not
include the client table notes
o CCNI_CLI_TB
•
CLI ALERTMEDICAL
•
CLI_ALERT OTHER
•
CLI ALERT SKILL
•
CLI BIRTHDATE
•
CLI BIRTHPLACE
•
CLI CRIM HIST_ENT
•
CLI_CTZNSHIP
•
CLI -DRIVERS -LICENSE
•
CLI -EDUCATION -LVL
•
CLI EN'T'RY BY
•
CLI FBI NBR
•
CLI -FIRST -NM
•
CLI_FIRST OFFENSE
•
CLI GENDER
•
CLI -GENERAL -NOTE
•
CLI ID
•
CLI INMATE NBR
•
CLI INVESTIGATOR
•
CLI -LAST -NM
•
CLI LEIN ACTIVITY NOTE
•
CLI MARITAL STATUS
•
CLl MDOC NBR
•
CLI -MID -NM
•
CLI -OPEN -FOC -CASE
•
CLI 0TH LNG
•
CLI_PAS11_ELIGIBILITY_DT
•
CLI_PA511_INEI.IGIBILITY_DT
•
CLI PHYS DESC
•
CLI PRI LNG
•
CLI RACE
•
CLI REFERRAL, SOURCE
•
CLI -UPDATED -BY
•
CLI -UPDATED -DT
•
CLI VETERAN
• Address data
o CLI ADDR CELT,
o CLI ADDR CITY
W
e
o
CLI_ADDR_CLI_ID
o
CLI ADDR COUNTRY
o
CLI_ADDR_CURRENT
u
CLI ADDR DURATION
o
CLI ADDR EMAIL
n
CLI_ADDR END DT
ci
CLI_ADDR ENTRY_BY
o
CLI ADDR ENTRY DT
o
CLl_ADDR_ID
o
CLI_ADDR_NOTE
o
CLI_ADDR_PAGER
CLI ADDR PHONE
o
CLI_ADDR_PHONE_OTH
CLI_ADDR START -DT
o
CLI _ADDR STATE
o
CLI ADDR ST 1
o
CLI_ADDR ST 2
o
CLI ADDR UPDATED BY
o
CLI_ADDR_UPDATED_DT
o
CLI_ADDR_VALID_RELEASE
CLI_ADDR_ZIP4
o
CLI_ADDR_ZIPS
Dependents
data
o
CLI DPNT BIRTHDATE
CLI-DPNT-CLI-ID
o
CLI DPNT FIRST NM
Q
CLI DPNT ID
u
CLI DPNT LAST NM
u
CLI DPNT LIVFS WI'1'11
o
CLI-DPNT NOTE
o
CLl DPNT OBSOLETE
o
CLI_DPNT_RLTNSHP
Education/Employment data
o
CLI_EMPL CAN CONTACT'
o
CLI_EMPL CITY
o
CLI EMPL _CLI ID
o
CLI F.MPL COMMENT
o
CLI EMPL _CURRENT
,
CLl EMPL DOLLARS PER
o
CLI_EMPL_DURATION_D
CL1_EMPL_DURATION_M
o
CLI EMPL DURATION Y
o
CLI EMPL EMPLOYER
o
CLl_EMPL END_DT
o
CLl EMPL FAX
o CLI_EMPI.ID
o CLI EMPL_LAST_WORKED
o CLI_EMPL_OCCUPATION
o CLI EMPL PHONE
o CLI__EMPL SATIS_RECC
o CLI_ EMPL_STAR'1'_DT
CLI EMPL STATE
o CLI_EMPL STATUS
o CLI EMPL ST 1
o CLl_EMPL_ST_2
o CLI_EMPL_SUPVR
where any enrollment Referral Date is >=1/1/16
Step Forward enrollments
o
SF_ENRL_ACE_SCORE
o
SF_ ENRL_APPT_COMMENTS
SF ENRL ASSESS_DATE
n
SF ENRL BENCH WARR
o
SF_ENRL_CASE_MGR_NBR
o
SF ENRL CLI ID
o
SF ENRL CLOSURE_REASON
o
SF ENRL_DCKT_ID
o
SF_ENRL_DCK'C_ID2
o
SF ENRL DCK'1'_ID3
o
SF_ENRL DIAGNOSIS -CODE
L;
SF ENRL ENRL DT
o
SF_ENRL_ENTRY BY
u
SF ENRL, ENTRY DT
n
SF ENRL EXIT SURVEY
n
SF ENRL FEE_WAIVED
o
SF ENRL. 1D
o
SF ENRL INTAKE DT
o
SF ENRL INTAKE_FEE
SF ENRL LEIN
n
SF_ENRL LOC INDEX CODE
n
SF ENRL NBR_REARRESTS
o
SF ENRL NBR RELAPSES
o
SF_ENRL OVERRIDE CD
o
SF ENRL OVERRIDE_OTHER
o
SF_ENRL_PRBTN_OFFCR
o
SF ENRL PRE INVESTIGATOR
o
SF -EN RL REFERRAL DT
o
SF_ EN RL_REFERRAL_SOURCE CODE
n
SF_ENRL REL SIGNED
o
SF ENRL RE REFERRAL
o
SF ENRL_SERVICE_CODE
n
SF ENRI, SITE
o
SF ENRL STATUS
n
SF ENRL SUPV LEVEL
o
SF_ENRL TERM-CODE
o
SF ENRL TERM-DT
o
SF_ENRI, VOP
r,
SF ENRL WILL_PARTCPT_SRVY
o PTS Enrollments
o
PTS ENRL CALL SCHED
o
PTS_ENRL_CASE_MGR_NBR
o
PTS_ENRL.CLI_ID
o
PTS ENRL CONTRACT SIGNED
o
PTS ENRL CURFEW CHK
PTS_ENRL CURFEW_NOTES
o
PTS_ENRL, DCKT ID
o
PTS_ ENRL_EDUCATION_CHK
o
PTS ENRL EDUCATION NOTES
o
PTS ENRL ELECT MONITOR CHK
o
PTS_ENRL_ELECT_MONITOR_NOTES
o
PTS_ENRL_EMPLOYMEN'I'_CHK
o
PTS ENRL EMPLOYMENT_NOTES
o
PTS_ENRL ENRL D'1'
o
PTS_ENRL GPS_RERFERRAL_COMMENT
o
PTS ENRL ID
o
PTS ENRL_NO_ALCOHOL_CIIK
o
PTS ENRL NO CONTACT WITH CHK
o
PTS_ENRL_NO_RETURN CIIK
o
PTS ENRL NO WEAPONS CHK
o
PTS ENRL OP'T'ION TYPE
o
PTS_ENRL OTHER CHK
u
PTS_ENRL RANDOM_TESTING CHK
o
PTS ENRL RANDOM TESTING_NOTES
o
PTS ENRL_RA SCORE
o
PTS ENRL REFERRAL DT
c
PTS ENRL RELEASE DT
PTS ENRL, REL SIGNED
PTS_ENRL SERVICE CODE
o
PTS ENRL SUPV LEVEI,
,)
PTS_L'NRI,_SUPV_TYPE_CODE
o
P1'S_ENRL_SIJRR_DRIVERS_LIC_CHK
o
PTS ENRL TERM-CODE
o
PTS ENRL TERM DT
o
PTS ENRL TX PROGRAM_CHI<
o
PTS ENRL TX PROGRAM_NOTES
o
PTS ENRL UPDATED BY
o
PTS ENRL UPDATED DT
• Generic Enrollments
o
AIC-ENRL-CLI-ID
o
AIC ENRI._DCKT-.]D
o
AIC_ENRL_DT1000THER_TXT
o
AIC ENRL_ENRL DT
o
AIC ENRL_ENTRY_DT
o
AIC-ENRL-FEE-STATUS
o
AIC_ ENRL_FUNDED_TESTG
o
AIC ENRL FUNDED TES'PG_END_DT
o
AIC ENRL FUNDED_TESTG_STARTDT
o
AIC ENRL ID
o
AIC_ENRL_ILODAYS
o
AIC ENRL LEIN
C,
AIC ENRL PRBTN OFFCR
o
AIC ENRL-REFERRAL-DT
o
AIC-ENRL-REFERRAL-SOURCE-CODE
o
AIC _ENRL_SERVICE. CODE
o
AIC_ ENRL_SERVICE_FEE
n
AIC ENRL SITE
o
AIC_ENRL_TERM_CODE
n
AIC _ENRL TERM-DT
o
AIC ENRL TEST BEGIN_DT
o
AIC_ ENRL _TEST_CASE_MGR_NBR
o
AIC ENRL TEST DRT
o
AIC_ENRL_TES'I'_ETG
,,
AIC_ ENRL_TEST_FREQ.DRT
o
A1C_ENRL_TEST_FREQ_ETG
o
AIC_ ENRL_TES'I'_FREQ_PBT
o
AIC_ENRL_`l'EST_FREQ_PER_DRT_CD
n
A1C_ENRL_TEST_FREQ_PER_DRT_0'1'I1
o
AIC CNRL_TEST_FREQ_PER_DRT_TXT
o
AIC_ENRL_TEST_FREQ_PER_ETG_CD
o
AIC_ENRL_TEST_FREQ_PER_ETG_OTH
o
AIC_ENRL_'1'EST_FREQ_PER_ETG_TXT
o
AIC_ ENRL_ TEST_FREQ, PER _PBT _CD
o
AIC-ENRL _'I'EST_FREQ_PER_PBT_OTH
u
AIC _ENRL_TES'I'_FREQ_PER_PBT_TXT
o
AIC ENRL-TEST-PBT
n
AIC ENRL TEST PROGRAM
o
AIC ENRL TST LOC CODE
o
AIC-.ENRL-UPDATED-DT
n
AIC ENRL VOP
• RESULTS
Enrollments (CCMDRUG_TSTG_TB)
u
DRUG _TSTG. CASE_MGR_NBR
u
DRUG_TSTG_CLI_ID
o
DRUG TSTG DCKT Ill
o
DRUG TSTG ENRLD__BY
o
DRUG_TSTG ENRLD DT
u
DRUG TSTG ENTRY DT
o
DRUG_TSTG_FUNDED
o
DRUG TSTG FUNDED END DT
DRUG TSTG FUNDEll SOURCE
o
DRUG TSTG_FUNDED_START_DT
o
DRUG TSTG_ID
o
DRUG TSTG NOTE
o
DRUG 'PSTG ON'TIME
DRUG_TSTG REFERRAL DT
o
DRUG TSTG_REFERRALSOURCE_CODE
o
DRUG TSTG SERVICE_CODE
o
DRUG TSTG_SITE
o
DRUG TSTG TERMD BY
o
DRUG_TSTG_TERM_CODE
o
DRUG _TSTG TERM DT
o
DRUG TSTG UPDATED_DT
® WWAM
Enrollments
o
WWAM .ENRI._ASSIGNED _WWAM-DAYS
o
WWAM ENRL CLI D
o
WWAM_ENRL CMPLTll WWAM_DAYS
o
WWAM_ENRL DCKT ID
o
WWAM ENRL ENRL DT
o
WWAM ENRL ENTRY DT
o
WWAM_ENRI._FINAL_SENTENCED_DAYS
o
WWAM_ENRL ID
o
WWAM-ENRL-MISSED-WWAM-DAYS
o
WWAM_ENRI._PROJ_COMPL_DT
u
WWAM ENRL REFERRAL DT
o
WWAM_ENRL_REINSTATEMEN'l'_D'I'
o
WWAM_ENRL_SENTENCED _WWAM-DAYS
o
WWAM-ENRL-SERVICE-CODE
o
WWAM-ENRL-TERM-CODE
o
WWAM ENRL TERM -COMMENTS
o
WWAM ENRL TERM DT
WWAM-ENRLTERM REASON
o
WWAM_ENRL TOTAL COMPI,TD_DAYS
o
WWAM ENRL UPDATED_DT
o
WWAM ENRL VOP
Include:
all enrollment data
o Do Not include the enroliment notes)
Do Not include the data firom Page 2 of the SF Intake and Assessment
® all docket data CCM_DCKT_TB)
o DCKT_ARREST_DT
o DCKT_BOUND_OVER
o DCKT CHARGE_PACC_CODE
DCKT CLl ID
u
DCKT-COURT-ID
DCKTCRIME CLASS_TYPE
C DCKT DISPOSITION
u DCKT DISP DT
o DCI<T_ENTRY_DT
o DCKT-FIRST-OFFENSE
o DCKT ID
o DCKT_JUDGE_ID
u DCKT LEGAL -STATUS
o DCKT NBR
0 DCKT_NEXT_COURT_DT
C) DCKTORIGINAL DOCKET
o DCKT OV
o DCKT PPO VIOLATOR
o DCKT PRIMARY -DOCKET
o DCKT PRV
o DCKT REFERRING_AGENT_CODE
o DCKT-SENTENCE-TYPE
o DCKT_SENT_CHARGE_PACC CODE
o DCKT SGL_MIN_MAX
u DCKT SGL MIN_MIN
o DCI<T_SGL_NA
u DCKT STAT MAX
u DCKT'l'YPE OF HEARING
o DCKT-UPDATED-DT
+ drug, pbt and etg records >=1/1/18 (CCM_ CLI_CAL_TB for 1, 2 and 8)
n CLI_CAL..CLI_ID
o CLl_CAL_DOCKET_11)
o CLI_CAL ENTRY DT
o CLI -CAL -EVENT -DT
o CLI_CAL_EVENT_STATUS
o CLI CAL EVFNT TIME
n CLI -CAL -EVENT _TYPE
o CLI_CAL ID
o CLI CAL INFO 1
u CLI CAL_INFO_2
u CLI CAL_1NF0 3
o CLI CAL INFO 4
n CLI CAL MANUALLY -ENTERED
u CLI CAL -UPDATED -DT
• all calendar events (CCM_CLI_CAL_TB -Do Not include CLI CAL EVEN'I'_DT for
WWAM dates (5, 6, 10, 50, 51))
o CLI CAL CLI ID
o CLI CAL DOCKET ID
o CLl CAL ENTRY__DT
o
CLI _CAL -EVENT -DT
o
CLI -CAL -EVENT -STATUS
o CLI -CAL -EVENT TIME
o CLI_CAL EVENT TYPE
o CLI CAL ID
o CL]_CAL INFO 1
o CLI CAL_INFO 2
o CLI CAL INFO 3
o CLI CAL INFO 4
o CLI CAL MANUALLY ENTERED
o CLI CAL UPDATED DT
• SF Group enrollments where referral is >=1/1/18 (CCM_(;RP_MMBR_'1'B)
o GRP MMBR CALL SCHED
o GRP MMBR_CLI ID
o GRP MMBR. DLI RATION
c GRP MMBR ENRI, DATE
o GRP MMBR GRP_ID
o GRP MMBR ID
o GRP_ MMBR_PROjCTD_END_DATE
o GRP MMBR REFERRAL DATE
o GRP MMBR TERM -CODE
o GRP MMBR TERM DATE
• Group Checkin data >=1/1/18 (CCM_GRP_CHKIN_TB)
GRP CHKIN_DT TIME
o GRP CHKIN_GRP_MMBR_ID
o GRP CHK1N_ID
o GRP CHKIN_METH
o GRP CHKIN_PBT
C) GRP CHI<IN SCIIED DT TIME
• Group Attendance data (CCM_GRP_ATTEN_TB)
u GRP_ATTEN_CLI ID
o GRP ATTEN_D'I"TIME
o GRP _ATTEN_GRP _ID
o GRP _ATTEN_ID
o GRP ATTEN SHOWED UP
• NEEDS data from COMPAS for TX plan (CCM_SF_CASEPLAN_NEED .TB -add need
desc instead of number or code)
o CASEPLAN_NEED_ACTIVEIND
n CASEPLAN NEED ASSMT NEED ID
o CASEPLAN_NEED_CASEPLAN_ID
o CASEPLAN_NEED_ENTRY_DT
c CASEPLAN_NEED_SYSID
• CASEPLAN NEED_UPDA'rED_DT
• List of Needs (CCM -SF -NEED -TB)
o SF NEED_ACTIVE..IND
c SF-NEED-,DESC
o SF NEED ENTRY UT
n SF NEED SYSID
o SF NEED -UPDATED -DT
• Goals Data (CCM_SF_CASEPLAN_GOAL_'I'B - add goal desc instead of number or
code)
c CASEPLAN GOAL ACTIVE_IND
o CASEPLAN_GOAL_CODE
o CASEPLAN_GOAL_ENTRY_DT
o CASEPLAN_GOAL FREEFORM_DESC
o CASEPLAN GOAL_FREEFORM_IND
o CASEPLAN_GOAL_NEED_ID
ID CASEPLAN_GOAL_SYSID
c CASEPLAN GOAL UPDATED_DT
• List of Goals (CCM -SF -GOAL -TB)
o SF_GOAL_ACTIVE_IND
o SF GOAL DESC
o SFGOAL ENTRY_DT
o SF_GOAL SYSID
o SF -GOAL -UPDATED -DT
• Tasks Data (CCM_SP CASEPLAN_'rASK_TB - add task desc instead of number or
code)
c, CASEPLAN_TASK-ACTIVE _IND
o CASEPLAN_TASK_CODE
n CASEPLAN_TASIi DRIVER
c CASEPLAN TASK DRIVER -OTHER
o CASEPLAN_TASK_END_DT
o CASE PLAN JASK_ENTRY_DT
n CASEPLAN TASK FREEFORM_DESC
o CASEPLAN_TASK_FREEFORM_IND
o CASEPLAN TASK FREEFORM_INST
o CASEPLAN_TASK_GOAL_ID
o CASEPLAN_TASK NONEDTBLE_NOTES
o CASE PLAN -TAS K S'I'ART_DT
o CASEPLAN_TASK_SYSID
C, CASEPLAN TASK UPDATED_DT
• List orrask (CCM_SF'_TASK _TB)
o SF TASK AC'rIVE_IND
o SF TASK DESC
o SF TASK ENTRY DT
o SF TASK INSTRUC
o SF TASK SYSID
SF -TASK -UPDATED -DT
Treatment Plan (CCM_SF_CASEPLAN_ASSMT_TB)
o CASEPLAN _ASSMT_ACTIVE_IND
u CASEPLAN ASSMT CASE_MGR_NBR
o CASEPLAN _ASSMT CLI ID
n CASEPLAN ASSMT END DT
o CASEPLAN_ASSMT_ENTRY_DT
o CASEPLAN ASSMT_NEED_CLI_SYSID
o
CASEPLAN _ASSMT_START_DT
CASEPLAN ASSMTSYSID
o CASEPLAN_ASSMT_TERM_CODE
o CASEPLAN ASSMT_ TXPLAN_DCK'1'_ID
o CASEPLANASSMT'_UPDATED_DT
AND include client data where the PRAXIS Entry date is >=1/1 /18
® Include all PRAXIS Data (CCM_PRAXIS_ASSM'I'_'PB - include name/desc of the factor
instead of number or code)
n PRAXIS_ASSMT 7655 STATUTE
o PRAXIS ASSMT ACCPTD 01
o PRAXIS ASSMT ACCPTD_02
n PRAXIS ASSMT ACCPTD 03
u PRAXIS_ASSMT ACCPTD 04
o PRAXIS ASSMT ACCPTD_05
o PRAXIS ASSMT_ACCPTD_06
o PRAXIS ASSMT ACCPTD 07
u PRAXIS_ASSMT_ACCP'l'D_08
n PRAXIS_ASSMT_ACCPTD_09
u PRAXIS_ASSMT_ACCP'I'D_10
o PRAXIS_ ASSMT_ ACCPTD_ 11
o PRAXIS_ ASSMT_ACCPTD_12
o PRAXIS_ ASSMT_ ACCPTD_ 13
n PRAXIS_ASSMT'_ACCPTD_14
u PRAXIS ASSMT ADDL CLIRGS
u 13RAXIS_ASSMT ADDL COMMEN'T'S
n PRAXIS_ASSMT ADDL CONSDERNI
o PRAXIS ASSMT ADDL CONSDERN2
o PRAXIS ASSMT ADDL CONSDERN3
o PRAXIS_ASSMT_ADDL_CONSDERN4
o PRAXIS ASSMTADDL CONSDERNS
n PRAXIS ASSMT ADDL CONSDERN6
o PRAXIS_ASSMT_APPEARANCE_DT
o PRAXIS ASSMTBAIT, AMT
PRAXIS ASSMT_CLI_ID
o PRAM SAS SM'I'_DCKT_ID
o PRAXIS_ASSM'I'_DFNDT-IN FO_VRFD
o PRAXIS _ASSMT_ELECT MONTR_NOTB
o PRAXIS_ASSMT_ENTRY_DT
o PRAXIS ASSMT EVEN'I'_1D
o PRAXIS ASSMT_FACTORI POINTS
o PRAXIS_ASSMT FACTOR2_POINTS
o PRAXIS ASSMT FACTOR3_POINTS
o PRAXIS_ASSMT_FACTOR4,_POIN'I'S
o PRAXIS_ASSNIT FACTORS_POINTS
o PRAXIS ASSMT FACTOR6_POINTS
o PRAXIS ASSMT_FACTOR7_POINTS
o PRAXIS_ASSM'l'_FACTO118_POINTS
o PRAXIS.ASSMT_FINL_BOND_TYPE_ID
o PRAXIS_ASSM'f_FNCL_BOND_'I'YPE_ID
PRAXIS_ASS MT_GRID_ID
PRAXIS_ASSMT INTERVIEWED_BY
o PRAXIS ASSMT INTERVIEWED_DT
n PRAXIS_ASSMT_JUDGE_ID
o PRAXIS ASSMT NO CONTACT_WITH
o PRAXIS_ASSMT_NO_OF_CNVCTD_OF'NS
o PRAXIS_ASSMT_OTHER_NOTE
o PRAXIS_ASSMT OVERRIDE
o PRAXIS ASSMT OVERRIDE-REASON
o PRAXIS ASSMT PACO CODE_ID
o PRAXIS_ASSMT_PRAXIS_NOT_USED
o PRAXIS_ASSMT_PRAXIS_SCORE
o PRAXIS ASSM'1'_RCMD_BOND_TYPE_I1)
o PRAXIS_ASSMT_RCMND-01
o PRAXIS_ASSMT_RCMND_02
u PRAXIS_ASSMT_RCMND_03
o PRAXIS_ ASSMT_RCMND_04
o PRAXIS_ASSMT_RCMND_O5
PRAXIS_ASSIVIT-RCMND Oe
o PRAXIS ASSMT RCMND_07
u PRAXIS_ASSMT_RCMND_08
PRAXIS ASSMT RCMND_09
o PRAXIS_ASSMT_RCMND_10
o PRAXIS ASSMT RCMND 11
o PRAXIS ASSMT RCMND 12
o PRAXIS_ASSM'l'MCMND_13
o PRAXIS ASSMT RCMND 14
PRAXIS ASSMT REPORT BY
o PRAXIS_ASSMT_SERVICE_CODE
PRAXIS ASSMT SUPV CHK
o PRAXIS ASSMT SYSID
o PRAXIS ASSMT UPDATED_DT
• Include all docket data associated with the PRAXIS — added in the docket table
Exclude
• Risk Assessment data
• Criminal History data
• SID Number from the client table
• FBI Number from the client table
• Bond Recommendation data
• RESULTS Profile data
• PTS Notes
• SF Notes
• Case Notes
• PTS Activity Report data
• SF Progress Report data
• AM Progress Report data
• WWAM Payments
• W WAM Site and Assignments
• Docket Victim data
• References data
• Demographic Notes (cli_tb)
Resolution #20231
July 2, 2020
Moved by Jackson seconded by Weipert the resolutions on the amended Consent Agenda be adopted
(with accompanying reports being accepted).
AYES: Hoffman, Jackson, Kochenderfer, Kowall, Kuhn, Long, Luebs, Markham, McGillivray,
Middleton, Miller, Nelson, Powell, Quarles, Spisz, Taub, Weipert, Woodward, Zack,
Gershenson. (20)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions on the amended Consent Agenda were adopted
(with accompanying reports being accepted).
"a'� �'Q c,
1 HEREBY APPROVE THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45,559A V)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and
accurate copy of a resolution adopted by the Oakland County Board of Commissioners on July 2, 2020,
with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac.
Michigan this 2nd day of July, 2020.
k�� ,11*we
Lisa Brown, Oakland County