BIS 245 Case Study

profilevvgreen
CaseStudyFiles1.zip
Home>Business & Finance homework help>Accounting homework help>BIS 245 Case Study

Appointments.xlsx

Appointments

AppointmentID AppointmentDate AppointmentTime AppointmentLocation
ADAM8910002 04-Oct-19 12:00 P.M. Hershey Hospital
JENN9101003 03-Oct-19 7:00 A.M. Palmyra Family Practice
JOHN7890001 02-Oct-19 10:00 A.M. Hershey Rehab Clinic
NELS1011005 09-Oct-19 9:30 A.M. Hershey General Clinic
SMIT6789001 01-Oct-19 9:00 A.M. Hershey General Clinic

1

2

3

4

5

6

7

8

9

A

B

C

D

E

Doctors.txt

------------------------------------------------------------------------------------------------------------- | DoctorID | DoctorLastName | DoctorFirstName | DoctorSpecialty | ------------------------------------------------------------------------------------------------------------- | DOC001 | Johnson | Virginia | Family Practice | ------------------------------------------------------------------------------------------------------------- | DOC002 | Miller | Alexis | Pediatrics | ------------------------------------------------------------------------------------------------------------- | DOC003 | Stewart | Dave | Cardiovascular | ------------------------------------------------------------------------------------------------------------- | DOC004 | Young | Phillip | Rehabilitation | ------------------------------------------------------------------------------------------------------------- | DOC005 | Wentz | Carson | Neurology | -------------------------------------------------------------------------------------------------------------

Patients.xlsx

Patients

PatientID PatientLastName PatientFirstName PatientCity PatientStreet PatientST PatientPostalCode
123-45-6789 Smith John Hershey Main PA 17234
234-56-7890 Johnson Alex Palmyra First PA 17078
345-67-8910 Adams Jake Anville Water PA 17345
456-78-9101 Jennings Mary Middletown Mill PA 17057
567-89-1011 Nelson Sue Cleona Second PA 17987

1

2

3

4

5

6

7

8

9

A

B

C

D

E

Procedure.xlsx

Procedure

ProdcedureID ProcedureName ProcedurePrep ProcedureLocation ProcedureDuration
001 Yearly Physical None Hershey General Clinic 30 minutes
002 Immunization Shots None Palmyra Family Practice 30 minutes
003 Stress Test Fast 12 Hours clear liquids no solid food Hershey Hospital 1 hour 30 minutes
004 Physical Therapy None Hershey Rehab Clinic 2 hours
005 Flu Vaccination None Hershey General Clinic 30 minutes

1

2

3

4

5

6

7

8

9

A

B

C

D

E