SQL Table - RADplus_workflow_history

Last updated
Save as PDF

Storage table for the To Do List form.

Stores to do items after the to do item is completed.

Table Column	Comment
RADplus_workflow_history	Unique row ID. Computed value.
approved_code	Y (approval filed), or N. Value is null if controlling_code equals N.
approved_value	Yes (approval filed), or No. Computed value. Value is null if controlling_code equals N.
controlling_code	Y (controlling type notification). or N.
controlling_value	Yes (controlling type notification). or N. Computed value.
date_sent	Notification send date.
entity_database	Entity database.
entity_database_desc	Entity database description.
ENTITY_ID	Entity ID.
FACILITY	Associated facility.
outgoing_comments	Outgoing comments.
response_comments	Response comments.
response_date	Response send date.
response_required_code	Y (response required), or N.
response_required_value	Yes (response required), or No. Computed value.
response_sent_code	Y (response sent), or N. Value is null if controlling_code equals N.
response_sent_value	Yes (response sent), or No. Computed value. Value is null if controlling_code equals N.
response_time	Response send time.
response_user	Response username.
response_user_desc	Response user description.
review_date	Notification review date.
reviewed_code	Y (notification reviewed), or N. Value is null if controlling_code equals Y.
reviewed_value	Yes (notification reviewed), or No. Computed value. Value is null if controlling_code equals Y.
review_time	Notification reviewed time.
review_user	Reviewed notification username.
required_user_desc	Reviewed notification user description. Computed value.
sending_user_desc	Notification send user description. Computed value.
sending_user	Notification send username.
table_name	Associated table name.
table_row_ref	Table row reference.
time_sent	Notification send time
TODO_ID	To do ID.
user_sent_to	Notification sent to username.
user_sent_to_desc	Notification receiving user name. Computed value.