AND ANSWERS GUIDE BOOK.
database object
If you already know the name of the table you're looking for, you can use
____________ search
primary key
Item extracted to one Clarity table all come from the same master file, have the same
add type (no-add or overtime), and have the same response type (single or
multiple/related) The master file, add type, and response type of the items extracted to a
table will dictate the ________of that table.
no add, single response
EPT 60 has an add type of "___________", which means that different values cannot
be stored on different contacts within the record. Its response type is "________", which
means that only one line of data can be stored. Any given
patient record can only have one value for EPT 60. For each unique patient ID, exactly
one city should be stored.
LINE
If a table in Clarity contains information that is multiple response or in a related
group, _________must be part of the primary key.
contact serial number (CSN)
Consider the item EPT 18030 (patient weight). This item is single-response - it stored
only one line of data. However, the patient's weight is different with each patient
encounter. To find a single value for
a patient's weight, you need more than just the patient's ID. You also need a specific
encounter (contact). A _________ is a number that uniquely identifies a single contact
within a master file.
contact date real (CDR)
A __________ is a
date in Epic's internal format, followed by a two decimal places that identify one contact
among many on the same date. Consider a patient with more than one contact on a
single calendar day. Eg. Contact: 6/1/2016, CDR 61148.00 and Contact:6/1/2016, CDR