New Century Health Clinic-Case Study1

New Century Health Clinic

The associates at New Century Health Clinic approved your recommendations for a new computer system. Your next step is to develop a design for the new system, including output and user interface issues.
Background 
To complete the output and user interface design for the new information system at New Century, you should review the DFDs and object-oriented diagrams you prepared previously, and the rest of the documentation from the systems analysis phase. Perform the following tasks.
Assignments
1. Dr. Jones has asked you to create a monthly Claim Status Summary report. He wants you to include the insurance company number, the patient number and name, the procedure date, the procedure code and description, the fee, the date the claim was filed, the amount of the claim, the amount of reimbursement, and the amount remaining unpaid. He wants you to group the data by insurance company number, with subtotals by company and grand totals for each numeric field. When you design the report, make sure to include a mock-up report and a report analysis form.
Answer:

Claim Status Summary Report

2. Design the daily appointment list and a monthly statement to make it readable and visually attractive. Include a mock-up report and a report analysis form for each report.
Answer:

Daily Appointment List

Monthly Statement

3. Determine the data required for a new patient. Design an input source document that will be used to capture the data and a data entry screen to input the information.
Answer:

New Patient Entry Form

4. What data validation checks would the clinic need for the new patient data entry screen? Write a brief memo with your recommendations.
Answer:
MEMORANDUM
To: Dr. Jones

From: Roxanne E. Bagtong

Date: April 30, 2018

Subject: Data Validation Checks

Dear Dr. Jones,

Data validation is the process of ensuring that data have undergone data cleansing to ensure they have data quality, that is, that they are both correct and useful. It uses routines, often called "validation rules" "validation constraints" or "check routines", that check for correctness, meaningfulness, and security of data that are input to the system. 

The following are the data validation checks that cold be used in the clinic for the new patient data entry screen:

• An existence check is used for mandatory data items. For example, if an employee user to save the record until he or she enters a suitable value in the Social Security number field.
• A range check tests data items to verify that they fall between a specified minimum and maximum value.
• A data type check tests to ensure that a data item fits the required data type.

Roxanne E. Bagtong