|
Data Cubes are special type of report that "rolls-up" much of the supporting data (procedure codes, diagnosis codes, surgeons, payments, adjustments, etc.) into one of three levels:
|
Data is "rolled-up" to the charge-level. Payments and Adjustments are included on each charge line.
|
|
Data is "rolled-up" to the patient-level. Individual visit and charge detail is lost. Total Charges, Payments, and Adjustments are included on each patient line. No date range is selected if the Patient option is selected; it will report data on all patients (patients do not have date ranges; charges, visits, and transactions do).
|
|
Data is "rolled-up" to the visit-level. Individual charge detail is lost. Total Charges, Payments, and Adjustments are included on each visit line.
|
|
This reports all Charge, Payment, and Adjustment transactions on a separate line.
|
|
This reports all main anesthesia charges by anesthesia time segment. Depending on selection criteria, the report will contain an entry for each anesthesiologist and each anesthetist on a case, with each start and stop time, and minutes. Charge information (dollars and units) are reported both as a total for the charge and a "pro-rata" share of the total based on a percentage of the minutes for each time segment.
|
The Data Cubes are different from the data cubes available on virtually all other reports in that these data cubes are designed to allow the user to explore "what-if" scenarios by changing sorting and roll-ups on "on-the-fly". Standard report data cubes only report the information available on those reports in a data cube. The Data Cubes request form is a tabbed dialog that consists of a General tab, a Sorting tab, and a Selection tab.
General Tab
Task Name
|
Task Name displayed in the Task Viewer.
|
Cube Type
|
Roll-up Level to be selected: (see explanations above)
|
Patient Details
|
Indicates if patient details such as name, address, date of birth, sex, etc should be included in the cube.
|
Date Details
|
Indicates if date details such as service dates, remit dates, posted dates, etc should be included in the cube.
|
Anesthesia Details
|
Indicates if anesthesia details such as base, time, age, physical status, minutes, etc should be included in the cube.
|
For Selected Date Ranges
|
Charge Selection and Payment Selection is based on date range only. The payments selected do not necessarily have anything to do with the charges selected. Note: Only available when Cube Type is Transactions.
|
Payments for Selected Charges
|
Charges are selected based on the charge date type (posted or service) and charge date range selected. Payments are selected based on the payment date type (entered, posted, or remit) and date range selected. In addition, the charge that the payment is applied against must be one of the charges selected for the report. Note: Only available when Cube Type is Transactions.
|
Charges for Selected Payments
|
Payments are selected based on the payment date type (entered, posted, or service) and payment date range selected. In addition, the charge that the payment is applied against that fall within the charge date type (service or posted) and charge date range date selected for the report. Note: Only available when Cube Type is Transactions.
|
Select Charges By
|
Charge Date to examine for Date Type:
Not available when Charges for Selected Payments has been selected.
|
Charge Date From
|
Beginning date of the (posted or service) date range.
|
Charge Date Thru
|
Ending date of the (posted or service) date range.
|
Select Payments By
|
Payment Date to examine for Date Type:
Note: Only available when Cube Type is Transactions.
|
Payment Date From
|
Beginning date of the (entered, posted, or remit) date range.
|
Payment Date Thru
|
Ending date of the (entered, posted, or remit) date range.
|
Run Now
|
Indicates in the report should be run immediately.
|
Schedule
|
Indicates that the report should be scheduled to run at a future time.
|
Schedule Button
|
Invokes the Task Schedule Wizard to guide the user through setting the report run date(s) and time(s).
|
Breaks Tab
An extensive list of break fields may be included or excluded from the data cube. If a break is included in a cube, the field (e.g. facility) will be included in the cube and the data will be "rolled-up" and broken by that field.
Selection Tab
Frequently when a report is run, you only wish to see data meeting certain criteria. The Selection tab consists of a list of fields they you may use to include or exclude specific data values from the report. For example, you may wish to run a report for just a certain physician or excluding a certain location.
By clicking on the checklist for the appropriate field (physicians, facilities, etc.) you may then select to include or exclude certain values from the respective tables. The limit to the number of specific values you can select is limited to your ability (or willingness) to enter them. While there is a theoretical limit to the number of selections you can make, you will run out of patience before MedSuite runs out of room to save them. Muli-Selections work with standard Windows keyboard functionality. CTRL+Click to select one at a time, SHIFT+Click to select a range of maintenance files.
|