PAT_TOPIC_HX_DATA

Description:

History of edits to patient 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	WPR_IDENT	INTEGER	No
	Indicates the user involved with the given edit to patient topic data.
4	AGENDA_CODEASSIST_C_NAME	NUMERIC	No
	Indicates the code/workflow involved with the given edit to patient 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 patient topic data.
6	TITLE_CHANGED_YN	VARCHAR	No
	Indicates whether a missing PREVIOUS_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 patient 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 patient description of the topic before the given edit.
10	PRIMARY_PAT_TOPIC_CHANGED_YN	VARCHAR	No
	Indicates whether a missing PREVIOUS_PRIMARY_PAT_TOPIC_YN 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_PRIMARY_PAT_TOPIC_YN	VARCHAR	No
	Was this topic the primary patient topic before the given edit? The category values for this column were already listed for column: TITLE_CHANGED_YN