Data dictionary › Audit & logs

AUDIT_REPORT_ACCESS

On request

File
data/AUDIT_REPORT_ACCESS.csv
Category
audit
Primary key
AUDIT_RPT_ACCESS_PK
Columns
11

01Relates to the patient

not linked to a patient

Single-patient export: not included.

02Columns

#ColumnTypeSource typeNullNotes
1AUDIT_RPT_ACCESS_PK PKintegerbigintno
2USER_TIMESTAMPdatetimedatetimeno
3USER_IDstringvarchar(20)no
4TIMEZONE_BIASintegerintyes
5COMPUTER_NAMEstringvarchar(30)yes
6IP_ADDRESSstringvarchar(50)yes
7FORM_NAMEstringvarchar(40)yes
8REPORT_NAMEstringvarchar(80)yes
9REPORT_SQL_COMMANDstringvarchar(max)yes
10ACCESS_PKintegerintyes
11SESSION_IDintegerintyes