Brainscape's Knowledge GenomeTM

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


See full index

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

Mapping Chronicles Relationships in Clarity Flashcards

1
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
2
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
3
Q

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

A
  1. Minimize redundant data
  2. Maintain consistent granularity

(Aug. 2021, 4.5)

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

In the EPT master file, what do contacts represent?

A

Different patient encounters (one row per encounter)

Aug. 2021, 4.6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
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)

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

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

A
  1. Add Type
  2. Response Type

(Aug. 2021, 4.6)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
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)

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

Define Contact Serial Number (CSN)?

A

A serial number that is unique for all contacts within that master file.

(Aug. 2021, 4.7)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
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 (from practice test)

(Aug. 2021, 4.7)

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

Does the meaning of contact differ between master files?

A

Yes.

Aug. 2021, 4.8

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

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

A

No.

Aug. 2021, 4.8

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

What two categories do master files generally fall into?

A
  1. Static
  2. Dynamic

(Aug. 2021, 4.8)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
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 patient

In 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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
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

17
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)

18
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.

(Aug. 2021, 4.8-4.9)

19
Q

What level of granularity should you start your query with?

A

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

(Aug. 2021, 4.14)

20
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 file

Relationships between an item in one master file and a Chronicles record or contact in another.

(Aug. 2021, 4.22)

21
Q

What do networked items store?

A

The ID of a Chronicles record or contact.

Aug. 2021, 4.22

22
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)

23
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 Hyperspace
  2. From the Record Viewer
  3. From the Item Editor

(Aug. 2021, 4.23)

24
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)

25
Q

What is the best tool for exploring networked relationships?

A

The Record Viewer.

Aug. 2021, 4.23

26
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)

27
Q

What does a networked item point to?

A

A record ID or contact within a master file.

Aug. 2021, 4.27

28
Q

What does a category item point to?

A

A value in a category list.

Aug. 2021, 4.27

29
Q

What value is stored in a networked item?

A
  • Record = .1 (Record ID)
  • Contact = CSN (Contact Serial Number)

(Aug. 2021, 4.40)

30
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)

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