Data dictionary › Encounter forms & clinical notes

EMR_ENCOUNTERS_MENTAL_STATUS

Single Population

File
data/EMR_ENCOUNTERS_MENTAL_STATUS.csv
Category
patient
Primary key
ENCOUNTER_ID
Columns
21

01Relates to the patient

ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1ENCOUNTER_ID PKintegerintno
2APPEARANCEstringvarchar(max)yes
3ORIENTATIONstringvarchar(max)yes
4ALERTNESSstringvarchar(max)yes
5AFFECTstringvarchar(max)yes
6MOODstringvarchar(max)yes
7DRESS_GROOMINGstringvarchar(max)yes
8EYE_CONTACTstringvarchar(max)yes
9SPEECHstringvarchar(max)yes
10RECENT_MEMORYstringvarchar(max)yes
11REMOTE_MEMORYstringvarchar(max)yes
12PSYCHOMOTOR_ACTIVITYstringvarchar(max)yes
13CONCEPTUAL_DISORGANIZATIONstringvarchar(max)yes
14THOUGHT_CONTENTstringvarchar(max)yes
15PERCEPTUAL_FUNCTIONINGstringvarchar(max)yes
16ATTITUDEstringvarchar(max)yes
17INSIGHTstringvarchar(max)yes
18JUDGMENTstringvarchar(max)yes
19ATTENTION_CONCENTRATIONstringvarchar(max)yes
20IMPULSE_CONTROLstringvarchar(max)yes
21MEN_STAT_REVIEWEDbooleanbityes