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 - Zero State
Indirect - Diagnosis
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.