Audit views
The audit views provide user session related info, showing which user accessed the StoredIQ® for Legal system at what time and from what IP address.
rep_audit_user_session_view (User session audit view)
Each row in this view represents an audit entry corresponding to a user action such as logging into the system or logging out from the StoredIQ for Legal system.
Reference table : appauditusersession
| Column | Attribute Name | Type | Description |
|---|---|---|---|
| loginid | Login ID | character varying(50) | The signin ID of the user. Reference table - persondistinct UI Column - Signin ID |
| ipaddress | IP Address | character varying(45) | IP address of the client machine from where the signin event occurred. Reference table - appauditusersession |
| eventtype | Event Type | character varying(512) | Type of event (signin, signout). Reference table - appauditusersession |
| eventdate | Event Date | timestamp without time zone | Date when the event occurred. Reference table - appauditusersession |
rep_audit_workflow_view (Workflow audit view)
Each row in this view represents an audit entry related to the workflow.
| Column | Attribute Name | Type | Description |
|---|---|---|---|
| id | ID | bigint | Unique identifier for this workflow audit event. Reference table - appauditworkflow |
| creationdate | Creation Date | timestamp without time zone | Creation time stamp for the workflow audit event. Reference table - appauditworkflow |
| modifieddate | Modified Date | timestamp without time zone | Last modified time stamp for the workflow audit event. Reference table - appauditworkflow |
| task_category | Task Category | character varying(255) | Task category. Reference table - appauditworkflow |
| proc_inst_id | Process Instance ID | character varying(64) | Workflow process instance ID. Reference table - appauditworkflow |
|
proc_inst_entity_definition_id
|
Process Instance Entity Definition ID | bigint | Entity definition ID associated with the process instance. Reference table - appauditworkflow |
| proc_inst_matter_id | Process Instance Matter ID | bigint | Matter ID associated with the process instance. Reference table - matter |
| proc_inst_entity_id | Process Instance Entity ID | bigint | Entity ID of the process instance. Reference table - appauditworkflow |
| proc_inst_status | Process Instance Status | character varying(512) | Status of the process instance. Reference table - appauditworkflow |
| actor_id | Actor ID | bigint | Unique identifier representing the initiator of this event. Reference table - appauditworkflow |
| task_type | Task Type | character varying(512) | Task type. Reference table - appauditworkflow |
| proc_def_key | Process Definition Key | character varying(255) | Process definition key. Reference table - appauditworkflow |
| correlation_id | Correlation ID | bigint | Correlation ID. Reference table - appauditworkflow |
| raw_data | Raw Data | character varying(10240) | JSON data containing the details of this audit event. Reference table - appauditworkflow |
| task_assignee_id | Task Assignee ID | bigint | Unique identifier for the task assignee. Reference table - appauditworkflow |
| proc_error | Process Error | character varying(512) | Workflow process error. Reference table - appauditworkflow |
| event_date | Event Date | timestamp without time zone | Time of this event. Reference table - appauditworkflow |
| task_id | Task ID | character varying(64) | Task unique identifier. Reference table - appauditworkflow |
| task_name | Task Name | character varying(255) | Task name. Reference table - appauditworkflow |
| event_type | Event Type | character varying(512) | Type of audit event. Reference table - appauditworkflow |
| proc_def_id | Process Definition ID | character varying(64) | Workflow process definition unique identifier. Reference table - appauditworkflow |
| proc_inst_entity_definition_name | Process Entity Definition Name | character varying(64) |
Entity definition Name associated with the process instance. Reference table - entity_definition |