Data dictionary › Audit & logs

AUDIT_FORM_ACCESS

On request

File
data/AUDIT_FORM_ACCESS.csv
Category
audit
Primary key
AUDIT_FORM_ACCESS_PK
Columns
14

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: not included.

02Columns

#ColumnTypeSource typeNullNotes
1AUDIT_FORM_ACCESS_PK PKintegerbigintno
2USER_TIMESTAMPdatetimedatetimeno
3USER_IDstringvarchar(20)no
4TIMEZONE_BIASintegerintyes
5COMPUTER_NAMEstringvarchar(30)yes
6IP_ADDRESSstringvarchar(50)yes
7FORM_NAMEstringvarchar(40)yes
8FORM_ACCESSstringchar(1)yes
9KEY_FIELD_NAMEstringvarchar(120)yes
10KEY_VALUEstringvarchar(120)yes
11SESSION_IDintegerintyes
12ACCOUNTstringvarchar(12)yes
13ACCESS_APPLICATION_NAMEstringvarchar(100)yes
14ASP_SESSION_IDstringvarchar(50)yes