HSB_MED_SIGN_AUDIT
Description:
Contains the list of all actions taken during the medication sign off process.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique identifier for the Episode.
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 AUD_MED_RVWR_ID VARCHAR No
Contains the ID of the user who took the corresponding action (like signing off on the report) during the medication review process.
4 AUD_MED_RVWR_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 AUD_MED_RVW_STAT_C_NAME VARCHAR No
Contains the action (such as updates sent or sign off received) that took place.
May contain organization-specific values: No
Category Entries:
Message Sent
Sign Off Received
Reviewed - Updates Needed
Retracted - Under Review
Sent Updates
No Signoff Needed
6 AUD_ACTION_INS_DTTM DATETIME (UTC) No
Contains the instant when this action occurred during the medication review process.
7 AUD_MED_RVW_DEV_C_NAME VARCHAR No
Stores the device used when the user signed off on the medications.
May contain organization-specific values: Yes