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