Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

My CLR110 Clarity Data Model Fundamentals > Mapping Chronicles Relationships in Clarity > Flashcards

Mapping Chronicles Relationships in Clarity Flashcards

1
Q

What Chronicles item characteristics allow multiple values to be stored for a single record?

A

Add type and response type

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

What is the add type and Response Type of Patient ID EPT .1?

A

No-Add, Single

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

What is the add type and Response Type of Patient ID EPT .2?

A

No-add Single

-May 2022, 4.6

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

What is the add type and Response Type of Patient Registries EPT 23400

A

No-Add Multiple

Research using Item Editor in Classic

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

What is the add type and Response Type of Patient Class EPT 10110

A

Overtime Single

Research using Item Editor in Classic

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

What is the add type and Response Type of Hospital Admission Date EPT 18850?

A

Overtime Single

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

What is the add type and Response Type of Attending Providers EPT 18864?

A

Overtime Multiple

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

All data in a single extracted table in Clarity typically come from the same Chronicles ____________

A. Add Type
B. Response Type
C. Master File
D. Separate

A

C. Master file

-May 2022, 4.12

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

Define the cardinality of a relationship

A

It describes the numerical relationship between entities in two tables

-May 2022, 4.14

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

If an item’s add type is no add and response type is single, what element will be present in theprimary key of the table that extracts the item?A. Record IDB. A Contact Identifier such as CSNC. Line

A

A. If an item’s add type is no add and response type is single then the primary key of the table willinclude the Record ID

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

What value is stored in a networked item?a. The .2 of a Chronicles record the nameb. The .1 of a Chronicles record or the CSN of a contact on a Chronicles recordc. the address of the pointer for the value

A

b. The .1 of a Chronicles record or the CSN of a contact on a Chronicles record

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

You have a patient query and would like to display the name of the patients’ providers: Admitting Provider is a networked item that points to the SER master file. How can you use Column Search help display the name of the admitting provider?

A

Use Column Search on I EPT 18867 to find the foreign key column in the starting table. You can also use Column Search on I SER .2 to find the table that stores provider names. Use the foreign key of the starting table to join to the primary key of the destination table

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

T or F Would it be possible to have more than one copy of the same table in one report?Why or why not?

A

True; Because Chronicles master files can reference each other multiple times, there are multipleways to link Clarity tables together

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

If an item’s response type is multiple, what element will be present in the primary key of the table that extracts the item?

A. Record ID
B. CSN
C. LINE
D. CDR

A

C . Line

-May 2022, 4.8

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

Why is it good practice to conduct research in Chronicles?

A

Report requesters may only be able to provide a workflow or a field in Hyperspace. In Chronicles youcan open the Record Viewer and validate the data in the source and explore links between the datapoints. The most reliable way to find the Clarity column that reflects the data point is to use theinformation stored in the Clarity Compass. Understanding how the data is structured in Chronicleswill allow you to better understand the structure of Clarity

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

Which database was built to easily store and retrieve small amounts of information across many topics at once?

A

Clarity. This emphasis is also reflected in the structure of the database, where each row in a table represents a different entity.(Aug. 2021, 4.5)

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

Which Epic database was designed to easily store and retrieve large amounts of information about one entity at a time?

A

Chronicles.For instance, fetching all the data about one patient, or one account, or one provider, or one user, etc.(Aug. 2021, 4.5)

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

What are the two main principles for constructing tables in the Clarity database?

A
  1. Minimize redundant data2. Maintain consistent granularity(Aug. 2021, 4.5)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

In the EPT master file, what do contacts represent?

A

Different patient encounters (one row per encounter)

(Aug. 2021, 4.6)

20
Q

How does Clarity minimize data redundancy while maintaining granularity?

A

By mapping a single Chronicles master file to multiple Clarity tables.(Aug. 2021, 4.6)

21
Q

What are two Chronicles item characteristics that are particularly important for Clarity queries?

A
  1. Add Type2. Response Type(Aug. 2021, 4.6)
22
Q

What Chronicles item stores the internal identifier?

A

The .1 item on the record. Also known as the record ID.The value stored in the .1 is unique across all records in that master file.(Aug. 2021, 4.7)

23
Q

What are the two possible identifiers for contacts in Epic?

A
  1. Contact Serial Number (CSN)2. Contact Date Real (CDR)(Aug. 2021, 4.7)
24
Q

Define Contact Serial Number (CSN)?

A

A serial number that is unique for all contacts within that master file.(Aug. 2021, 4.7)

25
Q

Define Contact Date Real (CDR)?

A

A date in Epic’s internal format, followed by two decimal places that start at .00 and increment for each additional contact on the same data. It is the number of days since 12/31/1840 followed by a two-digit decimal that identifies multiple contacts on the same date.

-May 2022, 4.7

26
Q

Does the meaning of contact differ between master files?

A

Yes.(Aug. 2021, 4.8)

27
Q

Can you assume that one master file has the same structure as another?

A

No.

-May 2022, 4.8

28
Q

What two categories do master files generally fall into?

A
  1. Static2. Dynamic(Aug. 2021, 4.8)
29
Q

Define static master files.

A

Static master files:1. Typically contain build records (departments, medications, and providers)2. Build records can be created before documenting care for a patientIn general, the meaning of a contact within a static master file is an update.For example, when Dr. Walt Whitecoat updates his primary department from EHS Clinic to EMC Family Medicine, his SER provider record will store this change on a new contact.(Aug. 2021, 4.8)

30
Q

Define dynamic master files.

A

Records in dynamic master files are generally created as part of a workflow. For example, when Dr. Whitecoat places an order for a patient, this will create a new record in the ORD master file. (Aug. 2021, 4.8)

31
Q

What should you consider when setting the granularity of your report?

A

Consider what the meaning of one row in your results.(Aug. 2021, 4.14)

32
Q

In the FROM clause, does the order of the tables affect the granularity of your results?

A

Yes. Starting the join with the most granular table will maintain consistent granularity with each subsequent join.(Aug. 2021, 4.14)

33
Q

In Chronicles, multiple response and related group items have a line number. What does that line number do?

A

The line number distinguishes one entry from another within a single item. Clarity tables extract this number to a LINE column, which becomes part of the primary key.

-May 2022, 4.8

34
Q

What level of granularity should you start your query with?

A

The most granular level a.k.a. the lowest level of granularity

-May 2022, 4.14

35
Q

What do networked items in Chronicles define?

A

• Networked items define relationships between master files• One master file will store the .1 or the CSN of another master fileRelationships between an item in one master file and a Chronicles record or contact in another.(Aug. 2021, 4.22)

36
Q

What do networked items store?

A

The ID of a Chronicles record or contact.(Aug. 2021, 4.22)

37
Q

Do networked items always point to the same master file?

A

Yes.Although there are many potential links between two master files, a single networked item will always point to the same master file.(Aug. 2021, 4.23)

38
Q

What are three ways to find the INI that a networked item points to?

A
  1. From the Item Information Window by way of a field in Hyperspace2. From the Record Viewer3. From the Item Editor(Aug. 2021, 4.23)
39
Q

Are networked items more likely to point to a contact or a record?

A

Most networked items point to records. However, some networked items point directly to a contact within a record.(Aug. 2021, 4.23)

40
Q

What is the best tool for exploring networked relationships?

A

The Record Viewer.(Aug. 2021, 4.23)

41
Q

Does a networked item or a category item store a value from a list?

A

They both do.• A NETWORKED item points to an ID or contact within a master file. This record or contact can store a wide variety of information depending on the master file. • A CATEGORY item points to a value in a category list. This category list contains little information other than the category value and name.(Aug. 2021, 4.27)

42
Q

What does a networked item point to?

A

A record ID or contact within a master file.(Aug. 2021, 4.27)

43
Q

What does a category item point to?

A

A value in a category list.(Aug. 2021, 4.27)

44
Q

What value is stored in a networked item?

A

• Record = .1 (Record ID)• Contact = CSN (Contact Serial Number)(Aug. 2021, 4.40)

45
Q

What is the most reliable way to find the Clarity column that holds the data point you want in your report?

A

The Clarity Compass.• Column Search• Database Object Search(Aug. 2021, 4.40)

My CLR110 Clarity Data Model Fundamentals (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions