The primary key of a Clarity table is PAT_ENC_CSN_ID. Which of the following describes the add type and response type of Chronicles data you would expect to be extracted to this table?
Reading the key as two independent signals leads to the answer. The identifier is a contact serial number for an encounter, so the extracted items are stored per contact, which is the overtime behavior; a record-level, no-add table would use the patient or record identifier. The key contains no LINE column, so no item in the table repeats within a contact, which indicates single response. The combination is overtime with single response, and the table holds one row per encounter. This is the structure of PAT_ENC, which the later exhibit describes as an overtime single table containing one row for every encounter. The first two options are excluded by the contact-level identifier. The fourth option is excluded by the absence of LINE, as multiple and related response items would require it for row uniqueness. The final option is a distractor: the pattern is a standard and clearly defined one, so there is no reason to reject all of the alternatives. Keys that depart from these patterns occur in views and derived tables, but the question concerns a table extracted directly from Chronicles items, where the add type and response type determine the key.
[Reference: Cogito Fundamentals – Clarity Data Model: Primary Key Patterns, Add Types and Response Types, ===============, ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit