DENTAL_MOUTH_HX

Description:

This table saves information about the history of a patient's mouth.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique identifier for the finding 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	DENT_BASELINE_YN	VARCHAR	No
	This flag indicates whether the patient's tooth chart was saved as a baseline at a given time. May contain organization-specific values: No Category Entries: No Yes
4	PERIO_EXAM_HX_DATE	DATETIME	No
	This item stores the clinical date of a periodontal exam. By default this will be the encounter date, but users can specify a past date as well.
5	HT_APRV_DTTM_HX_DTTM	DATETIME (Attached)	No
	The history of the date and time when the hard tissue chart was approved.
6	HT_APRV_USER_HX_ID	VARCHAR	No
	The history of the unique ID of the user who approved the hard tissue chart.
7	HT_APRV_USER_HX_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	HT_NEED_APRV_HX_YN	VARCHAR	No
	Indicates whether the hard tissue chart requires approval for this patient and contact. 'Y' indicates that the hard tissue chart needs approval for the patient in the encounter. 'N' and NULL indicate that the hard tissue chart does not need approval. May contain organization-specific values: No Category Entries: Yes No
9	PERIO_APRV_DTTM_HX_DTTM	DATETIME (Attached)	No
	The history of the date and time when the periodontal chart was approved.
10	PERIO_APRV_USER_HX_ID	VARCHAR	No
	The history of the unique ID of the user who approved the periodontal chart.
11	PERIO_APRV_USER_HX_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	PERI_NEED_APRV_HX_YN	VARCHAR	No
	Indicates whether the periodontal chart requires approval for this patient and contact. 'Y' indicates that the periodontal chart needs approval for the patient in the encounter. 'N' and NULL indicate that the periodontal chart does not need approval. The category values for this column were already listed for column: HT_NEED_APRV_HX_YN