MYC_MESG_RCP_STAFF

Description: |
This table holds the In Basket Staff Recipients (I WMG 196) item, which is the final staff (EMP) recipients for this Patient Access Message (WMG) record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
MESSAGE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | MESSAGE_ID | VARCHAR | No |
The unique ID used to identify a web based chart system message record.
2 | LINE | INTEGER | No |
The line number used to identify each row of read data associated with an individual web based chart system message record.
3 | IB_STAFF_RECIP_ID | VARCHAR | No |
This stores the user (EMP) ID of the final recipient of this message.
4 | IB_STAFF_RECIP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.