Data Documentation from Prior Years#

The complete data documentation for each year can be downloaded below as a .zip file.

Frequently Asked Questions#

Why don’t the ED/AS datasets include charges, like the PDD dataset does?

The Total Charges data element was not identified by the legislature as a data requirement for the ED/AS data.

In the patient-level SAS data sets, why are E-code and diagnosis variables different lengths in the PDD and ED/AS Data Sets?

It has to do with how the data is extracted for the submission system. In the near future, system changes to prepare for ICD-10-CM and ICD-10-PCA coding will result in the diagnosis codes and the external cause of injury codes being a consistent length across PDD, ED and AS datasets.

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.

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.

Why do hospitals have the same license number/OSHPD facility number even though they operate on geographically distinct campuses? 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.

Why don’t the ED/AS datasets include ICD-9 procedure codes?

The ED and AS datasets include CPT-4 procedure codes, not ICD-9 procedure codes. For more information, see the documentation for Principal Procedure and Other Procedure provided by the MIRCal (data submission) system.