HM_EDIT_AUD

Description:

The HM_EDIT_AUD table contains audit information for patient-specific health maintenance topic edits. This includes such information as what topic was edited, the editing user, the edits made, and the instant of the edit.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	HM_EDIT_AUD_TPC_ID	NUMERIC	No
	Audit information for patient specific HM edits: the edited topic
4	HM_EDIT_AUD_TPC_ID_NAME	VARCHAR	No
	The name of the health maintenance topic.
5	HM_EDT_AUD_RECOM_ID	NUMERIC	No
	Audit information for patient specific Health Maintenance edits: the recommendation record.
6	HM_EDT_AUD_DUE_DATE	DATETIME	No
	Audit information for patient specific Health Maintenance edits: the specified due date.
7	HM_EDIT_AUD_MSG_ID	VARCHAR	No
	Audit information for patient specific Health Maintenance edits: In Basket message record.
8	HM_EDT_AUD_REC_CSN	INTEGER	No
	Audit information for patient specific HM edits: the recommendation record's CSN