Multiple lines inside an item represent multiple values that are stored in a single item, such as several diagnoses or several phone numbers. Each value occupies a numbered line, and the item is then described as having a multiple response or, when linked with other items, a related group response. The second option is correct. SQL statements for Clarity queries are not related to lines. Master file indexes are a different feature, supporting efficient searching. Row-based permissions in Chronicles are a security concept and are not represented by lines. The concept has a direct effect on Clarity, where the items of this kind are extracted to tables whose primary key includes LINE, so that each value has its own row. An analyst who joins such a table to a table with one row per record or contact will obtain several rows for each parent, and this must be taken into account when counting entities. In the Record Viewer, the lines of an item can be seen as numbered rows beneath the item, which helps in confirming what is stored.
[Reference: Cogito Fundamentals – Epic Data Architecture: Lines in Items, ===============, ]
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