Data dictionary › Specialty clinical (dental, optical, podiatry, chiro)

PAT_CHIROS

Single Population

File
data/PAT_CHIROS.csv
Category
patient
Primary key
ACCOUNT
Columns
13

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1ACCOUNT PKstringvarchar(12)no
2INITIAL_TREATMENT_DATEdatetimedatetimeyes
3NO_IN_SERIESintegerintyes
4SUBLUXATION_TOPstringvarchar(3)yes
5SUBLUXATION_BOTTOMstringvarchar(3)yes
6TREATMENT_MONTHSintegerintyes
7TREATMENT_YEARSintegerintyes
8TREATMENTS_PER_MONTHintegerintyes
9NATURE_OF_CONDITIONstringchar(1)yes
10DATE_OF_MANIFESTATIONdatetimedatetimeyes
11COMPLICATION_INDICATORstringchar(1)yes
12DATE_OF_LAST_XRAYdatetimedatetimeyes
13LENGTH_OF_SERIESintegerintyes