Data Documentation

Documentation for current patient-level data sets and related products are provided here. Documentation for earlier files is available upon request.

Documentation FAQs

Data Dictionaries
Document Name Download Link
  • Data Dictionary
    A catalog of file contents, including the variable names, types, lengths, definitions, values and What's New information about the patient-level data that is released.
PDD
ED/AS
Appendices
Document Name Download Link
PDD/ED/AS
  • B – not used in 2015
N/A
  • C – Modifications and Exceptions
    Modifications to standard data reporting requirements are granted to some facilities that were unable to complete specific fields as required or were determined to be out of compliance at the time of reporting.
    Exceptions are reported for facilities with records that were initially flagged as wrong but were actually reported correctly.
PDD/ED/AS
  • D – Facility Status
    Facility consolidation status:
    when multiple facility locations operate under one hospital license, the licensed entity is considered a consolidated provider. These types of facilities can report patient-level data as either separate entities or aggregated, as one consolidated provider.
    Status changes: openings, closures, and ownership changes
PDD/ED/AS
  • E – not used in 2015
N/A
PDD | ED | AS
PDD/ED/AS
PDD only
PDD only
PDD only
  • K – Disposition Crosswalk
PDD only
PDD Q1-Q3 | PDD Q4
ED Q1-Q3 | ED Q4
AS Q1-Q3 | AS Q4
PDD/ED/AS
Additional Information
Document Name Download Link
File Sizes PDD/ED/AS
Record Counts per Database PDD/ED/AS
For SAS Users
Document Name Download Link
  • Proc Contents
    Summary list of variables and variable type, length, and label; similar to SAS Proc Contents output.
PDD | ED | AS
Data Dictionaries
Document Name Download Link
Public Nonpublic
  • Data Dictionary
    A catalog of file contents, including the variable names, types, lengths, definitions, values and What's New information about the patient-level data that is released.
PDD
ED/AS
PDD
ED/AS
Appendices
Document Name Download Link
Public Nonpublic
N/A PDD/ED/AS
PDD
ED/AS
N/A
  • C – Modifications and Exceptions
    Modifications to standard data reporting requirements are granted to some facilities that were unable to complete specific fields as required or were determined to be out of compliance at the time of reporting.
    Exceptions are reported for facilities with records that were initially flagged as wrong but were actually reported correctly.
PDD | ED | AS
  • D – Facility Status
    Facility consolidation status:
    when multiple facility locations operate under one hospital license, the licensed entity is considered a consolidated provider. These types of facilities can report patient-level data as either separate entities or aggregated, as one consolidated provider.
    Status changes: openings, closures, and ownership changes
PDD/ED/AS
PDD | ED | AS N/A
PDD | ED | AS
N/A PDD/ED/AS
N/A PDD only
PDD only
PDD only
  • K – not used in 2014
PDD | ED | AS
  • M – Linkable RLNs
PDD/ED/AS
Additional Information
Document Name Download Link
Public Nonpublic
File Sizes N/A PDD/ED/AS
Record Counts per Database N/A PDD/ED/AS
For SAS Users
Document Name Download Link
Public Nonpublic
  • Proc Contents
    Summary list of variables and variable type, length, and label; similar to SAS Proc Contents output.
PDD | ED | AS
Proc Format SAS Program Available upon request for PDD and ED/AS Public Use Files.
Data Dictionaries
Document Name Download Link
Nonpublic – IPA Nonpublic – AB 2876
  • Data Dictionary
    A catalog of file contents, including the variable names, types, lengths, definitions, values and What's New information about the patient-level data that is released.
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
Appendices
Document Name Download Link
Nonpublic – IPA Nonpublic – AB 2876
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
Data Dictionaries
Document Name Download Link
Public Nonpublic
  • Data Dictionary
    A catalog of file contents, including the variable names, types, lengths, definitions, values and What's New information about the patient-level data that is released.
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
Appendices
Document Name Download Link
Nonpublic – IPA Nonpublic – AB 2876
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
Data Dictionaries
Document Name Download Link
Nonpublic - IPA Nonpublic - AB 2876
  • Data Dictionary
    A catalog of file contents, including the variable names, types, lengths, definitions, values and What's New information about the patient-level data that is released.
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
Appendices
Document Name Download Link
Nonpublic – IPA Nonpublic – AB 2876
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
Data Dictionaries
Document Name Download Link
Nonpublic - IPA Nonpublic - AB 2876
  • Data Dictionary
    A catalog of file contents, including the variable names, types, lengths, definitions, values and What's New information about the patient-level data that is released.
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
Appendices
Document Name Download Link
Nonpublic – IPA Nonpublic – AB 2876
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug
PDD
ED/AS – Jan-Jun
ED/AS – Jul-Aug

Documentation FAQ

Charges
Diagnosis and E-Codes
Disposition
Expected Source of Payment
  • 4. Can patients enrolled in Covered California be tracked in OSHPD data?
    Covered California coverage will be able to be identified if a unique Plan Code identifier is assigned by the Department of Managed Care and reported on the submitted record. At this time, there is no indication that the Department of Managed Care is going to provide a unique identifier.
Facility Number
  • 5. Why is Facility Number a 9-digit variable in OSHPD's financial and utilization databases and a 6-digit variable in the patient-level PDD and ED/AS databases?
    OSHPD’s financial and utilization databases begin with a 3-digit number that indicates the “type of facility” (106=hospital, 206=long term care, 306 = clinic, 406 = home health/hospice agency). The last six digits are the Facility Number that is issued by OSHPD; this number is also used in the PDD & ED/AS Data Sets. The first two digits indicate the county in which the facility operates. The last four digits are assigned by OSHPD to identify the facility. The PDD and ED/AS databases do not have a “type of facility” indicator.
  • 6a. Why do hospitals have the same license number/OSHPD facility number even though they operate on geographically distinct campuses?

    6b. Why do hospitals that have identical license numbers/OSHPD facility numbers in OSHPD's PDD and ED/AS data have different OSHPD IDs in the Facility Listings report?
    Upon meeting certain criteria (e.g., a single governing body, administration, medical staff, and close proximity), the California Department of Public Health may issue a consolidated license to multiple hospital locations, whereby a single location is designated as the Parent Facility and each remaining location is designated as a Consolidated Facility. Currently, over 60 hospitals are operating with a consolidated license. These facilities report data to OSHPD as either separate entities or aggregated, as one consolidated provider, depending on the type of data they are reporting.
    • When reporting patient-level data to OSHPD's MIRCal system, each consolidated facility can elect to report as either a separate entity or aggregated, as one consolidated provider, under the OSHPD Facility Number of the Parent Facility. Usually facilities elect to combine on an all-or-nothing basis, but this is not always the case.
    • When reporting utilization data to OSHPD's ALIRTS system, multiple hospital locations that operate under a consolidated license must submit a separate report for each location. The hospital name, address and facility number is automatically entered into the ALIRTS database from OSHPD's Licensed Facility Information System (LFIS), based on data from the California Department of Public Health (CDPH) Licensing and Certification Division. OSHPD's Facility Listings report is also based on the LFIS data.
    • When reporting financial data to OSHPD's SIERA system, hospitals are permitted to report under the OSHPD Facility Number of the Parent Facility since facilities that operate under a consolidated license typically use an integrated accounting system.
Procedure Codes

This page was last updated on Friday, September 30, 2016.

Data Years Available
  PDD ED/AS
PUF 2010-2014 2010-2014
AB 2876 1983-2015 2005-2015
IPA 1983-2015 2005-2015
Custom 1983-2015 2005-2015
Contact Us

Healthcare Information Resource Center
400 R Street, Suite 250
Sacramento, CA 95811-6213
Tel: (916) 326-3802
Fax: (916) 324-9242
Hours: Monday-Friday 8 a.m. to 5 p.m. (PST)
E-mail HIRC