Data dictionary › OTP / methadone dispensing

MMT_ORDER_REVIEWS

Single Population

File
data/MMT_ORDER_REVIEWS.csv
Category
patient
Primary key
ACCOUNT, EPISODE_CARE_ID, ORDER_ID, REVIEW_DATE
Columns
6

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

  • ORDER_ID, ACCOUNT, EPISODE_CARE_ID → MMT_ORDERS.ORDER_ID, ACCOUNT, EPISODE_CARE_ID
  • USER_ID → USERS.USER_ID

03Columns

#ColumnTypeSource typeNullNotes
1ACCOUNT PKstringvarchar(12)no
2EPISODE_CARE_ID PKintegerintno
3ORDER_ID PKintegerintno
4REVIEW_DATE PKdatetimesmalldatetimeno
5USER_IDstringvarchar(20)no
6COMMENTSstringvarchar(1000)yes