Data dictionary › Encounter forms & clinical notes

EMR_ENCOUNTERS_ROS_SKIN

Single Population

File
data/EMR_ENCOUNTERS_ROS_SKIN.csv
Category
patient
Primary key
ENCOUNTER_ID
Columns
26

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
2SKN_SUSPECIOUS_LESIONSstringvarchar(max)yes
3SKN_NIGHT_SWEATSstringvarchar(max)yes
4SKN_EXCESSIVE_PERSPIRATIONstringvarchar(max)yes
5SKN_POOR_WOUND_HEALINGstringvarchar(max)yes
6SKN_DRYNESSstringvarchar(max)yes
7SKN_CHANGES_IN_NAIL_BEDSstringvarchar(max)yes
8SKN_ITCHINGstringvarchar(max)yes
9SKN_SKIN_CANCERstringvarchar(max)yes
10SKN_UNUSUAL_HAIR_DISTRIBUTIONstringvarchar(max)yes
11SKN_RASHstringvarchar(max)yes
12SKN_FLUSHINGstringvarchar(max)yes
13SKN_CHANGES_IN_COLOR_OF_SKINstringvarchar(max)yes
14SKN_SUSPECIOUS_LESIONS_COMMENTstringvarchar(max)yes
15SKN_NIGHT_SWEATS_COMMENTstringvarchar(max)yes
16SKN_EXCESSIVE_PERSPIRATION_COMMENTstringvarchar(max)yes
17SKN_POOR_WOUND_HEALING_COMMENTstringvarchar(max)yes
18SKN_DRYNESS_COMMENTstringvarchar(max)yes
19SKN_CHANGES_IN_NAIL_BEDS_COMMENTstringvarchar(max)yes
20SKN_ITCHING_COMMENTstringvarchar(max)yes
21SKN_SKIN_CANCER_COMMENTstringvarchar(max)yes
22SKN_UNUSUAL_HAIR_DISTRIBUTION_COMMENTstringvarchar(max)yes
23SKN_RASH_COMMENTstringvarchar(max)yes
24SKN_FLUSHING_COMMENTstringvarchar(max)yes
25SKN_CHANGES_IN_COLOR_OF_SKIN_COMMENTstringvarchar(max)yes
26ROS_SKIN_REVIEWEDstringvarchar(max)yes