HEALTHCARE COST & UTILIZATION PROJECT

User Support

Do Your own analysis
Explore Expert Research & Limited Datasets

Central Distributor SID: Description of Data Elements

 
PRn - ICD-9-CM Procedure
 
Documentation Sections:
General Notes
Uniform Values
State Specific Notes
General Notes
 

In data prior to the fourth quarter of 2015, International Classification of Diseases, Ninth Revision, Clinical Modification (ICD-9-CM) procedures reported on HCUP records are stored in the data elements PRn. Beginning in the fourth quarter of 2015, International Classification of Diseases, Tenth Revision, Clinical Modification (ICD-10-CM) procedures reported on HCUP records are stored in the data elements I10_DXn.

In the HCUP databases, ICD-9-CM procedures are represented as 3- to 4-character numeric codes with implicit decimals (i.e., decimals not included). Prior to data year 2014, the HCUP data elements for ICD-9-CM procedures are length 4; in 2014, they are length 7. The codes are left-justified in the HCUP databases so that prior to 2014 there is one space following a 3-digit procedure code (four spaces, in 2014). For example, the procedure code 37.0 would appear as '370 ' with a trailing blank in HCUP data. Any zeroes at the beginning of the code are significant; they are part of the code. Any zeroes at the beginning of the code are significant; they are part of the code. For example, the ICD-9-CM procedure code 03.1 would be stored in the HCUP databases as '031 ' and the diagnosis 003.1 would be stored as '0031'.

The original value of the ICD-9-CM first-listed procedure (PR1), whether blank or coded, is retained in the first position of the procedure vector. Starting at the first secondary procedure (PR2), the procedures are shifted during HCUP processing to eliminate blank secondary procedures. For example, if PR2 and PR4 contain nonmissing procedures and PR3 is blank, then the value of PR4 is shifted into PR3. Secondary procedures are never shifted into the first listed position (PR1).

Procedures are compared to a list of ICD-9-CM codes valid for the discharge date. Anticipation of or lags in response to official ICD-9-CM coding changes are permitted for discharges occurring within a window of time around the official ICD-9-CM coding changes (usually October 1). Prior to 1998 data, a six months window (three months before and three months after) is allowed. Beginning in the 1998 data, a year window (six months before and six months after) is allowed. If the procedure contains intermittent blank characters or is zero filled, then the procedure will be considered invalid.

Procedures are compared to the sex of the patient (edit check EPR03 beginning in the 1998 data and ED2nn prior to 1998 data) and the patient's age (edit check EAGE05 beginning in the 1998 data and ED5nn prior to 1998 data) for checking the internal consistency of the record.

How invalid and inconsistent codes are handled varies by data year.

  • Beginning in the 1998 data, invalid and inconsistent procedures are masked directly. Validity flags are not included on the HCUP record. Clinical Classifications Software (CCS) data elements are coded with respect to the procedure.
  Invalid Procedure Inconsistent Code
The value of PRn "invl" "incn"
PRCCSn Set to invalid (.A) Set to inconsistent (.C)
  • Prior to 1998 data, invalid and inconsistent procedures are retained on the record. Validity flags (PRVn) indicate invalid, inconsistent procedure codes. Clinical Classifications Software (CCS) data elements use the former name (PCCHPRn). The CCS was formerly known as the Clinical Classifications for Health Policy Research (CCHPRn). The procedure related data element are coded as follows:
  Invalid Procedure Inconsistent Code
The value of PRn Unchanged Unchanged
PRVn Set to 1 Set to inconsistent (.C)
PCCHPRn Set to invalid (.A) Retained (values 1-260)


The validity flags (PRVn) need to be used in connection with any analysis of the procedures (PRn).

The maximum number of procedures reported varies by state. HCUP retains all procedure fields provided by the data source.

 

Number of Procedures Provided by the Data Source
State 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
Alaska n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 20 20 25     25
Arizona 6 6 6 6 6 6 6 6 6 6 12 12 12 12 12 12 12 12
Arkansas n/a n/a n/a n/a n/a n/a 6 6 6 6 8 8 8 8 8 8 8 21
California 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21
Colorado 15 15 15 15 15 15 15 15 15 15 15 15 30 30 30 30 30 30
Connecticut 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30
District of Columbia n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 24 31 50
Florida 10 10 10 10 6 10 10 10 31 31 31 31 31 31 31 31 31 31
Georgia 6 6 6 6 6 6 6 6 6 30 30 30 30 30 30 50 50 50
Hawaii 10 10 10 10 10 15 20 20 20 20 20 20 20 20 25 25 25 35
Illinois 6 6 6 6 6 6 6 6 6 6 6 25 25 25 25 25 25 25
Indiana n/a n/a n/a n/a n/a 15 15 15 15 15 15 15 15 25 25 25 50 60
Iowa 6 6 6 6 6 6 6 6 6 32 37 37 29 26 50 55 50 35
Kansas 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25
Kentucky n/a n/a 6 6 6 6 6 6 6 6 25 25 25 25 25 25 25 25
Louisiana n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 7 6 8 8 8 6 6 50
Maine n/a 10 6 6 6 6 n/a n/a 6 6 6 6 6 6 6 6 6 25
Maryland 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 30 30 30
Massachusetts 10 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 66 66
Michigan n/a 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30
Minnesota n/a n/a n/a 6 6 6 6 6 6 25 25 25 34 40 50 50 50 50
Mississippi n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 6 6 n/a n/a n/a 30
Missouri 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25
Montana n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 25 25 25 25 25 25 25
Nebraska n/a n/a n/a 6 6 6 6 6 6 6 6 6 6 6 6 6 6 15
Nevada n/a n/a n/a n/a 6 9 9 10 10 10 12 12 12 12 12 25 25 25
New Hampshire n/a n/a n/a n/a n/a 6 6 6 6 6 6 6 n/a n/a n/a n/a n/a n/a
New Jersey 8 8 8 8 8 8 8 8 8 8 24 25 25 25 25 25 25 25
New Mexico n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 6 6 6 6 6 6 6
New York 15 15 15 15 15 15 15 15 15 15 15 15 15 15 14 14 14 14
North Carolina n/a n/a 10 11 6 6 6 7 6 6 8 24 24 20 20 20 20 20
North Dakota n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 25 25 25 25 25
Ohio n/a n/a n/a n/a 9 9 9 9 9 9 9 9 9 9 9 9 110 50
Oklahoma n/a n/a n/a n/a n/a n/a n/a 16 16 16 16 16 16 16 16 16 16 16
Oregon 6 6 6 6 6 6 6 6 6 6 25 25 25 25 25 25 25 32
Pennsylvania 6 6 6 6 6 6 n/a n/a n/a n/a 6 6 6 6 6 6 6 6
Rhode Island n/a n/a n/a 11 11 11 11 11 25 25 25 25 25 25 25 25 25 25
South Carolina 10 10 10 10 10 10 10 10 10 13 13 13 13 13 13 13 13 13
South Dakota n/a n/a n/a n/a 6 6 6 6 6 44 46 65 47 63 60 25 25 25
Tennessee 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
Texas n/a n/a 6 6 6 6 25 15 15 15 15 15 15 15 15 15 15 25
Utah 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
Vermont n/a n/a n/a 20 10 20 20 20 20 20 20 20 20 20 20 20 20 20
Virginia n/a 6 6 6 6 6 6 n/a 6 6 6 6 6 6 6 6 6 6
Washington 6 6 6 6 6 6 6 6 6 25 25 25 25 25 25 25 25 25
West Virginia n/a n/a 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
Wisconsin 6 6 6 6 6 6 6 6 30 30 30 30 30 30 50 50 50 50
Wyoming n/a n/a n/a n/a n/a n/a n/a n/a n/a 25 25 25 25 25 25 25 25 25
 
Top
 
 
 
Uniform Values
 
VariableDescriptionValueValue Description
PRnICD-9-CM ProcedurennnnProcedure code
BlankMissing
invlInvalid: beginning with 1998 data, EPR02
incnInconsistent: beginning with EAGE05, EPR03
 
Top
 
 
 
State Specific Notes

Arizona

Beginning in 1998, a few hospitals reported 5-digit codes in the procedure fields. Since ICD-9-CM procedures are have either 3 or 4 digits, these five digit codes were set to invalid.

Beginning in 1993, Arizona procedure codes were not right-padded with zeros. Arizona reported procedure codes with an explicit decimal point. The decimal point was removed during HCUP processing.

Prior to 1993, the procedure codes provided by Arizona were right-padded with zeros (e.g., the procedure code '403 ' was supplied as '4030'). The following algorithm was used during HCUP processing to validate the procedure codes:

Check four-digit code for validity (using a six-month window for coding changes, 3 months before and 3 months after October of each year when ICD-9-CM coding changes occur).

  1. If four-digit code is valid, set PR1 to the four-digit code and set PRV1 = 0.
  2. If the four-digit code is invalid and fourth digit is a zero, create a three-digit code by deleting the trailing zero and re-check for validity (using six-month window for coding changes). If the three-digit code is valid, set PR1 to the three-digit code and set PRV1 = 0.
  3. If both the four-digit and three-digit codes are invalid, save the original four-digit code PR1 and set the validity flag to indicate an invalid code (PRV1 = 1).


California

Shriner's hospitals do not report diagnoses, procedures or total charges.



Florida

In 1992 only, the hospitals identified below have erroneous procedure information when a patient had more than one operative episode during a stay. The first operative episode, which can be defined by one or more procedure codes, is correctly reported. The procedure codes for any subsequent operative episodes were not reported. The following hospitals, identified by the HCUP hospital identifier (HOSPID), are affected:

  • 390530
  • 390170
  • 391000
  • 390067
  • 390622
  • 390870
  • 390060
  • 391060
  • 390727
  • 390515
  • 390034


Kentucky

Kentucky supplied procedure codes in a field length of 7. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



Maryland

Maryland supplied procedure codes in a field of length 5. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



Massachusetts

Due to an error in HCUP processing, the procedure verification table for 1988-1992 incorrectly accepted some codes as valid, on year beyond the date when these codes were deleted or superseded by more detailed codes. With the three-month grace period built into the processor, these codes were mistakenly accepted for one full year beyond the year in which they became invalid.

Examination of frequencies from the HCUP Massachusetts files found a small number of records were affected. The procedures not flagged as invalid procedure codes (PRVn = 1) are:

Procedure Year
997l 1988
9972 1988
9974 1988
9975 1988
9978 1988
9979 1988
432 1990
493 1990
5996 1990
8141 1990
8187 1990
8899 1990

Beginning in 1993, procedures were validated correctly.



Massachusetts

CPT-4 and ICD-9-CM procedure codes were mixed together in the source supplied array of procedures. The CPT-4 procedures were moved into the HCUP array for CPT-4 codes (CPTn) and the ICD-9-CM procedures were packed into the HCUP array for ICD-9-CM codes (PRn). The first listed procedure was retained in the first position and all subsequent procedures were packed so there are no empty spots after the second position of the array (i.e., CPT2 or PR2).



Nebraska

Nebraska supplied procedure codes in a field of length 7. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



Nebraska

Approximately 2% of Nebraska's 2005 SID records have invalid values in the the ICD-9-CM Procedure array (PRn). Almost all of the invalid codes are reported by one hospital.



Nevada

Nevada supplied procedure codes in a field of length 10. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



New Jersey

Before 1994, the procedure codes provided by the state were right-padded with zeros (e.g., the procedure code '403' was supplied as '4030'). For the HCUP database the following algorithm was used to validate the procedure codes:

Check the four-digit code for validity (using a six-month window for coding changes, 3 months before and 3 months after October of each year when ICD-9-CM coding changes occur).

  1. If the four-digit code is valid, set PRn to the four-digit code and set PRVn = 0.
  2. If the four-digit code is invalid and the fourth digit is a zero**, create a three-digit code by deleting the trailing zero and re-check for validity (using six-month window for coding changes). If valid, set PRn to the three-digit code and set PRVn = 0.
  3. If both the four-digit and the three-digit codes are invalid, save the original four-digit code PRn and set the validity flag to indicate an invalid code (PRVn = 1).


New Jersey

In 1993 only. Due to an error in HCUP processing, the invalid three-digit code was saved in PRn instead of the invalid four-digit code.

** In 1993 only. An error in HCUP processing caused invalid four-digit codes that ended in non-zeros, as well as zeros, to be processed by the above algorithm. If deleting the rightmost non-zero digit created a valid code, then

  • PRn was set to the stripped valid code,
  • PRVn was set 0 to indicate a valid code,
  • PCCHPR was set based on the stripped valid code, and
  • DRG, MDC, DRG10, MDC10, NEOMAT and edit check variables ED100, ED2nn, and ED5nn may have been incorrectly assigned based on the stripped valid code.


New York

Beginning in 2008, New York suppressed the identifier for the hospital (DSHOSPID) on records with an indication of induced abortion. These records are retained in the HCUP SID with the DSHOSPID set to "BLNK". New York identifies an indication of induced abortion by ICD-9-CM diagnosis or procedure code:

  • An admitting, principal, or secondary diagnosis of "6350" through "6399", or "7796".
  • A principal or secondary procedure of "690", "695", "696", "6993", "738", "7491", "750", or "9649".


Rhode Island

Rhode Island supplied procedure codes in a field of length 5. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



South Carolina

In the 2004 outpatient data from South Carolina, there were a number of records with X-filled values in the list of procedures. This data source attempted to translate any CPT procedure codes into ICD-9-CM procedure codes. If this was not possible, the data source masked the CPT code with X's. During HCUP data processing, the X-filled values were discarded, and the procedure array was packed to eliminate the blank entries.

Also in 2004, we suspect that some South Carolina hospitals truncated their CPT codes to four digits instead of masking them with X's. The following hospitals have a large number of invalid ICD-9-CM procedure codes: DSHOSPID 045, 090, 1405, 370, 420, 565, 670. The invalid ICD-9-CM procedure codes look suspiciously like truncated CPT codes. It is also possible that some of the truncated CPT procedure codes were not identified because the 4-digit value was a valid ICD-9-CM code.

Prior to 2000 data, a small number of discharges explicitly included decimals in the procedure field, usually the decimal is implicit. This is problematic because South Carolina supplied procedures in a field of length 4. If decimals were included, then a valid 4-digit code would be truncated. For example, the procedure for a simple mastoidectomy "2041" would be incorrectly reported as "20.4". Prior to 1998, invalid procedure codes are marked by a validity flag (PRVn = 1). Beginning in 1998, invalid procedure codes are masked (PRn = "invl"). Beginning in 2000 data this was no longer a problem; explicit decimals were not included in the procedure codes.



South Dakota

South Dakota supplied procedure codes in a field of length 9. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



Vermont

Vermont supplied procedure codes in a field length of 7. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



Vermont

After the 2002 Vermont SID file was created, the data source reported that a small number of discharges have incorrect information. The following hospitals are affected.


DSHOSPID Discharges with Correct Information
6950 3 neonatal discharges with incorrect principal diagnosis
6952 1 discharge with incorrect date of birth
6953 1 discharge with incorrect principal diagnosis
2 neonatal discharges missing secondary diagnosis of V3000
6955 3 discharge with incorrect principal diagnosis
6956 1 discharge with incorrect gender
6957 2 discharges with incorrect principal diagnosis
3 discharges with incorrect principal procedure
4 discharges that incorrect patient disposition
8 discharges with a incorrect primary payer
6958 9 discharges with incorrect discharge date and length of stay
6959 1 discharge with incorrect principal diagnosis
6962 1 discharge with incorrect admission date and length of stay
1 discharge with incorrect discharge date and length of stay
2 discharges with incorrect principal procedure
6963 24 discharges missing principal procedure "4524", procedure date, and operating physician
Total 66 discharges


Washington

Washington supplied procedure codes in a field of length 5. Only the first four characters of five contained the procedure code and were used to assign the HCUP procedure code.



West Virginia

West Virginia supplied procedure codes in a field length of 7. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.



Wisconsin

To comply with statutory requirements, Wisconsin modified diagnosis and procedure codes that explicitly referenced induced termination of pregnancy to eliminate distinctions between induced and spontaneous termination. The following codes were modified:

  • Diagnoses with the first three digit of 634, 635, 636, 637, 638 were recoded to 637, while retaining the reported fourth digit,
  • Procedure 6901 was changed to 6902,
  • Procedure 6951 was changed to 6952,
  • Procedure 6993 was changed to 6999,
  • Procedure 7491 was changed to 7499,
  • Procedure 750 was changed to 7599, and
  • Procedures 9641-9649 were changed to 964 (which would be flagged as invalid, PRV=1).

Beginning Q4 2015, the following codes were modified:

  • Diagnosis Z33.2 was changed to Z31.9,
  • Diagnoses O04x and O07x were changed to O03.9,
  • Procedure 10A07ZZ was changed to 10D17ZZ,
  • Procedure 10A08ZZ was changed to 10D18ZZ,
  • Procedure 10A07ZZ was changed to 10D17ZZ,
  • Procedure 10A08ZZ was changed to 10D18ZZ,
  • Procedure 10A07ZW was changed to 0UCB7ZZ,
  • Procedure 10A00ZZ was changed to 10D00Z0,
  • Procedure 10A03ZZ was changed to 0UC93ZZ,
  • Procedure 10A04ZZ was changed to 0UC94ZZ,
  • Procedure 10A07ZX was changed to 3E0P7GC.

Wisconsin supplied ICD-9-CM procedure codes in a field length of 5. Only the first four characters contained in the left-justified source field were used to assign the HCUP procedure codes.

CPT codes submitted in the emergency department and ambulatory surgery files were converted to ICD-9-CM procedure codes by the Wisconsin Hospital Association using the current Thomson Reuters Procedure Conversion Files. When a CPT code does not convert to an ICD-9-CM code, four 'X' (XXXX) characters were placed in the ICD field. These X-filled codes are recoded as missing prior to HCUP processing to prevent them being set to invalid.

For 2013, several facilities unintentionally duplicated the principal procedure in the secondary procedure fields on some records.

Beginning Q4 2015, the Wisconsin Hospital Association will no longer convert CPT procedure codes to ICD procedure codes.



Wisconsin

According to source documentation, the principal and secondary procedures for one hospital (DSHOSPID="056" and HOSPID=55155) are incorrect in the fourth quarter of 1997. System problems at the hospital caused the last procedure coded on the medical record to be stored as the principal procedure. No secondary procedures were recorded. This affects the DRG, DRG10, MDC, and MDC10 assignment.


Top
 
 
 

Internet Citation: HCUP Central Distributor SID Description of Data Elements - All States. Healthcare Cost and Utilization Project (HCUP). August 2008. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/db/vars/siddistnote.jsp?var=prn.
Are you having problems viewing or printing pages on this website?
If you have comments, suggestions, and/or questions, please contact hcup@ahrq.gov.
Privacy Notice, Viewers & Players
Last modified 8/12/08