SQL Table - RADplus_entity_access
Maintains a record of form and entity access. A table row is inserted when:
-
An active client is selected.
-
The form includes a standard entity lookup screen.
-
A new entity ID is added through an entity file lookup field. Entity access is tracked even when unsuccessful.
-
The user accesses a chart review item.
| Table Column | Comment |
| ID | Unique row ID. |
| FACILITY | Associated facility. |
| ENTITY_ID | Entity ID. |
| access_date | Entity access system date. |
| access_time | Entity access system time. |
| chart_review_item_code | Chart form code. |
| chart_review_item_value | Chart form value. |
| entity_database | Entity database. |
| login_user | Login username. |
| option_code | Form ID. |
| option_description | Form description. |
| option_user | Form username. |