SQL Table - RADplus_post_it_audit
Storage table for the Sticky Note Maintenance form.
Contains Sticky notes purged from the RADplus_post_it table.
| Table Column | Comment |
| ID | Unique row ID. |
| data_entry_by_login | Login username. |
| data_entry_by_option | Form username. |
| data_entry_date | System date. |
| data_entry_user_id |
|
| data_entry_user_name |
|
| deletion_option |
|
| deletion_option_desc |
|
| deletion_user_id |
|
| deletion_user_name |
|
| data_entry_time | System time. |
| deletion_by_login | Sticky note delete login username. |
| deletion_by_option | Sticky note delete form username. |
| deletion_date | System date Sticky note deleted. |
| deletion_reason | Reason for Deletion field text. |
| deletion_time | System time Sticky note deleted. |
| entity_database | Entity database. |
| entity_database_desc | Entity database description. |
| ENTITY_ID | Entity ID. |
| FACILITY | Associated facility. |
| notes | Sticky note text |
| option_desc | Form description. |
| option_id | Form ID. |
| tablename | Form table. |
| table_row_ref | Table row reference. |
| tablerowrefctr | Table row reference counter. |