CLINICIAN_TOPIC_HX_DATA

Description: |
History of edits to clinician topic data.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
AGENDA_TOPIC_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | AGENDA_TOPIC_ID | NUMERIC | No |
The unique identifier (.1 item) for the visit agenda topic record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | EMP_IDENT | INTEGER | No |
Indicates the user involved with the given edit to clinician topic data.
4 | AGENDA_CODEASSIST_C_NAME | NUMERIC | No |
Indicates the code/workflow involved with the given edit to clinician topic data.
May contain organization-specific values: No
Category Entries:
Added directly by user
Agent - Dynamic Questions
Agent - Patient to Provider
Agent - Chart-Informed Topics
Indirect - Diagnosis
Cloned From Patient Topic
5 | EDIT_UTC_DTTM | DATETIME (UTC) | No |
Time as a UTC instant for the given edit to clinician topic data.
6 | TITLE_CHANGED_YN | VARCHAR | No |
Indicates whether a missing PREV_TITLE value means "no change" or that it was previously null.
May contain organization-specific values: No
Category Entries:
No
Yes
7 | PREVIOUS_TITLE | VARCHAR | No |
State of the clinician title of the topic before the given edit.
8 | DESCRIPTION_CHANGED_YN | VARCHAR | No |
Indicates whether a missing PREVIOUS_DESCRIPTION value means "no change" or that it was previously null.
The category values for this column were already listed for column: TITLE_CHANGED_YN
9 | PREVIOUS_DESCRIPTION | VARCHAR | No |
State of the clinician description of the topic before the given edit.
10 | CHILD_TOPICS_CHANGED_YN | VARCHAR | No |
Indicates whether a missing PREVIOUS_CHILD_TOPICS_IDENT value means "no change" or that it was previously null
The category values for this column were already listed for column: TITLE_CHANGED_YN
11 | PREVIOUS_CHILD_VAT_IDENT | VARCHAR | No |
State of the child topics of the topic before the given edit.