Databases and Record Keeping

 

Objective: The purpose of this assignment is to demonstrate  application and evaluation of compliance with state and local  regulations of  MacIntosh Hospital , as well as a variety of modern data capture and data  storage techniques.

Examples include:
Administrative Functions
Human resources functions-hiring, termination, employee benefits
Billing office-coding and billing, accounts receivable
Admissions, discharge and transfer-ADT system
Patient Care Functions
Radiology
Laboratory
Pharmacy
Nursing
 

For each department and function that you identify, prepare a  table examining types of data kept by that department, the urgency for  having availability of information, and potential methods for storage.  For example:

 

Department/function

Types of data Urgency Storage Needs   

Admissions, Discharge, Transfers

Patient identification and demographics: Address, phone, insurance types Immediate availability for current inpatients
 

        Retrievable within one hour after discharge Database ADT tables on an active server
 

        Stored on reserve disk drives   

Dietary

Prescribed patient diet Immediate for inpatients
        Archived EHR post discharge Contained in EHR on active server   

Once completed, your data retention plan should include the following:

A summary of the data needs for the organization, the management  of the needed use and access and the storage requirements to maintain  sufficient data to support the patient’s care.

A breakdown of the requirements (both business and user)     related to gathering, capturing, structuring, storing, protecting,  and retrieving data. This plan should be 3-5 pages in length.