Patient Care Details

 

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.

 

Patient Care Details Search Screen Elements

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.

Patient Care Details Main Screen Elements

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

 

Patient Care Details: Search Screen Elements within a Fund

 

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

 

 

 

 

 

Patient Care Details:  Line Item Expenses within a Fund

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.

 

 

F# / Special Billing#5

Patient Name

Medical Record #

Post Date

Service Date

Charge Code

CPT Code

Charge Description

QTY

Full Charge Amount

Discount Amount

Amount Charged to Fund

 

 

The last row on the last page of Patient Care Detail expenses will provide a sum total of the following:

 

 

 

Patient Care Export Options

Reports can be downloaded by clicking on the available download links.

 

When download to Excel, formulas are also downloaded (see table below)

 

Patient Care Details Navigation

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:

 

By clicking the Expense Overview tab from the following pages:

 

From Patient Care Details users can navigate back to the following:

 

 

 

 

Patient Care Details Use: Notes

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: