ORDER_SIGNED_MED

Description:

This table contains the users, providers, and messages related to medication verbal orders and cosign orders.

Primary Key

Column Name	Ordinal Position
ORDER_MED_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_MED_ID	NUMERIC	No
	The unique orders record ID for the medication order.
2	LINE	INTEGER	No
	The line count for the table.
3	SIGNED_TYPE_C_NAME	VARCHAR	No
	Indicates the type of order signing the row represents. Note: Any type can have cosigner data. May contain organization-specific values: Yes Category Entries: Ordering Cosign Discontinuing Pending Discontinue Edit Delete Continue on Transfer Discontinue on Transfer New on Transfer Unreview on Transfer Holding Unholding Order and Hold Assigning Administration Responsibility Cancel Hold Discontinue on Admission Discontinue on Discharge Sign on Admission Sign on Discharge Modify for Admission Modify for Discharge Modify for Transfer Continue on Admission Continue on Discharge Do Not Order on Admission Do Not Prescribe on Discharge Do Not Order on Transfer Sign on Inter-Facility Transfer Modify for Inter-Facility Transfer Discontinue on Inter-Facility Transfer Continue on Inter-Facility Transfer Do Not Order on Inter-Facility Transfer
4	VERB_COMM_PROV_ID	VARCHAR	No
	The unique provider record ID for the provider communicating the verbal order.
5	VERB_SGNER_USER_ID	VARCHAR	No
	The unique user record ID for the user signing the verbal order.
6	VERB_SGNER_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	VERB_MSGRC_USER_ID	VARCHAR	No
	The unique user record ID for the recipient of the In Basket message for the verbal order.
8	VERB_MSGRC_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	VERB_MSG_ID	VARCHAR	No
	The unique In Basket message record ID of the In Basket message created by the verbal order.
10	VERB_SIGNED_TIME	DATETIME (Local)	No
	The date and time the verbal order was signed.
11	VERBAL_MODE_C_NAME	VARCHAR	No
	The mode associated with the verbal order. May contain organization-specific values: Yes Category Entries: Verbal Standard
12	ORDER_PROV_ID	VARCHAR	No
	The unique provider record ID for the ordering provider.
13	AUTH_PROV_ID	VARCHAR	No
	The unique provider record ID for the authorizing provider.
14	CSGN_MSGRC_USER_ID	VARCHAR	No
	The unique user record ID for the recipient of the cosigned In Basket message.
15	CSGN_MSGRC_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
16	CSGN_MSG_ID	VARCHAR	No
	The unique In Basket message record ID of the cosigned In Basket message.
17	CSGN_SIGNED_TIME	DATETIME (Local)	No
	The date and time the order was cosigned.
18	COSIGNER_ID	VARCHAR	No
	The unique user record ID for the order cosigner.
19	COSIGNER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
20	IS_HOSPITALIST_YN	VARCHAR	No
	Indicates if the order was by a hospitalist. May contain organization-specific values: No Category Entries: Yes No
21	VERB_ORD_CMT	VARCHAR	No
	Verbal order comment.
22	CSGN_CREATE_DTTM	DATETIME (UTC)	No
	When the cosign requirement was created (UTC Time).
23	CSGN_RQRD_C_NAME	VARCHAR	No
	This item stores whether or not an order requires a cosign based on when a new line is added to the verbal order category type (I ORD 34800). May contain organization-specific values: No Category Entries: Yes No Administratively Closed
24	SIG_REQ_CRT_USER_ID	VARCHAR	No
	If the order signature requirement was manually created, this item stores the ID of the user who created the requirement.
25	SIG_REQ_CRT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
26	SIG_REQ_CRT_SRC_C_NAME	VARCHAR	No
	This item stores the creation source for order signature requirements. May contain organization-specific values: No Category Entries: Automatically Created HIM Create Signature Requirement Utility Patient Creator Utility Bulk Orders Utility Beacon Inactive User Attached to Ordering Provider Instant Orders Cosign Checkbox Cosign Rule LQL Profile Setting 8535 - Admission Orders Profile Setting 8536 - Code Status Orders Profile Setting 38800 - RW Bulk Orders Home Health Code Status Order Anesthesia Sedation Order Radiant Change Order LPP Low Acuity Order Cadence Decision Tree Security EC36 - Rx Non-controlled Security EC37 - Rx Controlled w/o C-II Security EC90 - OP Procedures Security EC104 - Rx Schedule II Security EC235 - IP Non-controlled Security EC236 - IP Controlled w/o C-II Security EC237 - IP Schedule II Security EC238 - IP Procedure Security EC282 - DC Med