Documentation for current patient-level data sets and related products are provided here. Documentation for earlier files is available upon request.
- 1. Why don't the ED/AS data sets include charges, like the PDD data set does?
The Total Charges data element was not identified by the legislature as a data requirement for the ED/AS data.
Diagnosis and E-Codes
- 2. 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 data sets.
- 3. When will the "disposition" code in the PDD or ED/AS data sets conform to National Uniform Billing Code (NUBC) standards?
ED and AS disposition was established to conform to NUBC standards from the beginning of data collection in 2005. Changes to the current proprietary inpatient data reporting requirements require regulatory action.
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.
- 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.
This page was last updated on Friday, September 30, 2016.
Type of Request
Data Years Available
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)