HIM

Question 1

The HIM application consists of four modules. What are they?

Answer 1

Chart tracking
Deficiency tracking
Release of Information
Hospital Coding

Question 2

What are the levels of an organization as set up in Epic?

Answer 2

Facility
Service Area
Location
Hospital Area (optional)
Department / Unit
Rooms
Beds

Question 3

Why might an organization have more than one service area?

Answer 3

To separate the finances.

Question 4

What table holds facility and service area data?

Answer 4

CLARITY_SA

Question 5

What table holds revenue location data?

Answer 5

CLARITY_LOC

Question 6

What does the SER master file contain.

Answer 6

Schedulable Epic Resources

Question 7

CLARITY_SER is full of information about clinicians what other resources will you find in this table?

Answer 7

Imaging machines (MR, CT, etc), classes (diabetic ed), and operating rooms… all resources that need a schedule.

Question 8

Who needs a record in CLARITY_EMP?

Answer 8

Anyone who logs in to Hyperspace.

Question 9

T/F: A provider can have multiple specialties.

Answer 9

True

Question 10

T/F: If a provider is going to have a schedule in a specific department there will be an entry in CLARITY_SER_DEPT.

Answer 10

True

Question 11

Is it possible to have the security to do something in Epic but still not be able to see it in Hyperspace?

Answer 11

Yes, security controls permissions, user role controls what you see when you log in.

Question 12

Is it possible for a user to have more than one role in Hyperspace?

Answer 12

Yes. CLARITY_EMP_ROLE is the intermediate table that holds user id and the ID of all the roles listed for that user.

Question 13

What table and column are the recommended way of discovering if a provider is a resident?

Answer 13

CLARITY_SER_2 . IS_RESIDENT_C

link to ZC_IS_RESIDENT to know which is which

Question 14

T/F: A provider’s primary specialty and department are saved overtime in CLARITY_SER_SPEC and CLARITY_SER_DEPT.

Answer 14

False. These entries are not dated and in fact rely solely on a person entering the provider’s primary spec and dept first.

Question 15

What records are stored in CLARITY_ECL?

Answer 15

security classification records

Question 16

How many Chronicles master files are used to store facility, service areas, locations, and departments?

Answer 16

Two, EAF and DEP. Facility, service areas and locations are all EAF files (extracted to different tables). Departments are stored in DEP.

Question 17

You need to report on departments by location. What two tables do you need and how would you join them?

Answer 17

The department’s location is stored in CLARITY_DEP . REV_LOC_ID. Connect that to CLARITY_LOC . LOC_ID

Question 18

There are two deficiency master files, what are they, and how are they different?

Answer 18

DEF holds the deficiency definitions and DIF holds the individual instances. (4.13)