ORDER_SIGNED_PROC

Description: |
This table contains the users, providers, and messages related to procedure verbal orders and cosign orders.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_PROC_ID | NUMERIC | No |
The unique ID for the procedure order record.
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
Pause on Discharge
Resume from Pause on Discharge
4 | VERB_COMM_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
13 | AUTH_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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 column is 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
27 | SIG_REQ_CRT_ENC | NUMERIC | No |
This item stores the CSN of the patient encounter where a cosign or verbal sign requirement was created. This item is populated when a cosign or verbal signature requirement is generated.