Data dictionary › Audit & logs

AUDIT_ACTIVITY

On request

File
data/AUDIT_ACTIVITY.csv
Category
audit
Primary key
AUDIT_ACTIVITY_PK
Columns
11

01Relates to the patient

not linked to a patient

Single-patient export: not included.

02Columns

#ColumnTypeSource typeNullNotes
1AUDIT_ACTIVITY_PK PKintegerbigintno
2USER_TIMESTAMPdatetimesmalldatetimeno
3USER_IDstringvarchar(20)no
4FORM_NAMEstringvarchar(40)no
5PK1stringvarchar(40)yes
6PK2stringvarchar(40)yes
7PK3stringvarchar(40)yes
8OPERATIONstringvarchar(30)no
9FORM_ACCESSstringchar(1)no
10PK4stringvarchar(40)yes
11PK5stringvarchar(40)yes