EPI MOU WITH ADHS FOR DSA.PDF

MEMORANDUM OF UNDERSTANDING
HU756005
MEMORANDUM OF UNDERSTANDING
FOR THE SHARING OF PUBLIC HEALTH DATA
BETWEEN
THE ARIZONA DEPARTMENT OF HEALTH SERVICES
AND
MARICOPA COUNTY DEPARTMENT OF PUBLIC HEALTH
WHEREAS, the Arizona Department of Health Services (ADHS) is a division of the State of Arizona
established to promote and protect public health and welfare through the operation of health related
programs within the state.
WHEREAS, MARICOPA COUNTY DEPARTMENT OF PUBLIC HEALTH (MCDPH) is a division of
Maricopa County government established to promote and protect public health and welfare through the
operation of health related programs within the county.
WHEREAS, MCDPH is a public health authority pursuant to the requirements of the Health Insurance
Portability and Accountability Act of 1996 (Pub. L. 104-191) (HIPAA) and applicable law.
WHEREAS, ADHS and MCDPH recognize the need to set forth and define the terms under which ADHS
will provide data files to MCDPH containing public health records for the development of community health
profiles and other general public health surveillance activities and Public Health Practice performed by
MCDPH.
NOW, THEREFORE, in consideration of the mutual promises and representations set forth in this
Memorandum of Understanding (MOU), MCDPH and ADHS mutually agree as follows:
1. DEFINITIONS: Capitalized terms used herein shall have the meanings set forth in this
Section 1.
1.1. "Authorized Persons" means MCDPH employees or contractors who have a need to
know or otherwise access Personally Identifying Information to enable MCDPH to
perform its mission in conformance with the requirements of this MOU and who are
bound in writing by confidentiality obligations sufficient to protect Personally Identifying
Information in accordance with the terms and conditions of this MOU and applicable
law.
1.2. “Public Health Data” means health information organized and maintained by ADHS and
received by ADHS under applicable law, including, but not limited to, patient names,
mailing addresses and geocodes, dates of birth and death, gender, race, ethnicity,
discharge status, disease codes, procedures performed and other information reported to
ADHS under applicable law. The elements of data shared and specific restrictions of their
use under this MOU are fully described in sections 2.2 (Scope) and 19 (Data Use and
Ownership).
Page 1 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
1.3. "Personally Identifying Information" means information provided to the County by, or
at the direction of, ADHS that:
1.3.1. Identifies or can be used to identify an individual (including, without
limitation, names, signatures, addresses, telephone numbers, e-mail
addresses and other unique identifiers); or
1.3.2. Can be used to authenticate an individual (including, without limitation,
employee identification numbers, government-issued identification numbers,
passwords or PINs, financial account numbers, credit report information,
biometric or health data, answers to security questions and other personal
identifiers). ADHS’ business contact information is not by itself deemed to
be Personal Information.
1.4. “Protected Health Information (PHI)” means individually identifiable health information
including demographic information, or health information with respect to which there is a
reasonable basis to believe the information can be used to identify individuals, collected,
maintained or stored in any form (electronic or non-electronic), relating to the past,
present, or future physical or mental health or condition of an individual; the provision of
health care to an individual; or the past, present, or future payment for the provision of
health care to an individual. This excludes individually identifiable health information in
education records covered by the Family Educational Rights and Privacy Act, as
amended, 20 U.S.C. 1232g; records described at 20 U.S.C. 1232g(a)(4)(B)(iv); and
employment records held by a covered entity in its role as employer.
1.5. “Public Health Practice” means programs, projects, practices and interventions
designed solely to enhance the well-being of a specific subject population, and which
have reasonable expectation of success, including surveillance, needs assessments,
program evaluation, disease investigation, policy development and health education.
1.6. “Research” means a systematic investigation, including research development, testing
and evaluation, designed to develop or contribute to generalizable knowledge. Activities
which meet this definition constitute research for purposes of this MOU, whether or not
they are conducted or supported under a program which is considered research for other
purposes. For example, some demonstration and service programs may include research
activities.
1.7. "Security Breach" means: (i) any act or omission that materially compromises either
the security, confidentiality or integrity of Personally Identifying Information or the
physical, technical, administrative or organizational safeguards put in place by MCDPH
or any Authorized Persons that relate to the protection of the security, confidentiality or
integrity of Personal Information, or (ii) receipt of a complaint in relation to the privacy
practices of MCDPH or any Authorized Persons or a breach or alleged breach of this
MOU relating to such privacy practices.
2. PURPOSE AND SCOPE OF AGREEMENT:
2.1. Purpose:
Subject to availability of data and ADHS resources, ADHS agrees to provide MCDPH
with Public Health Data as defined in section 2.2.1 of this MOU in a mutually
agreeable format.
Page 2 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
2.2. Scope:
Section 2.1 notwithstanding, the Parties agree that MCDPH does not require, and ADHS
shall not provide MCDPH (except as required for public health activity) with data files
containing any of the following information related to any individual county resident: (i)
signatures, telephone numbers, e-mail addresses; (ii) employee identification numbers,
passwords or PINs, credit report information, answers to security questions and other
similar personal identifiers; (iii) individual's government-issued identification number
(including driver's license number or state-issued identified number); and (iv) financial
account number, credit card number, debit card number, credit report information, with or
without any required security code, access code, personal identification number or
password, that would permit access to an individual’s financial account or accounts.
2.2.1. Selection Criteria:
ADHS will select records to give to MCDPH if the record meets this criterion:
for residents within Maricopa County, registered within Maricopa County,
submitted by a facility within Maricopa County, or remains transported within
Maricopa County for inclusion. Data elements that ADHS will provide in the
data sets may include any data element permitted by this MOU and that is
specifically requested by MCDPH for inclusion.
2.2.2. Data Requests:
To request data MCDPH must submit a request in writing to ADHS.
Following initial release of data under this MOU, MCDPH may request
updated data as needed.
2.2.3. Data Shared:
The data that will be provided by ADHS to MCDPH under this MOU is
itemized in Exhibit A.
2.2.4. Data Transfer Methods:
The method of data sharing will be in a manner agreeable to ADHS and
MCDPH, and which meets the requirements of ADHS to assure the security
of the data as follows:
2.2.4.1. Encrypted file transfer using Secure File Transfer Protocol
(SFTP). The data file will be posted to a web accessible ADHS
server by ADHS, where it can be accessed only by MCDPH.
The MCDPH staff designated to access the SFTP file transfer
site must be Authorized Persons for the data element(s) they
receive, and must use an ADHS issued user id and secure
password to access the SFTP site.
Page 3 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
2.2.4.2. Direct Access to ADHS application software (front end) or
database tables (back end) by MCDPH staff who are designated
as Authorized Persons for the data element(s) they are
accessing. To utilize this method of access, MCDPH must
demonstrate that their IT network from which Authorized Users
will use Direct Access meets and maintains all of the
requirements determined by ADHS Information Technology to be
necessary for this type of access, and which conform to the
most current ADHS security standards.
2.3. Inadvertent Disclosure:
In the event that MCDPH is inadvertently provided with data files containing any of the
information listed in subsection 2.2, MCDPH will notify ADHS of the disclosure and
delete or destroy such data files upon ADHS’s request.
3. SUPERSESSION OF PAST AGREEMENTS:
This MOU is intended to and shall supersede or replace any currently valid MOU in place
between MCDPH and ADHS regarding the Public Health Data elements identified under section
2.2.3 and Exhibit A of this MOU.
4. TERM OF THE AGREEMENT:
The Term of this MOU shall commence upon signature of both parties and shall continue for a
period of five (5) years thereafter, unless terminated, or canceled as otherwise provided herein.
5. CONTRACT EXTENSION:
This MOU shall not exceed a total of five (5) years from the effective date of the MOU.
6. TERMINATION:
6.1. This MOU remains in effect as provided in Sections 4 and 5 or until the MOU is
otherwise terminated under the following terms and conditions:
6.1.1. Termination without Cause:
Both ADHS and MCDPH may terminate this MOU at any time with thirty
(30) calendar days’ notice, in writing, specifying the termination date. Such
notices shall be given by personal delivery or by certified mail, return receipt
requested.
6.1.2. Termination for Default:
The ADHS reserves the right to terminate the MOU in whole or in part due to
the failure of MCDPH to comply with any material obligation, term or
condition of this MOU. ADHS agrees to provide MCDPH with written
notice detailing the area of alleged lack of compliance or non-performance
and to provide MCDPH with thirty (30) days to correct the alleged lack of
compliance or non-performance prior to termination for default.
Page 4 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
6.1.3. Cancellation for Conflict of Interest:
Pursuant to A.R.S. § 38-511, ADHS may cancel this MOU within three
(3) years after MOU execution without penalty or further obligation if any
person significantly involved in initiating, negotiating, securing, drafting or
creating the MOU on behalf of ADHS is, or becomes at any time while
the MOU or an extension of the MOU are in effect, an employee of or a
consultant to any other party to this MOU with respect to the subject matter
of the MOU. The cancellation shall be effective upon receipt of the
written notice of cancellation, unless the notice specifies a later time.
7. SECURITY OF CONFIDENTIAL INFORMATION:
7.1. MCDPH shall monitor the use of all Public Health Data disclosed by ADHS under this
MOU, including but not limited to Personal Identifying Information, and to carefully restrict
the use and disclosure of such information as provided for herein.
7.2. Survival of Duty to Protect Confidential Information:
It is understood and agreed by the Parties that the obligations set forth in this Section 7,
shall survive the expiration or termination of this MOU, except as expressly provided for
herein.
7.3. Minimum Safeguards for Protected Health Information:
MCDPH shall carefully restrict use and access of ADHS Personally Identifying
Information solely to Authorized Persons and shall ensure that MCDPH implements the
following minimum safeguards to prevent a Security Breach in a manner consistent with
the requirements of this MOU or applicable law. MCDPH safeguards shall, at the
minimum, require that MCDPH and its Authorized Persons:
7.3.1. Prohibit Personally Identifying Information supplied under the terms of this
MOU from being released or disclosed to anyone not working on MCDPH
data collection and analysis as an Authorized Person.
7.3.2. Ensure that any Authorized Persons, including any agent, or subcontractor to
MCDPH, to whom MCDPH provides confidential medical information, or
Personally Identifying Information under this MOU, agrees to the same
restrictions and conditions that apply through this MOU to MCDPH with
respect to such information.
7.3.3. Secure all printouts containing individual identifiers or confidential data in a
locked vault, file cabinet or other method reasonably necessary to protect
the confidential information.
7.3.4. Store all Public Health Data shared pursuant to this MOU only on secured
servers or encrypted devices within M C D P H , which, at the termination of
this MOU, shall be securely deleted upon the conclusion of this MOU
consistent with the requirements of this MOU and applicable law.
Page 5 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
7.3.5. Provide ADHS with a description of the security measures that are in place to
maintain the confidentiality of the data being received under this MOU.
MCDPH will consider the items described in the document titled "Security
Considerations for Applicants" prepared by the ADHS HSRB (See
http://www.azdhs.gov/ops/oacr/documents/HSRB_SecurityChecklist.pdf).
7.3.6. Provide ADHS, upon request, with a current list of Authorized Persons, and
evidence that all Authorized Persons who have access to the Public
Health Data shared under this MOU have participated in any required
training and signed any documents that are necessary to keep both MCDPH
and ADHS in compliance with HIPAA, including but not limited to, Business
Associate Agreement, user confidentiality affirmation statement, HIPAA
training certification or other HIPAA related compliance documents, if
applicable.
7.3.7. Provide or continue to provide the ADHS with a copy of MCDPH's procedure
for the notification of ADHS of any Security Breach, which shall include a
requirement that any user of the Public Health Data shared under this MOU
shall immediately notify a designated individual at MCDPH of any known or
reasonably suspected Security Breach.
7.3.8. Maintain a log of all encrypted devices and identification numbers of those
devices that are authorized to transmit, receive or store the Public Health
Data shared under this MOU, until the data is destroyed. The ADHS may
request a copy of the log at any time during the term of the MOU or
until the data is destroyed.
7.3.9. Make clear to all Authorized Persons and other M C D P H employees
with a need to know that M C D P H is prohibited from storing Public
Health Data on non-encrypted flash drives, CDs, external drives, smart
phones or other non- networked hard drives.
7.3.10. Provide ADHS prompt proof of the complete destruction of the original data
and any copies or subsidiary data sets containing Personally Identifying
Information that are developed from the original data upon the conclusion of
this MOU or at such time that such destruction is required by applicable law.
7.3.11. Take all reasonable steps to ensure that Authorized Persons who have
access to the Public Health Data shared under this MOU shall maintain the
same in strict confidence after the termination of this MOU; provided that
MCDPH’s obligations hereunder shall not apply to information that:
7.3.11.1. Was already known to the receiving party prior to the time of
first disclosure, as demonstrated by contemporaneous, written
documentation; or
7.3.11.2. Is received without any obligation of confidentiality from a third
party having a legal right to disclose the same; or
7.3.11.3. Is independently developed by the receiving party by individuals
without access to such information, as demonstrated by
contemporaneous, written documentation; or
Page 6 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
7.3.11.4. Is required to be disclosed by the receiving party pursuant
to a legally enforceable order, subpoena, or other regulation
(ORDER), provided, however, that the receiving party promptly
notifies the disclosing party In advance of such disclosure and
discloses only that information necessary to comply with said
ORDER.
7.4. Security Breach:
In the event of a Security Breach, pursuant to A.R.S. § 44-7501, MCDPH and ADHS
agree to collaborate with each other on the investigation, mitigation, remediation and,
if necessary, breach notification of citizens. Pursuant to A.R.S. § 41-3507, MCDPH
and ADHS shall notify the Arizona Strategic Enterprise Technology (ASET) Statewide
Information Security and Privacy Office (SISPO) immediately upon becoming aware or
receiving notice of a Security Breach.
8. NON-DISCRIMINATION:
The Parties shall comply with Executive Order 75-5 as modified by Executive Order 2009-09,
which mandates that all persons, regardless of race, color, religion, sex, age, national origin or
political affiliation, shall have equal access to employment opportunities, and all other
applicable State and Federal employment laws, rules, and regulations, including the Americans
with Disabilities Act. The Parties shall take affirmative action to ensure that applicants for
employment and employees are not discriminated against due to race, creed, color, religion,
sex, national origin or disability.
9. RECORDS AND RIGHT OF INSPECTION:
Under A.R.S. § 35-214 and § 35-215, M C D P H shall retain all data and other records
(“records”) relating to the MOU for a period of five (5) years after the completion of the
MOU. All records shall be subject to inspection and audit by ADHS at reasonable times.
MCDPH shall provide ADHS the right of access to MCDPH and those servers or drives used
for the storage of Personally Identifying Information, at all reasonable times, in order to monitor
and evaluate performance, compliance, and/or quality assurance under this MOU.
10. ARBITRATION:
The parties to this MOU agree to resolve all disputes arising out of or relating to this MOU,
after exhausting applicable administrative review, through arbitration to the extent required by
A.R.S. §12-1518.
11. AMENDMENT OR MODIFICATIONS:
No amendment or modifications to this MOU, including any amendment or modification of this
Section, shall be effective unless the same is in writing signed by the Parties.
12. ARIZONA LAW:
The law of Arizona applies to this MOU including, where applicable, the Uniform Commercial
Code as adopted by the State of Arizona.
Page 7 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
13. RELATIONSHIP OF PARTIES:
MCDPH warrants that it is acting as an independent entity under this MOU. Neither party to
this MOU shall be deemed to be the employee or agent of the other party to the MOU.
14. SEVERABILITY:
The Provisions of this MOU are severable. Any term or condition deemed illegal or invalid
shall not affect any other term or condition of the MOU.
15. NO PAROLE EVIDENCE:
This MOU is intended by the parties to be a final and complete expression of their agreement.
No course of prior dealings between the parties and no usage of the trade shall
supplement or explain any terms used in this document.
16. NO WAIVER:
Either Party’s failure to insist on strict performance of any term or condition of the MOU shall not
be deemed a waiver of that term or condition even if the party accepting or acquiescing in the
nonconforming performance knows of the nature of the performance and fails to object to it.
17. HEADINGS:
Headings are for organizational purposes only and shall not be interpreted as having legal
significance or meaning.
18. ADVERTISING AND PROMOTION OF CONTRACT:
MCDPH shall not advertise, publish, or re-release any information for commercial benefit
concerning this MOU without the prior written approval of an ADHS Procurement Officer and the
ADHS Human Subject Review Board (HSRB).
19. DATA USE AND OWNERSHIP:
19.1. MCDPH will use the Public Health Data shared under this MOU exclusively for Public
Health Practice as defined in Section 1.5.
19.2. MCDPH must request approval from ADHS HSRB to use data for the development of
research studies as defined in Section 1.6. If it is unclear to MCDPH whether the use of
Public Health Data is research or public health practice or both, then MCDPH must
request clarification from ADHS HSRB.
19.3. If ownership in Section 2.2.3 and Exhibit A is designated to ADHS, MCDPH activities
using the ADHS data that generate external papers or publications for dissemination
outside of MCDPH, (excluding routine reports and those requested by local partners,
including but not limited to the annual Health Status Report and data requests from the
Board of Supervisors, Law Enforcement, and other public health stakeholders), MCDPH
must provide those materials to the data owner at ADHS for review and clearance before
release. MCDPH shall allow a reasonable time frame for ADHS review (30 calendar
days is preferred).
Page 8 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
19.4. If ownership in Section 2.2.3 is designated to ADHS, ADHS shall be cited as the source of
the data in all tables, reports, presentations, and scientific papers, and MCDPH or its
corresponding authors shall be cited as the source of interpretations, calculations, and/or
manipulations of the data.
19.5. Publication of any kind by either ADHS or MCDPH that includes tribal affiliation and uses
data shared under this agreement shall require prior consent of the appropriate tribal
authority.
19.6. If ownership in section 2.2.3 is designated to ADHS, ADHS retains exclusive ownership of
the Public Health Data, shared with MCDPH under this MOU, whether housed in the
ADHS server, or downloaded to MCDPH computers or storage. Any release, or modified
re-release of Public Health Data designated as owned by ADHS and shared under this
MOU requires prior ADHS approval.
19.7. If ownership in section 2.2.3 is designated to MCDPH, then the data become the
exclusive ownership of MCDPH only when downloaded or extracted from the ADHS
server in which the data are housed by MCDPH.
20. NOTICES, CORRESPONDENCE AND REPORTS:
20.1. Notices, correspondence and reports from MCDPH to ADHS shall be sent to:
Arizona Department of Health Services
Attn. Public Health Data Sharing, Bureau of Public Health Statistics
150 N. 18th Avenue, Suite 550
Phoenix, AZ 85007
Phone: (602)542-8064
20.2. Notices, correspondence, and reports from ADHS to MCDPH shall be sent to:
Maricopa County Department of Public Health
Attn: MCDPH Director
4041 North Central St. #1400
Phoenix, AZ 85334
Phone: 602-506-6900
21. Signatures/Approvals:
FOR: Maricopa County FOR: Arizona Department of Health Services:
by and through its Department of
Public Health
_________________________Sign _______________________________________
Mr. Tracey Thomas
Acting Chief Procurement Officer
_________________________Print
Chairman, Board of Supervisors
_________________________________ _______________________________________
Date Date
ATTEST:______________________________
Clerk of the Board
APPROVED as to FORM:________________
Attorney for Maricopa County Page 9 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT A – DATA ELEMENTS SHARED
DATA SET Owner PII PHI County Principle Custodial Allowed Purpose HSRB Attachments
Program
Vital Records ADHS Y N Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit B
Births
Vital Records ADHS Y N Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit C
Death
Vital Records ADHS Y N Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit D
Fetal Death
Hospital ADHS Y Y Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit E
Discharge Data
BRFSS ADHS Y N Dr. Bob England MCDPH Public Health Qualifying Activity ADHS Exhibit F
MEDSIS MCDPH Y Y Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit G
Sexually MCDPH Y Y Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit H
Transmitted
Diseases Data
(PRISM)
Immunization ADHS Y Y Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit I
Data
HIV Data ADHS Y Y Tom Mickey MCDPH Public Health Qualifying Activity ADHS* Exhibit J
(EHARS)
Arizona State ADHS Y Y Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit K
Trauma Registry
Data
Vital Records ADHS Y Y Dr. Bob England MCDPH Administrative Operations Support N/A Exhibit L
CSMS Data
Birth Defects ADHS Y Y Dr. Bob England MCDPH Public Health Qualifying Activity under N/A Exhibit M
Registry Data contract to ADHS
Cancer Registry ADHS Y Y Dr. Bob England MCDPH Public Health Qualifying Activity under N/A Exhibit N
Data contract to ADHS
AZ-PIERS ADHS Y Y Dr. Bob England MCDPH Public Health Qualifying Activity ADHS* Exhibit O & O2
*HSRB review is required for research uses, but not for Public Health Practice.
Page 10 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT B – VITAL RECORDS BIRTHS DATA SET
Fields shared:
All included in pii data file.
Frequency of Data Sharing:
PII Year-To-Date data file provided via encrypted Secure File Transfer Protocol (SFTP) or PII data provided
through direct database link on a scheduled frequency as requested by MCDPH. A designated contact at
the County will be granted credentials for SFTP access to the ADHS SFTP server to facilitate data transfer,
or a direct access link and query defined to pull data appropriate for the county.
Allowable Data Uses:
Public Health uses including surveillance, assessments, quality controls, interventions, and other public
health related activity.
Data Query Code Used:
libname brth oracle path="vtrain1" schema=H16BIRTH user=&orauser. password=&ORAPSWD. readbuff=5000
multi_datasrc_opt=in_clause read_lock_type=nolock dbindex=YES access=readonly;
libname bth '\\VITALRECORDS\DATA\BIRTH-PII\DEVO\CDR';
data datetime;
y2="'"||strip(put(year(intnx('year',today(),-1,'end')),4.))||"'";
y1="'"||strip(put(year(intnx('year',today(),-0,'end')),4.))||"'";
y3=input(strip(put((year(today())-1),4.)),best12.);
call symput('YRN',y3);
call symput('YRT',y2);
call symput('YRT2',y1);
run;
/*Birth*/
data work.Birth;
set brth.h16birth_2003;
where ci_birth_year in (&YRT2., &YRT.) and sequence_number=1;
MODIFICATION_COMMENTS=Compress(MODIFICATION_COMMENTS,'0D0A'x);
run;
data work.birth_medical;
set brth.h16medical_2003;
proc sort data=work.birth_medical;
by state_certnum sequence_number;
run;
proc sql _method outobs=max feedback SORTMSG;
CREATE TABLE work.birth_source
as select a.*, B.MR_DIABETES_PRE_PREG_PRIOR, B.MR_DIABETES_GEST, B.MR_HYPER_PRE_PREG_CHRONIC,
Page 11 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
B.MR_HYPER_GEST_PIH, B.MR_HYPER_ECLAMPSIA,
B.MR_PREV_PRETERM_BIRTH, B.MR_OTHER_POOR_PREG_OUTCOMES, B.MR_OTHER_PREG_INFERTILITY,
B.MR_OTHER_FERTILITY_DRUGS, B.MR_OTHER_ASSIST_TECHNOLOGY,
B.MR_OTHER_NONE, B.MR_PREV_CESAREAN_DELIVERY, B.MR_NBR_CESAREAN_DELIVERIES,
B.MR_INFECTIONS_GONORRHEA, B.MR_INFECTIONS_SYPHILLIS,
B.MR_INFECTIONS_CHLAMYDIA, B.MR_INFECTIONS_HEPATITISB, B.MR_INFECTIONS_HEPATITISC,
B.MR_INFECTIONS_NONE, B.OL_PRE_RUPTURE_MEMBRANES,
B.OL_PRECIPITOUS_LABOR, B.OL_PROLONGED_LABOR, B.OL_NONE, B.CL_INDUCTION_OF_LABOR,
B.CL_AUGMENTATION_OF_LABOR, B.CL_NON_VERTEX_PRESENTATION,
B.CL_STEROIDS, B.CL_ANTIBIOTICS, B.CL_CLINICAL_CHORIOANMIONITIS, B.CL_MECONIUM_STAINING,
B.CL_FETAL_INTOLERANCE, B.CL_EPIDURAL, B.CL_NONE,
B.CL_MORBID_MAT_TRANSFUSION, B.CL_MORBID_3RD_4TH_DEGREE_LAC, B.CL_RUPTURED_UTERUS,
B.CL_MORBID_UNPLANNED_HYST, B.CL_MORBID_ADMIN_ICU,
B.CL_MORBID_UNPLANNED_OR_PROC, B.CL_MORBID_NONE, B.CA_ANENCEPHALY, B.CA_MENINGOMYELOCELE,
B.CA_CYANOTIC_CONG_HD, B.CA_CONG_DIAPH_HERNIA,
B.CA_OMPHALOCELE, B.CA_GASTROSCHISIS, B.CA_LIMB_REDUCT_DEFECT, B.CA_CLEFT_LIP, B.CA_CLEFT_PALATE,
B.CA_DOWN_SYNDROME, B.CA_DOWN_KAR_CONFIRMED,
B.CA_DOWN_KAR_PENDING, B.CA_SUSP_CHROMO_DIS_CONF, B.CA_SUSP_KAR_CONFIRMED,
B.CA_SUSP_KAR_PENDING, B.CA_HYPOSPADIAS, B.CA_UNKNOWN, B.CA_NONE,
B.OB_CERVICAL_CERCLAGE, B.OB_TOCOLYSIS, B.OB_EXT_CEPHALIC_VERSION_SUCC,
B.OB_EXT_CEPH_VERSION_FAILED, B.OB_NONE, B.MD_ATTEMPTED_FORCEPS,
B.MD_ATTEMPTED_VACUUM, B.MD_FETAL_PRESENTATION, B.MD_FINAL_ROUTE_DELIV_METHOD,
B.MD_TRIAL_OF_LABOR_ATTEMPTED, B.MD_PREV_CESAREAN_DELIVERY,
B.MD_NBR_CESAREAN_DELIVERIES, B.AB_ASSIST_VENT_IMMED, B.AB_ASSIST_VENT_GT_6HOURS,
B.AB_NICU_ADMISSION, B.AB_SURFACTANT_REPL_THERAPY,
B.AB_ANTIBIOTICS_SEPSIS, B.AB_SEIZURE_SER_NEURO_DYS, B.AB_SIG_BRAIN_INJURY,
B.AB_SIG_BRAIN_INJURY_DESC, B.AB_NONE, B.CS_SMOKED_CIGARETTES,
B.CS_AVG_CIGARETTES_3MONTHS_PREV, B.CS_AVG_CIGARETTES_1ST_3MONTHS,
B.CS_AVG_CIGARETTES_2ND_3MONTHS, B.CS_AVG_CIGARETTES_LAST_3MONTHS,
B.MHW_MOTHER_HEIGHT_FEET, B.MHW_MOTHER_HEIGHT_INCHES, B.MHW_PRE_PREG_WEIGHT,
B.MHW_AT_DELIVERY_WEIGHT, B.MHW_REQ_DATA_UNK, B.IM_VACCINATION1_TYPE_DESC,
B.IM_VACCINATION1_DATE, B.IM_INJECTION_SITE_DESC_1, B.IM_VACCINATION_LOT_ID_1, B.IM_MFG_NAME_1,
B.IM_PROVIDER_NAME_1, B.IM_PROVIDER_TITLE_DESC_1,
B.IM_VACCINATION2_TYPE_DESC, B.IM_VACCINATION2_DATE, B.IM_INJECTION_SITE_DESC_2,
B.IM_VACCINATION_LOT_ID_2, B.IM_MFG_NAME_2, B.IM_PROVIDER_NAME_2,
B.IM_PROVIDER_TITLE_DESC_2, B.IM_CHILD_MED_REC_NBR, B.IM_MOTHER_MED_REC_NO, B.MR_DIABETES,
B.MR_HYPERTENSION, B.OB_EXT_CEPHALIC_VERSION, B.OL_UNKNOWN
from work.birth a left join work.birth_medical b
on a.state_certnum=b.state_certnum
and a.sequence_number=b.sequence_number;
quit;
%MACRO REPORTS (COUNTY);
/* BIRTH DATASET BY COUNTY */
PROC SQL;
CREATE TABLE bth.&FN1. AS
SELECT *
FROM work.BIRTH_SOURCE
Page 12 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
WHERE year(intnx('month',today(),-1,'end'))=input(ci_birth_year,4.) AND
(MA_MOTHER_RESID_COUNTY_DESC=&COUNTY. OR CI_COUNTY_NAME=&COUNTY.);
QUIT;
proc export data=dbth.&fn1. outfile=&path1.
dbms = csv replace;
quit;
%MEND;
%REPORTS (MARICOPA);
Page 13 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT C – VITAL RECORDS DEATH DATA SET
Fields shared:
All included in pii data file.
Frequency of Data Sharing:
PII Year-To-Date data file provided via encrypted Secure File Transfer Protocol (SFTP) or PII data provided
through direct database link on a scheduled frequency as requested by MCDPH. A designated contact at
the County will be granted credentials for SFTP access to the ADHS SFTP server to facilitate data transfer,
or a direct access link and query defined to pull data appropriate for the county.
Allowable Data Uses:
Public Health uses including surveillance, assessments, quality controls, interventions, and other public
health related activity.
Data Query Code Used:
libname deth oracle path="vtrain1" schema=AZ_VSIMS_full user=&orauser. password=&ORAPSWD.
readbuff=5000 multi_datasrc_opt=in_clause read_lock_type=nolock dbindex=YES access=readonly;
libname dth '\\VITALRECORDS\DATA\DEATH -PII\DEVO\CDR';
data datetime;
y2="'"||strip(put(year(intnx('year',today(),-1,'end')),4.))||"'";
y1="'"||strip(put(year(intnx('year',today(),-0,'end')),4.))||"'";
y3=input(strip(put((year(today())-1),4.)),best12.);
call symput('YRN',y3);
call symput('YRT',y2);
call symput('YRT2',y1);
run;
/*Death*/
data work.death_source;
set deth.Az_vsims_death_confid_tb;
WHERE death_book_year>=&YRN.;
CDC_II=Compress(CDC_II,'0D0A'x);
CDC_INJURYDESC=compress(CDC_INJURYDESC,'0D0A'x);
Run;
/* imports race and ethnicity information for both ADOA and Big Book methods of bridging the categories */
proc sql _method outobs=max feedback SORTMSG;
CREATE TABLE race AS
select a.CERT_AMEND_NDX_NO, a.CERT_SEQ, a.CERT_FILE_NO, a.CERT_FNAME, a.CERT_MNAME,
a.CERT_LNAME, a.CERT_SEX_GENX_CODE,
datepart(a.CERT_DOD) as cert_dod format date9., a.CERT_DOB, b.MC_CODE_ID, b.MC_SEQ, b.MC_MCT_SEQ,
Page 14 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
b.MC_PROMPT, c.MCI_SEQ, c.MCI_MC_SEQ, c.MCI_DATA_SEQ
from deth.dth_certificates a, deth.vsb_master_codes b, deth.vsb_master_code_intersects c
where c.MCI_DATA_SEQ = a.CERT_SEQ
AND b.MC_SEQ = c.MCI_MC_SEQ
AND b.MC_MCT_SEQ = 761
AND intnx('year',today(),-1,'beginning')<=datepart(a.CERT_DOD)
AND CERT_AMEND_NDX_NO in (9999, .)
ORDER by CERT_FILE_NO;
quit;
proc sql _method outobs=max feedback SORTMSG;
CREATE TABLE ORIGIN AS
select a.CERT_AMEND_NDX_NO, a.CERT_SEQ, a.CERT_FILE_NO, a.CERT_FNAME, a.CERT_MNAME,
a.CERT_LNAME, a.CERT_SEX_GENX_CODE,
datepart(a.CERT_DOD)as cert_dod format date9., a.CERT_DOB, b.MC_CODE_ID, b.MC_SEQ, b.MC_MCT_SEQ,
b.MC_PROMPT, c.MCI_SEQ, c.MCI_MC_SEQ, c.MCI_DATA_SEQ
from deth.dth_certificates a, deth.vsb_master_codes b, deth.vsb_master_code_intersects c
where c.MCI_DATA_SEQ = a.CERT_SEQ
AND b.MC_SEQ = c.MCI_MC_SEQ
AND b.MC_MCT_SEQ = 762
AND intnx('year',today(),-1,'beginning')<=datepart(a.CERT_DOD)
AND CERT_AMEND_NDX_NO in (9999, .)
ORDER by CERT_FILE_NO;
quit;
DATA ORIGIN_3 (keep=cert_file_no O_Cuban O_Mexican_American_Chicano O_Not_Obtainable
O_Not_Spanish_Hispanic_or_Latino O_Other O_Puerto_Rican
O_Refused O_Specify O_Unknown);
retain O_Cuban O_Mexican_American_Chicano O_Not_Obtainable O_Not_Spanish_Hispanic_or_Latino O_Other
O_Puerto_Rican O_Refused O_Specify O_Unknown;
set ORIGIN;
by cert_file_no;
if first.cert_file_no then do;
O_Cuban=0;
O_Mexican_American_Chicano=0;
O_Not_Obtainable=0;
O_Not_Spanish_Hispanic_or_Latino=0;
O_Other=0;
O_Puerto_Rican=0;
O_Refused=0;
O_Specify=0;
O_Unknown=0;
end;
if mc_prompt='Cuban' then do;
O_Cuban=1;
END;
if mc_prompt='Mexican, Mexican American, Chicano' then do;
O_Mexican_American_Chicano=1;
END;
if mc_prompt='Not Obtainable' then do;
Page 15 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
O_Not_Obtainable=1;
END;
if mc_prompt='Not Spanish, Hispanic, or Latino' then do;
O_Not_Spanish_Hispanic_or_Latino=1;
END;
if mc_prompt='Other' then do;
O_Other=1;
END;
if mc_prompt='Puerto Rican' then do;
O_Puerto_Rican=1;
END;
if mc_prompt='Refused' then do;
O_Refused=1;
END;
if mc_prompt='Specify' then do;
O_Specify=1;
END;
if mc_prompt='Unknown' then do;
O_Unknown=1;
END;
if last.cert_file_no then output;
run;
data race_3 ( keep=cert_file_no R_White R_Vietnamese R_Unknown R_Samoan R_Specify R_Refused
R_Primary_or_enrolled_tribe R_Other_Pacific_Islander
R_Other_Asian R_Other R_Not_Obtainable R_Native_Hawaiian R_Korean R_Japanese
R_Guamanian_or_Chamorro R_Filipino R_Chinese R_Black_African_American
R_Asian_Indian R_American_Indian_or_Alaska R_Additional_Tribe);
retain R_White R_Vietnamese R_Unknown R_Samoan R_Specify R_Refused R_Primary_or_enrolled_tribe
R_Other_Pacific_Islander R_Other_Asian R_Other
R_Not_Obtainable R_Native_Hawaiian R_Korean R_Japanese R_Guamanian_or_Chamorro R_Filipino R_Chinese
R_Black_African_American R_Asian_Indian
R_American_Indian_or_Alaska R_Additional_Tribe;
set race;
by cert_file_no;
if first.cert_file_no then do ;
R_White=0 ;
R_Vietnamese=0;
R_Unknown=0;
R_Samoan=0;
R_Specify=0;
R_Refused=0;
R_primary_or_enrolled_tribe=0;
R_Other_Pacific_Islander=0;
R_Other_Asian=0;
R_Other=0;
R_Not_Obtainable=0;
R_Native_Hawaiian=0;
R_Korean=0;
Page 16 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
R_Japanese=0;
R_Guamanian_or_Chamorro=0;
R_Filipino=0;
R_Chinese=0;
R_Black_African_American=0;
R_Asian_Indian=0;
R_American_Indian_or_Alaska=0;
R_Additional_Tribe=0;
end;
if mc_prompt='White' then do;
R_White=1;
END;
if mc_prompt='Vietnamese' then DO;
R_Vietnamese=1;
END;
if mc_prompt='Unknown' then DO;
R_Unknown=1;
END;
if mc_prompt='Samoan' then DO;
R_Samoan=1;
END;
if mc_prompt='Specify' then DO;
R_Specify=1;
END;
if mc_prompt='Refused' then DO;
R_Refused=1;
END;
if mc_prompt='Primary or Enrolled Tribe' then DO;
R_Primary_or_enrolled_tribe=1;
END;
if mc_prompt='Other Pacific Islander' then DO;
R_Other_Pacific_Islander=1;
END;
if mc_prompt='Other Asian' then DO;
R_Other_Asian=1;
END;
if mc_prompt='Other' then DO;
R_Other=1;
END;
if mc_prompt='Not Obtainable' then DO;
R_Not_Obtainable=1;
END;
if mc_prompt='Native Hawaiian' then DO;
R_Native_Hawaiian=1;
END;
if mc_prompt='Korean' then DO;
R_Korean=1;
END;
Page 17 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
if mc_prompt='Japanese' then DO;
R_Japanese=1;
END;
if mc_prompt='Guamanian or Chamorro' then DO;
R_Guamanian_or_Chamorro=1;
END;
if mc_prompt='Filipino' then DO;
R_Filipino=1;
END;
if mc_prompt='Chinese' then DO;
R_Chinese=1;
END;
if mc_prompt='Black, African American' then DO;
R_Black_African_American=1;
END;
if mc_prompt='Asian Indian' then DO;
R_Asian_Indian=1;
END;
if mc_prompt='American Indian or Alaska Native' then DO;
R_American_Indian_or_Alaska=1;
END;
if mc_prompt='Additional Tribe' then DO;
R_Additional_Tribe=1;
END;
if last.cert_file_no then output;
run;
data vrace;
merge race_3 (in=A) origin_3 (in=B);
by cert_file_no;
fromrace_3=A;
fromorigin_3=B;
Hispanic=0;
white=0;
black=0;
ai=0;
asian=0;
other=0;
Otherasian=0;
Chinese=0;
Japanese=0;
Hawaiian=0;
Filipino=0;
if O_Cuban = 1 or O_Mexican_American_Chicano = 1 or O_Other = 1 or O_Puerto_Rican = 1 or O_Specify=1 then
Hispanic=1;
if R_White=1 then white=1;
if R_Black_African_American=1 then black=1;
if R_American_Indian_or_Alaska=1 then ai=1;
if R_Asian_Indian=1 or R_Chinese=1 or R_Filipino=1 or R_Japanese=1 or R_Korean=1 or R_Vietnamese=1 or
Page 18 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
R_Other_Asian=1 or R_Native_Hawaiian=1
or R_Guamanian_or_Chamorro=1 or R_Other_Pacific_Islander=1 or R_Samoan=1 then asian=1;
if R_Other=1 then other=1;
if R_Chinese=1 then chinese=1;
if R_Japanese=1 then Japanese=1;
if R_Native_Hawaiian=1 then Hawaiian=1;
if R_Filipino=1 then filipino=1;
if R_Korean=1 or R_Vietnamese=1 or R_Other_Asian=1 or R_Other_Pacific_Islander=1 or R_Asian_Indian=1 or
R_Guamanian_or_Chamorro=1 or R_Samoan=1
then Otherasian=1;
array raceeth (5) white black ai asian other;
x=0;
do i= 1 to 5;
if raceeth(i) ne 0 then x=x+1;
end;
NewRace=9;
If Otherasian=1 then Newrace=0;
if white=1 then Newrace=1;
if black=1 then Newrace=2;
if ai=1 then Newrace=3;
if chinese=1 then Newrace=4;
if Japanese=1 then Newrace=5;
if Hawaiian=1 then Newrace=6;
if other=1 then Newrace=7;
if Filipino=1 then Newrace=8;
if x gt 1 then Newrace=10;
drop white black ai asian other x i;
If Newrace=0 then NewRace_Desc='OTHER ASIAN';
If Newrace=1 then NewRace_Desc='WHITE';
if Newrace=2 then NewRace_Desc='BLACK';
If Newrace=3 then NewRace_Desc='AMERICAN INDAIN';
If Newrace=4 then NewRace_Desc='CHINESE';
If Newrace=5 then NewRace_Desc='JAPANESE';
If Newrace=6 then NewRace_Desc='HAWAIIAN';
If NewRace=7 then NewRace_Desc='OTHER';
If NewRace=8 Then NewRace_Desc='FILIPINO';
If Newrace=9 Then NewRace_Desc='UNKNOWN';
If NewRace=10 then NewRace_Desc='MULTIPLE';
If Hispanic=0 then Hispanic_Desc='NON-HISPANIC';
If Hispanic=1 then Hispanic_Desc='HISPANIC';
If Hispanic=9 then Hispanic_Desc='UNKNOWN';
LENGTH RACE_VSIMS $50;
race_VSIMS='unknown';
if Newrace=1 and Hispanic ne 1 then race_VSIMS='WHITE NON-HISPANIC';
if Newrace=2 and Hispanic ne 1 then race_VSIMS='BLACK OR AFRICAN AMERICAN';
if Newrace=3 and Hispanic ne 1 then race_VSIMS='AMERICAN INDIAN OR ALASKA NATIVE';
if Newrace in(0 4 5 6 8) and Hispanic ne 1 then race_VSIMS='ASIAN OR PACIFIC ISLANDER';
if Newrace=7 and Hispanic ne 1 then race_VSIMS='OTHER';
Page 19 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
if Newrace=10 and Hispanic ne 1 then race_VSIMS='MULTIPLE RACE';
if Newrace=9 and Hispanic ne 1 then race_VSIMS='UNKNOWN';
if Hispanic=1 then race_VSIMS='HISPANIC OR LATINO';
if Newrace=1 and Hispanic ne 1 then race_PHS='WHITE NON-HISPANIC';
if Newrace=1 and Hispanic=1 then race_PHS='HISPANIC OR LATINO';
if Newrace=2 and Hispanic ne 1 then race_PHS='BLACK OR AFRICAN AMERICAN';
if Newrace=2 and Hispanic= 1 then race_PHS='BLACK OR AFRICAN AMERICAN';
if Newrace=3 and Hispanic ne 1 then race_PHS='AMERICAN INDIAN OR ALASKA NATIVE';
if Newrace=3 and Hispanic= 1 then race_PHS='AMERICAN INDIAN OR ALASKA NATIVE';
if Newrace in(0 4 5 6 8) and Hispanic ne 1 then race_PHS='ASIAN OR PACIFIC ISLANDER';
if Newrace in(0 4 5 6 8) and Hispanic= 1 then race_PHS='ASIAN OR PACIFIC ISLANDER';
if Newrace=7 and Hispanic ne 1 then race_PHS='WHITE NON-HISPANIC';
if Newrace=7 and Hispanic= 1 then race_PHS='HISPANIC OR LATINO';
if Newrace=10 and Hispanic ne 1 then race_PHS='WHITE NON-HISPANIC';
if Newrace=10 and Hispanic= 1 then race_PHS='HISPANIC OR LATINO';
if Newrace=9 and Hispanic ne 1 then race_PHS='WHITE NON-HISPANIC';
if Newrace=9 and Hispanic= 1 then race_PHS='HISPANIC OR LATINO';
if race_PHS eq '' then race_PHS='WHITE NON-HISPANIC';
Run;
proc sort data=vrace;
by cert_file_no;
run;
/* merge this with the death file */
proc sql _method outobs=max feedback SORTMSG;
CREATE TABLE work.death AS
select a.*, b.R_White, b.R_Vietnamese, b.R_Unknown, b.R_Samoan, b.R_Specify, b.R_Refused,
b.R_Primary_or_enrolled_tribe, b.R_Other_Pacific_Islander,
b.R_Other_Asian, b.R_Other, b.R_Not_Obtainable, b.R_Native_Hawaiian, b.R_Korean, b.R_Japanese,
b.R_Guamanian_or_Chamorro, b.R_Filipino, b.R_Chinese,
b.R_Black_African_American, b.R_Asian_Indian, b.R_American_Indian_or_Alaska, b.R_Additional_Tribe,
b.O_Cuban, b.O_Mexican_American_Chicano,
b.O_Not_Obtainable, b.O_Not_Spanish_Hispanic_or_Latino, b.O_Other, b.O_Puerto_Rican, b.O_Refused,
b.O_Specify, b.O_Unknown, b.hispanic, b.otherasian,
b.chinese, b.japanese, b.hawaiian, b.filipino, b.newrace, b.newrace_desc, b.hispanic_desc, b.race_vsims,
b.race_phs
from work.death_source a left join work.vrace b
on strip(a.death_certificate_number)=strip(b.cert_file_no)
order by last_update_date;
quit;
%MACRO REPORTS (COUNTY);
/* DEATH DATASET BY COUNTY */
data datetime;
M=strip(put(month(intnx('month',today(),-1,'end')),2.));
y=strip(put(year(intnx('month',today(),-1,'end')),4.));
if input(M,2.)<10 then M="0"||strip(M);
Mt=strip(M)||"_"||strip(y);
county=&COUNTY.;
Page 20 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
county2=compress(county);
pathB='"\\VITALRECORDS\DATA\DEATH-PII\DEVO\CDR\';
path2=strip(pathb)||strip(county)||'_DEATHS_'||strip(Mt)||'.csv"';
filename2=strip(county2)||'_deaths'||'_'||strip(Mt);
call symput('path2',path2);
call symput('fn2',filename2);
run;
PROC SQL;
CREATE TABLE dth.&FN2. AS
SELECT *
FROM WORK.DEATH
WHERE death_book_year>=&YRN. AND
(STRIP(UPCASE(RESIDENCE_COUNTY_NAME ))= &COUNTY. OR STRIP(UPCASE(DEATH_COUNTY_NAME)) =
&COUNTY.);
QUIT;
%MEND;
%DIDREPORTS (MARICOPA);
Page 21 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT D – VITAL RECORDS FETAL DEATH DATA SET
Fields shared:
All included in non-pii data file.
Frequency of Data Sharing:
PII Year-To-Date data file provided via encrypted Secure File Transfer Protocol (SFTP) or PII data provided
through direct database link on a scheduled frequency as requested by MCDPH. A designated contact at
the County will be granted credentials for SFTP access to the ADHS SFTP server to facilitate data transfer,
or a direct access link and query defined to pull data appropriate for the county.
Allowable Data Uses:
Public Health uses including surveillance, assessments, quality controls, interventions, and other public
health related activity.
Data Query Code Used:
/*options nosource nonotes;*/
libname fetd oracle path="vtrain1" schema=AZ_VSIMS_full user=&orauser.
password=&ORAPSWD. readbuff=5000
multi_datasrc_opt=in_clause read_lock_type=nolock dbindex=YES access=readonly;
libname fd '\\vitalrecords\data\FetalDeath-PII\DEVO\CDR';
data datetime;
y2="'"||strip(put(year(intnx('year',today(),-1,'end')),4.))||"'";
y1="'"||strip(put(year(intnx('year',today(),-0,'end')),4.))||"'";
y3=input(strip(put((year(today())-1),4.)),best12.);
call symput('YRN',y3);
call symput('YRT',y2);
call symput('YRT2',y1);
run;
proc sql _method outobs=max feedback SORTMSG;
create table fdeath as
select f.*,
intck('YEAR',mdy(mothers_birth_month,mothers_birth_day,mothers_birth_year),datepart(d
ate_delivery),'C') as mothers_age_at_delivery,
intck('YEAR',mdy(father_birth_month,father_birth_day,father_birth_year),datepart(date
_delivery),'C') as fathers_age_at_delivery
from fetd.fetal_death_view f
where year(datepart(date_delivery))>=&YRN.;
quit;
%MACRO REPORTS (COUNTY);
data datetime;
M=strip(put(month(intnx('month',today(),-1,'end')),2.));
y=strip(put(year(intnx('month',today(),-1,'end')),4.));
county=&COUNTY.;
county2=compress(county);
pathE='"\\VITALRECORDS\DATA\FETALDEATH-PII\DEVO\CDR\';
Page 22 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
path5=strip(pathe)||strip(county)||'_FETALDEATHS_'||strip(y)||'.csv"';
filename3=strip(county2)||'_fetaldeaths'||'_'||strip(y);
call symput('YRT',y);
call symput('path5',path5);
call symput('fn3',filename3);
run;
/* Fetal Death By County */
PROC SQL;
CREATE TABLE fd.&FN3. AS
SELECT *
FROM WORK.FDEATH
WHERE year_delivery=&YRN.
AND (MOTHER_CURRENT_COUNTY=&COUNTY. OR DELIVERY_COUNTY=&COUNTY.);
QUIT;
proc export data=dfd.&fn3. outfile=&path6.
dbms = csv replace;
quit;
%MEND;
%ANNUAL_REPORTS ('MARICOPA');
Page 23 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT E – HOSPITAL DISCHARGE DATA SET
Fields shared:
AZ_FAC_ID R078X_TELEMEDICINE ECODE_1
HOSPITAL_NPI R079X_EXTRA_CORP_SHOCK ECODE_1_POA
PT_MEDICAL_REC_NUMBER R080X_IP_RENAL_DIALYSIS ECODE_2
PT_CONTROL_NUMBER R081X_ACQUIRE_BODY_COMP ECODE_2_POA
PT_NAME R088X_MISC_DIALYSIS ECODE_3
PT_ADDRESS R090X_BEHAVIORAL_HEALTH ECODE_3_POA
PT_CITY R091X_BEHAVIORAL_EXT_090X ECODE_4
PT_STATE R092X_OTHER_DIAGNOSTIC ECODE_4_POA
PT_ZIP_CODE R094X_OTHER THERAPEUTIC ECODE_5
PT_COUNTRY_CODE R095X_OTHER_THERA_EXT_094X ECODE_5_POA
HOMELESS_INDICATOR R096X_PROFESSIONAL_FEES ECODE_6
BIRTH_DATE R097X_PROF_FEES_EXT_096X ECODE_6_POA
SEX R098X_PROF_FEES_EXT_097X ACCIDENT_STATE
RACE_ETHNICITY R099X_PATIENT_CONVENIENCE PRINCIPAL_PROCEDURE
MARITAL_STATUS R210X_ALTERNATIVE_THERAPY PRINCIPAL_PROCEDURE_DATE
ONSET_SYMPTOMS_DATE RALL_OTHER_REVENUE PROCEDURE_2
ADMISSION _DATE R0710_NURSERY_GENERAL PROCEDURE_2_DATE
ADMISSION_HOUR R0171_NURSERY_LEVEL_1 PROCEDURE_3
PRIORITY_OF_VISIT R0172_NURSERY_LEVEL_2 PROCEDURE_3_DATE
SOURCE_OF_VISIT R0173_NURSERY_LEVEL_3 PROCEDURE_4
DISCHARGE_DATE R0174_NURSERY_LEVEL_4 PROCEDURE_4_DATE
DISCHARGE_HOUR R0179_NURSERY_OTHER PROCEDURE_5
DISCHARGE_STATUS IRF_PPS_CMG PROCEDURE_5_DATE
NEWBORN_BIRTH_WEIGHT DRG PROCEDURE_6
DO_NOT_RESUSCITATE DRG_VERSION PROCEDURE_6_DATE
BILL_CREATION_DATE ICD_VERSION PROCEDURE_7
TOTAL_CHARGES REASON_FOR_VISIT_1 PROCEDURE_7_DATE
PAYER_TYPE REASON_FOR_VISIT_2 PROCEDURE_8
R010X_ALL_INCLUSIVE_RATE REASON_FOR_VISIT_3 PROCEDURE_8_DATE
R011X_RB_PRIVATE ADMITTING_DIAGNOSIS PROCEDURE_9
R012X_RB_SEMI_PRIVATE PRINCIPAL_DIAGNOSIS PROCEDURE_9_DATE
R013X_RB_3_4_BEDS PRINCIPAL_DIAGNOSIS_POA PROCEDURE_10
R014X_RB_DELUXE_PRIVATE DIAGNOSIS_2 PROCEDURE_10_DATE
R015X_RB_WARD DIAGNOSIS_2_POA PROCEDURE_11
R016X_RB_OTHER DIAGNOSIS_3 PROCEDURE_11_DATE
R018X_LEAVE_OF_ABSENCE DIAGNOSIS_3_POA PROCEDURE_12
R019X_SUBACUTE DIAGNOSIS_4 PROCEDURE_12_DATE
R020X_INTENSIVE_CARE DIAGNOSIS_4_POA ATTENDING_PROV_NAME
R021X_CORONARY_CARE DIAGNOSIS_5 ATTENDING_PROV_NPI
R022X_SPECIAL_CHARGES DIAGNOSIS_5_POA ATTENDING_PROV_LICENSE
R023X_INCREMENTAL_NURSING DIAGNOSIS_6 ATTENDING_PROV_BOARD
R024X_ALL_INCLUSIVE_ANCILLARY DIAGNOSIS_6_POA OPERATING_PROV_NAME
R025X_PHARMACY DIAGNOSIS_7 OPERATING_PROV_NPI
R026X_IV_THERAPY DIAGNOSIS_7_POA OPERATING_PROV_LICENSE
R027X_MED_SURG_SUPPLIES DIAGNOSIS_8 OPERATING_PROV_BOARD
R028X_ONCOLOGY DIAGNOSIS_8_POA OTHER_PROV_NAME
R029X_DURABLE_MEDICAL_EQUIP DIAGNOSIS_9 OTHER_PROV_NPI
R030X_LABORATORY DIAGNOSIS_9_POA OTHER_PROVIDER_LICENSE
R031X_LAB_PATHOLOGY DIAGNOSIS_10 OTHER_PROVIDER_BOARD
R032X_RADIOLOGY_DIAGNOSTIC DIAGNOSIS_10_POA RECORD_TYPE
R033X_RADIOLOGY_THERA_CHEMO DIAGNOSIS_11 N_ADDRESS
R034X_NUCLEAR_MEDICINE DIAGNOSIS_11_POA N_CITY
Page 24 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
R035X_CT_SCAN DIAGNOSIS_12 N_STATE
R036X_OPER_ROOM_SVCS DIAGNOSIS_12_POA N_ZIP
R037X_ANESTHESIA DIAGNOSIS_13 N_ZIP4
R038X_BLOOD_COMPONENTS DIAGNOSIS_13_POA N_LON
R039X_BLOOD_ADMIN DIAGNOSIS_14 N_LAT
R040X_OTHER_IMAGING DIAGNOSIS_14_POA N_MCODE
R041X_RESPIRATORY DIAGNOSIS_15 N_LCODE
R042X_PHYSICAL_THERAPY DIAGNOSIS_15_POA N_COUNTY
R043X_OCCUPATIONAL_THERAPY DIAGNOSIS_16 N_TRACT2
R044X_SPEECH_THERAPY DIAGNOSIS_16_POA N_BLOCK
R045X_EMERGENCY_ROOM DIAGNOSIS_17 CHAA
R046X_PULMONARY_FUNCTION DIAGNOSIS_17_POA CHAA_ID
R047X_AUDIOLOGY DIAGNOSIS_18 ED_ADMISSION_FLAG
R048X_CARDIOLOGY DIAGNOSIS_18_POA VISIT_QUALIFIER
R050X_OUTPATENT_SVCS DIAGNOSIS_19 PCA
R053X_OSTEOPATHIC_SVCS DIAGNOSIS_19_POA PCA_ID
R061X_MRT DIAGNOSIS_20 ETHNIC
R062X_MED_SURG_EXT_027X DIAGNOSIS_20_POA
R063X_PHARMACY_EXT_025X DIAGNOSIS_21
R068X_TRAUMA_RESPONSE DIAGNOSIS_21_POA
R070X_CAST_ROOM DIAGNOSIS_22
R071X_RECOVERY_ROOM DIAGNOSIS_22_POA
R072X_LABOR_DELIVERY DIAGNOSIS_23
R073X_EKG_ECG DIAGNOSIS_23_POA
R074X_EEG DIAGNOSIS_24
R075X_GI_SVCS DIAGNOSIS_24_POA
R076X_TREAT_OBSERVATION DIAGNOSIS_25
R077X_PREVENTIVE_CARE DIAGNOSIS_25_POA
Frequency of Data Sharing:
Data are routinely provided every 6 months, usually in the months of November, and May, files being
generated on the fifteenth day of those months, containing all records during the prior reporting period
(January – June or July – December) regarding reportable hospital events. Events will include persons
residing in the county, or non-residents of the county when the hospital event took place within the
county.
Data Query Code Used:
libname hdd oracle user=&orauser. password=&orapswd. path=natp;
Data a;
set hdd.H09HDD_08RESTRICTEDVIEW;
if INTNX('MONTH',TODAY(),-10,'BEGINNING')<=DISCHARGE_DATE<=INTNX('MONTH',TODAY(),-
5,'END'); *reporting period for Jan- May if run in November, or July – December if run in May;
run;
data Maricopa;
set a;
where (N_COUNTY = ‘MARICOPA’)
or (AZ_FAC_ID in (‘MED0001’, ‘MED0002’, ‘MED0209’, ‘MED0211’, ‘MED0216’, ‘MED0217’, ‘MED0219’, ‘MED0222’,
Page 25 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
‘MED0223’, ‘MED0224’, ‘MED0225’, ‘MED0226’, ‘MED0227’, ‘MED0228’, ‘MED0230’, ‘MED0233’, ‘MED0234’,
‘MED0235’, ‘MED0236’, ‘MED0237’, ‘MED0238’, ‘MED0239’, ‘MED0240’, ‘MED0241’, ‘MED0340’, ‘MED0483’,
‘MED0532’, ‘MED1442’, ‘MED1574’, ‘MED1724’, ‘MED1864’, ‘MED2117’, ‘MED2124’, ‘MED2125’, ‘MED2149’,
‘MED2151’, ‘MED2157’, ‘MED2170’, ‘MED2199’, ‘MED2205’, ‘MED2277’, ‘MED2312’, ‘MED2568’, ‘MED2590’,
‘MED2615’, ‘MED2640’, ‘MED2660’, ‘MED2787’, ‘MED2910’, ‘MED2941’, ‘MED3150’, ‘MED3301’, ‘MED3311’,
‘MED3348’, ‘MED3513’, ‘MED3555’, ‘MED3556’, ‘MED3557’, ‘MED3573’, ‘MED3795’, ‘MED3921’, ‘MED4071’,
‘MED4271’, ‘MED4385’, ‘MED4433’, ‘MED4535’, ‘MED4578’, ‘MED4707’, ‘MED5150’, ‘MED5410’, ‘MED5520’,
‘MED5523’, ‘MED5753’, ‘MED5828’, ‘MED5829’, ‘MED6089’)); /* note that this list will change with each release,
but should include all past and present licensed sites that reported during the period */
run;
data Maricopa;
set Maricopa;
DROP
RECORD_ID
PERSON_ID
PT_SSN
BIRTH_CERT_ID
DEATH_CERT_ID
CTR_NUMBER
CREATED_BY
CREATED_BY_DATE
METHOD
MODIFIEDBY
MODIFIEDDATE
RESERVATION
RESERVATION ID
R_METHOD;
run;
Page 26 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT F – BRFSS LIMITED DATA SET
Fields Shared:
All contained within the limited data set, including 5 digit zip code, and PCA assignment, but excluding nearest
intersection responses or geocoding.
 All core and state-only survey question responses will be included in the data set shared with MCDPH.
 ADHS and MCDPH will collaborate to review and redact responses as needed to protect respondent
confidentiality when producing any analyses below the county level.
 ADHS will assist MCDPH as needed to develop and assign each survey response to all geographic regions
below the county level as requested by MCDPH.
 Neither the residence zip code value, nor PCA assignment of nearest intersection response are to be
released by MCDPH to third parties.
 The county may release all fields contained in the public data set to third parties.
 Publications of sub-county level estimates will present aggregated data only.
 ADHS and MCDPH shall agree on a cell suppression policy for small number cell counts to be applied in
small area estimate reporting.
Frequency of Data Sharing:
Annual Data file provided via encrypted Secure File Transfer Protocol (SFTP). Data files are generally
available for the prior year survey between August, and October.
Allowable Data Uses:
Public Health uses including surveillance, assessments, quality controls, interventions, and other public
health related activity.
Page 27 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT G – MEDSIS
Time Frame and Scope of Data Shared:
All data in MEDSIS for residents of Maricopa County, and events reported into MEDSIS by medical providers
located within Maricopa County.
Data Fields Shared:
All fields shared.
Frequency of Data Sharing:
Real-time continuous access to the MEDSIS production data. Sharing of reportable health event (MEDSIS) data is
facilitated by granting access to MEDSIS to authorized persons designated by MCDPH to have such access.
Method of Data Transfer:
Data is maintained and protected by ADHS while it is resident on the ADHS MEDSIS server. MCDPH becomes the
owner of all data downloaded from the ADHS MEDSIS server by MCDPH, and becomes responsible to maintain
and protect the downloaded data.
Allowable Data Uses:
All uses allowable under applicable law as determined by MCDPH. For Research uses, MCDPH may use the ADHS
HSRB, or another IRB of its choice to oversee the protection of privacy in data use.
Page 28 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT H – SEXUALLY TRANSMITTED DISEASE DATA (PRISM)
Time Frame and Scope of Data Shared:
All data in PRISM for residents of Maricopa County, and events reported into PRISM by medical providers located
within Maricopa County. Exception: cases or their contacts from other jurisdictions may be viewed by MCDPH
only during relevant case investigations.
Data Fields Shared:
All fields shared, dependent upon user permission level.
Frequency of Data Sharing:
Real-time continuous access to the PRISM production data. Sharing of reportable health event (PRISM) data is
facilitated by granting access to PRISM to authorized persons designated by MCDPH to have such access.
Method of Data Transfer:
Data is maintained and protected by ADHS while it is resident on the ADHS PRISM server. MCDPH becomes the
owner of all data downloaded from the ADHS PRISM server by MCDPH, and becomes responsible to maintain and
protect the downloaded data.
Allowable Data Uses:
Public Health uses including surveillance, assessments, quality controls, interventions, and other public health
related activity. All uses must abide by terms defined under Section 19 Data Use and Ownership and all data
security and confidentiality requirements mentioned therein. For research uses, MCDPH may use the ADHS HSRB,
or another IRB of its choice to oversee the protection of privacy in data use.
Page 29 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT I – IMMUNIZATION DATA (ASIIS)
Time Frame and Scope of Data Shared:
All data in ASIIS for residents of Maricopa County, and events reported into ASIIS by medical providers located
within Maricopa County.
Data Fields Shared:
All fields shared.
Frequency of Data Sharing:
Real-time continuous access to the ASIIS production data. Sharing of immunization events (ASIIS) data is
facilitated by granting access to ASIIS to authorized persons designated by MCDPH to have such access.
Method of Data Transfer:
In addition to ASIIS access, the County may request HEDIS reports for specific entities by submitting required
information to the ADHS ASIIS Program Manager, and summary information will be produced and released by
secure transfer method agreed by ADHS and MCDPH.
Allowable Data Uses:
Public Health allowable activity as defined by HIPAA. Any research use must first be reviewed and approved by the
ADHS HSRB.
Page 30 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT J – HIV/AIDS SURVEILLANCE DATA (EHARS)
Time Frame and Scope of Data Shared:
All data in EHARS for residents of Maricopa County, and events reported into ASIIS by medical providers located
within Maricopa County. The HIV/AIDS data are of an exceptionally sensitive and private nature, and for this
reason close collaboration in sharing, using, and protecting these data are appropriate as a condition of this
sharing. Data access will be provided on a read-only basis, and MCDPH will coordinate closely with ADHS HIV/AIDS
Surveillance to assure data quality is maintained, and that data are used in a manner that complies with all special
CDC HIV/AIDS Surveillance requirements and regulations. Otherwise federal HIV/AIDS surveillance funding to
Arizona might be jeopardized.
Data Fields Shared:
All fields shared.
Frequency of Data Sharing:
Real-time continuous access to the E-HARS production data on a read-only basis. Sharing of HIV/AIDS surveillance
(E-HARS) data is facilitated by granting limited access to E-HARS to authorized persons designated by MCDPH to
have such access.
Method of Data Transfer:
MCDPH and ADHS HIV/AIDS Surveillance will collaborate, and closely coordinate the exchange of HIV/AIDS
Surveillance data due to the extremely sensitive nature of the information it contains. ADHS and MCDPH will use
HIV/AIDS data shared under this agreement in a manner that fully complies with usage and privacy restrictions
defined by the HIV/AIDS branch of the CDC and required as a condition of HIV/AIDS Surveillance grant funding to
ADHS for the collection of these data. There will be no un-authorized uses of HIV/AIDS data shared with MCDPH
which have not been agreed to by both MCDPH and ADHS.
Allowable Data Uses:
Public Health allowable activity as defined by HIPAA and conforming to the CDC Security and Confidentiality
Guidance and the responding ADHS Security & Confidentiality document. Any research use must first be reviewed
and approved by the ADHS HSRB.
Page 31 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT K – ARIZONA STATE TRAUMA REGISTRY (ASTR)
Time Frame and Scope of Data Shared:
Annual data files are shared once produced by ADHS. Typically the data annual data file has been closed, cleaned,
and finalized by the first day of August.
Data Fields Shared:
All data elements found in the ASTR FULL data set.
Limitations on Data Use:
Data may only be used for public health activity. No identifiable information may be published. No contact may
be attempted with agencies or individuals contained within the shared ASTR data unless approved by ADHS.
Principle Contacts:
Arizona Department of Health Services
Bureau Chief, Bureau of EMS and Trauma System
150 N 18th Avenue, Suite 540
Phoenix, AZ, 85007
Phone: (602) 364-3149
Selection Criteria:
All events in the FULL Data Set which occurred within Maricopa County, or which were reported by a provider
located within Maricopa County.
Page 32 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT L – Arizona Vital Records CSMS Data
Time Frame and Scope of Data Shared:
Data are shared via data extract either through direct-link or a scheduled data extract from the ADHS Vital Records
Data System.
Data Fields Shared:
CERTIFICATEINFO.CERTIFICATELOCATION_ID CSMS_LOG.LOGID
CERTIFICATEINFO.CERTIFICATESTATUS_ID CSMS_LOG.MACHINENAME
CERTIFICATEINFO.CERTIFICATETIMEFRAME_ID CSMS_LOG.PACKAGEID
CERTIFICATEINFO.CERTIFICATETYPE_ID CSMS_LOG.PACKAGENAME
CERTIFICATEINFO.COMPLETEDBY_ID CSMS_LOG.SOURCEID
CERTIFICATEINFO.CREATEDBY_ID CSMS_LOG.SOURCENAME
CERTIFICATEINFO.CREATEDBYNAME CSMS_LOG.USERNAME
CERTIFICATEINFO.CREATEDBYROLENAME CSMS_ROWCOUNTS.EPICNT
CERTIFICATEINFO.DATEAPPROVED_ID CSMS_ROWCOUNTS.EPIDIFF
CERTIFICATEINFO.DATECREATED_ID CSMS_ROWCOUNTS.ORACNT
CERTIFICATEINFO.ERA_ID CSMS_ROWCOUNTS.RUNDTM
CERTIFICATEINFO.FILENUMBER CSMS_ROWCOUNTS.TBLNAME
CERTIFICATEINFO.ID CSMS_STATS.PACKAGENAME
CERTIFICATEINFO.PRINTREASONINFO_ID CSMS_STATS.RID
CERTIFICATEINFO.REGISTEREDBY_ID CSMS_STATS.ROWSINSERTED
CERTIFICATEINFO.REGISTRARNAME CSMS_STATS.ROWSREJECTED
CERTIFICATEINFO.VOIDEDBY_ID CSMS_STATS.ROWSRETRIEVED
CERTIFICATEINFO.VOIDEDCOMMENT CSMS_STATS.ROWSUPDATED
CERTIFICATESERVICE.ALLOWCERTIFIED CSMS_STATS.RUNDATE
CERTIFICATESERVICE.ALLOWFEE CSMS_STATS.RUNMINS
CERTIFICATESERVICE.ALLOWWHITE CSMS_STATS.RUNTYPE
CERTIFICATESERVICE.CERTIFICATECODE CSMS_STATS.SYNCDATE
CERTIFICATESERVICE.ID CSMS_STATS.TBLID
CERTIFICATESERVICE.MAXQUANTITYEVER CSMS_SYNCDATE.PACKAGENAME
CERTIFICATESERVICE.MAXQUANTITYPERREGISTRANT CSMS_SYNCDATE.SYNCDATETIME
CERTIFICATESERVICE.NAME CSMS_TABLES.ORASCHEMA
CERTIFICATESERVICE.SERVICEGROUP_ID CSMS_TABLES.SYNCDATE
COUNTY.COUNTYNAME CSMS_TABLES.TBLID
COUNTY.ID CSMS_TABLES.TBLNAME
COUNTY.PROVINCE_ID CSMS_TABLES.TBLTYPE
CSMS_LOG.ERRORCODE ERA.ERAEND
CSMS_LOG.ERRORDESCRIPTION ERA.ERANAME
CSMS_LOG.EVENTDATETIME ERA.ERANOTES
CSMS_LOG.EVENTTYPE ERA.ERASTART
CSMS_LOG.EXECUTIONID ERA.ID
CSMS_LOG.INTERACTIVEMODE FACILITY.ACTIVEINFO_ID
Page 33 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
FACILITY.ADDRESS_ID FETALDEATH.MOTHERHISPANICORIGIN_ID
FACILITY.ALLOWCHARGE FETALDEATH.MOTHERPLACECURRENT_ID
FACILITY.FACILITYTYPE_ID FETALDEATH.MOTHERRACE_ID
FACILITY.ID FETALDEATH.NAMEINFO_ID
FACILITY.INVOICECONFIG_ID FETALDEATH.PLURALITY_ID
FACILITY.NAME FETALDEATH.PREGNANCY_ID
FACILITY.NPI FETALDEATH.RISKFACTOR_ID
FACILITY.PHONE FETALDEATH.SEX_ID
FACILITY.PHONEEXTENSION FETALDEATH.STATUSMESSAGE_ID
FACILITY.STATEASSIGNED_ID FETALDEATHREGISTRANTINFO.COUNTYOFDELIVERY_ID
FACILITYCOUNTYJOIN.ALLOWCHARGE FETALDEATHREGISTRANTINFO.ID
FACILITYCOUNTYJOIN.COUNTY_ID FETALDEATHREGISTRANTINFO.MOTHERFIRSTNAME
FACILITYCOUNTYJOIN.FACILITY_ID FETALDEATHREGISTRANTINFO.MOTHERLASTNAME
FACILITYCOUNTYJOIN.ID FETALDEATHREGISTRANTINFO.MOTHERMIDDLENAME
FACILITYINFO.ADDRESSOTHER FETALDEATHREGISTRANTINFO.NOTNAMED
FACILITYINFO.FACILITY_ID FETALDEATHTRANSITPERMIT.CHILD_ID
FACILITYINFO.ID FETALDEATHTRANSITPERMIT.DELIVERYDATE_ID
FACILITYINFO.NAMEOTHER FETALDEATHTRANSITPERMIT.DELIVERYPLACE_ID
FACILITYINFO.PLACE_ID FETALDEATHTRANSITPERMIT.DELIVERYPLACETYPE_ID
FETALCAUSEINFO.AUTOPSYPLACENTACAUSEINFO_ID FETALDEATHTRANSITPERMIT.FACILITYINFO_ID
FETALCAUSEINFO.ESTGESTATIONDELIVERY FETALDEATHTRANSITPERMIT.FETALCAUSEINFO_ID
FETALCAUSEINFO.ESTGESTATIONDELIVERYUNKNOWN FETALDEATHTRANSITPERMIT.FETALDISPOSITION_ID
FETALCAUSEINFO.ESTIMATEDTIMEFETALDEATH_ID FETALDEATHTRANSITPERMIT.ID
FETALCAUSEINFO.FETUSWEIGHT_ID FETALDEATHTRANSITPERMIT.LINKEDFETALDEATH_ID
FETALCAUSEINFO.ID FETALDEATHTRANSITPERMIT.MEDICALEXAMINATIONINFO_ID
FETALDEATH.ATTENDANTSTAFFINFO_ID FETALDEATHTRANSITPERMIT.MOTHER_ID
FETALDEATH.CERTIFICATEINFO_ID FETALDEATHTRANSITPERMIT.SEX_ID
FETALDEATH.CHILD_ID FETALDISPOSITION.BURIAL
FETALDEATH.CONGENITALANOMALIES_ID FETALDISPOSITION.CREMATION
FETALDEATH.DELIVERYDATE_ID FETALDISPOSITION.CREMATIONFACILITY_ID
FETALDEATH.DELIVERYMETHOD_ID FETALDISPOSITION.DATEOFDISPOSITION_ID
FETALDEATH.DELIVERYPLACE_ID FETALDISPOSITION.DISCRIMINATOR
FETALDEATH.DELIVERYPLACETYPE_ID FETALDISPOSITION.DONATION
FETALDEATH.FACILITYINFO_ID FETALDISPOSITION.ENTOMBMENT
FETALDEATH.FATHER_ID FETALDISPOSITION.FACILITY1_ID
FETALDEATH.FATHERHISPANICORIGIN_ID FETALDISPOSITION.FACILITY2_ID
FETALDEATH.FATHERRACE_ID FETALDISPOSITION.FAMILYDISPOSITION
FETALDEATH.FETALCAUSEINFO_ID FETALDISPOSITION.FUNERAL_ID
FETALDEATH.FETALDEATHTYPE_ID FETALDISPOSITION.FUNERALDIRECTORINFO_ID
FETALDEATH.FETALDISPOSITION_ID FETALDISPOSITION.FUNERALINFOSAVEDBY_ID
FETALDEATH.ID FETALDISPOSITION.HELD
FETALDEATH.MEDICALEXAMINATIONINFO_ID FETALDISPOSITION.HOSPITALDISPOSITION
FETALDEATH.MOTHER_ID FETALDISPOSITION.ID
Page 34 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
FETALDISPOSITION.OTHER PLACE.CITY_ID
FETALDISPOSITION.REMOVALFROMCOUNTRY PLACE.CITYOTHER
FETALDISPOSITION.REMOVALFROMSTATE PLACE.CITYUNKNOWN
FETALDISPOSITION.UNKNOWN PLACE.COUNTRY_ID
LOOKUP.DESCRIPTION PLACE.COUNTRYOTHER
LOOKUP.GROUPNAME PLACE.COUNTRYUNKNOWN
LOOKUP.ID PLACE.COUNTY_ID
LOOKUP.KEYNAME PLACE.COUNTYOTHER
MOTHER.BIRTH_DATE PLACE.COUNTYUNKNOWN
MOTHER.FIRST_NAME PLACE.ID
MOTHER.LAST_NAME PLACE.INSIDECITYLIMITS_ID
MOTHER.MAIDEN_NAME PLACE.LATITUDE
MOTHER.MIDDLE_NAME PLACE.LONGITUDE
MOTHER.MOTHER_ID PLACE.POSTAL_ID
MOTHER.SUFFIX PLACE.POSTALOTHER
MOTHERSTG.BIRTH_DATE PLACE.POSTALPLUS4
MOTHERSTG.FIRST_NAME PLACE.POSTDIRECTIONAL
MOTHERSTG.LAST_NAME PLACE.PREDIRECTIONAL
MOTHERSTG.MAIDEN_NAME PLACE.PROVINCE_ID
MOTHERSTG.MIDDLE_NAME PLACE.PROVINCEOTHER
MOTHERSTG.MOTHER_ID PLACE.PROVINCEUNKNOWN
MOTHERSTG.SUFFIX PLACE.STREETDESIGNATOR
NAME.FIRSTNAME PLACE.STREETNAME
NAME.ID PLACE.STREETNUMBER
NAME.ISNAMED REGISTRANT.DISCRIMINATOR
NAME.LASTNAME REGISTRANT.ID
NAME.MIDDLENAME REGISTRANT.REGISTRANTINFO_ID
NAME.PERSON_ID REGISTRANT.REGISTRANTTYPE_ID
NAME.PREFIX REGISTRANT.RELATIONSHIP_ID
NAME.SUFFIX REGISTRANT.REQUEST_ID
NAMEINFO.FATHERNAME_ID REGISTRANT.SOURCE_ID
NAMEINFO.ID REGISTRANT.STATEFILENUMBER
NAMEINFO.MOTHERCURRENTNAME_ID REGISTRANT.VAULTREQUESTINFO_ID
NAMEINFO.MOTHERPRIORNAME_ID REGISTRANT.VITALSORDERDETAIL_ID
PERSON.BIRTHDATE_ID REGISTRANTINFO.DATEOFBIRTH_ID
PERSON.BIRTHPLACE_ID REGISTRANTINFO.FIRSTNAME
PERSON.CURRENTNAME_ID REGISTRANTINFO.ID
PERSON.ID REGISTRANTINFO.LASTNAME
PERSON.PRIORNAME_ID REGISTRANTINFO.MIDDLENAME
PLACE.ADDRESS1 REGISTRANTINFO.SEX_ID
PLACE.ADDRESS2 REGISTRANTINFO.STATEFILENUMBER
PLACE.ADDRESS3 REQUEST.CLOSEDBY_ID
PLACE.APTNUMBER REQUEST.CREATEDBY_ID
Page 35 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
REQUEST.ID STAFF.TITLE_MD
REQUEST.ISCHARGE STAFF.TITLE_MIDWIFE
REQUEST.REQUESTIDENTIFIER STAFF.TITLE_NNP
REQUEST.REQUESTORINFO_ID STAFF.TITLE_NURSEMIDWIFE
REQUEST.REQUESTSOURCE_ID STAFF.TITLE_OTHER
REQUEST.REQUESTSTATUS_ID STAFF.TITLE_OTHERMIDWIFE
REQUEST.RESPONSIBLE_ID STAFF.TITLE_PA
REQUEST.STATUSMESSAGE_ID STAFF.TITLE_RN
REQUESTLETTER.CREATEDBY_ID STAFF.TITLE_SNM
REQUESTLETTER.ID STAFF.TITLETEXT
REQUESTLETTER.NAME STAFFFACILITYROLEJOIN.ACTIVEINFO_ID
REQUESTLETTER.PRINTEDTEXT STAFFFACILITYROLEJOIN.FACILITY_ID
REQUESTLETTER.REQUEST_ID STAFFFACILITYROLEJOIN.ID
REQUESTLETTER.STATUS_ID STAFFFACILITYROLEJOIN.ROLE_ID
REQUESTORINFO.ADDRESS_ID STAFFFACILITYROLEJOIN.STAFF_ID
REQUESTORINFO.FACILITY_ID STATUSMESSAGEINFO.CREATEDBY_ID
REQUESTORINFO.FIRSTNAME STATUSMESSAGEINFO.ID
REQUESTORINFO.ID STATUSMESSAGEINFO.MESSAGETEXT
REQUESTORINFO.LASTNAME STATUSMESSAGEINFO.MESSAGETYPE
REQUESTORINFO.PHONE TRANSITPERMIT.APPROVEDBY_ID
REQUESTORINFO.REQUESTORVERIFICATIONINFO_ID TRANSITPERMIT.CREATEDBY_ID
REQUESTORINFO.SAVEDREQUESTOR_ID TRANSITPERMIT.CURRENTSTATUS_ID
REQUESTORINFOADDRESS.ADDRESS1 TRANSITPERMIT.ID
REQUESTORINFOADDRESS.ADDRESS2 TRANSITPERMIT.PERMITNUMBER
REQUESTORINFOADDRESS.ADDRESS3 TRANSITPERMIT.STATUSMESSAGE_ID
REQUESTORINFOADDRESS.ADDRESS4 VITADATE.CONSTRUCTEDDATE
REQUESTORINFOADDRESS.CITY VITADATE.DATEACTUAL
REQUESTORINFOADDRESS.COUNTRY_ID VITADATE.DATEAPPROX
REQUESTORINFOADDRESS.COUNTRYOTHER VITADATE.DATEUNKNOWN
REQUESTORINFOADDRESS.ID VITADATE.DAY
REQUESTORINFOADDRESS.POSTALCODE VITADATE.DAYUNKNOWN
REQUESTORINFOADDRESS.PROVINCE_ID VITADATE.HOURS
STAFF.DISCRIMINATOR VITADATE.ID
STAFF.EMAILADDRESS VITADATE.MINUTES
STAFF.FIRSTNAME VITADATE.MONTH
STAFF.ID VITADATE.MONTHUNKNOWN
STAFF.LASTNAME VITADATE.SECONDS
STAFF.LICENSEEXPIRATION VITADATE.TIMEACTUAL
STAFF.LICENSENUMBER VITADATE.TIMEAPPROX
STAFF.MIDDLENAME VITADATE.TIMETYPE
STAFF.NPI VITADATE.TIMEUNKNOWN
STAFF.TITLE_CNMCM VITADATE.YEAR
STAFF.TITLE_DO VITADATE.YEARUNKNOWN
Page 36 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
VITAUSER.CURRENTASSIGNMENT_ID VWRPT_FETALLATEREGISTRATION.CHILD_FNAME
VITAUSER.ID VWRPT_FETALLATEREGISTRATION.CHILD_LNAME
VITAUSER.PASSWORD VWRPT_FETALLATEREGISTRATION.CHILD_MNAME
VITAUSER.STAFF_ID VWRPT_FETALLATEREGISTRATION.COUNTY
VITAUSER.USERNAME VWRPT_FETALLATEREGISTRATION.COUNTY_ID
VITAUSER.USERSTATUS_ID VWRPT_FETALLATEREGISTRATION.DAYS_SINCE_ENTERED
VITAUSERACTION.ACTIONDATE VWRPT_FETALLATEREGISTRATION.DELIVERY_DATE
VITAUSERACTION.ACTIONUSER_ID VWRPT_FETALLATEREGISTRATION.DELIVERY_DAY
VITAUSERACTION.CLIENTINFO VWRPT_FETALLATEREGISTRATION.DELIVERY_MONTH
VITAUSERACTION.ID VWRPT_FETALLATEREGISTRATION.DELIVERY_YEAR
VITAUSERACTION.REMOTEADDRESS VWRPT_FETALLATEREGISTRATION.ENTRY_DATE
VITAUSERACTION.STAFFFACILITYROLEJOIN_ID VWRPT_FETALLATEREGISTRATION.FACILITY_ID
VWFETALDEATHFACILITY.FACILITYNAME VWRPT_FETALLATEREGISTRATION.FETAL_DEATH_TYPE
VWFETALDEATHFACILITY.FACILITYTYPE VWRPT_FETALLATEREGISTRATION.FETUS_WEIGHT_GRAMS
VWFETALDEATHFACILITY.SFN VWRPT_FETALLATEREGISTRATION.FH
VWFETALDEATHONBASE.DECEDENT_FNAME VWRPT_FETALLATEREGISTRATION.GESTATION_WEEKS
VWFETALDEATHONBASE.DECEDENT_LNAME VWRPT_FETALLATEREGISTRATION.MOTHER_MAIDEN_NAME
VWFETALDEATHONBASE.DECEDENT_MNAME VWRPT_FETALLATEREGISTRATION.SFN
VWFETALDEATHONBASE.DELIVERY_DAY VWRPT_FETALMORTALITY.CERTIFICATE_STATUS
VWFETALDEATHONBASE.DELIVERY_MONTH VWRPT_FETALMORTALITY.CERTIFICATESTATUS_ID
VWFETALDEATHONBASE.DELIVERY_YEAR VWRPT_FETALMORTALITY.CHILD_FNAME
VWFETALDEATHONBASE.FETAL_DEATH_TYPE VWRPT_FETALMORTALITY.CHILD_LNAME
VWFETALDEATHONBASE.MOTHER_FIRST_NAME VWRPT_FETALMORTALITY.CHILD_MNAME
VWFETALDEATHONBASE.MOTHER_LAST_NAME VWRPT_FETALMORTALITY.COUNTY
VWFETALDEATHONBASE.MOTHER_MAIDEN_NAME VWRPT_FETALMORTALITY.COUNTY_ID
VWFETALDEATHONBASE.MOTHER_MIDDLE_NAME VWRPT_FETALMORTALITY.DELIVERY_DATE
VWFETALDEATHONBASE.REQUESTIDENTIFIER VWRPT_FETALMORTALITY.DELIVERY_DAY
VWFETALDEATHONBASE.SOURCE VWRPT_FETALMORTALITY.DELIVERY_MONTH
VWFETALDEATHONBASE.STATEFILENUMBER VWRPT_FETALMORTALITY.DELIVERY_YEAR
VWRPT_CSMS_PENDINGAPPLICATIONS.ACTIONDATE VWRPT_FETALMORTALITY.ENTRY_DATE
VWRPT_CSMS_PENDINGAPPLICATIONS.COUNTYNAME VWRPT_FETALMORTALITY.FACILITY_ID
VWRPT_CSMS_PENDINGAPPLICATIONS.DESCRIPTION VWRPT_FETALMORTALITY.FETAL_DEATH_TYPE
VWRPT_CSMS_PENDINGAPPLICATIONS.FIRSTNAME VWRPT_FETALMORTALITY.FETALDEATHTYPE_ID
VWRPT_CSMS_PENDINGAPPLICATIONS.LASTNAME VWRPT_FETALMORTALITY.FETUS_WEIGHT_GRAMS
VWRPT_CSMS_PENDINGAPPLICATIONS.MIDDLENAME VWRPT_FETALMORTALITY.FH
VWRPT_CSMS_PENDINGAPPLICATIONS.OFFICE VWRPT_FETALMORTALITY.GESTATION_WEEKS
VWRPT_CSMS_PENDINGAPPLICATIONS.OVRFIRSTNAME VWRPT_FETALMORTALITY.MOTHER_MAIDEN_NAME
VWRPT_CSMS_PENDINGAPPLICATIONS.OVRLASTNAME VWRPT_FETALMORTALITY.SFN
VWRPT_CSMS_PENDINGAPPLICATIONS.REQUESTIDENTIFIER VWRPT_FETALPERMITS.COUNTYNAME
VWRPT_CSMS_PENDINGAPPLICATIONS.STATEFILENUMBER VWRPT_FETALPERMITS.DELIVERY_DATE
VWRPT_CSMS_PENDINGAPPLICATIONS.TYPE VWRPT_FETALPERMITS.ENTRY_DATE
VWRPT_FETALLATEREGISTRATION.CERT_STATUS VWRPT_FETALPERMITS.FETALDEATH_ID
VWRPT_FETALLATEREGISTRATION.CERTIFICATESTATUS_ID VWRPT_FETALPERMITS.FILENUMBER
Page 37 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
VWRPT_FETALPERMITS.PERMITNUMBER VWSAFESLEEP.ACTIONDATE
VWRPT_MORTUARYDISPOSITION.CERT_STATUS VWSAFESLEEP.ADDRESS1
VWRPT_MORTUARYDISPOSITION.CERTIFICATE_STATUS VWSAFESLEEP.ADDRESS2
VWRPT_MORTUARYDISPOSITION.CERTIFICATESTATUS_ID VWSAFESLEEP.CITY
VWRPT_MORTUARYDISPOSITION.CHILD_FNAME VWSAFESLEEP.COUNTYNAME
VWRPT_MORTUARYDISPOSITION.CHILD_LNAME VWSAFESLEEP.FIRSTNAME
VWRPT_MORTUARYDISPOSITION.CHILD_MNAME VWSAFESLEEP.LASTNAME
VWRPT_MORTUARYDISPOSITION.COUNTY VWSAFESLEEP.PHONE
VWRPT_MORTUARYDISPOSITION.COUNTY_ID VWSAFESLEEP.POSTALCODE
VWRPT_MORTUARYDISPOSITION.DELIVERY_DATE VWSAFESLEEP.REGISTRANT_TYPE
VWRPT_MORTUARYDISPOSITION.DELIVERY_DAY VWSAFESLEEP.RELATIONSHIP
VWRPT_MORTUARYDISPOSITION.DELIVERY_MONTH VWSAFESLEEP.REQUEST_SOURCE
VWRPT_MORTUARYDISPOSITION.DELIVERY_YEAR VWSAFESLEEP.REQUEST_STATUS
VWRPT_MORTUARYDISPOSITION.ENTRY_DATE VWSAFESLEEP.REQUESTIDENTIFIER
VWRPT_MORTUARYDISPOSITION.FACILITY_ID VWSAFESLEEP.STATEFILENUMBER
VWRPT_MORTUARYDISPOSITION.FETAL_DEATH_TYPE WEIGHT.GRAMS
VWRPT_MORTUARYDISPOSITION.FETALDEATHTYPE_ID WEIGHT.ID
VWRPT_MORTUARYDISPOSITION.FETUS_WEIGHT_GRAMS WEIGHT.OUNCES
VWRPT_MORTUARYDISPOSITION.FH WEIGHT.POUNDS
VWRPT_MORTUARYDISPOSITION.GESTATION_WEEKS WEIGHT.UNKNOWN
VWRPT_MORTUARYDISPOSITION.MOTHER_MAIDEN_NAME
VWRPT_MORTUARYDISPOSITION.SFN
Limitations on Data Use:
Data may only be used for administrative support and operations of MCDPH. No identifiable information may be
published, used in public health research, and no contact may be attempted with individuals or families of
individuals contained within the shared CSMS data unless approved by ADHS.
Principle Contacts:
Arizona Department of Health Services
Bureau Chief, Bureau of Vital Records
Arizona Department of Health Services
1818 West Adams
Phoenix, AZ, 85007
Phone: (602) 364-1300
Selection Criteria:
All events which occurred within Maricopa County, or which were reported by a provider located within Maricopa
County.
Page 38 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT M – Arizona Birth Defects Registry Data
Time Frame and Scope of Data Shared:
Data are shared via data extract of individual records that need chart abstraction.
Data Fields Shared:
All data elements deemed necessary as found in the Birth Defects Registry Confidential data set.
Limitations on Data Use:
Data may only be accessed or used by MCDPH staff acting under a medical record abstraction services contract
between ADHS and MCDPH. Data may only be used in chart abstraction activity conducted under that contract.
Data may not be retained by MCDPH or MCDPH staff once services relating to that record under the contract are
completed. Data must be properly secured per the terms and conditions specified in this MOU.
Principle Contacts:
Arizona Department of Health Services
Birth Defects Registry Program Manager
150 N 18th Avenue, Suite 584
Phoenix, AZ, 85007
Phone: (602) 542-7335
Selection Criteria:
All records selected by the ADHS Principal contact.
Page 39 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT N – Arizona Cancer Registry Data
Time Frame and Scope of Data Shared:
Data are shared via data extract of individual records of Arizona residents that need chart abstraction, data quality
control or editing as directed by the Arizona Cancer Registry Program.
Data Fields Shared:
All data elements deemed necessary as found in the Cancer Registry Confidential data set.
Limitations on Data Use:
Data may only be accessed or used by MCDPH staff acting under a medical record abstraction services contract
between ADHS and MCDPH for chart abstraction, data quality control or editing as directed by the Arizona Cancer
Registry Program. Data may only be used in chart abstraction activity conducted under that contract. Data may
not be retained by MCDPH or MCDPH staff once services relating to that record under the contract are completed.
Data must be properly secured per the terms and conditions specified in this MOU.
Principle Contacts:
Arizona Department of Health Services
Cancer Registry Program Manager
150 N 18th Avenue, Suite 550
Phoenix, AZ, 85007
Phone: (602) 542-7321
Selection Criteria:
All records selected by the ADHS Principal contact.
Page 40 of 41

MEMORANDUM OF UNDERSTANDING
HU756005
EXHIBIT O – ARIZONA PREHOSPITAL INFORMATION EMERGENCY
MEDICAL SERVICES REGISTRY SYSTEM (AZ-PIERS)
Allowable Purpose:
Data are allowed to be exchanged by ADHS and MCDPH for conducting public health practice, surveillance, and
research as a part of a joint public health initiative with ADHS. Specific projects must be approved as described in
this MOU.
Limitations on Data Use:
Data may only be used as described above, no identifiable information may be published and no contact may be
attempted with agencies or individuals unless approved as described above.
Principle Contacts:
Arizona Department of Health Services
Bureau Chief, Bureau of EMS and Trauma System
150 N 18th Avenue, Suite 540
Phoenix, AZ, 85007
Phone: (602) 364-3149
Frequency of Data Release:
Yearly, after the data file has been closed, cleaned, and finalized, typically by the first day of August. Weekly
aggregate files will also be shared on a case-by-case basis as determined by ADHS and the County.
Selection Criteria:
As agreed by ADHS and the MCDPH on a project by project basis (see attached list for full data set).
Page 41 of 41