Services & Data Requests - Data Available



Databases Year/Quarter
Inpatient Discharge 1990 - Q1 2017
Ambulatory/Outpatient Procedure 1996 - Q1 2017
Revenue Code Detail - Inpatient 1996 - Q1 2017
Revenue Code Detail - Ambulatory/Outpatient 1997 - Q1 2017
Financial 1996 - 2015

Inpatient Discharge Data:

PHC4 collects more than 1.7 million inpatient discharge records from Pennsylvania hospitals per year. These records are available for those who wish to analyze detailed hospital inpatient discharge data in the form of standard predetermined data files or custom data files. There are more than 70 data fields available, which include clinical, utilization, and administrative data. Some examples of these include information such as Diagnosis Related Groups (DRGs), Major Diagnostic Categories (MDCs), admission type and source, diagnosis and procedure codes, discharge status, length of stay, and charges. Information on patient origin, payer, physician, and facility is also included.

Ambulatory/Outpatient Procedure Data:

PHC4 collects more than 3.5 million ambulatory/outpatient records from Pennsylvania ambulatory surgery centers and hospitals per year. These records are available for those who wish to analyze detailed ambulatory/outpatient procedure data in the form of standard predetermined data files or custom data files. There are more than 70 data fields available, which include utilization and administrative data. Some examples of these include information such as admission type and source, diagnosis and procedure codes, and charges. Information on patient origin, payer, physician, and facility is also included. View the list of ambulatory/outpatient procedures required to be submitted to PHC4.

Standard Data: Pennsylvania statewide records, regional records, or specific facility records are available in standard data files. Statewide files include all records regardless of where a patient resides. Regional files are made available by PHC4’s nine assigned geographic areas of the state (view regional map). Regional files include records from the facilities within that region, not patients who are residents of the regional area. Facility files are records from the specific facility.

Custom Data: a subset of records from the Pennsylvania statewide database selected based on criteria provided in an application. Such as, a custom data request may request a specific geographic scope (by county or zip codes) and/or clinical/condition scope (MDCs, DRGs, diagnosis codes, or combination). Custom data requests may entail aggregated data, such as the number of cases by DRG and so forth. Additionally, custom data requests may include linking data to other data sources upon request, such as the vital statistics data from the Pennsylvania Department of Health.

Revenue Code Detail Data:

The Revenue Code Detail data contains very detailed billing information that is provided by Pennsylvania hospitals and ambulatory surgery centers. These records are available in the form of a statewide standard inpatient or ambulatory/outpatient dataset for those who wish to analyze detailed records that breakout the aggregated charges contained in the Inpatient Discharge database and Ambulatory/Outpatient Procedure databases. Each individual line item in the Revenue Code Detail data file is a charge amount for different types of room and board, services, equipment and other charges.

Financial Data:

The Financial Data is a statewide standard data file that presents a profile of the financial health of Pennsylvania hospitals and ambulatory surgery centers. The data file includes financial, utilization, and payer information by facility per year. The information contained in the file is used in PHC4’s annual Financial Analysis reports.


Quarterly Data Release Schedule:

Inpatient discharge, ambulatory/outpatient procedure, and revenue code detail databases are processed by the date of discharge and released on a quarterly basis. Financial data is released at the end of the year on an annual basis.

When applicable, PHC4 provides supplemental physician and facility data files with each data request file. The supporting physician file provides the physician name by national provider identifier/license number. The supporting facility file provides a profile of hospitals and ambulatory surgery centers. The file includes facility name, type of facility, PHC4 assigned facility ID (PAF number), bed count, region, county, address, and total number of inpatient and outpatient records.


For more information contact Special Requests at .