HEALTHCARE COST & UTILIZATION PROJECT

User Support

Do Your own analysis
Explore Expert Research & Limited Datasets

Central Distributor SASD: Description of Data Elements

 
TOTCHG_X - Total charges, as received from data source
 
Documentation Sections:
General Notes
Uniform Values
State Specific Notes
General Notes
 

TOTCHG_X retains the total charge supplied by a data source, including cents and negative values, with the following exceptions:

  • Zero charges are set to missing (.); and
  • Charges that round to zero are set to missing (.).

TOTCHG_X has the same value as TOTCHG just before edit checks on total charges are performed. TOTCHG contains the cleaned total charges. TOTCHG_X contains the original value of total charges.

Generally, total charges (TOTCHG and TOTCHG_X) do not include professional fees and non-covered charges. If the source provides total charges with professional fees, then the professional fees are removed from the charge during HCUP processing. In a small number of HCUP databases, professional fees can not be removed from total charges because the data source cannot provide the information. Please check the state-specific notes for information on which states are affected.

In some cases, only copay amounts, such as $10 or $20, may be in the total charges. There is no documentation as to the prevalence of this practice.

Emergency department charges incurred prior to admission to the hospital may be included in total charges (TOTCHG and TOTCHG_X). Medicare requires a bundled bill for Medicare patients admitted to the hospital through the emergency department. Other payers may or may not have similar requirements.

 
Top
 
 
 
Uniform Values
 
VariableDescriptionValueValue Description
TOTCHG_XTotal charges, as received from data source+/- 100 millionTotal charge (with 2 decimal places)
.Missing
.AInvalid (nonnumeric or out of range)
 
Top
 
 
 
State Specific Notes

Colorado

According to Colorado, hospital based physician fees are excluded from total charges (TOTCHG and TOTCHG_X).



Florida

The coding of TOTCHG and TOTCHG_X in Florida is inconsistent with the coding of total charges in other states. In Florida, total charges may include professional fees. In all other HCUP states, either professional fees are not included in the supplied total charges or the professional fees are subtracted from the total during HCUP processing.

Use the variable PROFEE to identify records for which the total charges include professional fees. PROFEE is a required submission field for ambulatory surgery data in Florida. PROFEE indicates whether or not professional fees for radiology services are included in total charges (TOTCHG and TOTCHG_X).



Iowa

Iowa includes professional fees in its total charges if the hospital combines hospital and professional bills. Professional fees are subtracted from total charges (TOTCHG and TOTCHG_X) during HCUP processing to make Iowa total charges comparable to data from other states. Due to an error in processing the outpatient data in 2004, professional fees were NOT subtracted from the total charges. Users can correct this by subtracting non-covered charges (CHG16) and professional fees (CHG17) from the total charges (TOTCHG and TOTCHG_X). Beginning in 2005, professional fees and non-covered items are excluded from the total charges (TOTCHG and TOTCHG_X).



Maryland

Beginning in 2007, Maryland included the records from all other outpatients, Greenbaum cancer center, and UMMS shock trauma in the unified AS and ED outpatient data file. Total changes associated with some of these new records were smaller than $100. During the HCUP processing, these values were categorized in ‚€œInconsistent‚€, which resulted in increasing the frequency associated with it.

Beginning in 2006, Maryland stopped providing total charges. This data element is created based on charges associated with revenue code 0001 during the HCUP data processing.

Maryland excluded the following from total charges:

  • Physician charges and
  • Charges not regulated by the Health Services Cost Review Commission (for example, telephone service, television charges or private duty nursing charges).


Michigan

In 2006, two Michigan hospitals submitted TOTCHG_X with implied decimals. The problem begins in March for one hospital and in July for the other. During processing we fixed the problem data for both TOTCHG_X and TOTCHG.



New York

For the 1988-1993 HCUP files, New York supplied their Master File which consists of Discharge Data Abstracts (DDA) matched to Uniform Billing Forms (UBF) for inpatient stays. Information on total charges is included in the UBF part of the record. Due to an administrative change in the collection of billing records for 1989, a large percentage of the DDAs could not be matched to a UBF. When there was no match, charge information is missing. The match rate improves over time and stabilizes after 1991. The percentage of DDA records that have a matching UBF record in the Master File is as follows:

1988 77.2%
1989 26.3%
1990 62.8%
1991 93.7%
1992 91.8%
1993 95.5%.


Beginning in the 1994 data, hospitals submitted discharge records to New York in a new format, using Universal Data Set (UDS) specifications. This format combines the old UBF and DDA data into a single submission record.

Adjustment to Charges for Interim Bills

  • For 1988-1993, when the length of stay from the Discharge Data Abstract did not equal the length of the billing period from the Uniform Billing Form, total charges (TOTCHG) were set to missing (.) because this billing information pertained only to the billing period, not the complete inpatient stay. However, TOTCHG_X contains the original value from the billing record.
  • Beginning in 1994, billing dates were not reported by New York and the adjustment to charge details (CHGn, RATEn, UNITn, REVCDn) was not made.


South Carolina

The total charges for South Carolina freestanding clinic data may include professional fees and charges for patient convenience items. South Carolina did not supply detailed charges with the freestanding clinic data. Professional fees and charges for patient convenience items could not be subtracted from total charges (TOTCHG and TOTCHG_X) during HCUP processing as was done with the South Carolina inpatient and hospital-based ambulatory surgery data.

In 2006, total charges were not included on South Carolina SASD or SEDD because of a problem with a major data vendor in the state.



South Dakota

Charges associated with the professional fees and non-covered items (revenue code centers 096X, 097X, 098X, and 099X) have been removed from total charges.



Wisconsin

Prior to 2006, Wisconsin may have included professional fees and convenience items in its total charges. Hospitals are instructed to remove these fees from total charges, but some hospitals do not subtract them and others have had difficulties with their accounting software. There is no way to determine which hospitals did or did not include these items.

Hospitals are not required to report total charges for stays over 100 days.


Top
 
 
 

Internet Citation: HCUP Central Distributor SASD Description of Data Elements - All States. Healthcare Cost and Utilization Project (HCUP). April 2008. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/db/vars/sasddistnote.jsp?var=totchg_x.
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 4/11/08