Clarity - Beacon Flashcards

1
Q

True/False: An encounter can belong to more than one episode?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

When is an Oncology Episode created?

A

When the Oncologist applies a Treatment Plan to a patient an oncology episode is created behind the scenes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Why is it necessary to use the EPISODE_LINK table to join EPISODES with their related encounters?

A

Because one encounter can be linked to many episodes and one episode may have many encounters attached to it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In Oncology, a stage is what?

A

The numeric representation of the progression of a patient’s cancer. Most, but not all, types of cancer are staged.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Treatment Plans are stored in what master file?

A

TPL. Treatment plans are linked to the patient through an episode.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Oncology protocols (PRL) are the base for what?

A

A patient’s treatment plan. Protocols are not patient specific.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

In addition to protocols the PRL master file also contains what records?

A

Smart Set / Order Set and Therapy plan records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

True/False: Treatment Plan Cycles represent a specific ‘course’ of treatment. Cycle lengths and the number of days are the same for every plan.

A

False. Cycles can vary in length and number of days.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You can manually associate patient encounters and Problems (diagnoses) to an episode in what activity?

A

Episodes of Care activity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Staging a cancer involves what?

A

Identifying the location, size and extent of metastasis of the tumor to determine the most appropriate treatment for the patient.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

True/False: To stage a patient’s cancer a cancer diagnosis must be added to the Problem List?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

‘T’, ‘N’, and ‘M’ stand for what when staging a cancer?

A
T = Primary Tumor size in mm
N = How involved are the nearby lymph nodes
M = Distant metastasis
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What action starts the Treatment Day?

A

Releasing orders

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

True/False: A Treatment Day equals a Calendar Day

A

False. In the Inpatient setting a planned treatment day can span more than one calendar days. You ‘complete’ a day you are really completing the planned treatment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What actions advance the plan?

A

Completing a Day
Cancelling
Deferring
Marking that treatment was given somewhere else

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A treatment plan order (OTP) record is also known as…

A

an Order Template Record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

A treatment plan order is a container for…

A

A single medication that will be administered,
or a single procedure that will be performed,
on a given day of treatment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Describe the difference between an OTP record and an ORD record.

A

Order template records provide the treatment plan context from which an order is generated. Order template records are ‘place-holders’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Orders can be deleted from the treatment plan at any of four levels. They are…

A

Individual Orders (allows propagation)
Order category (allows propagation)
Treatment day
Treatment Cycle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

True/False: You can delete orders that are signed.

A

True. You cannot delete orders that have been released. Those must be discontinued.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

True/False: Treatment days and Treatment cycles can exist on their own, without any orders.

A

True. It is best practice to delete the entire day or cycle if you are going to remove all the orders from it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

True/False: When you change an order and click Accept you are prompted to propagate your change to other instances of the same order.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What activity would you use to change a chemotherapy dose by a percentage?

A

Dose Modification. It can be a percentage of either the original dose or the current dose.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

OTP Master File holds…

A

Patient Order Templates, each a container, holding a single medication that will be administered, or a single procedure that will be performed, on a given day of treatment.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

LINE in the EPISODE_LINK table represents

A

patient encounters linked to the episode

26
Q

LINE in the PAT_EPISODE table

A

patient episode (useful when the episode does not have encounters yet)

27
Q

LINE in the EPI_PROBLEM_LIST table

A

each problem associated with the episode

28
Q

What column(s) in the PROBLEM_LIST table can you use to determine if a diagnosis is chronic?

A
PROBLEM_LIST.CHRONIC_YN = Y
CLASS_OF_PROBLEM_C = 2 //Chronic 1-Acute, 3-Minor, 5-Stage I, 8-End Stage
29
Q

Which table/column combinations can you use to display the ICD codes associated with a patient’s problem list diagnosis?

A

CLARITY_EDG.CURRENT_ICD9_LIST

CLARITY_EDG.CURRENT_ICD10_LIST

30
Q

True/False: Every row in STG_INFO will have a value in the STAGE_CONV_SRC_ID column?

A

False. Only stages that were created via conversion will have a value in this column.

31
Q

True/False: If you have stage records in both the ‘old’ data structure (pre-Epic 2014 conversion) and the ‘new’ data structure (Epic 2014 +) you need to manually combine the two data sets together to report on all stages.

A

False. V_CANCER_STAGING table combines the two data sets for you.

32
Q

Under what circumstances is STAGE_EPT_ENC_CSN in table STG_CONTACT_INFO null?

A

If the user edited the stage outside of an encounter context (i.e. in the Chart workspace).

33
Q

True/False: CL_PRL_SS and CL_PRL_SS_OT contain patient-specific treatment information.

A

False. Protocol PRL records and their associated tables don’t contain any patient specific info.

34
Q

Which table could you use to determine all plans associated with a patient’s episode?

A

HSB_TPL_LIST

35
Q

List the four levels of the treatment plan structure starting from the least specific.

A

Cycle, Day, Order Category, Order

36
Q

Why would you compare protocols to patient treatment plans?

A

To understand how clinicians are using and modifying them.

37
Q

Name three things that are contained in a treatment plan.

A

The Goal for the treatment
Information needed for dosing
The provider managing the patient’s plan

38
Q

When you change an order, Foundation is configured to match on what order details?

A

dose, route, and category

39
Q

Explain the difference between TPL_TX_DAYS.TX_PLANNED_DT and TPL_TX_DAYS.TREATMENT_DATE.

A

Planned date is the date originally laid out, Treatment date is the date stored when a day’s status is changed.

40
Q

How might you report on orders contained in TRG_BLOCK_INFO and TRG_DEL_BLOCK_INFO in one query?

A

Use UNION to combine the tables.

41
Q

True/False: All orders deleted from a plan will be contained in TRG_DEL_BLOCK_INFO.

A

False. Only orders deleted individually will show up in this table. If a cycle or day is deleted in total, those orders will not be in this table.

42
Q

Which tables do you need to get from the OTP_INFO table back to the PATIENT table?

A
PATIENT
*TPL_HSB_EPT_LINK*
TPL_INFO
TPL_CYCLES
TPL_TXDAYS
TRG_BLOCK_INFO
OTP_INFO
43
Q

Which column do you use in OTP_INFO to get the ERX associated with the order template? To get to EAP?

A

OTP_INFO.MED_ID (ERX)

OTP_INFO.PROC_ID (EAP)

44
Q

True/False: Medication order templates do not appear in the OTP_DOSE_CHANGE table unless the original dose is modified.

A

False. The initial instance is listed too.

45
Q

The process of creating new child orders from a parent order is called…

A

Instantiating an order, also ‘dropping child orders into the system’

46
Q

True/False: Any procedure order placed during a hospital encounter is considered a standing order.

A

True

47
Q

True/False: All child orders are created when the parent inpatient procedure order is released.

A

False

48
Q

True/False: Future and Standing Parent orders are never actually acted upon or resulted.

A

True

49
Q

True/False: Only child orders will have results.

A

True

50
Q

Results for procedure orders are generally populated in the system in one of three ways.

A

An incoming results interface
By Beaker
By using the Enter/Edit Results activity

51
Q

Which table and column provides a link from order (ORD) record to treatment plan order template (OTP) record?

A

ORDER_PRFLST_TRK.ORDER_TEMPLATE_ID

52
Q

How can you differentiate between a future, normal, parent, and child record in ORDER_PROC?

A

Future = FUTURE_OR_STANDING = F
Standing = FUTURE_OR_STANDING = S
Normal = FUTURE_OR_STANDING is null
INSTANTIATED_TIME is null
Child = FUTURE_OR_STANDING is null
INSTANTIATED_TIME is populated

53
Q

Is it possible for a lab order to have more than one component? Is it possible for a component to have more than one result? Do you need a filter to get the most recent result?

A

Yes, some labs have many components.
Yes, components
No filter necessary, only the most recent result for each component is extracted.

54
Q

What is the difference between ORDER_RESULTS.LAB_STATUS_C and RESULT_STATUS_C?

A

LAB_STATUS_C is for all the components in the test. RESULT_STATUS_C holds the result for each component.

55
Q

Grandparent Orders are created how?

A

When an Outpatient Standing Order is released into an Inpatient/HOV setting.

56
Q

Which is more granular PAT_LIFEDOSE or PAT_LIFEDOSE_HX?

A

PAT_LIFEDOSE_HX provides individual dosing history

57
Q

True/False: If multiple administrations occur for the same order, there is an entry in PAT_LIFEDOSE_HX for each of the administrations.

A

True

58
Q

What is the difference between TAKEN_TIME, SCHEDULED_TIME, and SAVED_TIME?

A

SCHEDULED_TIME the scheduled time on the MAR.
TAKEN_TIME the user specified time
SAVED_TIME the time they clicked ‘accept’

59
Q

What is the purpose of the SEC_USER_ID field?

A

If dual signoff is required for the medication it holds the verifying User’s ID.

60
Q

You are creating a report of medications administered on a particular day. How can you display which medication is being administered?

A

MAR_ADMIN_INFO.ORDER_MED_ID to ORDER_MED.ORDER_MED_ID.

61
Q

Will the column ORDER_MED_ID always be populated with a chemotherapy order for rows of PAT_LIFEDOSE_HX?

A

No, externally administered chemotherapy will not contain a value in the ORDER_MED_ID column.

62
Q

How would you determine a patient’s lifetime cumulative dosage of doxorubicin?

A

Check PAT_LIFEDOSE.SIMP_DOSE_AMT where the CHEMICAL_C is equal to your system’s configured chemical for ‘Doxorubicin’.