Clarity Shared Clinical

Question 1

T/F: One INP record for each Encounter?

Answer 1

True. The INP record gathers FSD records for that encounter.

Question 2

T/F: One FSD record holds a day of raw data

Answer 2

True. Midnight to Midnight.

Question 3

Each line in the IP_FLWSHT_MEAS table holds, what?

Answer 3

A flowsheet cell

Question 4

A line in IP_FLWSHT_EDITED holds, what?

Answer 4

One edit, to one cell.

Question 5

You need to find ALL edits to a flowsheet cell. What fields do you connect after FSD_ID to FSD_ID?

Answer 5

IP_FLWSHT_MEAS.LINE –> IP_FLWSHT_EDITED.LINE_NUM

Question 6

What is the intermediate table linking flowsheet data (FSD) to the encounter/patient?

Answer 6

IP_FLWSHT_REC.

INPATIENT_DATA_ID to either PAT_ENC or PAT_ENC_HSP.

Question 7

How do you determine if a flowsheet row is duplicable?

Answer 7

IP_FLO_GP_DATA.DUPLICATEABLE_YN (FLO 865)

Question 8

What column in the IP_FLWSHT_MEAS table do you use to distinguish between duplicable rows?

Answer 8

OCCURANCE

Question 9

Each LDA has two different kinds of rows, what are they?

Answer 9

property and assessment

Question 10

Property rows are recorded once and that data is stored on what masterfile?

Answer 10

LDA

Question 11

Flowsheet templates are stored in what masterfile?

Answer 11

FLT

Question 12

Flowsheet cells are stored in what masterfile

Answer 12

FSD

Question 13

Flowsheet rows and groups are stored in the same masterfile. What is it, and how would you identify a group row?

Answer 13

FLO (item 815) = 2

IP_FLO_GP_DATA . ROW_TYPE_C = 2

Question 14

IP_FLWSHT_MEAS . OCCURANCE distinguishes duplicable rows from each other. What table/column do you connect it to and why?

Answer 14

IP_FLOWSHEET_ROWS . LINE

To ensure that the data from IP_FLWSHT_MEAS relates to the appropriate LDA.

Question 15

How do you discover the Row ID of a flowsheet cell?

Answer 15

Turn on Show Report and Print Group IDs (EPIC > Reports). Go back to the flowsheet and scroll to the bottom of the righthand column. Row ID is the first thing listed.

Question 16

There are six context points at which a SmartData element can be stored. What are they?

Answer 16

Patient, Encounter, Episode

Order, Note, and Concept

Question 17

HLX master file contains?

Answer 17

Info about a particular SmartData element. It stores the ‘question’.

Question 18

HLV master file contains?

Answer 18

The SDE ‘answer’ entered by the end user.

Question 19

Explain the importance of the column IP_FLWSHT_MEAS.OCCURANCE.

Answer 19

Identifies which duplicable flowsheet group the measure is about.

Question 20

T/F: An LDA can only have one set of property rows.

Answer 20

True

Question 21

If an abbreviation is available, then IP_FLWSHT_MEAS.MEAS_VALUE will store…

Answer 21

The abbreviation

Question 22

If an abbreviation is not available then IP_FLWSHT_MEAS.MEAS_VALUE will store…

Answer 22

The name

Question 23

T/F: You can use the table GOUPER_ITEMS to find all the records contained by the grouper.

Answer 23

False, this table contains general info about the grouper, like the name.

Question 24

T/F: When joining from the main part of a report to GROUPER_DX_RECORDS, you should join to GROUPER_DX_RECORDS . CMPL_DX_RECS_ID. You should not join to GROUPER_DX_RECORDS . GROUPER_ID.

Answer 24

True