SQL Table - RADplus_client_alerts
Storage table for client alerts assigned in the Client Alerts form.
| Table Column | Comment |
| FACILITY | Associated facility. |
| PATID | Client ID. |
| SYSTEM_ALERT_ID | System-defined alert ID. |
| system_alert_desc | System-defined alert ID value. |
| USER_ALERT_ID | User-defined alert ID. |
| user_alert_desc | User-defined alert value. |
| active_range_code | Active, or active for date range code. |
| active_range_value | Active, or active for date range value. |
| alert_type_code | U (user-defined alert type), S (system-defined), CE (custom error), CW (custom warning). |
| alert_type_value | Alert type values. |
| applicable_opts_code | ‘&’ form ID codes (Applicable Forms field). |
| applicable_opts_value | ‘&’ form ID values (Applicable Forms field). |
| custom_message | Custom Message field text. |
| data_entry_by_login | Login username. |
| data_entry_by_option | Form username. |
| data_entry_date | System date. |
| data_entry_time | System time. |
| disabled_code | Code associated with Disabled field. |
| disabled_value | Value associated with Disabled field. |
| end_date | End Date field date. |
| Option_Desc | Form description (RADplusClient_100). |
| Option_Id | Form ID. |
| selected_episodes | ‘&’ delimited list (Episode(s) field). |
| start_date | Date (Start Date field). |
| unique_ID | Client alert row ID. |
| ID |
|
| data_entry_user_id |
|
| data_entry_user_name |
|