HMT_PPN_AT

Description:

This table contains information stored in the Health Maintenance Postpone audit trail.

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	HMT_PPN_TOPIC_ID	NUMERIC	No
	The unique ID of the health maintenance topic that is postponed.
4	HMT_PPN_TOPIC_ID_NAME	VARCHAR	No
	The name of the health maintenance topic.
5	HMT_PPN_USR_ID	VARCHAR	No
	The unique ID of the user that postponed a health maintenance topic.
6	HMT_PPN_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	HMT_PPN_DTTM	DATETIME (Local)	No
	The instant at which a health maintenance topic was postponed.
8	HMT_PPN_UNTL_AT_DT	DATETIME	No
	The date until which a health maintenance topic is postponed.
9	HMT_PPN_RSN_AT_C_NAME	VARCHAR	No
	The postpone reason category number for the health maintenance topic which was postponed. May contain organization-specific values: Yes
10	HM_PPN_CMT_AT	VARCHAR	No
	This item stores a free-text comment associated with a Health Maintenance postponement.