Inpatient and Outpatient Data

Texas Health Care Information Collection
Center for Health Statistics

Texas Outpatient Public Use Data File (PUDF)

The Outpatient PUDF contains data on outpatient surgical and radiological procedures from Texas hospitals and ambulatory surgery centers. Data are available by quarter beginning with data for fourth quarter 2009 through second quarter 2010. The scheduled release date for fourth quarter 2010 is December 2011. Purchasing the PUDF requires a completed Order Form and a signed Data Use Agreement.

The data files for data released include 123 data fields in a base data file, 141 data fields in a classifications data file, 13 data fields in a detailed charges file, and 27 data fields in a facility type code file. Information on the data fields is included in the Data Dictionary, 2010 and information on the facilities reporting data is included in the Reporting Status, 2010 table. The PUDF includes:

• Reporting Status, 2010 (PDF format, 409 KB)
• Data Use Agreement (PDF format, 96 KB)
• PUDF Order Form (PDF format, 31 KB)

Data Dictionary (PDF format):

• Data Dictionary, 2010 (PDF format, 267 KB)

Comments submitted by facilities about their data. (PDF format)

• 2010 First Quarter (109 KB), Second Quarter (92 KB), Third Quarter (89 KB)
• 2009 Fourth Quarter (153 KB)

Texas Inpatient Public Use Data File (PUDF)

• User Manual, 2010 (PDF format, 529 KB)
• Data Use Agreement (PDF format, 96 KB)
• PUDF Order Form (PDF format, 26 KB)

Statistics on hospital discharges. (Excel format)

• 2010 (185 KB)
• 2009 (132 KB)
• 2008 (134 KB)
• 2007 (104 KB)
• 2006 (101 KB)
• 2005 (97 KB)

User Manuals for earlier years (PDF format):

• User Manual, 2009 (543 KB)
• User Manual, 2008 (923 KB)
• User Manual, 2007 (936 KB)
• User Manual, 2006 (580 KB)
• User Manual, 2005 (545 KB)
• User Manual, 2004 (549 KB)

Comments submitted by hospitals about their data. (PDF format)

• 2010 First Quarter (184 KB), Second Quarter (156 KB), Third Quarter (153 KB)
• 2009 First Quarter (230 KB), Second Quarter (194 KB), Third Quarter (197 KB) and Fourth Quarter (191 KB)
• 2008 First Quarter (194 KB), Second Quarter (228 KB), Third Quarter (223 KB) and Fourth Quarter (196 KB)
• 2007 First Quarter (215 KB), Second Quarter (965 KB), Third Quarter (236 KB) and Fourth Quarter (235 KB)
• 2006 First Quarter (217 KB), Second Quarter (214 KB), Third Quarter (215 KB) and Fourth Quarter (210 KB)
• 2005 First Quarter (224 KB), Second Quarter (211 KB), Third Quarter (204 KB) and Fourth Quarter (210 KB)
• 2004 First Quarter (224 KB), Second Quarter (225 KB), Third Quarter (219 KB) and Fourth Quarter (213 KB)
  

The Public Use Data File (PUDF) for 1999, 2000, 2001, 2002, 2003 and 2004, in fixed-length format, is available for free download.

• Second quarter, 2010 - Update in Excel format

Charges records for some discharges were inadvertently omitted from the Second quarter 2010 PUDF.  These records should be added to your copy of the Quarter 2 2010 Public Use Data File (PUDF).

• Second quarter, 2010 - Charges file update in fixed-length format and tab-delimited format

Records for additional discharges in Quarter 4, 2009 have been found to be duplicated in the data for Quarter 1, 2010. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 1 Public Use Data File (PUDF). August 19, 2011.

• First quarter, 2010 - Update in Excel format

Records for some discharges in Quarter 4, 2009 were inadvertently duplicated in the data for Quarter 1, 2010. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 1 Public Use Data File (PUDF). May 18, 2011.

• First quarter, 2010 - Update in Excel format

Records for some discharges in Quarter 1, 2009 were inadvertently duplicated in the data for Quarter 2, 2009. The following update includes the Record ID for those duplicate records that should be deleted from your copy of the Quarter 2 Public Use Data File (PUDF). September 9, 2010.

• Second quarter, 2009 - Update in Excel format

Updates to correct missing uniform physician identifiers have been released for the second, third and fourth quarter 2007 Public Use Data Files (PUDF) and the first, second and third quarter 2008 PUDF. The updates include uniform identifiers for the Attending Physician and Operating Physician fields, ATTENDING_PHYSICIAN_UNIF_ID and OPERATING_PHYSICIAN_UNIF_ID, that were set to missing in the original files. Use the update to correct your copy of the PUDF files. For more information please contact THCIC Staff. 

• Second quarter, 2007 Fixed-length format, Tab-delimited format
• Third quarter, 2007 Fixed-length format, Tab-delimited format
• Fourth quarter, 2007 Fixed-length format, Tab-delimited format
• First quarter, 2008 Fixed-length format, Tab-delimited format
• Second quarter, 2008 Fixed-length format, Tab-delimited format
• Third quarter, 2008  Fixed-length format, Tab-delimited format

An update has been released for the second quarter 2006 Public Use Data File (PUDF). It updates county codes, ZIP codes and Public Health Regions that were set to missing in the original file. Use the update to correct your copy of the PUDF. For more information please contact THCIC Staff.

• Second quarter, 2006 Fixed-length format, Tab-delimited format

An update has been released for the third quarter 2004 Public Use Data File (PUDF). The update includes those records for which the 3M APR-DRG grouping was corrected. This correction was necessitated because some records were not grouped with Version 20 of the APR-DRG Grouper. The files include the Record ID and four additional data elements: APR-DRG code, APR-MDC, Severity of Illness, and Risk of Mortality. Use the update to correct your copy of the PUDF.

Third quarter, 2004 Fixed-length format, Tab-delimited format

Updates have been released for the 2003 PUDF. The updates include Patient Status codes for those records where the patient status was incorrectly indicated as invalid. The files contain the 12-digit Encounter ID and the 2-digit Patient Status Code. Use the files to update your copy of the PUDF. September 23, 2005

• First quarter, 2003 Fixed-length format, Tab-delimited format
• Second quarter, 2003 Fixed-length format, Tab-delimited format
• Third quarter, 2003 Fixed-length format, Tab-delimited format
• Fourth quarter, 2003 Fixed-length format, Tab-delimited format

The User Manuals for 1999, 2000 and 2001 have been updated to correctly document the data field ADMIT WEEKDAY. The values for this data field should be interpreted as:

• Monday
• Tuesday
• Wednesday
• Thursday
• Friday
• Saturday
• Sunday

Research File

Hospital Discharge Data not released in the PUDF can be requested for research purposes by individuals and organizations, including universities and government agencies. The data elements required for the proposed research and a description of the intended use of the data are reviewed by the THCIC. The approved application is then submitted to the DSHS Institutional Review Board, acting as the Scientific Review Panel (SRP), for final approval.