The Patient Care Details page displays the inpatient clinical expense totals (excluding room and bed charges and professional fees) for a fund since the last general ledger post date. This page can be generated based on a fund #, a PI name, or from the View drop down options: View All, View NIH, Other federal, Industry/Corporate, Not for Profit, or Sundries.
In addition to using the Document Direct report PQY0850.R1 at the end of the month to look at Patient Care charges against clinical trials research grants or using manually issued invoices, the Patient Care Details screen provides the ability to effectively review patient charges applied to research funds with data coming in nightly from PATCOM. The data will be display from a selected fund on a patient by patient basis with detailed information of charges.
Caption |
Type |
Description |
Fund # |
Number |
Displays the PeopleSoft fund number. |
PI Name |
Text |
The name of Principal Investigator of the Agreement |
View |
Drop down list |
View All, View NIH, Other federal, Industry/Corporate, Not for Profit, or Sundries. |
Caption |
Type |
Description |
Direct Costs |
Radio button |
Direct costs such as salaries, equipment cost incurred for all the categories are summed up and displayed month wise with totals. |
Total Costs |
Radio button |
Total of direct and indirect costs are displayed across months and total. |
Last GL Post |
Label |
The last date when patient care expenses were posted to the General Ledger data |
Last PO/AP Post |
Label |
Date Last Purchase Order or Accounts Payable to hit the general ledger |
Last Salary Post |
Label |
Date Last Salary expenses were posted to the general ledger |
Caption |
Type |
Description |
MRN# |
Number |
Ability to search for patient care expenses for a particular medical record # within the fund selected
|
Patient Last Name |
Text |
Ability to search for patient care expenses for a particular patient last name within the fund selected |
Patient First Name |
Text |
Ability to search for patient care expenses for a particular patient first name within the fund selected |
Charge Code |
Number |
Ability to search for patient care expenses for a particular procedure charge code within the fund selected |
Post Date From |
Date |
Ability to search for patient care expenses for a particular date range within the fund selected based on when the expense was applied to the general ledger |
Post Date To |
Date |
|
Service Date From |
Date |
Ability to search for patient care expenses for a particular date range within the fund selected based on date of service |
Service Date To |
Date |
|
Patcom/BICS# |
Number |
Ability to search for patient care expenses by Patcom or BICS# within the fund selected |
Any of the column headings can be selected to re-sort expenses. For example, Post Date can be selected to sort patient care expenses from most recent Post Date to oldest Post Date within the fund selected.
The last row on the last page of Patient Care Detail expenses will provide a sum total of the following:
Full Charge Amount
Discount Amount
Amount Charged to Fund
Reports can be downloaded by clicking on the available download links.
Download to Excel
When download to Excel, formulas are also downloaded (see table below)
Download to PDF
The navigation trail keeps track of the path that the user came in from to allow for easy ‘back’ access to where they came from. Example:
Financial Summary >> Patient Care Details
The Patient Care Details page can be accessed from the following pages:
Sub-Modules
By clicking the Expense Overview tab from the following pages:
Financial Summary
From Patient Care Details users can navigate back to the following:
Sub-Modules
Agreement Summary
Financial Summary
Transaction details
Budget details
Salary details
Project details
Contract details
Projections
Links
First Page
Previous Page
Next Page
Last Page
Patient Care expenses display will not display for those clinical trials which are using discount rates which are different from the flat institutional rates established at MGH on 6/1/2006 and at BWH on 10/1/2002.
For clinical trials which have independently negotiated a different discount rate for various procedures, the independently discounted amount will not be accurately reflected.
As individual patient identifiers and clinical information are provided in the Patient Care Expense details display, Health Insurance Portability and Accountability Act 0f 1996 ( HIPAA) policies and Partners guidelines should be applied at all times.
References:
Partners Health Information Services Privacy Policies
Minimum Necessary Standard PH-112
Information System Activity Review PH-505
Risk Assessment and Management Policy PH-501