OTP_INFO

Description: |
This table stores basic information about a treatment plan order, such as its status, display name, which medication or procedure it represents, etc.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
OTP_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | OTP_ID | NUMERIC | No |
The unique identifier for the patient order template record.
2 | ORDER_TYPE_C_NAME | VARCHAR | No |
The order type of the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Medications
3 | PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
4 | ORDER_DESC | VARCHAR | No |
The description of the order linked to the order template in this row.
5 | DISPLAY_NAME | VARCHAR | No |
The display name of the order template in this row.
6 | PRESEL_DISPLAY_NAME | VARCHAR | No |
The pre-selection display name for the order template in this row.
7 | ORDER_CLASS_C_NAME | VARCHAR | No |
The order class of the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Normal
8 | RESULTING_AGENCY_ID | NUMERIC | No |
The resulting agency ID of the order template in this row.
9 | RESULTING_AGENCY_ID_LLB_NAME | VARCHAR | No |
Interface laboratory name.
10 | OTP_STATUS_C_NAME | VARCHAR | No |
The status of the order template in this row. May be empty, or In Process (being released), or Converted (actually released).
May contain organization-specific values: No
Category Entries:
In Process
Converted
Released for scheduling
11 | PRIORITY_C_NAME | VARCHAR | No |
The priority of the order template in this row.
May contain organization-specific values: Yes
12 | ORDERING_QUANTITY | NUMERIC | No |
The ordering quantity of the order template in this row.
13 | DX_FOLLOW_UP_C_NAME | VARCHAR | No |
The diagnostic followup of the order template in this row.
May contain organization-specific values: Yes
14 | CHECK_OUT_COMMENT | VARCHAR | No |
The check-out comments for the order template in this row.
15 | SPECIMEN_TYPE_C_NAME | VARCHAR | No |
The specimen type for the order template in this row.
May contain organization-specific values: Yes
16 | SPECIMEN_SOURCE_C_NAME | VARCHAR | No |
The specimen source for the order template in this row.
May contain organization-specific values: Yes
17 | ORD_SIGN_CONTEXT_C_NAME | VARCHAR | No |
The context of revalidation for the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Login
Other Encounters
Exam Room
Charting
Med Orders - Ambulatory and Inpatient
Addendum
Immunization
History
Procedure Orders - Ambulatory and Inpatient
Change Assoc DX
SmartSets
Meds except for reorders
Orders through Addendum
Mark letter as Sent
Cosign Orders
Sign Verbal Orders
Documentation Flowsheet
Discharge Writer
Notes
Discontinue/Cancel Order
Change Order Status from Report
Med Orders - Ambulatory
Procedure Orders - Ambulatory
Med Orders - Inpatient
Procedure Orders - Inpatient
RxRefill Request - In Basket Message (RAR)
Medication Administration
Pharmacy Enter Verification
Pharmacy Per Order Verification
E-Prescribing Pharmacy - Ambulatory
Medication Order Edit
Change Challenge Answers
Med Orders - Controlled
Pharmacy Controlled Med Verification
Pharmacy Dispense Checking
Pharmacy Compounding and Repackaging
Anesthesia User Verification
Medication Review Verification
Pharmacy Dispense Preparation
Imaging Study
Pre-Login Status Board Case Tracking
E-Prescribing Controlled Medications - First Context
E-Prescribing Controlled Medications - Second Context
Break-the-Glass
Home Care Add New Medication
Home Care Edit Medication Sig
Home Care Discontinue Medication
Rover Medication Administration
Ambulatory Pharmacy Prescription Actions
Remote Client Login
PDC Signoff
Pharmacy Intervention
Pharmacy Dispense Tracking
Minimum Data Set Signatures
Cosign Medication Orders
Cosign Procedure Orders
Sign Verbal Medications
Sign Verbal Procedures
Rover Feedings Administration
IRF Patient Assessment Instrument
Infertility Open Anonymous Chart
Standalone Staff Badge Scan
Specialty Narrator Staff Badge Scan
Chart Abstraction
Plan of Care Signatures
Enroll in Native Two Factor Authentication
PDC Waste Signoff
BMT Plan Verification
Dental Sign-Off
Rover Work List Authentication
Therapy Plan Review
Beacon Verbally Remove Orders
Beacon Sign Stage
Beacon Cancel or Defer Day
Cancel Order Reconciliation
Anesthesia Narcotic Reconciliation First User Verification
Anesthesia Narcotic Reconciliation Second User Verification
OpTime Timeout Verification
Lab QC Report Signature
Fertility Embryology Documentation Finalize
Med Orders - Outpatient Controlled
Med Orders - Inpatient Controlled
MyChart Administrator Login
Fertility Embryology Personnel Authentication
OpTime Trigger Charges Verification
OpTime Scheduling Override Authentication
MyChart Elevated Session
Chart Cosign
Inventory Sign Off
Lab Verification
User Passive Authentication
Identity Chart Correction
User Provisioning and Access Activities
CDA Password Verification
Authentication into Third Party
E-Signature Authentication
Willow Ambulatory Login
Ambulatory Pharmacy Security Point Actions (Login User Missing Security)
Ambulatory Pharmacy Security Point Actions
Ambulatory Pharmacy Point Of Sale Workflow Resumption
Stork Delivery Summary Sign
Clarity Console Login
2FA Verification
Specialty Narrator Staff Sign-off
Default User
PATIENT 1
PATIENT 2
PATIENT 3
PATIENT 4
PATIENT 5
PATIENT 6
PATIENT 7
PATIENT 8
PATIENT 9
Kiosk Identification
Kiosk Verification
Hyperspace Identification
Hyperspace Verification
Hyperspace Passive Identification
Hyperspace On-Demand Identification
Hyperspace Enrollment
Kiosk Enrollment
Default Patient
E-Signature (Default)
E-Signature (Full Client)
E-Signature (Thin Client)
Haiku Login
Canto Login
Mobile Close Encounter
Canto SmartSets
Mobile Meds except for reorders
Mobile Cosign Orders
Mobile Sign Verbal Orders
Mobile Notes
Mobile Discontinue/Cancel Order
Mobile Med Orders - Ambulatory
Mobile Procedure Orders - Ambulatory
Mobile Med Orders - Inpatient
Mobile Procedure Orders - Inpatient
Mobile IP Discontinue Medication
Mobile IP Discontinue Procedure
Mobile Med Orders - Controlled
Mobile OP Discontinue Medication
Mobile Cosign Medication Orders
Mobile Cosign Procedure Orders
Mobile Sign Verbal Medications
Mobile Sign Verbal Procedures
Mobile Med Orders - Outpatient Controlled
Mobile Med Orders - Inpatient Controlled
Mobile E-Prescribing Pharmacy - Ambulatory
Mobile E-Prescribing Controlled Medications - First Context
Mobile E-Prescribing Controlled Medications - Second Context
Mobile Break-the-Glass
Epic Monitor Login
Rover Login
Mobile Change PIN
Mobile Medication Dual Sign
Default Context
EpicCare Link Login
Willow Inventory Second Sign Off
18 | ORDER_ID | NUMERIC | No |
The unique identifier of the order record linked to the order template in this row.
19 | STANDING_ORDER_C_NAME | VARCHAR | No |
The standing status of the order template in this row, for example Standing or Once (Future).
May contain organization-specific values: No
Category Entries:
Standing
Once (Future)
20 | STANDING_EXP_DATE | VARCHAR | No |
The Recurring expiration date of the order template in this row.
21 | FUT_EXPECT_COMP_DT | VARCHAR | No |
The Once (Future) expected completion date of the order template in this row.
22 | FUT_APPROX_DT_YN | VARCHAR | No |
Indicates whether this patient order template has an approximate target date (Pre-May 26: approximate future expected date)
May contain organization-specific values: No
Category Entries:
Approximate
Exact
23 | STAND_INTERVAL | VARCHAR | No |
The Standing/Recurring interval for the order template in this row.
24 | DISCRETE_INTERVAL_C_NAME | VARCHAR | No |
The discrete interval selection for the order template in this row.
May contain organization-specific values: Yes
25 | STAND_OCCUR | NUMERIC | No |
The Standing/Recurring occurrences for the order template in this row.
26 | STAND_ORIG_OCCUR | NUMERIC | No |
The original number of Standing/Recurring occurrences for the order template in this row.
27 | PERFORMING_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
28 | REFG_PROV_ID | VARCHAR | No |
The ID of the referring provider for the order template in this row.
29 | REFG_PROV_ID_REFERRING_PROV_NAM | VARCHAR | No |
The name of the referral source.
30 | SER_ADDRESSID | VARCHAR | No |
Stores the referring provider address ID for referral orders. The format is provider external ID - Address line number. For example, if provider external ID = 123 and Address line = 4, the value would be 123-4. If the referring provider has no address, this will store the provider external ID only.
31 | REFD_TO_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.
32 | REFD_TO_FACILITY_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
33 | REFD_TO_SPECLTY_C_NAME | VARCHAR | No |
The referred-to specialty for the order template in this row.
May contain organization-specific values: Yes
34 | DEPT_REF_TO_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
35 | DEPT_SPEC_REF_TO_C_NAME | VARCHAR | No |
The referred-to department specialty for the order template in this row.
May contain organization-specific values: Yes
36 | RFL_PRIORITY_C_NAME | VARCHAR | No |
The referral priority for the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Routine
Urgent
Emergency
Elective
Two Week Wait
See Details
37 | RFL_TYPE_C_NAME | VARCHAR | No |
The referral type for the order template in this row. This links to ZC_RFL_TYPE.
May contain organization-specific values: Yes
38 | RSN_FOR_RFL_C_NAME | VARCHAR | No |
The reason for referral for the order template in this row.
May contain organization-specific values: Yes
39 | RFL_NUM_VIS | NUMERIC | No |
The referral number of visits for the order template in this row.
40 | RFL_EXPIRE_DT | VARCHAR | No |
The referral expiration date for the order template in this row.
41 | PRN_COMMENT | VARCHAR | No |
The user-entered comments for why the PRN medication should be administered.
42 | MED_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
43 | MED_CONTACT_DAT | NUMERIC | No |
The contact date of the linked medication for the order template in this row.
44 | MED_ROUTE_C_NAME | VARCHAR | No |
The route of the linked medication for the order template in this row.
May contain organization-specific values: Yes
45 | MED_QUANTITY | VARCHAR | No |
The quantity of the linked medication for the order template in this row.
46 | MED_REFILLS | VARCHAR | No |
The refill information for the linked medication for the order template in this row.
47 | MED_DIRECTN_LONG | VARCHAR | No |
The long version of the instructions for the medication linked to the order template in this row.
48 | MED_START_DATE | VARCHAR | No |
The start date of the medication linked to the order template in this row.
49 | START_TIME | DATETIME (Local) | No |
The start time of the medication linked to the order template in this row.
50 | MED_END_TIME | DATETIME (Local) | No |
The end time of the medication linked to the order template in this row.
51 | MED_END_DATE | VARCHAR | No |
The end date of the medication linked to the order template in this row.
52 | DISP_AS_WRITTEN_YN | VARCHAR | No |
The Y/N flag to dispense as written for the medication linked to the order template in this row.
May contain organization-specific values: No
Category Entries:
Yes
No
53 | MED_DFL_DSCR_FRQ_YN | VARCHAR | No |
The Y/N flag to indicate if this order template applied to a patient should default discrete frequency info for after-visit (take-home prescription) orders.
May contain organization-specific values: No
Category Entries:
Yes
No
54 | MED_DFL_DSCR_DOS_YN | VARCHAR | No |
The Y/N flag to indicate if this order template applied to a patient should default discrete dose info for after-visit (take-home prescription) orders.
The category values for this column were already listed for column: MED_DFL_DSCR_FRQ_YN
55 | MED_NF_CODE_C_NAME | VARCHAR | No |
The non-formulary code for the medication linked to the order template in this row.
May contain organization-specific values: Yes
56 | MED_COMMENTS | VARCHAR | No |
The medication comments for the medication linked to the order template in this row.
57 | MED_NUM_OF_DOSES | NUMERIC | No |
The number of doses for the medication linked to the order template in this row.
58 | MED_TYPE_C_NAME | VARCHAR | No |
The type of medication linked to the order template in this row.
May contain organization-specific values: No
Category Entries:
Mixture
TPN
Combination
59 | MODIFIED_MIXTURE_YN | VARCHAR | No |
The Y/N flag for whether the order template in this row is a modified mixture.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
60 | MED_INFUSION_TYPE_C_NAME | VARCHAR | No |
The infusion type for the medication linked to the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Continuous
61 | MED_INFUSION_RATE | VARCHAR | No |
The infusion rate for the medication linked to the order template in this row.
62 | MED_RATE_UNIT_C_NAME | VARCHAR | No |
The units to use with the rate for the medication linked to the order template in this row.
May contain organization-specific values: Yes
Category Entries:
mL
L
mg
g
Units
mmol
mEq
mcg
%
Int'l Units
Million Units
kcal
nanogram
mg PE
milli-units
pg
KBq
MBq
GBq
mcL
mL/min
L/min
mg/min
g/min
Units/min
mmol/min
mEq/min
mcg/min
kJ/min
Int'l Units/min
Million Units/min
kcal/min
nanogram/min
mg PE/min
milli-units/min
pg/min
KBq/min
MBq/min
GBq/min
mcL/min
mL/hr
L/hr
mg/hr
g/hr
Units/hr
mmol/hr
mEq/hr
mcg/hr
kJ/hr
Int'l Units/hr
Million Units/hr
kcal/hr
nanogram/hr
mg PE/hr
milli-units/hr
pg/hr
KBq/hr
MBq/hr
GBq/hr
mcL/hr
mL/day
L/day
mg/day
g/day
Units/day
mmol/day
mEq/day
mcg/day
kJ/day
Int'l Units/day
Million Units/day
kcal/day
nanogram/day
mg PE/day
milli-units/day
pg/day
Inch/day
KBq/day
MBq/day
GBq/day
mcL/day
IR/day
BAU/day
PFU/day
Million PFU/day
Million Int'l Units/day
Kilo Int'l Units/day
EIN/day
Million EIN/day
mL/kg
L/kg
mg/kg
g/kg
Units/kg
mmol/kg
mEq/kg
mcg/kg
kJ/kg
Int'l Units/kg
Million Units/kg
kcal/kg
nanogram/kg
mg PE/kg
milli-units/kg
pg/kg
mg/kg (Actual)
Each/kg
Puff/kg
Package/kg
Drop/kg
Inch/kg
KBq/kg
MBq/kg
GBq/kg
mcL/kg
IR/kg
BAU/kg
Million Int'l Units/kg
mcmol/kg
1e12 Vector Genomes/kg
Vector Genomes/kg
Dose/kg
mcg DFE/kg
Kilo Int'l Units/kg
1e11 Vector Genomes/kg
1e13 Vector Genomes/kg
1e14 Vector Genomes/kg
1e15 Vector Genomes/kg
EIN/kg
IR/min
BAU/min
Million Int'l Units/min
Kilo Int'l Units/min
IR/hr
BAU/hr
Million Int'l Units/hr
Kilo Int'l Units/hr
mL/mL
L/mL
mg/mL
g/mL
Units/mL
mmol/mL
mEq/mL
mcg/mL
kJ/mL
Int'l Units/mL
Million Units/mL
kcal/mL
nanogram/mL
mg PE/mL
milli-units/mL
pg/mL
KBq/mL
MBq/mL
GBq/mL
mcL/mL
IR/mL
BAU/mL
PFU/mL
Million PFU/mL
Million Int'l Units/mL
mcmol/mL
1e12 Vector Genomes/mL
Vector Genomes/mL
Kilo Int'l Units/mL
1e11 Vector Genomes/mL
1e13 Vector Genomes/mL
1e14 Vector Genomes/mL
1e15 Vector Genomes/mL
millicurie/mL
mL/L
L/L
mg/L
g/L
Units/L
mmol/L
mEq/L
mcg/L
kJ/L
Int'l Units/L
Million Units/L
kcal/L
nanogram/L
mg PE/L
milli-units/L
pg/L
KBq/L
MBq/L
GBq/L
mcL/L
IR/L
BAU/L
Million Int'l Units/L
Kilo Int'l Units/L
mL/m2
L/m2
mg/m2
g/m2
Units/m2
mmol/m2
mEq/m2
mcg/m2
kJ/m2
Int'l Units/m2
Million Units/m2
kcal/m2
nanogram/m2
mg PE/m2
milli-units/m2
pg/m2
mg/m2 (Actual)
Each/m2
Puff/m2
Package/m2
Drop/m2
KBq/m2
MBq/m2
GBq/m2
mcL/m2
IR/m2
BAU/m2
Million Int'l Units/m2
mcmol/m2
1e12 Vector Genomes/m2
Vector Genomes/m2
Kilo Int'l Units/m2
1e11 Vector Genomes/m2
1e13 Vector Genomes/m2
1e14 Vector Genomes/m2
1e15 Vector Genomes/m2
mL/1.7m2
L/1.7m2
mg/1.7m2
g/1.7m2
Units/1.7m2
mmol/1.7m2
mEq/1.7m2
mcg/1.7m2
kJ/1.7m2
Int'l Units/1.7m2
Million Units/1.7m2
kcal/1.7m2
nanogram/1.7m2
mg PE/1.7m2
milli-units/1.7m2
pg/1.7m2
Each/1.7m2
KBq/1.7m2
MBq/1.7m2
GBq/1.7m2
mcL/1.7m2
IR/1.7m2
BAU/1.7m2
Million Int'l Units/1.7m2
Kilo Int'l Units/1.7m2
mL/kg (IDL)
L/kg (IDL)
mg/kg (IDL)
g/kg (IDL)
Units/kg (IDL)
mmol/kg (IDL)
mEq/kg (IDL)
mcg/kg (IDL)
Int'l Units/kg (IDL)
Million Units/kg (IDL)
Kcal/kg (IDL)
ng/kg (IDL)
mg PE/kg (IDL)
milli-units/kg (IDL)
pg/kg (IDL)
mg/m2 (IDL)
mL/kg (ADJ)
L/kg (ADJ)
mg/kg (ADJ)
g/kg (ADJ)
Units/kg (ADJ)
mmol/kg (ADJ)
mEq/kg (ADJ)
mcg/kg (ADJ)
Int'l Units/kg (ADJ)
Million Units/kg (ADJ)
Kcal/kg (ADJ)
ng/kg (ADJ)
mg PE/kg (ADJ)
milli-units/kg (ADJ)
pg/kg (ADJ)
mg/m2 (ADJ)
mL/100 mL
L/100 mL
mg/100 mL
g/100 mL
Units/100 mL
mmol/100 mL
mEq/100 mL
mcg/100 mL
kJ/100 mL
Int'l Units/100 mL
Million Units/100 mL
kcal/100 mL
nanogram/100 mL
mg PE/100 mL
milli-units/100 mL
pg/100 mL
KBq/100 mL
MBq/100 mL
GBq/100 mL
mcL/100 mL
IR/100 mL
BAU/100 mL
Million Int'l Units/100 mL
Kilo Int'l Units/100 mL
mL/oz
L/oz
mg/oz
g/oz
Units/oz
mmol/oz
mEq/oz
mcg/oz
kJ/oz
Int'l Units/oz
Million Units/oz
kcal/oz
nanogram/oz
mg PE/oz
milli-units/oz
pg/oz
KBq/oz
MBq/oz
GBq/oz
mcL/oz
IR/oz
BAU/oz
Million Int'l Units/oz
Kilo Int'l Units/oz
mL/kg/min
L/kg/min
mg/kg/min
g/kg/min
Units/kg/min
mmol/kg/min
mEq/kg/min
mcg/kg/min
kJ/kg/min
Int'l Units/kg/min
Million Units/kg/min
kcal/kg/min
nanogram/kg/min
mg PE/kg/min
milli-units/kg/min
pg/kg/min
KBq/kg/min
MBq/kg/min
GBq/kg/min
mcL/kg/min
mL/kg/min (IDL)
L/kg/min (IDL)
mg/kg/min (IDL)
g/kg/min (IDL)
Units/kg/min (IDL)
mmol/kg/min (IDL)
mEq/kg/min (IDL)
mcg/kg/min (IDL)
Int'l Units/kg/min (IDL)
Million Units/kg/min (IDL)
Kcal/kg/min (IDL)
ng/kg/min (IDL)
mg PE/kg/min (IDL)
milli-units/kg/min (IDL)
pg/kg/min (IDL)
mL/kg/min (ADJ)
L/kg/min (ADJ)
mg/kg/min (ADJ)
g/kg/min (ADJ)
Units/kg/min (ADJ)
mmol/kg/min (ADJ)
mEq/kg/min (ADJ)
mcg/kg/min (ADJ)
Int'l Units/kg/min (ADJ)
Million Units/kg/min (ADJ)
Kcal/kg/min (ADJ)
ng/kg/min (ADJ)
mg PE/kg/min (ADJ)
milli-units/kg/min (ADJ)
pg/kg/min (ADJ)
IR/kg/min
BAU/kg/min
Million Int'l Units/kg/min
Kilo Int'l Units/kg/min
mL/m2/min
L/m2/min
mg/m2/min
g/m2/min
Units/m2/min
mmol/m2/min
mEq/m2/min
mcg/m2/min
kJ/m2/min
Int'l Units/m2/min
Million Units/m2/min
kcal/m2/min
nanogram/m2/min
mg PE/m2/min
milli-units/m2/min
pg/m2/min
KBq/m2/min
MBq/m2/min
GBq/m2/min
mcL/m2/min
mL/1.7m2/min
L/1.7m2/min
mg/1.7m2/min
g/1.7m2/min
Units/1.7m2/min
mmol/1.7m2/min
mEq/1.7m2/min
mcg/1.7m2/min
kJ/1.7m2/min
Int'l Units/1.7m2/min
Million Units/1.7m2/min
kcal/1.7m2/min
nanogram/1.7m2/min
mg PE/1.7m2/min
milli-units/1.7m2/min
pg/1.7m2/min
KBq/1.7m2/min
MBq/1.7m2/min
GBq/1.7m2/min
mSv
mGy
mcL/1.7m2/min
mcSv
Sv
µGy
cGy
Gy
mRAD
RAD
mg of pseudoephedrine
mg of ephedrine
IR/m2/min
BAU/m2/min
Million Int'l Units/m2/min
Kilo Int'l Units/m2/min
IR/1.7m2/min
BAU/1.7m2/min
Million Int'l Units/1.7m2/min
Kilo Int'l Units/1.7m2/min
mL/kg/hr
L/kg/hr
mg/kg/hr
g/kg/hr
Units/kg/hr
mmol/kg/hr
mEq/kg/hr
mcg/kg/hr
kJ/kg/hr
Int'l Units/kg/hr
Million Units/kg/hr
kcal/kg/hr
nanogram/kg/hr
mg PE/kg/hr
milli-units/kg/hr
pg/kg/hr
KBq/kg/hr
MBq/kg/hr
GBq/kg/hr
mcL/kg/hr
mL/kg/hr (IDL)
L/kg/hr (IDL)
mg/kg/hr (IDL)
g/kg/hr (IDL)
Units/kg/hr (IDL)
mmol/kg/hr (IDL)
mEq/kg/hr (IDL)
mcg/kg/hr (IDL)
Int'l Units/kg/hr (IDL)
Million Units/kg/hr (IDL)
Kcal/kg/hr (IDL)
ng/kg/hr (IDL)
mg PE/kg/hr (IDL)
milli-units/kg/hr (IDL)
pg/kg/hr (IDL)
mL/kg/hr (ADJ)
L/kg/hr (ADJ)
mg/kg/hr (ADJ)
g/kg/hr (ADJ)
Units/kg/hr (ADJ)
mmol/kg/hr (ADJ)
mEq/kg/hr (ADJ)
mcg/kg/hr (ADJ)
Int'l Units/kg/hr (ADJ)
Million Units/kg/hr (ADJ)
Kcal/kg/hr (ADJ)
ng/kg/hr (ADJ)
mg PE/kg/hr (ADJ)
milli-units/kg/hr (ADJ)
pg/kg/hr (ADJ)
IR/kg/hr
BAU/kg/hr
Million Int'l Units/kg/hr
Kilo Int'l Units/kg/hr
mL/m2/hr
L/m2/hr
mg/m2/hr
g/m2/hr
Units/m2/hr
mmol/m2/hr
mEq/m2/hr
mcg/m2/hr
kJ/m2/hr
Int'l Units/m2/hr
Million Units/m2/hr
kcal/m2/hr
nanogram/m2/hr
mg PE/m2/hr
milli-units/m2/hr
pg/m2/hr
KBq/m2/hr
MBq/m2/hr
GBq/m2/hr
mcL/m2/hr
mL/1.7m2/hr
L/1.7m2/hr
mg/1.7m2/hr
g/1.7m2/hr
Units/1.7m2/hr
mmol/1.7m2/hr
mEq/1.7m2/hr
mcg/1.7m2/hr
kJ/1.7m2/hr
Int'l Units/1.7m2/hr
Million Units/1.7m2/hr
kcal/1.7m2/hr
nanogram/1.7m2/hr
mg PE/1.7m2/hr
milli-units/1.7m2/hr
pg/1.7m2/hr
KBq/1.7m2/hr
MBq/1.7m2/hr
GBq/1.7m2/hr
mcL/1.7m2/hr
IR/1.7m2/hr
BAU/1.7m2/hr
Million Int'l Units/1.7m2/hr
Kilo Int'l Units/1.7m2/hr
IR/m2/hr
BAU/m2/hr
Million Int'l Units/m2/hr
Kilo Int'l Units/m2/hr
mL/kg/day
L/kg/day
mg/kg/day
g/kg/day
Units/kg/day
mmol/kg/day
mEq/kg/day
mcg/kg/day
kJ/kg/day
Int'l Units/kg/day
Million Units/kg/day
kcal/kg/day
nanogram/kg/day
mg PE/kg/day
milli-units/kg/day
pg/kg/day
Inch/kg/day
KBq/kg/day
MBq/kg/day
GBq/kg/day
mL/kg/day (IDL)
L/kg/day (IDL)
mg/kg/day (IDL)
g/kg/day (IDL)
Units/kg/day (IDL)
mmol/kg/day (IDL)
mEq/kg/day (IDL)
mcg/kg/day (IDL)
Int'l Units/kg/day (IDL)
Million Units/kg/day (IDL)
Kcal/kg/day (IDL)
ng/kg/day (IDL)
mg PE/kg/day (IDL)
milli-units/kg/day (IDL)
pg/kg/day (IDL)
mL/kg/day (ADJ)
L/kg/day (ADJ)
mg/kg/day (ADJ)
g/kg/day (ADJ)
Units/kg/day (ADJ)
mmol/kg/day (ADJ)
mEq/kg/day (ADJ)
mcg/kg/day (ADJ)
Int'l Units/kg/day (ADJ)
Million Units/kg/day (ADJ)
Kcal/kg/day (ADJ)
ng/kg/day (ADJ)
mg PE/kg/day (ADJ)
milli-units/kg/day (ADJ)
pg/kg/day (ADJ)
mcL/kg/day
IR/kg/day
BAU/kg/day
Million Int'l Units/kg/day
mL/m2/day
L/m2/day
mg/m2/day
g/m2/day
Units/m2/day
mmol/m2/day
mEq/m2/day
mcg/m2/day
kJ/m2/day
Int'l Units/m2/day
Million Units/m2/day
kcal/m2/day
nanogram/m2/day
mg PE/m2/day
milli-units/m2/day
pg/m2/day
KBq/m2/day
MBq/m2/day
GBq/m2/day
mcL/m2/day
mL/1.7m2/day
L/1.7m2/day
mg/1.7m2/day
g/1.7m2/day
Units/1.7m2/day
mmol/1.7m2/day
mEq/1.7m2/day
mcg/1.7m2/day
kJ/1.7m2/day
Int'l Units/1.7m2/day
Million Units/1.7m2/day
kcal/1.7m2/day
nanogram/1.7m2/day
mg PE/1.7m2/day
milli-units/1.7m2/day
pg/1.7m2/day
KBq/1.7m2/day
MBq/1.7m2/day
GBq/1.7m2/day
mcL/1.7m2/day
mL/oz/day
L/oz/day
mg/oz/day
g/oz/day
Units/oz/day
mmol/oz/day
mEq/oz/day
mcg/oz/day
kJ/oz/day
Int'l Units/oz/day
Million Units/oz/day
kcal/oz/day
nanogram/oz/day
mg PE/oz/day
milli-units/oz/day
pg/oz/day
KBq/oz/day
MBq/oz/day
GBq/oz/day
mcL/oz/day
IR/m2/day
BAU/m2/day
Million Int'l Units/m2/day
Kilo Int'l Units/m2/day
IR/1.7m2/day
BAU/1.7m2/day
Million Int'l Units/1.7m2/day
Kilo Int'l Units/1.7m2/day
IR/oz/day
BAU/oz/day
Million Int'l Units/oz/day
Kilo Int'l Units/oz/day
kJ/30 mL
kcal/30 mL
Gy-cm2
µGy-cm2
mGy-cm2
cGy-cm2
dGy-cm2
µGy-m2
mGy-m2
cGy-m2
dGy-m2
Gy-m2
mRAD-cm2
RAD-cm2
mL/cm2
mg/cm2
mOsmol
each
tablet
capsule
drop
tsp
puff
suppository
spray
Squirt
inch
patch
Act
ampule
Bar
Bottle
Can
Device
enema
Gallon
Inhaler
kit
lb
lozenge
oz
packet
Stick
strip
Tbsp
Tube
vial
Wafer
Container
Syringe
Package
applicator
cm
Applicatorful
Troche
millicurie
Intra Uterine Device
Part
m
Film
Million Cells
Dose
mm
IR
BAU
kg
cm2
Imperial Gallon
kJ
PFU
Piece
Million PFU
Doses/Fill
Cartridge
Thousand Units
Lipoprotein Lipase Releasing Unit
Scoop
Million Int'l Units
mm2
Pump
fluid ounce
Product
Bag
mcmol
1e12 Vector Genomes
Vector Genomes
millicurie/kg
millicurie/m2
millicurie/1.7m2
microcurie
microcurie/kg
microcurie/m2
microcurie/1.7m2
Canister
mcg DFE
Billion Cells
Application
Box
Capful
Inhalation
Lancet
Needle
Pad
Pen
Piece of gum
Ring
Swab
Sachet
Implant
Insert
Pools
Kilo Int'l Units
Kilo Int'l Units/kg/day
1e11 Vector Genomes
1e13 Vector Genomes
1e14 Vector Genomes
1e15 Vector Genomes
Cells
EIN
Million EIN
EIN/kg/day
mGy-cm
cGy-cm
dGy-cm
Gy-cm
mGy-m
cGy-m
dGy-m
Gy-m
Hounsfield Units
mg/mL/min (AUC)
None / Other
63 | MED_INFUSE_DURATION | VARCHAR | No |
The duration for the medication linked to the order template in this row.
64 | MED_DURATION_UNIT_C_NAME | VARCHAR | No |
The units to use with the duration of the medication linked to the order template in this row.
May contain organization-specific values: No
Category Entries:
Minutes
Hours
Days
65 | TPN_SITE_C_NAME | VARCHAR | No |
The infusion site of the medication linked to the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Central
Peripheral
Umbilical
None / Other
66 | MED_VOLUME | VARCHAR | No |
The volume of the medication linked to the order template in this row.
67 | MED_VOLUME_UNIT_C_NAME | VARCHAR | No |
The units to use with the volume of the medication linked to the order template in this row.
The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
68 | CALCULATE_VOLUME_YN | VARCHAR | No |
The Y/N flag for whether or not the volume should be calculated for the medication linked to the order template in this row.
The category values for this column were already listed for column: DISP_AS_WRITTEN_YN
69 | MIXTURE_CONC_C_NAME | VARCHAR | No |
The concentration of a mixture (for fixed ratio mixtures) for the medication linked to the order template in this row.
May contain organization-specific values: Yes
70 | DISCRETE_FREQ_ID | VARCHAR | No |
The discrete frequency for the medication linked to the order template in this row.
71 | DISCRETE_FREQ_ID_FREQ_NAME | VARCHAR | No |
The name of the frequency record.
72 | DISCRETE_DOSE_MIN | VARCHAR | No |
The minimum discrete dose for a medication whose dose was entered as a range, or the discrete dose amount for a medication whose dose was not entered as a range.
73 | DOSE_UNIT_C_NAME | VARCHAR | No |
The dose unit category for the medication linked to the order template in this row.
The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
74 | ORDER_TIME_PRIOR_C_NAME | VARCHAR | No |
The discrete order time priority for the medication linked to the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Now
AM
Today
Tomorrow
Next Draw
75 | ENC_CSN | NUMERIC | No |
The contact serial number (CSN) of the encounter linked to the order template in this row.
76 | ORDER_FREQ | VARCHAR | No |
The frequency of the medication being ordered in this order template.
77 | OTP_TPL_ID | NUMERIC | No |
The ID of the treatment plan that contains this order template.
78 | OTP_TRG_ID | NUMERIC | No |
The ID of the treatment day that contains this order template.
79 | DISCRETE_DOSE_MAX | VARCHAR | No |
The maximum discrete dose for a medication whose dose was entered as a range.
80 | MAX_DOSE | NUMERIC | No |
This column stores the suggested maximum dose amount for the patient order template record.
81 | MAX_DOSE_UNIT_C_NAME | VARCHAR | No |
This column stores the suggested maximum dose unit for the patient order template record.
The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
82 | OVRD_IMS_PROD_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
83 | INDICATION_COMMENTS | VARCHAR | No |
User's comments for the corresponding Indications of Use (stored in OTP_INDICATIONS table)
84 | MED_DISP_QTY | NUMERIC | No |
This item stores the medication dispense quantity when discrete dispense is enabled.
85 | MED_DISP_UNIT_C_NAME | VARCHAR | No |
This item stores the medication dispense unit when discrete dispense is enabled.
The category values for this column were already listed for column: MED_RATE_UNIT_C_NAME
86 | MAX_BSA | NUMERIC | No |
The maximum Body Surface Area (BSA) for an order, if the selected BSA is greater than this BSA than the selected BSA will be capped at this value.