Data dictionary › Audit & logs

EXCHANGE_DEBUG_LOG

Single Population

File
data/EXCHANGE_DEBUG_LOG.csv
Category
patient
Primary key
EXCHANGE_DEBUG_LOG_PK
Columns
11

01Relates to the patient

APPT_ID matches APPOINTMENTS.APPT_ID on a row of APPOINTMENTS that relates to the patient

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1EXCHANGE_DEBUG_LOG_PK PKintegerbigintno
2ACTION_DATETIMEdatetimedatetimeno
3APPT_DATEdatetimedatetimeno
4MODIFIED_DATEdatetimedatetimeno
5PROVIDER_CODEstringvarchar(20)yes
6EVENT_DESCRIPTIONstringvarchar(80)yes
7DURATIONintegerintno
8OFFICE_LOCATIONstringvarchar(20)yes
9APPT_IDintegerintyes
10EXCHANGE_IDstringvarchar(240)no
11EXCHANGE_APPT_TYPEintegerintyes