SERIES_LOG_INFO
Description:
Table to store the audit log information for questionnaire series answer records. The audit log contains data such as the last update instant, date, action, questionnaire ID, User (EMP) ID, Patient Access Account (WPR) ID and reason why tickler notification was not queued.

Primary Key
Column Name Ordinal Position
SERIES_ANS_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SERIES_ANS_ID NUMERIC No
This column stores the unique identifier for the series answer record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 SRS_ACTION_INS_DTTM DATETIME (UTC) No
This column is used to store the instant when there is a update on this record.
4 SRS_ACTION_DATE DATETIME No
This column is used to store the action date for this questionnaire series.
5 SRS_ACTION_C_NAME VARCHAR No
This column is used to store the actions taken for this questionnaire series.
May contain organization-specific values: Yes
Category Entries:
Enable Series - Provider
Enable Series - Reporting Workbench
Enable Series - OPA
Enable Series - UnMerge
Enable Series - Pending
Enable Series - Procedure Pass
Enable Series - Research Automatic Assignment
Enable Series - Research Activity Assignment
Disable Series - Provider
Disable Series - Reporting Workbench
Disable Series - Merge
Disable Series - Contact Mover
Disable Series - Batch Job
Disable Series - Patient Opted Out
Disable Series - Found New Treatment
Disable Series - Procedure Pass
Disable Series - Patient Expired
Disable Series - Research Activity Retraction
Enable Questionnaire
Disable Questionnaire
Notification - Queued
Notification - Not Queued
Notification - Sent
Notification - Not Sent
Completed
6 SRS_ACT_QUESR_ID VARCHAR No
This column is used to store the questionnaire ID for the audit action
7 SRS_ACT_QUESR_ID_FORM_NAME VARCHAR No
The name of the form associated with the questionnaire.
8 SRS_ACT_USER_ID VARCHAR No
This column is used to store who made this action.
9 SRS_ACT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 SRS_ACT_WPR_ID VARCHAR No
This column stores the web portal ID of the user who answered the questionnaire.
11 SRS_NOTIF_FAIL_REASON_C_NAME VARCHAR No
Reason why tickler notification could not be queued.
May contain organization-specific values: No
Category Entries:
No Subscriber
Throttled
Invalid Call
Build Issue
Lock Failed