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
Enable Series - Medication Experience
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
Disable Series - Medication Discontinued
Enable Questionnaire
Disable Questionnaire
Notification - Queued
Notification - Not Queued
Notification - Sent
Notification - Not Sent
Conversion - Contact Added
Conversion - HQAs Modified
File Throttled Answers - Procedure Pass
File Preserved Answers - Procedure Pass
Remove Throttled Answers - Procedure Pass
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