Calculate and insert the number of delinquent records


Written Assignment - Delinquent Record Statistics

Assignment Overview

Scenario

For the purpose of this assignment, assume that you are the manager of the HIM Department of General Hospital. The hospital is due for a Joint Commission accreditation survey in six months.

The CEO has asked for a report regarding medical staff compliance with Joint Commission requirements for delinquent records last year.

Information Regarding Joint Commission Standards

The following are Joint Commission standards that address timeliness of medical record completion.

Joint Commission Standard Record of Care, Treatment, and Services (RC) RC.01.03.01

Documentation in the medical record is entered in a timely manner. Elements of Performance RC.01.03.01

1.   The hospital has a written policy that requires timely entry of information into the medical record.

2.   The hospital defines the time frame for completion of the medical record, which does not exceed 30 days after the patient's discharge.

3.   The hospital implements its policy requiring timely entry of information into the patient's medical record.

Joint Commission Standard Record of Care, Treatment and Services (RC) RC.01.04.01

The hospital audits its medical records.

Elements of Performance RC.01.04.01

The hospital measures its medical record delinquency rate at regular intervals, but no less than every three months

Information Regarding General Hospital's Policies, Procedures, Rules, and Regulations

To implement this standard, General Hospital's policies and procedures state:

- The medical record delinquency rates are monitored on a monthly basis;

- Action will be taken when a problem is indicated; and

- Data will be available to demonstrate improvement.

In addition, to ensure the timely entry of all significant clinical information into the patient's record, the Medical Staff Rules and Regulations list the following documentation requirements:

- The total number of delinquent records may not exceed 50% of the total number of inpatient discharges and ambulatory surgeries performed for the month.

- The total number of delinquent history and physicals may not exceed 2% of the total number of inpatient discharges and ambulatory surgeries performed for the month.

- The total number of delinquent operative reports may not exceed 2% of the total number of inpatient operations and ambulatory surgeries.

Assignment Instructions

Use Delinquent Record Report to complete the following:

Part-1: Create Delinquent Record Report Table

1. Using Microsoft Excel, input the data from the Delinquent Record Report. Include report, column and row titles, and the monthly data.

2. Use Excel to calculate and automatically insert the total number of discharges for the month.
a. Total discharges = total inpatient discharges + total ambulatory surgeries.
b. Total operations = total ambulatory surgeries + total inpatient operations.

3. Use Excel to calculate and insert the number of delinquent records, history and physical exam reports (H & Ps), and operative reports permitted according the Medical Staff Bylaws for each month in 20XX based on the hospital's statistics for that month. To calculate the year's figure, the monthly average should be used. Therefore, have a final monthly average column and use Excel to compute the averages for all rows.

Part-2: Create Line and Bar Graphs

4. Using Microsoft Excel, construct both line graphs and bar graphs showing the following:

a. The hospital's actual delinquent records compared to the total number of delinquent records permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year)

b. The hospital's actual delinquent H & Ps compared to the total number of delinquent H & Ps permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year).

c. The hospital's actual delinquent ORs compared to the total number of delinquent ORs permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year).

Part-3: Write Narrative Analysis
5. In a Word document, provide a narrative analysis of the findings for the CEO.
a. Reference the table and use the graphs you prefer to illustrate compliance in the report.
b. Include in the analysis whether the hospital was in compliance with the Medical Staff Rules and Regulations in each of the three areas during each month of the year.
c. Was the hospital in compliance for the whole year?
d. Be sure your analysis is free of spelling and grammar errors.

Submit the following to your instructor:
a. Delinquent Record Report Table
b. Line and bar graphs
c. Narrative analysis of findings

DELINQUENT RECORD REPORT 20XX

 

ITEM

JAN

FEB

MAR

APR

MAY

JUN

JULY

AUG

SEP

OCT

NOV

DEC

TOTAL

Total Inpatient Discharges

1499

1311

1297

1314

1708

1567

1736

1499

1578

1609

1588

1834

 

Total Ambulatory Surgeries

168

243

289

348

551

296

342

350

301

333

312

421

 

Total Inpatient Operations

672

888

553

540

354

468

494

416

518

437

279

599

 

Total Discharges

1667

 

 

 

 

 

 

 

 

 

 

 

 

Total Operations

840

 

 

 

 

 

 

 

 

 

 

 

 

Actual Delinquent Records

426

391

406

429

509

614

598

679

796

690

537

711

 

Actual Delinquent H & Ps

27

15

31

7

23

21

18

9

11

34

46

39

 

Actual Delinquent OR Reports

13

14

20

18

26

30

29

37

42

59

33

34

 

# of Delinquent Records Permitted

834

 

 

 

 

 

 

 

 

 

 

 

 

# of Delinquent H&Ps Permitted

33

 

 

 

 

 

 

 

 

 

 

 

 

# of Delinquent OR Reports Permitted

17

 

 

 

 

 

 

 

 

 

 

 

 

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Calculate and insert the number of delinquent records
Reference No:- TGS02492792

Now Priced at $60 (50% Discount)

Recommended (90%)

Rated (4.3/5)