|
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 |
|
|
|
|
| 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 |
|
|
