Analysis and reporting of performance of service providers5652842
Abstract
A computer-based method aids comparison of competitive performance of a first provider of services with other providers of the services, where the services are provided to a mix of customers belonging to different classes and the performance in providing the services is different for customers belonging to different classes. Data representing the first provider's competitive performance in providing various services to its customers is stored. Also stored is mix data representing the mix of its customers to which the services are provided. Similar data is stored representing each of the other providers' competitive performance in providing various services to its customers. The data of the other providers is adjusted in accordance with the mix data of the first provider. The unadjusted data of the first provider is visually provided together with the adjusted data of the other providers. Other aspects include automatically generating a printed report of information comparing performance of a first provider of services with performances of other providers of the services; and more broadly generating a report of an analysis of data.
Claims
We claim:
1. A computer-based method of aiding comparison of competitive performance of a first provider of services with at least one other provider of the services, where the services are provided to a mix of customers of different types and the performance in providing the services is different for different types of customers, the method comprising:
storing (a) performance data representing the first provider's competitive performance in providing various services to the first provider's customers and (b) customer data indicating the types of customers and the number of customers within each type to which the first provider's services are provided,
storing competitor performance data representing the other provider's competitive performance in providing various services to the other provider's customers,
adjusting the competitor performance data in accordance with the customer data of the first provider to reflect how the other provider would have performed if it had serviced the types of customers serviced by the first provider, and
visually presenting the performance data of the first provider together with the adjusted competitor performance data.
2. The method of claim 1 wherein
the providers comprise health-care providers.
3. The method of claim 2 wherein
the data relates to length of stay, charges, or costs.
4. The method of claim 1 wherein
the customers comprise patients and the types comprise distinct groups.
5. The method of claim 4 wherein the groups are distinguished demographically.
6. The method of claim 1 wherein
the services comprise health care services.
7. The method of claim 1 wherein the step of presenting the data comprises generating a report.
8. The method of claim 7 wherein the step of generating a report comprises:
selecting a report template,
creating a graphical representation of the performance data and the competitor performance data, and
merging the report template and the graphical representation.
9. The method of claim 7 further comprising including in the report a description of a competitive strategy for the first service provider.
10. The method of claim 7 further comprising including in the report a section selected by a user from a group of user-selectable sections.
11. The method of claim 10 further comprising allowing the user to define a level of detail for each of the sections in the report, and producing the sections in accordance with the level of detail.
12. The method of claim 1, wherein the data includes hospital departmental cost information.
13. A computer-based method for automatically generating a report of information comparing performance of a first provider of services with performance of at least one other provider of the services, the method comprising:
storing raw data representing information about the services provided by the first provider and the other provider in a database,
extracting from the database a set of comparison data containing similar types of raw data for the first provider and the other provider,
storing rules for selecting which of the comparison data to use in comparing the performances of the service providers, and
automatically applying the rules to the comparison data to select the information to be presented in the generated report.
14. The method of claim 13 wherein the rules are based on which data represent the greatest difference in performance of the first provider of services compared to performance of the other provider.
15. The method of claim 13 wherein the rules are based on which data represent opportunities for improved performance.
16. A computer-based method of generating a report of an analysis of stored data comprising
allowing a user to select which of a group of sections to include in the report, each section corresponding to a particular portion of the data,
automatically retrieving the portions of the stored data corresponding to the selected sections, and thereafter
automatically performing the analysis on the retrieved data,
automatically generating results of the analysis for each selected section,
automatically generating printable narrative text and non-text graphics representations of the results for each selected section, and
automatically combining the printable narrative text and non-text graphics representations of the selected sections to form an integrated report ready for printing.
17. The method of claim 16 wherein the data comprises data concerning the competitive performance of a medical service business.
18. The method of claim 16 wherein the data comprises financial data.
19. The method of claim 16 wherein the non-text graphics representations comprise tables and charts.
Description
BACKGROUND OF THE INVENTION
This invention relates to analysis and reporting of performance of service providers.
Hospitals, for example, can remain competitive only by frequent analysis of their cost and revenue performance versus competitors. Hospitals typically hire staff analysts or contract with consultants to provide such analyses. The work is usually based on a combination of publicly available and internal patient and financial data, and ends with a formal written report to the hospital's administration. The cost and time for doing the report is often high.
One excellent public source of data is the Healthcare Finance Administration (HCFA) of the federal government. HCFA has created a diagnosis classification system for use in administering Medicare claims. Costs and charges for every hospital in the United States fall into one of twenty-five departments, such as "Operating Room" or "Anesthesiology." A list of the twenty-five departments is attached as FIG. 5. A small portion of the type of data generated by the HCFA, which can be attained by submitting form MCR-2552 to the HCFA, is shown in Table I.
Even more detailed patient information is available from many individual state governments. For example, the state of Massachusetts makes available yearly information on every healthcare patient in the state. Included in this state-provided information are demographic data, such as the age, sex, race, and home zip code of each patient; clinical data, such as length of stay and discharge date for each patient; and charge data, including total amount charged by the healthcare provider for services rendered. All patient information provided by the state of Massachusetts is divided into forty-two healthcare charge categories. Each charge category represents a group of services provided by the healthcare industry and can be linked to one of the twenty-five federally defined departments discussed above. A list of the forty-two charge categories defined by the state of Massachusetts is attached as FIG. 4. Patient level information is available from the Rate Setting Commission of the Commonwealth of Massachussetts.
SUMMARY OF THE INVENTION
In general, in one aspect, the invention features a computer-based method of aiding comparison of competitive performance of a first provider of services with other providers of the services, where the services are provided to a mix of customers belonging to different classes and the performance in providing the services is different for customers belonging to different classes. Data representing the first provider's competitive performance in providing various services to its customers is stored. Also stored is mix data representing the mix of its customers to which the services are provided. Similar data is stored representing each of the other providers' competitive performance in providing various services to its customers. The data of the other providers is adjusted in accordance with the mix data of the first provider. The unadjusted data of the first provider is visually provided together with the adjusted data of the other providers.
Implementations of the invention may include the following features. The providers may be health-care providers. The data may relate to length of stay, charges, or costs. The customers may be patients and the classes may be distinct groups, e.g., demographically distinct. The step of presenting the data may include printing a report. The reporting step may include selecting a report template, creating a graphical representation of the data, and merging the report template and the graphical representation. An action plan describing a competitive strategy for the first service provider may be included in the report. A user may provide selections of sections to be included in the report. The user may also give choices of a level of detail for each of the sections. The data may includes hospital departmental cost information.
In general, in another aspect, the invention features automatically generating a printed report of information comparing performance of a first provider of services with performances of other providers of the services. Raw data is stored in a database. From the raw data in the database, a set of pertinent data is generated appropriate to comparing the performances of the service providers. Rules are stored for selecting which of the pertinent data has greater significance in comparing the performances of the service providers. The rules are automatically applied to the pertinent data to select the information for the printed report.
Implementations of the invention may include the following features. The raw data may include data for services provided. The rules may be based on which of the pertinent data represent the greatest difference in performance of the first provider of services compared to performance of the other providers, or on which of the pertinent data represent the greatest opportunities for improved performance.
In general, in another aspect, the invention features generating a report of an analysis of data. the data is stored. A user provides instructions on how to perform the analysis. Thereafter, the analysis of the data is automatically performed based on the instructions. Corresponding results are automatically generated. Printable narrative text and non-text graphics representations of the results are generated automatically, ready for printing in a single integrated report.
Implementations of the invention may include the following features. The data may include data (e.g., financial data) concerning the competitive performance of a medical service business. The non-text graphics representations may include tables and charts.
Advantages of the invention include the following. High-quality useful reports are generated automatically for service providers, i.e., hospitals, at low cost. In each report, a client service provider is compared to its peers in several areas of competition for a particular consumer group. The consumer group is selected by a user and may be predefined or may be created by the user. The information used to compare a service provider to its competitors is determined according to parameters generated by the user. Prior to comparison, data representing the performance of the competitors is adjusted to reflect the clientele of the service provider. This adjustment does not affect the service provider's data. The invention is also able to provide multiple levels of comparison, depending upon the level of detail required by the user.
The invention uses stored rules for selecting information of particular interest to the service provider. This information is used to generate a report which focuses the attention of the service provider on the most promising opportunities for cost savings, profit improvements, and improved competition. The report also lays out an action plan for achieving these improvements.
Other advantages will become apparent from the following description, and from the claims.
DESCRIPTION
FIG. 1 is a block diagram of a computer-based system for analyzing and reporting healthcare information;
FIG. 2 is a flow chart of a process for using the system;
FIG. 3 is a flow chart for creation of a database of healthcare information;
FIG. 4 is a chart of state-defined hospital charge categories;
FIG. 5 is a chart of federally-defined hospital departments;
FIG. 6 is a mapping of state categories to federal departments;
FIG. 7 is a flow diagram of a process for the entry of report request parameters;
FIGS. 8A-8C are screen shots of report request parameter entry;
FIG. 9 is a flow diagram of the report generation process;
FIG. 10 is an example of case mix adjustment;
FIGS. 11A-11C are an example of the generation of a report section.
FIG. 12 is a key to FIGS. 12a-12d.
FIGS. 12a-12d are components of a database structure diagram.
FIGS. 13A through 13F are bar graphs included in a report.
Referring to FIG. 1, healthcare facility (i.e., hospital) financial information is managed by a computer system 5 controlled by a program 10. This financial information is used by the system to analyze the comparative performance of competing hospitals and produce a report on the results. The report helps hospitals plan strategies for cutting costs and improving their competitive position.
Referring also to FIG. 2, in a first main step, a database 12 is created 102 from raw patient level information 14 and raw hospital cost information 16. Patient level information 14 is usually acquired from a state government and generally provides patient-by-patient healthcare data in several state-defined charge categories for each healthcare patient in a given year. Massachusetts, for example, provides patient level information which includes demographic, clinical, and charge data in forty-two charge categories for each patient, as described above. Hospital cost information 16 is usually acquired from the HCFA in the form of a Medicare Cost Report, which includes cost and charge information for the twenty-five departments for every hospital in the United States. The patient level information 14 and hospital cost information 16 are combined in the database 12 to provide patient level cost and charge information 12d for every department of every hospital.
The cost and charge information provided by the state and federal governments is sufficient for generation of many comparison reports, and is called Level I analysis. A client hospital may also need a report which includes a financial analysis at levels beyond the government defined departments. At a so-called Level II, the client hospital's internal cost and charge information is entered into the database and combined with the public information. A hospital's internal information may include, for example, the total charges of its physicians within each department, or total costs incurred for certain procedures, such as x-rays or lab work, performed by a department.
The client hospital may need even more detail in the report. At a Level III, cost and charge information similar to Level II information is entered into the database for each of the competing hospitals. This allows a more detailed comparison between a client hospital and its competitors.
In a second main step, a hospital comparison report is requested. To request a report, a user must enter 104 report request parameters 18 which are used by the computer system 5 to retrieve and manipulate the cost and charge information stored in the database 12. The parameters 18 input by the user determine, for example, which patient groups to compare in which hospitals and, therefore, which of the patient level cost and charge information 12d to retrieve from the database 12. Once the appropriate information has been retrieved, the information is accumulated to create total cost and charge information 20 for the chosen patient groups in the chosen hospitals. Even though the maintenance of cost and charge information for every patient of every hospital in a city (or even the nation) requires an enormous database, retrieval and combination of data according to user-defined parameters eliminates unnecessary manipulation of data irrelevant to the particular report being generated.
In a third main step, a final printed report 22 is generated 106 to provide, among other things, a hospital-by-hospital comparison of adjusted cost and charge information 24 for the patient group specified by the user. The adjusted cost and charge data 24 is created by adjusting the accumulated data 20 for each hospital to conform to a Mix Adjustment Field of a reference hospital (the client hospital). Mix Adjustment Fields are described in more detail below.
The final report 22 not only presents a mathematical and graphical comparison according to the user's parameters 18, but it also constructs an English-language prose explanation of the results of the comparison. A report may contain one or more of several sections. These sections include analyses of the client hospital's market share, payor mix, patient demographics, admit source, case mix, length of stay, and cost per case. The report also searches for comparison results of particular interest to the client hospital. Internal rules 28 cause the system 5 to determine, for example, if the client hospital has significantly (more than 110%) higher costs than its competitors, or which single competitor is most superior in a particular report area. In addition, the report includes an "Opportunity Analysis/Action Plan" section which provides suggestions to help the client hospital improve its competitiveness.
For each section of the report, the system 5 selects a report file 26, which provides guidelines for generating text and creating graphical representations of the results of the hospital comparisons. The graphical representations and text are merged according to the report file 26 to produce an easily readable final report 22 on the requested information. The final report is of a quality and style that is as good as or better than what might be prepared by hand by a consultant on a one-shot custom basis. The report also highlights the information determined by the internal rules 28 to be of particular interest to the client hospital. An example of such a report is shown in Appendix H.
Referring to FIGS. 3 through 6, the database is created by entering and combining the appropriate cost and charge information. For a healthcare cost and charge database for hospitals in the state of Massachusetts, patient level demographic, clinical, and charge information from a given year is entered 120 for each patient according to the forty-two state-defined charge categories, which are detailed in FIG. 4. For example, from the state-provided information, a patient's age, sex, and race are entered as demographic data. Then clinical information such as Length of Stay (LOS) and days spent in intensive care (ICU) is entered. In addition, the total amount (in dollars) charged to the patient in each category is entered into the database.
The patient level information is then divided and stored 122 in two database files. The first file is a "Patient Summary" file 12a (FIG. 1) which includes individual patient discharge information derived from the demographic and clinical data described above. The second file is a "Patient Charge" file 126 (FIG. 1). This file contains patient level charge information for each state-defined charge category. Creation of the "Patient Summary" and "Patient Charge" files allows maintenance of demographic and clinical information separately from charge information.
Along with patient level information, cost and charge information for each of twenty-five federally-defined departments in every hospital in the United States is entered 124 from a Medicare Cost Report provided by the HCFA. As shown in FIG. 5, the Medicare Cost Report covers twenty-five departments in a hospital and divides costs into direct and indirect (overhead) costs. The cost report further divides indirect costs into salary related and non-salary related costs. The cost report also provides total charge information for each of the twenty-five departments. Using this charge information, a ratio of cost to charge (RCC) is calculated 126 for total cost, direct cost, salary cost and non-salary cost in each of the twenty-five departments. The forty-two state-defined charge categories are then mapped to the twenty-five federal departments, and the results are stored 128 along with the corresponding RCCs in a "Department Cost" file 12c (FIG. 1). The mapping of the forty-two Massachusetts state departments to the twenty-five federal departments is shown in FIG. 6.
The patient level information and hospital cost information provided by the state and federal governments are sufficient to create a Level I comparison. However, for a Level II comparison, as described above, hospital specific internal cost information must be supplied 130 to the database. For example, if a hospital requests a department-by-department charge comparison of several of its doctors, detailed charge information for each doctor must be entered into the database. To perform a Level III comparison, the database requires 132 similar internal cost information for the hospitals in which the client hospital is interested. For example, if the client hospital requests a report on its departmental x-ray costs as compared to its chief competitors, detailed internal cost information from each competing hospital must be entered into the database. Level II and III information is optional.
As discussed above, all hospital services are divided among federally-defined Diagnosis Related Groups (DRG). In order to enhance the comparison capabilities of the invention, the DRGs are "refined" 134 according to a methodology developed at Yale University and marketed by Karen Schneider Associates located in New Haven, Conn. Refining a DRG includes the addition of "level of severity" information to each group. In other words, the DRGs are further defined by describing each diagnosis in terms of three or four levels of medical severity (refinement classes). The calculation of a severity level for each patient within a DRG considers whether the DRG is a grouping of medical or surgical diagnoses, the patient's sex, the patient's age, length of stay, whether the patient died within two days of admission, and whether the patient was discharged against medical advice. For example, an infant requiring heart surgery and intensive care for weeks is likely to place a greater drain on resources than a middle-aged victim of a minor heart attack. Even though these patients fall into the same DRG, the cost attributed to the treatment of each can be more accurately analyzed due to the refining of the DRG. In this manner, refined DRGs group patients according to resource intensity, and thus allow more accurate comparisons.
In addition to departmental cost and charge information, supplemental code tables are entered 136 into the database. Supplemental code tables are description or translation tables which allow the report generator to "translate" the data from the database into information understood by the user. For example, payor data may be handled for "Payor 1" and "Payor 2". To provide a useful report, however, the report generator must inform the user who "Payor 1" and "Payor 2" are. Therefore, a supplemental code table will indicate that "Payor 1" and "Payor 2" are, for example, Medicare and Blue Cross, respectively. Supplemental code tables will also indicate, for example, that data under "DRG 103" represents heart transplant patients.
After all mandatory and optional information has been entered into the database, costs are calculated 138 for each patient by combining patient level information with hospital cost information. The RCCs and charge category/department mappings in the "Department Cost" file are applied to the patient level charge information in the "Patient Charge" file. The total costs, direct costs, salary related costs, and non-salary related costs in each charge category are determined for each patient by multiplying the corresponding RCC with the category charge for the patient. In this manner, a database containing departmental costs and charges for every patient is created. From this departmental cost database, hospital comparisons are performed according to patient groups defined by the user, as described below.
A diagram showing the structure for the completed database is shown in FIGS. 12a-12d. The database comprises several structure groups, each of which contains at least one field of information. For example, a "Patient Summary" structure 310 includes a patient's unique ID 312 (in the form of a long integer, L), identification 314 of the hospital at which the patient was treated (in the form of a four-character alphanumeric word, A), the patient's age 316 (in the form of an integer, I), the patient's home zip code 318 (in the form of a five character alphanumeric word), and many other critical information fields.
Some of the fields within a structure may be linked to a substructure which provides further detail for the field. For example, within the "Patient Summary" structure 310, the "Zip Code" field 318 is linked to a "Zip Code" structure 320. The "Zip Code" structure 320 further defines the "Zip Code" field 318 by storing zip code, town and community information for each patient. In addition, a field within a structure may not contain data in and of itself, but instead may comprise a subfile which holds several critical subfields related to that field. For example, within a "Patient Cost" structure 322, a "Cost" field 324 comprises a "Cost" subfile 326 which includes "Department Code", "Charges", "Total Cost", and "Direct Cost" subfields 328, all of which describe the "Cost" field 324 of the "Patient Cost" 322 structure group.
Many fields within the database contain critical information which is to be available quickly without the usual search process. These critical fields, such as a patient's unique ID or a hospital code, are indexed for easy retrieval from the database. The indexed fields are shown in bold type in the database structure diagram of FIGS. 12a-12d. The database structures and field definitions are shown in Table II.
In addition to demographic data, clinical data, and cost and charge data, the database contains report files and report graphics. A "Report File" data structure 330 comprises fields which indicate the report ID, the study group compared in the report, and the client hospital, as well as information on the report organization options chosen by the user. A "Report Pics" data structure 332 holds the ID for each report and graphical representations (such as cost tables and cost graphs) of the results of the comparisons. The report files and report pictures are described in more detail below.
Referring to FIGS. 7 and 8A through 8C, parameters 18 (FIG. 1) for generation of a comparison report are derived from a request form completed by a client hospital. Report request parameters determine which fields of information are retrieved from the database for analysis. Despite the vast amount of healthcare information stored in the database, the report request parameters allow the retrieval of only that information requested by the client hospital. For example, if the client hospital requests an analysis of its performance against its five primary competitors in pediatric services, only pediatric-related DRG data for six hospitals is needed. This limited amount of information is easily accumulated and adjusted for comparison. In this manner, report request parameters allow the creation of a useful, low cost report from a large, comprehensive database of healthcare information.
In FIGS. 8A-8C, the report request parameters 18 for a comparison report of a so-called "MCard4" study group are entered 152 into an Apple Macintosh computer. This report compares only the cardiology-related DRGs within the hospitals selected by the user. In this example, the user enters 154 the report name 170 and a description 172 of the patient group to be compared. Any special patient groupings are then defined 156 by the user. In this example, patients are grouped according to a user-defined "CardDRG" grouping, which will be described in more detail below. The user then enters 158 the selected patient group into a patient group display field 174. The patent group display field 174 determines which patients will be displayed in the report.
The case mix or severity field 176 by which comparison data is adjusted (Mix Adjustment Field) is then entered 160. The user then enters 162 a patient selection field 178 which determines the broad group of patients to be included in the comparison data. Finally, the user enters 164 the names and/or identification codes 180 of the hospitals to be included in the comparison report. Included in the hospital selection list is the client hospital requesting the report (Brockton Hospital).
In FIG. 8B, the "CardDRG" patient group display field 174 of FIG. 8A is created by the user. This custom patient group creates a comparison of the standard cardiology DRGs of the selected hospitals. To create the "CardDRG" group, the user selects the specific DRGs to be included in the group and enters the appropriate DRG descriptions 182 and ID values 184. The DRG descriptions and values are listed in Table III below. As will be described in more detail below, the "MCard4" report is generated by combining and comparing cost, charge, and demographic information for every patient of the user-selected cardiology DRGs for each of the selected hospitals.
In FIG. 8C, the user enters 166 the report organization instructions. To do so, the user assigns a name 190 to the report, selects the study group 192 to be included (as discussed with reference to FIG. 8A above), and selects the client hospital 194, from whose perspective the report will be generated. The user then selects the amount and type of comparison data 196 to be included in the generated report. For example, one section of the report compares the cost per cardiology case 198 for each hospital, providing a summary of the results, a detailed analysis of the results, and the data from which the results were determined. The "MCard4" report is described in detail hereinafter, with focus on the "Cost per Case" section.
Referring to FIG. 9, the report request parameters input 200 by the user are used to create the requested report. These report request parameters allow the system to retrieve 202 only the information requested by the user. Once the appropriate information has been retrieved from the database, patient level information is accumulated 204 for each hospital as summary data. In Table IV, summary data, including total cases, total patient age, total days, routine days, ICU days, and total charges, is shown for the "MCard4" study group for each selected hospital, including the client hospital. For example, Table IV shows that St. Luke's Hospital of New Bedford charged a total of $1,074,529 for 64 cases in DRG 116.
In addition to summary data, detailed cost and charge information is accumulated 204 for the patient group. This detailed information may, for example, show total charge by charge category for the patient group in each hospital. Table V shows total cost information for the "MCard4" patient group broken down into the forty-two charge categories defined by the state of Massachusetts. For example, Table V shows that within DRG 127, Cape Cod Hospital charged $104,634 for medical/surgical supplies.
Tables IV and V indicate the vast amount of information that the user may request from the database. Table V, in particular, shows the power of combining patient level charge information acquired from the state with hospital cost information provided by the HCFA. The healthcare reports, however, are not limited to the detail provided in Tables IV and V. Instead, an important feature of the invention is its ability to accumulate and compare data according to almost any combination of factors chosen by the user.
Once the summary and detailed data is accumulated, the data for each of the selected hospitals is adjusted 206 for direct comparison with the data for the client hospital. In performing a mix adjustment of competing hospital data, consideration is given to what the cost, length of stay, and charges would be for the competing hospitals if the competing hospitals treated the exact same mix of patients (or treated the same severity levels) as the client hospital. Therefore, the client hospital's case mix is assigned to the competing hospitals, and the competing hospital data is adjusted accordingly. The client hospital's data, however, is unaffected by mix adjustment.
Referring to FIG. 10, in a simple example of case mix adjustment, the total number of cases and cost per case for six DRGs (A-F) are shown for "Your" hospital (in column C1) and an "Other" hospital (in column C2). Line 215 shows that for Your hospital there are 4,000 total cases at $2,500 per case, while at the Other hospital there are 3,500 cases for $2,400 per case. In view of these values, it appears that the Other hospital controls its costs better than Your hospital. However, in column C3 the Other hospital's cases are adjusted to reflect the case mix of Your hospital, while the cost per case in each DRG is held constant. After the adjustment in column C3, line 215 shows that when the Other hospital treats the same 4,000 cases as Your hospital, its cost per case rises to $2,950, or $550 greater than the cost per case of Your hospital. The adjustment in column C3 provides a more accurate comparison and reveals that Your hospital's cost is actually lower than the Other hospital's cost.
Column C2 shows that the Other hospital had no cases in DRG "E". As a result, DRG "E" has no cost per case. When this situation occurs, the cost per case for Your hospital is assigned to the Other hospital during adjustment. Therefore, in column C3, the adjusted data for the Other hospital includes 400 cases for DRG "E" at $2,000 per case. Adjusting the data in this manner prevents skewing of the overall cost per case for the Other hospital.
Table IV shows the adjusted summary data for the "Cost per Case" section of the "MCard4" report. Brockton Hospital, whose summary data appears in Table IV, is the client hospital, so each competing hospital is assigned Brockton's case mix during adjustment. Therefore, each DRG under one hospital has the same number of cases as the same DRG under every other hospital. The remaining data fields (age, charges, etc.) are adjusted for each competing hospital by multiplying the average per case from the unadjusted summary data (Table V) by the adjusted number of cases. Similarly, the total costs, direct costs, and total charges for each of the forty-two state-defined charge categories within each hospital are calculated from the adjusted data. Table VII shows the adjusted charge and cost data in each of the forty-two categories for each of the selected hospitals.
In the "MCard4" example of Tables IV through VII, a user-selected group of cardiology DRGs serves as the basis for mix adjustment. However, while DRGs or refined DRGs are typically selected as the basis for adjustment, the invention is not limited to the use of these groups. Instead, the user may select any field or user-defined group. For example, mix adjustment may be performed according to fields such as patient age, payor, length of stay, principal diagnosis, or discharge status, as well as many other fields contained in the database. In addition, a combination of fields may be used as the basis for adjustment. As described above, the mix adjustment field is determined by the report request parameters entered by the user.
Referring again to FIG. 9, after the data for the competing hospitals has been adjusted, the data for all of the hospitals is analyzed and compared. For the "Cost per Case" section of the "MCard4" report, the total number of cardiology cases is determined from Table VI, and the total cost (not shown) is determined. The cost per cardiology case is then calculated for each hospital, and the cost per case for the client hospital is compared 208 to the adjusted cost per case of each of the other hospitals. During the comparison, internal rules 28 (FIG. 1) cause the system to look 210 for results which may be of particular interest to the client hospital. For example, in the "MCard4" report, if the client hospital's cost per case is less than 110% of the average adjusted cost per case of the competing hospitals, the comparison focuses on the differences between the client hospital and the hospital with the lowest adjusted cost per case. This special comparison allows the report to display the client hospital's performance with respect to the average competitors, while at the same time focusing on the changes necessary to compete more effectively with the highest performing competitor.
The internal rules determine information of particular interest in each of the report sections described above. Other examples of information gathered according to the internal rules are as follows: comparing the proportion of revenues paid by each of the client hospital's top three payors to the average proportion paid by the same three payors at all of the compared hospitals (see FIG. 13A); comparing the proportion of minority patients at the client hospital to the average proportion of minority patients (see FIG. 13B); comparing the proportion of the client hospital's patients admitted through its primary admission source to the average proportion of patients admitted through the same source (see FIG. 13C). Many areas of particular interest are determined according to the internal rules and reported to the user, most of which are clearly presented in the final report, an example of which is described below with respect to FIGS. 13A through 13F.
Once comparison of the hospital is complete, a report template for the "Cost per Case" section is selected 212. The template is then completed 214 by inserting text, graphs, and charts according to the comparison results.
Referring to FIGS. 11A through 11C, the "Cost per Case" report section is generated by inserting the appropriate information into the report template. First, the abbreviation of the client hospital's name (Brockton) is inserted at 221. The description of the comparison group (cardiology) is inserted at 222, and the average total cost per case for the client hospital ($4,385) is inserted at 223. The system then inserts the number of competing hospitals (seven) at 224 and the average total cost per case of the competing hospitals ($4,119) at 225. The dollar difference ($266) and percentage difference (6% lower) between the average total cost per case for the competing hospitals and the total cost per case for the client hospital are determined and inserted at 225 and 226, respectively. The name of the client hospital (Brockton Hospital) and the abbreviation of the client's name (Brockton) are inserted at 228 and 229.
The relative rank of the client hospital's total cost per case in relation to the average total cost per case of the competing hospitals is then determined. This rank is used to report information of special interest to the client hospital according to the internal rules 28 (FIG. 1), as described above. If the client hospital has the lowest total cost per case (ranked first), the phrase "lowest total cost per case, followed by X with Y" is inserted at 231. The name of the second ranking hospital replaces "X", and the total cost per case of the second ranking hospital replaces "Y". If the client hospital has the highest total cost per case, the phrase "highest total cost per case" is inserted at 231. If the client hospital's total cost per case is greater than the competitor average, but not the highest, the rank of the client hospital's total cost per case is inserted at 231, followed by the phrase "highest total cost per case." If the client hospital's total cost per case is less than or equal to the competitor's average, but is not the lowest, the rank of the client hospital's total cost per case is inserted at 231, followed by the phrase "lowest total cost per case." For all of the above situations, except where the client hospital is ranked first, the phrase "X had the lowest total cost with Y dollars" is inserted after the last phrase at 231. In this case, the abbreviation of the name of the first ranked hospital replaces "X" and the first ranked hospital's total cost per case replaces "Y". At 233, the description of the client hospital (Brockton Hospital) is inserted.
A cost table depicting the comparison between the hospitals is inserted at 234. The cost table is created by inserting the adjusted data into five columns of a preformatted spreadsheet. The abbreviations of the names of the hospitals are inserted in column 1, with the client hospital inserted into the first row. The phrase "average excluding Z", where "Z" is replaced by the abbreviation of the name of the client hospital, is inserted into the last row. The adjusted total cost per case for each hospital is then inserted into column 2. An average of these values, excluding the client hospital, is placed in the final row. In column 3, the percentage difference between each competing hospital's total cost per case and the client hospital's total cost per case is inserted. In the last row, the percentage difference between the average total cost per case and the client hospital's total cost per case is inserted. Columns 4 and 5 are similar to columns 2 and 3, except that direct cost per case and percentage difference of direct cost per case are inserted. When the cost graph is complete, the graph is stored as a picture in the "Report Pics" file 332 (FIG. 12C) in the database.
At 235, the abbreviation of the name of the client hospital is inserted. The system then inserts at 236 a column chart which shows the adjusted total cost per case for several cardiology department groups for each hospital. The cardiology department groups are defined by the user during entry of the report request parameters. The data for the client hospital is placed in the first column of the chart, and the column chart is stored as a picture in the "Report Pics" file.
The abbreviation of the name of the client hospital is inserted at 237. The difference between the total cost per case of the client hospital and the total cost per case of the highest (first) ranking hospital (or second ranking if the client is highest ranking) is inserted at 238. If the client hospital is the highest ranking hospital, the difference inserted at 238 is followed by the word "lower"; otherwise the difference is followed by the word "higher". This word is then followed by the phrase "total cost per case than the lowest cost competitor X and", where the name of the lowest cost competitor replaces "X". The difference between the total cost per case of the client hospital and the average total cost per case for the competing hospitals is inserted along with the word "higher" or "lower", depending on this difference value. The phrase "total cost per case than the competitor's average" is then inserted as the last phrase at 238.
The system then inserts another cost table at 239. The cost table compares the total cost per case for the client hospital to the adjusted total cost per case for the lowest ranking hospital in each of the user defined department groups. The table also compares total cost per case for the client hospital to the average cost per case of all of the competing hospitals in the user-defined department groups. The completed cost graph is stored in the database file "Report Pics".
At 240, a phrase is inserted indicating in which user-defined department groups Brockton's total cost exceeds the total cost of the lowest cost competitor by more than $100. No more than two department groups are listed. At 241 a phrase is inserted which indicates in which department groups Brockton's total cost is lower than the total cost of the lowest cost competitor by more than $100. The phrase "significantly above" is used when Brockton's costs exceed the competitor's by more than $100, and the phrase "significantly lower" is used when Brockton's costs are lower than the competitors by more than $100.
Referring to FIGS. 13A through 13F, the printed report may, in one embodiment, look as follows.
Executive Summary
Central Caribbean Medical Center treated 1,328 Cardiology patients in 1992. This volume compared with 1,601 cases for St. Thomas Hospital, 1,743 cases for Aruba Hospital, 1,553 cases for Martinique Hospital, 2,250 cases for St. John Hospital, 1862 cases for St. Bart's Hospital, and 1,271 cases for St. Croix Hospital.
Medicare dominated the Cardiology payor mix at Central Caribbean medical Center with 66.7% of the patients, followed by Blue Cross with 13.0%, and HMO with 7.2%. Central Caribbean Medical Center had the second highest proportion of Medicare for Cardiology patients, had an average percentage of Blue Cross patients, and had a below average share of HMO patients compared with the hospitals in the group.
Central Caribbean Medical Center's Cardiology patients were about the same age as the average of its competitors (69.5 years compared to 68.6 years). The largest source of admissions for Central Caribbean Medical Center's Cardiology patients was emergency room (75% of patients), followed by physician referral (20%) and unknown (4%). Central Caribbean had an above average proportion of emergency room for Cardiology patients compared to the other hospitals in the group, and had an average percentage of physician referral patients.
The top five Cardiology patient groups for Central Caribbean Medical Center accounted for 1,066 or 80% of the hospital's total Cardiology cases. These groups were Angina Pectoris (23%), Heart Failure & Shock (20%), AMI (18%), Cardiac Arrhythmia (12%), and Chest Pain (7%).
Central Caribbean Medical Center's average length of stay per Cardiology case was 6.8 days, 0.1 days or 1% lower than the case mix adjusted average of its six major competitors of 6.9 days. St. Bart's Hospital had the lowest length of stay of 5.6 days, 1.2 days of 18% lower than Central Caribbean's.
Central Caribbean's average total cost per Cardiology case was $5,240. The case mix adjusted average of its six major competitors was $4,633-$608 or 12% lower than Central Caribbean Medical Center. Central Caribbean had the highest cost per case. St. Thomas Hospital had the lowest cost with $4,099. When examining major cost components, the key area of lower total cost for Central Caribbean was EKG/EEG. Central Caribbean's total cost for routine care, laboratory/cath, radiology, and other services were significantly above St. Thomas Hospital's costs.
For additional cost savings, Central Caribbean should consider ways to reduce Routine Care, Laboratory/Cath, Radiology, and Other Services costs for Cardiology cases to the cost of St. Thomas Hospital and to emulate the length of stay achieved by St. Bart's Hospital. Such actions have the potential to save Central Caribbean Medical Center $609,123 to $1,015,206 a year--$192,018 to $320,029 related to ancillary services and $417,106 to $695,176 related to length of stay reductions.
Payor Mix
Medicare dominated the Cardiology payor mix at Central Caribbean Medical Center with 66.7% of the patients, followed by Blue Cross with 13.0%, and HMO with 7.2%. Central Caribbean's payor mix as compared with the Cardiology payor mix for all hospitals in the comparison group was as shown in Table VIII.
FIG. 13A compares the Cardiology payor mix for Central Caribbean Medical Center with that of its primary Cardiology competitors.
Central Caribbean Medical Center had the second highest proportion of Medicare for Cardiology patients, had an average percentage of Blue Cross patients, and had a below average share of HMO patients compared with the hospitals in the group.
Patent Demographics
As shown in Table IX, Central Caribbean Medical Center's Cardiology patients were about the same age as the average of its competitors (69.5 years compared to 68.6 years). Males represented a lower proportion of Cardiology (47% versus 52%), while minorities mad up an average share of patients compared to the competitor average (3.8% versus 3.5%).
FIG. 13B provides more detail on the age distribution of Central Caribbean's patients compared to its competitors.
Admit Source
The largest source of admissions for Central Caribbean Medical Center's Cardiology patients was emergency room (75% of patients), followed by physician referral (20%) and unknown (4%). FIG. 13C compares the admit source of Central Caribbean's Cardiology patients with that of its primary competitors.
Emergency Room, the largest source of admissions for Central Caribbean Medical Center, was also the largest source of admissions for all the other hospitals in the group. Central Caribbean had an above average proportion of emergency room for Cardiology patients compared to the other hospitals in the group, and had an average percentage of physician referral patients.
Case Mix
The top five Cardiology patient groups for Central Caribbean Medical Center accounted for 1.066 or 80% of the hospital's total Cardiology cases. These key patient groups were as shown in Table X.
FIG. 13D shows the specialty mix of these Cardiology patient groups for Central Caribbean versus its six main competitors.
Central Caribbean had an above average proportion of angina pectoris cases and an above average proportion of heart failure and shock cases compared with the other six hospitals in the group.
Length of Stay (Case Mix Adjusted)
As shown in Table XI, Central Caribbean Medical Center's average length of stay per Cardiology case was 6.8 days, 0.1 days or 1% lower than the average of its six major competitors of 6.9 days. St. Bart's Hospital had the lowest length of stay of 5.6 days, 1.2 days or 18% lower than Central Caribbean's.
Central Caribbean's length of stay was consistently above St. Bart's LOS across the key patient groups. FIG. 13E shows a comparison of Central Caribbean Medical Center with St. Bart's Hospital.
Cost per Case (Case Mix Adjusted)
Central Caribbean's average total cost per Cardiology case was $5,240. The average of its six major competitors was $4,633-$608 or 12% lower than Central Caribbean Medical Center. Control Caribbean had the highest cost per case. St. Thomas Hospital had the lowest cost with $4,099. Specifically, the cost per case for each hospital as compared to Central Caribbean Medical Center was as shown in Table XII.
FIG. 13F shows the composition of the cost per case by department group for Central Caribbean and its competitors.
The $1,141 lower cost per case for St. Thomas Hospital compared to Central Caribbean Medical Center was composed of the elements shown in Table XIII.
As shown in Table XIII, the key area of lower total cost for Central Caribbean was EKG/EEG. Central Caribbean's total costs for routine care, laboratory/cath, radiology, and other services were significantly above St. Thomas Hospital's costs.
Opportunity Analysis/Action Plan
Central Caribbean Medical Center spent $806,847 more treating its 1,328 Cardiology cases than if it had performed at the comparative average (1,328 cases * $608 per case). This increased cost was primarily due to its significantly higher Routine Care, Intensive Care, and Radiology costs than its competitors.
For additional cost savings, Central Caribbean should consider ways to reduce Routine Care, Laboratory/Cath, Radiology, and Other Services costs for Cardiology cases to the cost of St. Thomas Hospital and to emulate the length of stay achieved by St. Bart's Hospital. Such actions have the potential to save Central Caribbean Medical Center $609,123 to $1,015,206 a year--$192,108 to $320,029 related to ancillary services and $417,106 to $695,176 related to length of stay reductions.
To achieve the potential savings, Central Caribbean Medical Center should focus on meeting the following goals:
Reduce the average length of stay in the Intensive Care Units from 1.3 days to the 0.8 days of St. Bart's Hospital (savings of $201,662 to $336,104)
Reduce the average length of stay in the Routine Units from 5.5 days to the 4.8 days of St. Bart's Hospital (savings of $81,248 to $135,414)
Reduce Routine Care cost per day by 25% to the cost of St. Thomas Hospital (savings of $134,195 to $223,659)
Reduce Radiology expenditure by 63% to the cost of St. Thomas Hospital (savings of $89,387 to $148,979)
Reduce Laboratory/Cath expenditure by 32% to the cost of St. Thomas Hospital (savings of $50,832 to $84,720)
Reduce Other Services expenditure by 32% to the cost of St. Thomas Hospital (savings of $51,798 to $86,330).
Other embodiments are within the scope of the following claims. For example, the technique could be applied to a comparison of educational institutions, such as colleges or universities, or to any other kind of service organization for which comparable data is available.
TABLE I
__________________________________________________________________________
FY 1992 (AS FILED) MCR-2552 COST REPORT
KBO & CO. / COSTREP+ MICRO - 2552-92
FILE: YE92
VERSION: 155
1/28/1993
15:25
s3
PROVIDER NO.: 22-0053
PERIOD:
HOSPITAL AND HOSPITAL-HEALTH CARE COMPLEX
FROM
10/01/91
STATISTICAL DATA SYMMES HOSPITAL
TO 9/30/92
INPATIENT DAYS
BED DAYS TOTAL ALL
NO. OF BEDS
AVAILABLE
TITLE V
TITLE XVIII
TITLE XIX
PATIENTS
COMPONENT 1 2 3 4 5 6
__________________________________________________________________________
1.01
HOSPITAL (EXCLUDING SWING BED)
114 41,724 0 20,368 302 27,608
1.02
HOSPITAL - SWING BED SNF
*** *** *** 0 *** 0
1.03
HOSPITAL - SWING BED NF
*** *** 0 *** 0 0
1.04
HOSPICE *** *** *** 0 0 0
1.05
TOTAL ADULTS/PED. (EX. OBS. BEDS)
114 41,724 0 20,368 302 27,608
2 INTENSIVE CARE UNIT
8 2,928 0 1,307 26 1,925
3 CORONARY CARE UNIT 0 0 0 0 0 0
4 BURN INTENSIVE CARE UNIT
0 0 0 0 0 0
5 SURG INTENSIVE CARE UNIT
0 0 0 0 0 0
6 0 0 0 0 0 0
7 NURSERY 0 0 0 0 0 0
8 TOTAL HOSPITAL (SUM LINES 1.05-7)
122 44,652 0 21,675 328 29,533
9 SUBPROVIDER 1 0 0 0 0 0 0
11 SKILLED NURSING FACILITY 1
0 0 0 0 0 0
12 OTHER NURSING FACILITY 1
0 0 0 *** 0 0
13 OTHER LONG TERM CARE
0 0 *** *** *** 0
14.01
HOME HEALTH AGENCY 2
*** *** *** *** *** ***
15 CORF *** *** *** *** *** ***
16 ASC *** *** *** *** *** ***
17 HOSPICE 0 0 *** 0 0 0
18 TOTAL (SUM OF LINES 8-17)
122 44,652 0 21,675 328 29,533
19 OBSERVATION BED DAYS
*** *** *** *** *** 0
__________________________________________________________________________
FY 1992 (AS FILED) MCR-2552 COST REPORT
KBO & CO. / COSTREP+ MICRO - 2552-92
FILE: YE92
VERSION: 155
1/28/1993
15:26
A
RECLASSIFICATION AND ADJUSTMENT
PROVIDER NO.: 22-0053
PERIOD:
OF TRAIL BALANCE OF EXPENSES FROM 10/01/91
SYMMES HOSPITAL
TO 9/30/92
RECLASSED NET EXPENSE
RECLASSI-
TRIAL ADJUST-
FOR
COST CENTER DESCRIPTION
SALARIES
OTHER TOTAL FICATIONS
BALANCE
MENTS
ALLOCATION
(OMIT CENTS) (1) (2) (3) (4) (5) (6) (7)
__________________________________________________________________________
GENERAL SERVICES C.C.'S
*** *** *** *** *** *** ***
0100
OLD CAPITAL - BLDG + FIX
*** 1,469,513
1,469,513
538,577
2,008,090
0 2,008,090
0200
OLD CAPITAL - MOV EQUIP
*** 0 0 1,047,987
1,047,987
(101,081)
946,906
0300
NEW CAPITAL - BLDG + FIX
*** 0 0 11,003
11,003 0 11,003
0400
NEW CAPITAL - MOV EQUIP
*** 0 0 424,684
424,684
(112,701)
311,983
0500
EMPLOYEE BENEFITS
159,624
2,415,466
2,575,090
0 2,575,090
0 2,575,090
0600
ADMINISTRATIVE + GENERAL
2,536,338
2,536,338
5,295,632
(37,495)
5,258,137
(86,045)
5,172,092
0700
MAINTENANCE AND REPAIRS
205,124
234,706
439,830
(57) 439,773
0 439,773
0800
OPERATION OF PLANT
153,403
524,654
678,057
0 678,057
(2,809)
675,248
0900
LAUNDRY AND LINEN SERVICE
15,659
179,318
194,977
0 194,977
0 194,977
1000
HOUSEKEEPING 360,130
84,632
444,762
0 444,762
0 444,762
1100
DIETARY 606,342
311,297
917,639
(365,088)
552,551
0 552,551
1200
CAFETERIA 0 0 0 361,880
361,880
0 361,880
1300
MAINTENANCE OF PERSONNEL
0 0 0 0 0 0 0
1400
NURSING ADMINISTRATION
294,300
25,972
320,272
0 320,272
0 320,272
1500
CENTRAL SERVICES + SUPPLY
84,419
64,872
149,291
977,577
1,126,868
(4,225)
1,122,643
1600
PHARMACY 214,147
626,143
840,290
96,311
936,601
(14,580)
922,021
1700
MEDICAL RECORDS + LIBRARY
328,090
125,082
453,172
0 453,172
(19,509)
433,663
1800
SOCIAL SERVICE 142,900
4,364 147,264
0 147,264
0 147,264
0 0 0 0 0 0 0
2000
NONPHYSICIAN ANESTHETISTS
0 0 0 0 0 0 0
2100
NURSING SCHOOL 0 0 0 0 0 0 0
2200
INTERN-RESIDENT (SALARY)
0 0 0 0 0 0 0
2300
INTERN-RESIDENT (OTHER)
0 0 0 0 0 0 0
PARAMEDICAL EDUCATION
0 0 0 0 0 0 0
I/P ROUT. SRVC COST CNTRS.
*** *** *** *** *** *** ***
2500
ADULTS AND PEDIATRICS
3,612,021
867,000
4,479,021
(254,947)
4,224,074
(335,633)
3,888,441
2600
INTENSIVE CARE UNIT
809,374
110,007
919,381
(51,483)
867,898
0 867,898
2700
CORONARY CARE UNIT
0 0 0 0 0 0 0
2800
BURN INTENSIVE CARE UNIT
0 0 0 0 0 0 0
2900
SURG INTENSIVE CARE UNIT
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
3300
NURSERY 0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
ANCILLARY SERVICE C.C.'S
*** *** *** *** *** *** ***
3700
OPERATING ROOM 731,692
1,341,210
2,072,902
(447,636)
1,625,266
0 1,625,266
3800
RECOVERY ROOM 297,115
39,537
336,652
(13,932)
322,720
0 322,720
3900
DELIVERY AND LABOR ROOMS
0 0 0 0 0 0 0
4000
ANESTHESIOLOGY 0 88,224
88,224
(74,762)
13,462 0 13,462
4100
RADIOLOGY - DIAGNOSTIC
661,900
642,348
1,304,248
(65,915)
1,238,333
(735)
1,237,598
4200
RADIOLOGY - THERAPEUTIC
0 0 0 0 0 0 0
4300
RADIOISOTOPE 56,871
86,080
142,951
(1,538)
141,413
0 141,413
4400
LABORATORY 1,004,169
906,714
1,910,883
75,172
1,986,055
(90,000)
1,896,055
4500
PBP CLINICAL LAB SERVICE
*** 0 0 0 0 0 0
4600
WHOLE BLOOD AND PRBC'S
0 0 0 0 0 0 0
4700
BLOOD STORING + PROCESSING
0 0 0 0 0 0 0
4800
INTRAVENOUS THERAPY
118,163
31,404
149,567
(128,650)
20,917 0 20,917
4900
RESPIRATORY THERAPY
367,431
114,874
482,305
14,811
497,116
(65,427)
431,689
5000
PHYSICAL THERAPY
281,361
6,277 287,638
(2,043)
285,595
(31,842)
253,753
5100
OCCUPATIONAL THERAPY
20,751
3,993 24,744
(2,876)
21,868 0 21,868
5200
SPEECH PATHOLOGY
9,746 492 10,238
0 10,238 0 10,238
5300
ELECTROCARDIOLOGY
69,805
101,540
171,345
(3,963)
167,382
(17,600)
149,782
5400
ELECTROENCEPHALOGRAPHY
22,816
2,776 25,592
(123) 25,469 0 25,469
5500
MED. SUPPL. CHD. TO PATIENTS
0 0 0 0 0 0 0
5600
DRUGS CHARGED TO PATIENTS
0 0 0 0 0 0 0
5700
RENAL DIALYSIS 0 0 0 0 0 0 0
5800
ASC (NON-DISTINCT PART)
0 0 0 0 0 0 0
0 0 0 0 0 0 0
OUTPAT. SERVICE C.C.'S
*** *** *** *** *** *** ***
6000
CLINIC 381,083
160,268
541,351
(34,262)
507,089
(7,713)
499,376
6100
EMERGENCY 1,168,539
340,064
1,508,603
(81,520)
1,427,083
(725,920)
701,163
6200
OBSERVATION BEDS (NON-D)
*** *** *** *** *** *** ***
6101
ADVANCED LIFE SUPPORT
350,048
390,691
740,739
(7,711)
733,028
(11,440)
721,588
0 0 0 0 0 0 0
OTHER REIMBURSABLE C.C.'S
*** *** *** *** *** *** ***
0 0 0 0 0 0 0
6500
AMBULANCE SERVICES
0 0 0 0 0 0 0
6600
DURABLE MED. EQUIP.-RENTED
0 0 0 0 0 0 0
6700
DURABLE MED. EQUIP.-SOLD
0 0 0 0 0 0 0
0 0 0 0 0 0 0
7000
INTERN-RESIDENT (NOT APPR)
0 0 0 0 0 0 0
__________________________________________________________________________
FY 1992 (AS FILED) MCR-2552 COST REPORT
KBO & CO. / COSTREP+ MICRO - 2552-92
FILE: YE92
VERSION: 155
1/28/1993
15:38
C
PROVIDER NO.: 22-0053
PERIOD:
COMPUTATION OF RATIOS OF COSTS TO CHARGES
FROM
10/01/91
SYMMES HOSPITAL
TO 9/30/92
WKST. 8, PT 1
RT/PT LIMIT
TOTAL RCE TOTAL TOTAL
COL. 27 ADJUSTMENT
COSTS DISALLOWANCE
COSTS CHARGES
COST CENTER DESCRIPTION
1 2 3 4 5 6
__________________________________________________________________________
I/P ROUT. SRVC COST. CNTRS.
*** *** *** *** *** ***
ADULTS AND PEDIATRICS
10,225,629
*** 10,225,629
0 10,225,629
9,431,026
INVENSIVE CARE UNIT
1,704,674
*** 1,704,674
0 1,704,674
1,046,068
CORONARY CARE UNIT
0 *** 0 0 0 0
BURN INTENSIVE CARE UNIT
0 *** 0 0 0 0
SURG INTENSIVE CARE UNIT
0 *** 0 0 0 0
0 *** 0 0 0 0
0 *** 0 0 0 0
NURSERY 0 *** 0 0 0 0
0 *** 0 0 0 0
0 *** 0 0 0 0
0 *** 0 0 0 0
ANCILLARY SERVICE C.C.'S
*** *** *** *** *** ***
OPERATING ROOM 3,165,571
*** 3,165,571
0 3,165,571
6,536,725
RECOVERY ROOM 622,489 *** 622,489
0 622,489
2,145,544
DELIVERY AND LABOR ROOMS
0 *** 0 0 0 0
ANESTHESIOLOGY 249,139 *** 249,139
0 249,139
1,209,934
RADIOLOGY - DIAGNOSTIC
2,465,401
*** 2,465,401
0 2,465,401
6,465,992
RADIOLOGY - THERAPEUTIC
0 *** 0 0 0 0
RADIOISOTOPE 346,227 *** 346,227
0 346,227
849,177
LABORATORY 3,041,904
*** 3,041,904
0 3,041,904
4,582,858
PBP CLINICAL LAB SERVICE
0 *** 0 0 0 0
WHOLE BLOOD AND PRBC'S
0 *** 0 0 0 0
BLOOD STORING + PROCESSING
0 *** 0 0 0 0
INTRAVENOUS THERAPY
85,909 *** 85,909
0 85,909
120,013
RESPIRATORY THERAPY
784,800 0 784,800
0 784,800
234,401
PHYSICAL THERAPY
488,724 0 488,724
0 488,724
1,128,458
OCCUPATIONAL THERAPY
51,645 *** 51,645
0 51,645
109,970
SPEECH PATHOLOGY
22,409 *** 22,409
0 22,409
46,681
ELECTROCARDIOLOGY
306,098 *** 306,098
0 306,098
1,906,873
ELECTROENCEPHALOGRAPHY
47,326 *** 47,326
0 47,326
48,917
MED. SUPPL. CHD. TO PATIENTS
717,671 *** 717,671
0 717,671
2,185,222
DRUGS CHARGED TO PATIENTS
999,755 *** 999,755
0 999,755
1,105,642
RENAL DIALYSIS 0 *** 0 0 0 0
ASC (NON-DISTINCT PART)
0 *** 0 0 0 0
0 *** 0 0 0 0
OUTPAT. SERVICE C.C.'S
*** *** *** *** *** ***
CLINIC 1,011,380
*** 1,011,380
0 1,011,380
237,003
EMERGENCY 1,597,000
*** 1,597,000
0 1,597,000
1,086,739
OBSERVATION BEDS (NON-D)
0 *** 0 *** 0 0
01
ADVANCED LIFE SUPPORT
1,012,834
*** 1,012,834
*** 1,012,834
707,130
0 *** 0 0 0 0
OTHER REIMBURSABLE C.C.'S
*** *** *** *** *** ***
0 *** 0 0 0 0
AMBULANCE SERVICES
0 *** 0 0 0 0
DURABLE MED. EQUIP.-RENTED
0 *** 0 0 0 0
DURABLE MED. EQUIP.-SOLD
0 *** 0 0 0 0
0 *** 0 0 0 0
SUBTOTAL 28,946,585
*** 28,946,585
0 28,946,585
41,184,373
LESS OBSERVATION BEDS
0 *** 0 *** 0 ***
TOTAL 28,946,585
*** 28,946,585
0 28,946,585
41,184,373
__________________________________________________________________________
TABLE II
______________________________________
Structure: Patient Summary
______________________________________
Unique ID Long Integer
Indexed; Unique; Enterable; Modifi-
able
Year Alpha 2 Enterable; Modifiable
Hospital Alpha 4 Indexed; Enterable; Modifiable
Payor Alpha 4 Indexed; Enterable; Modifiable
Specialty Alpha 2 Indexed; Enterable; Modifiable
MDC Alpha 2 Indexed; Enterable; Modifiable
DRG Alpha 3 Indexed; Enterable; Modifiable
Prin Diagnosis
Alpha 5 Indexed; Enterable; Modifiable
Prin Procedure
Alpha 4 Indexed; Enterable; Modifiable
Sex Alpha 2 Indexed; Enterable; Modifiable
Age Integer Indexed; Enterable; Modifiable
Town Alpha 20 Indexed; Enterable; Modifiable
Zip Code Alpha 5 Indexed; Enterable; Modifiable
Disposition
Alpha 2 Indexed; Enterable; Modifiable
Race Alpha 2 Indexed; Enterable; Modifiable
Admit Type Alpha 2 Enterable; Modifiable
Admit Source
Alpha 2 Indexed; Enterable; Modifiable
Admit Day Integer Enterable; Modifiable
Admit Month
Integer Enterable; Modifiable
Discharge Day
Integer Enterable; Modifiable
Discharge Month
Integer Enterable; Modifiable
LOS Integer Indexed; Enterable; Modifiable
Routine Days
Integer Enterable; Modifiable
ICU Days Integer Enterable; Modifiable
Preop Days Integer Enterable; Modifiable
Total Charges
Real Enterable; Modifiable
Routine Charges
Real Enterable; Modifiable
ICU Charges
Real Enterable; Modifiable
Ancill Charges
Real Enterable; Modifiable
Net Revenue
Real Enterable; Modifiable
Total Cost Real Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Vbl Cost Real Enterable; Modifiable
Net Profit Real Enterable; Modifiable
Direct Contr
Real Enterable; Modifiable
Vbl Contr Real Enterable; Modifiable
Patient ID Alpha 10 Enterable; Modifiable
Leave Days Integer Enterable; Modifiable
Admin Nec Days
Integer Enterable; Modifiable
Secondary Payor
Alpha 2 Enterable; Modifiable
Admitting MD
Alpha 2 Enterable; Modifiable
Operating MD
Alpha 2 Enterable; Modifiable
Veteran Status
Alpha 2 Enterable; Modifiable
DRG Old Alpha 3 Enterable; Modifiable
Num Sec Procs
Integer Enterable; Modifiable
Pharm Charges
Integer Enterable; Modifiable
Pharm Cost Real Enterable; Modifiable
Infection Boolean Enterable; Modifiable
Compl.sub.-- Comorb
Boolean Enterable; Modifiable
Expired Boolean Enterable; Modifiable
Num Infections
Integer Enterable; Modifiable
Num Comp.sub.-- Corm
Integer Enterable; Modifiable
Pharmacy Charge
Real Enterable; Modifiable
Pharmacy Cost
Real Enterable; Modifiable
Supplies Charge
Real Enterable; Modifiable
Supplies Cost
Real Enterable; Modifiable
Lab Charge Real Enterable; Modifiable
Lab Cost Real Enterable; Modifiable
RGN Alpha 4 Enterable; Modifiable
______________________________________
Structure: Patient Detail
______________________________________
Unique ID Long Integer
Indexed; Unique; Enterable; Modifi-
able
Diagnoses Subfile
Procedures Subfile
Pat Calc Flds
Subfile
______________________________________
Structure: Diagnoses
______________________________________
Diagnosis Code
Alpha 5 Enterable; Modifiable
______________________________________
Structure Procedures
______________________________________
Procedure Code
Alpha 4 Enterable; Modifiable
______________________________________
Structure: Pat Calc Flds
______________________________________
Element Alpha 10 Mandatory; Enterable; Modifiable
Value Real Enterable; Modifiable
______________________________________
Structure: Patient Cost
______________________________________
Unique ID Long Integer
Indexed; Unique; Enterable; Modifi-
able
Cost Subfile
Hospital Alpha 4 Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Total Cost Real Enterable; Modifiable
______________________________________
Structure: Cost
______________________________________
Department Code
Alpha 3 Enterable; Modifiable
Charges Real Enterable; Modifiable
Total Cost Real Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Vbl Cost Real Enterable; Modifiable
Quantity Real Enterable; Modifiable
______________________________________
Structure: Dept Cost
______________________________________
Medicare Code
Alpha 6 Indexed; Enterable; Modifiable
Year Alpha 2 Enterable; Modifiable
Department Code
Alpha 3 Indexed; Enterable; Modifiable
Total Cost Real Enterable; Modifiable
Total Charges
Real Enterable; Modifiable
Total Volume
Long Integer
Enterable; Modifiable
Total RCC Real Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Direct RCC Real Enterable; Modifiable
Salary Cost
Real Enterable; Modifiable
Salary RCC Real Enterable; Modifiable
NonSalary Cost
Real Enterable; Modifiable
NonSalary RCC
Real Enterable; Modifiable
PPS Year Alpha 2 Indexed; Enterable; Modifiable
Unused1 Alpha 2 Enterable; Modifiable
Unused2 Alpha 2 Enterable; Modifiable
______________________________________
Structure: Hospital
______________________________________
Code Alpha 4 Indexed; Enterable; Modifiable
Abbrev Alpha 12 Enterable; Modifiable
Description
Alpha 40 Indexed; Enterable; Modifiable
Attributes Subfile
Medicare Code
Alpha 6 Indexed; Unique; Enterable; Modifi-
able
Database ID
Alpha 2 Enterable; Modifiable
______________________________________
Structure: Attributes
______________________________________
Attribute Alpha 6 Indexed; Enterable; Modifiable
Attribute Value
Alpha 6 Indexed; Enterable; Modifiable
______________________________________
Structure: Payor
______________________________________
Code Alpha 2 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 30 Enterable; Modifiable
______________________________________
Structure: Specialty
______________________________________
Code Alpha 20 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 30 Enterable; Modifiable
______________________________________
Structure: Disposition
______________________________________
Code Alpha 2 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
______________________________________
Structure: Departments
______________________________________
Department Code
Alpha 3 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
Dept Group Alpha 2 Indexed; Enterable; Modifiable
______________________________________
Structure: Race
______________________________________
Code Alpha 2 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 20 Enterable; Modifiable
______________________________________
Structure: Admit Type
______________________________________
Code Alpha 2 Indexed; Enterable; Modifiable
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 30 Enterable; Modifiable
______________________________________
Structure: Admit Source
______________________________________
Code Alpha 2 Indexed; Enterable; Modifiable
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 30 Enterable; Modifiable
______________________________________
Structure: Procedure Code
______________________________________
Code Alpha 5 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
Infection Integer Enterable; Modifiable
Compl.sub.-- Comorb
Integer Enterable; Modifiable
______________________________________
Structure: Diagnosis Code
______________________________________
Code Alpha 5 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
Infection Integer Enterable; Modifiable
Compl.sub.-- Comorb
Integer Enterable; Modifiable
______________________________________
Structure: BatchReports
______________________________________
Report Alpha 20 Indexed; Enterable; Modifiable
Process Time
Time Enterable; Modifiable
Department Code
Alpha 3 Enterable; Modifiable
Volume Long Integer
Enterable; Modifiable
Charges Real Enterable; Modifiable
Total Cost Real Indexed; Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Total RCC Real Enterable; Modifiable
Direct RCC Real Enterable; Modifiable
Status Alpha 2 Enterable; Modifiable
______________________________________
Structure: Hospital Data
______________________________________
Hospital Alpha 4 Indexed; Mandatory; Enterable;
Modifiable
Year Alpha 2 Indexed; Enterable; Modifiable
State Alpha 2 Indexed; Enterable; Modifiable
Beds Integer Enterable; Modifiable
Discharges Integer Enterable; Modifiable
Patient Days
Long Integer
Enterable; Modifiable
Total Charges
Real Enterable; Modifiable
Total Cost Real Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Indirect Cost
Real Enterable; Modifiable
Indirect RCC
Real Enterable; Modifiable
Status Alpha 2 Indexed; Enterable; Modifiable
______________________________________
Structure: Hosp Attributes
______________________________________
Hospital Code
Alpha 4 Indexed; Mandatory; Enterable;
Modifiable
Attribute Alpha 5 Indexed; Enterable; Modifiable
Attribute Value
Alpha 6 Indexed; Enterable; Modifiable
______________________________________
Structure: Attrib Master
______________________________________
Attribute Code
Alpha 6 Indexed; Unique; Enterable; Modifi-
able
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
Type Alpha 2 Indexed; Enterable; Modifiable
Attrib Values
Subfile
______________________________________
Structure: Attrib Values
______________________________________
Attribute Value
Alpha 6 Indexed; Unique; Enterable; Modifi-
able
Value Abbrev
Alpha 10 Enterable; Modifiable
Value Descrip
Alpha 40 Enterable; Modifiable
______________________________________
Structure: SG Summary
______________________________________
Study Group
Alpha 6 Indexed; Mandatory; Enterable; Modifi-
able
Hospital Alpha 4 Indexed; Enterable; Modifiable
PG Index Integer Indexed; Enterable; Modifiable
Cases Real Enterable; Modifiable
Charges Real Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Total Cost Real Enterable; Modifiable
Patient Days
Real Enterable; Modifiable
Study Group ID
Long Integer
Indexed; Enterable; Modifiable
______________________________________
Structure: SG Cost
______________________________________
Study Group ID
Long Integer
Indexed; Enterable; Modifiable
Department Code
Alpha 3 Indexed; Enterable; Modifiable
Charges Real Enterable; Modifiable
Direct Cost
Real Enterable; Modifiable
Quantity Real Enterable; Modifiable
______________________________________
Structure: SG Structure
______________________________________
Study Group
Alpha 6 Indexed; Enterable; Modifiable
PG Index Integer Indexed; Enterable; Modifiable
PG1 Index Integer Indexed; Enterable; Modifiable
PG1 Value Alpha 10 Indexed; Enterable; Modifiable
PG2 Index Integer Indexed; Enterable; Modifiable
PG2 Value Alpha 10 Indexed; Enterable; Modifiable
SG Children
Subfile
______________________________________
Structure: SG Children
______________________________________
PG Child Index
Integer Indexed; Enterable; Modifiable
______________________________________
Structure: SG Description
______________________________________
Study Group
Alpha 10 Indexed; Mandatory; Enterable;
Modifiable
PG1 Field Alpha 20 Enterable; Modifiable
PG2 Field Alpha 20 Enterable; Modifiable
Num Hospitals
Integer Enterable; Modifiable
Num Discharges
Long Integer
Enterable; Modifiable
SG Abbrev Alpha 15 Enterable; Modifiable
SG Description
Alpha 40 Enterable; Modifiable
SG Attributes
Subfile
SG Hospitals
Subfile
Adjust Cost
Boolean Enterable; Modifiable
______________________________________
Structure: SG Attributes
______________________________________
Attribute Field
Alpha 20 Enterable; Modifiable
Attrib Values
Subfile
Attrib Type
Alpha 2 Enterable; Modifiable
______________________________________
Structure: Attrib Values
______________________________________
Attrib Values
Alpha 20 Enterable; Modifiable
______________________________________
Structure: SG Hospitals
______________________________________
Hospital Alpha 4 Indexed; Enterable; Modifiable
Description
Alpha 40 Indexed; Enterable; Modifiable
______________________________________
Structure: Report Pics
______________________________________
PMTable Picture Enterable; Modifiable
PMGraph Picture Enterable; Modifiable
Report ID Alpha 10 Indexed; Enterable; Modifiable
PMDoc Picture Enterable; Modifiable
LOSTable Picture Enterable; Modifiable
LOSGraph Picture Enterable; Modifiable
PDTable Picture Enterable; Modifiable
PDGraph Picture Enterable; Modifiable
MSTable Picture Enterable; Modifiable
MSGraph Picture Enterable; Modifiable
ASGraph Picture Enterable; Modifiable
CMTable Picture Enterable; Modifiable
CMGraph Picture Enterable; Modifiable
CostTable Picture Enterable; Modifiable
CostGraph Picture Enterable; Modifiable
CostTable2 Picture Enterable; Modifiable
ASTable Picture Enterable; Modifiable
ChargeTable
Picture Enterable; Modifiable
ChargeGraph
Picture Enterable; Modifiable
______________________________________
Structure: Groups
______________________________________
Group Name Alpha 10 Indexed; Enterable; Modifiable
Abbrev Alpha 15 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
Group Values
Subfile
Description2
Alpha 30 Enterable; Modifiable
______________________________________
Structure: Group Values
______________________________________
Group Value
Alpha 6 Indexed; Enterable; Modifiable
Abbrev Alpha 15 Enterable; Modifiable
Description
Alpha 40 Indexed; Enterable; Modifiable
Base File Info
Subfile
Description2
Alpha 20 Enterable; Modifiable
______________________________________
Structure: Base File Info
______________________________________
Base Field Alpha 20 Enterable; Modifiable
Type Alpha 2 Enterable; Modifiable
Field Values
Subfile
______________________________________
Structure: Field Values
______________________________________
Sequence Integer Enterable; Modifiable
Value Alpha 10 Enterable; Modifiable
______________________________________
Structure: Report File
______________________________________
Study Group
Alpha 10 Choices; Mandatory; Enterable;
Modifiable
Hospital Alpha 4 Choices; Mandatory; Enterable;
Modifiable
Report ID Alpha 10 Indexed; Mandatory; Enterable;
Modifiable
Summary Options
Subfile
Detail Options
Subfile
Data Options
Subfile
Option11 Integer Enterable; Modifiable
Option12 Integer Enterable; Modifiable
Option13 Integer Enterable; Modifiable
Option21 Integer Enterable; Modifiable
Option22 Integer Enterable; Modifiable
Option23 Integer Enterable; Modifiable
Option31 Integer Enterable; Modifiable
Option32 Integer Enterable; Modifiable
Option33 Integer Enterable; Modifiable
Option41 Integer Enterable; Modifiable
Option42 Integer Enterable; Modifiable
Option43 Integer Enterable; Modifiable
Option51 Integer Enterable; Modifiable
Option52 Integer Enterable; Modifiable
Option53 Integer Enterable; Modifiable
Option61 Integer Enterable; Modifiable
Option62 Integer Enterable; Modifiable
Option63 Integer Enterable; Modifiable
Option71 Integer Enterable; Modifiable
Option72 Integer Enterable; Modifiable
Option73 Integer Enterable; Modifiable
Option81 Integer Enterable; Modifiable
Option82 Integer Enterable; Modifiable
Option83 Integer Enterable; Modifiable
Adjust Info
Boolean Enterable; Modifiable
Option91 Integer Enterable; Modifiable
Option92 Integer Enterable; Modifiable
Option93 Integer Enterable; Modifiable
______________________________________
Structure: Summary Options
______________________________________
Options Integer Enterable; Modifiable
______________________________________
Structure: Detail Options
______________________________________
Options Integer Enterable; Modifiable
______________________________________
Structure: Data Options
______________________________________
Options Integer Enterable; Modifiable
______________________________________
Structure: DRG
______________________________________
Code Alpha 3 Indexed; Enterable; Modifiable
Abbrev Alpha 15 Enterable; Modifiable
Description
Alpha 30 Enterable; Modifiable
Specialty Alpha 2 Indexed; Enterable; Modifiable
Description2
Alpha 3 Enterable; Modifiable
______________________________________
Structure: Zip Code
______________________________________
Zip Code Alpha 5 Indexed; Enterable; Modifiable
Abbrev Alpha 20 Enterable; Modifiable
Town Alpha 20 Enterable; Modifiable
Community Alpha 20 Indexed; Enterable; Modifiable
______________________________________
Structure: Sex
______________________________________
Code Alpha 2 Indexed; Enterable; Modifiable
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 20 Enterable; Modifiable
______________________________________
Structure: Dept Group
______________________________________
Code Alpha 2 Indexed; Enterable; Modifiable
Abbrev Alpha 10 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
______________________________________
Structure: Output
______________________________________
Report Name
Alpha 20 Indexed; Enterable; Modifiable
I Value Integer Indexed; Enterable; Modifiable
J Value Integer Indexed; Enterable; Modifiable
Document Picture Enterable; Modifiable
______________________________________
Structure: Hold File
______________________________________
Group Name Alpha 10 Enterable; Modifiable
Abbrev Alpha 15 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
Group Values
Subfile
______________________________________
Structure: Group Values
______________________________________
Group Value
Value 6 Enterable; Modifiable
Abbrev Alpha 15 Enterable; Modifiable
Description
Alpha 40 Enterable; Modifiable
Description2
Alpha 20 Enterable; Modifiable
Base Field Alpha 20 Enterable; Modifiable
Type Alpha 2 Enterable; Modifiable
Value Alpha 10 Enterable; Modifiable
______________________________________
Structure: Database Info
______________________________________
Database ID
Alpha 2 Enterable; Modifiable
Database Name
Alpha 20 Enterable; Modifiable
______________________________________
TABLE III
__________________________________________________________________________
DRG Descriptions, Average Lengths of Stay, Day Outller Thresholds and
Relative Weights
Fiscal 91
Geometric
Fiscal 90
Fiscal 91 FY 90-91
Mean Day Day Fiscal 90
Fiscal
Charge in
DRG Length of
Outller
Outller
Relative
Relative
Relative
No.
Type
Description Stay Threshold
Threshold
Weights
Weights
Weights
__________________________________________________________________________
MDC 01-DISEASES & DISORDERS OF THE NERVOUS SYSTEM
1 Surg
Craniotomy Except Trauma
Age > 17 12.9 42 42 3.5670
3.3580
-0.2090
2 Surg
Craniotomy for Trauma
Age > 17 12.1 41 41 4.1379
3.5485
-0.5894
3 Surg
Craniotomy Age 0-17 12.7 41 42 2.8830
2.8830
0.0000
4 Surg
Spinal Procedures 10.8 40 40 2.6483
2.4532
-0.1951
5 Surg
Extracranial Vascular Procedures
5.8 34 35 1.5214
1.5246
0.0032
6 Surg
Carpal Tunnel Release 2.0 17 19 0.4709
0.4823
0.0114
7 Surg
Periph & Cran. Nerve & Other Nerv. Sys.
With C.C.
11.5 41 41 3.1110
2.6823
-0.4287
Proc.
8 Surg
Periph & Cran. Nerve & Other Nerv. Sys.
W/O C.C. 3.0 31 32 0.7355
0.7451
0.0096
Proc.
9 Med
Spinal Disorders & Injuries
6.9 35 36 1.4058
1.2229
-0.1829
10
Med
Nervous System Neoplasms
With C.C.
7.8 36 37 1.2449
1.2765
0.0316
11
Med
Nervous System Neoplasms
W/O C.C. 4.7 33 34 0.7451
0.7771
0.0320
12
Med
Degenerative Nervous System Disorders
6.9 35 36 0.9391
0.9256
-0.0135
13
Med
Multiple Sclerosis & Cerebellar Ataxia
7.1 35 36 0.8699
0.8726
0.0027
14
Med
Spec Cerebrovascular Disorders Ex TIA
7.3 35 36 1.2260
1.2212
-0.0048
15
Med
Transient Ischemic Attacks & Precerebral
4.2 32 33 0.6350
0.6420
0.0070
Occ.
16
Med
Nonspecific Cerebrovascular Disorders
With C.C.
6.7 35 36 1.0949
1.0703
-0.0246
17
Med
Nonspecific Cerebrovascular Disorders
W/O C.C. 4.4 33 33 0.6452
0.6326
-0.0126
18
Med
Cranial & Peripheral Nerve Disorders
With C.C.
6.0 34 35 0.9640
0.8749
-0.0891
19
Med
Cranial & Peripheral Nerve Disorders
W/O C.C. 3.9 32 33 0.5869
0.5629
-0.0240
20
Med
Nerv Sys. Infection Ex. Viral Meningitis
8.4 36 37 1.7817
1.8683
0.0866
21
Med
Viral Meningitis 7.5 36 37 1.4190
1.4439
0.0249
22
Med
Hypertensive Encephalopathy
4.4 32 33 0.6981
0.7206
0.0225
23
Med
Nontraumatic Stupor & Coma 4.3 32 33 0.8698
0.8322
-0.0376
24
Med
Seizure & Headache
Age > 17 w/C.C.
5.3 33 34 0.9689
0.9602
-0.0067
25
Med
Seizure & Headache
Age > 17 w/o C.C.
3.5 29 28 0.5270
0.5197
-0.0073
26
Med
Seizure & Headache
Age 0-17 4.0 31 33 0.7313
0.8176
0.0863
27
Med
Traumatic Stupor & Coma, Coma > 1 Hr.
4.3 33 33 1.6124
1.3481
-0.2643
28
Med
Traumatic Stupor & Coma, Coma < 1 Hr.
Age > 17 w/C.C.
5.9 34 35 1.2750
1.2060
-0.0690
29
Med
Traumatic Stupor & Coma, Coma < 1 Hr.
Age > 17 w/o C.C.
3.3 31 32 0.5730
0.5674
-0.0056
30
Med
Traumatic Stupor & Coma, Coma < 1 Hr.
Age 0-17 2.0 17 17 0.3496
0.3496
0.0000
31
Med
Concussion Age > 17 w/C.C.
4.2 32 33 0.7007
0.6933
-0.0074
32
Med
Concussion Age > 17 w/o C.C.
2.7 25 25 0.4038
0.4100
0.0062
33
Med
Concussion Age 0-17 1.6 9 9 0.2427
0.2427
0.0000
34
Med
Other Disorders of Nervous System
w/C.C. 6.0 34 35 1.2069
1.1714
-0.0355
35
Med
Other Disorders of Nervous System
w/o C.C. 3.6 32 33 0.5597
0.5464
-0.0133
MDC 02-DISEASES & DISORDERS OF THE EYE
36
Surg
Retinal Procedures 2.3 14 13 0.6443
0.6487
0.0044
37
Surg
Orbital Procedures 2.9 31 32 0.7415
0.7431
0.0016
38
Surg
Primary Iris Procedures 2.2 16 17 0.3550
0.3614
0.0064
39
Surg
Lens Procedures w/ or w/o Vitrectomy
1.6 7 8 0.4494
0.4456
-0.0038
40
Surg
Extraocular Procedures Except Orbit
Age > 17 2.0 20 21 0.4762
0.4923
0.0161
41
Surg
Extraocular Procedures Except Orbit
Age 0-17 1.6 7 7 0.3613
0.3613
0.0000
42
Surg
Intraccular Proc. Ex. Retina, Iris & Lens
2.2 16 16 0.6305
0.6202
-0.0103
43
Med
Hyphema 4.0 24 32 0.3350
0.3867
0.0517
44
Med
Acute Major Eye Infections 5.5 33 35 0.6035
0.5879
-0.0056
45
Med
Neurological Eye Disorders 3.4 30 29 0.5454
0.5650
0.0196
46
Med
Other Disorders of the Eye
Age > 17 with C.C.
4.2 32 33 0.6495
0.6701
0.0206
47
Med
Other Disorders of the Eye
Age > 17 w/o C.C.
2.6 28 28 0.3539
0.3608
0.0069
48
Med
Other Disorders of the Eye
Age 0-17 2.9 30 30 0.3969
0.3969
0.0000
MDC 03-DISEASES & DISORDERS OTHE EAR, NOSE & THROAT
49
Surg
Major Head & Neck Procedures
7.4 39 36 2.8633
2.3273
-0.5360
50
Surg
Sialodenectomy 2.2 15 14 0.6298
0.6413
0.0115
51
Surg
Salivary Gland Proc. Ex. Sialodenectomy
2.1 18 20 0.5647
0.5822
0.0175
52
Surg
Cleft Up & Palate Repair 2.6 26 25 0.8129
0.7394
-0.0735
53
Surg
Sinus & Mastoid Procedures
Age > 17 1.9 20 19 0.6161
0.6308
0.0147
54
Surg
Sinus & Mastoid Procedures
Age 0-17 3.2 22 22 0.6805
0.6805
0.0000
55
Surg
Miscellaneous Ear, Nose & Throat Proc.
1.6 14 13 0.4879
0.4905
0.0026
56
Surg
Rhinoplasty 1.7 14 13 0.4881
0.4982
0.0101
57
Surg
T & A Proc. Except Tonsil and/or
Age > 17 3.4 32 32 0.9313
0.8774
-0.0539
Adenoid
58
Surg
T & A Proc. Except Tonsil and/or
Age 0-17 1.5 4 4 0.3060
0.3060
0.0000
Adenoid
59
Surg
Tonsillectomy and/or Adenoidectomy
Age > 17 1.6 11 12 0.3878
0.4192
0.0314
60
Surg
Tonsillectomy and/or Adenoidectomy
Age 0-17 1.5 4 4 0.2584
0.2584
0.0000
61
Surg
Myringotomy w/ Tube Insertion
Age > 17 2.3 30/ 31
0.6945
0.7656
0.0711
62
Surg
Myringotomy w/ Tube Insertion
Age 0-17 1.3 5 5 0.3052
0.3052
0.0000
63
Surg
Other Ear, Nose, Mouth & Throat O. R.
3.8 32 33 1.1822
1.0111
-0.1771
Proc.
64
Med
Ear, Nose, Mouth & Throat Malignancy
5.0 33 34 1.1762
1.0651
-0.1111
65
Med
Dysequilibrium 3.3 23 23 0.4564
0.4636
0.0072
66
Med
Epistaxis 3.3 24 24 0.4496
0.4526
0.0032
67
Med
Epiglotitis 4.3 32 33 0.8589
0.8478
-0.0111
68
Med
Otitis Media & Uri
Age > 17 w/C.C.
4.9 33 33 0.7232
0.7209
-0.0023
69
Med
Otitis Media & Uri
Age > 17 w/o C.C.
3.8 25 24 0.5281
0.5086
-0.0195
70
Med
Otitis Media & Uri
Age 0-17 2.3 22 13 0.4589
0.2830
-0.1759
71
Med
Larynogotracheitis 4.3 32 27 0.7307
0.7030
-0.0277
72
Med
Nasal Trauma & Deformity 3.2 31 32 0.5528
0.5547
0.0019
73
Med
Other Ear, Nose, Mouth & Throat
Age > 17 4.1 32 33 0.7525
0.7291
-0.0234
Diagnosis
74
Med
Other Ear, Nose, Mouth & Throat
Age 0-17 2.1 20 20 0.3386
0.3386
0.0000
Diagnosis
MDC 04-DISEASES & DISORDERS OF THE RESPIRATORY SYSTEM
75
Surg
Major Chest Procedures 11.7 40 41 2.9603
2.9860
0.0257
76
Surg
Other Resp. System O.R. Procedures
w/C.C. 10.5 38 39 2.3038
2.3074
0.0036
77
Surg
Other Resp. System O.R. Procedures
w/0 C.C. 4.6 33 34 1.0895
1.0413
-0.0482
78
Med
Pulimonary Embolism 8.8 37 38 1.4320
1.4372
0.0052
79
Med
Respiratory Infections & Inflammations
Age > 17 w/C.C.
9.3 37 38 1.8530
1.8144
-0.0386
80
Med
Respiratory Infections & Inflammations
Age > 18 w/o C.C.
6.8 35 36 1.1382
1.0404
-0.0978
81
Med
Respiratory Infections & Inflammations
Age 0-17 6.1 34 35 1.0899
1.0899
0.0000
82
Med
Respiratory Neoplasms 6.7 35 36 1.2016
1.2178
0.0162
83
Med
Major Chest Trauma
w/C.C. 6.3 35 35 1.0064
0.9628
-0.0436
84
Med
Major Chest Trauma
w/o C.C. 3.7 32 28 0.5009
0.4846
|
