OTP_INFO_1
Description:
This table is a continuation of related table OTP_INFO. It stores additional information about a treatment plan order, such as verbal signing information, inpatient medication information, 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 TRANSPORTATION_C_NAME VARCHAR No
The transportation type associated with the order template in this row.
May contain organization-specific values: Yes
3 IP_DISC_INTERVAL_ID VARCHAR No
The discrete interval associated with the order template in this row.
4 IP_DISC_INTERVAL_ID_FREQ_NAME VARCHAR No
The name of the frequency record.
5 IP_STANDING_COUNT NUMERIC No
The standing count associated with the order template in this row.
6 IP_STAND_CNT_TYPE_C_NAME VARCHAR No
The inpatient standing count type (Dose/Days/etc) associated with the order template in this row.
May contain organization-specific values: No
Category Entries:
Days
Weeks
Hours
Occurrences
7 IP_INCLUDE_NOW_C_NAME VARCHAR No
The frequency associated with the order template in this row, for example, "Include Now", "As Scheduled", "At Nurse Discretion."
May contain organization-specific values: No
Category Entries:
Include Now
As Scheduled
At Nurse Discretion
8 SCHED_EXTRA_DOSE_TM DATETIME (Local) No
The time at which to schedule the first occurrence of the associated order template in this row.
9 COST_CENTER_ID NUMERIC No
The unique identifier for the cost center associated with the order template in this row.
10 COST_CENTER_ID_COST_CENTER_NAME VARCHAR No
The name of the cost center.
11 ORDERING_MODE_C_NAME VARCHAR No
The ordering mode (inpatient or outpatient) of the order template in this row.
May contain organization-specific values: No
Category Entries:
Outpatient
Inpatient
12 SELF_ADMIN_YN VARCHAR No
Indicates whether the order template in this row is self-administered. ‘Y’ indicates that the order template in this row is self-administered. ‘N’ or NULL indicate that the order template in this row is not self-administered.
May contain organization-specific values: No
Category Entries:
Yes
No
13 PAT_SUPP_MED_YN VARCHAR No
Indicates whether the order template in this row is a patient supplied medication. ‘Y’ indicates that the order template in this row is a patient supplied medication. ‘N’ or NULL indicate that the order template in this row is not a patient supplied medication.
The category values for this column were already listed for column: SELF_ADMIN_YN
14 PAT_SUPPLIED_DOSES NUMERIC No
The number of patient supplied doses.
15 CALC_DOSE_AMOUNT VARCHAR No
The calculated dose to administer for the order template in this row.
16 CALC_DOSE_UNIT_C_NAME VARCHAR No
The units for the calculated dose to administer for 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
ng
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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
mg of pseudoephedrine
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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
ng/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
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
None / Other
17 DOSE_CALC_INFO VARCHAR No
The dose calculation information for the order template in this row.
18 ADMIN_DOSE VARCHAR No
The amount to administer for the medication in this order template.
19 ADMIN_UNIT_C_NAME VARCHAR No
The units to use with the amount to administer for the medication in this order template.
The category values for this column were already listed for column: CALC_DOSE_UNIT_C_NAME
20 VERB_ORD_TYPE_C_NAME VARCHAR No
The verbal order type for the order template in this row. For example, Ordering, Cosign, or Discontinuing.
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
21 VERB_ORD_COMM_ID VARCHAR No
The provider ID of the verbal order communicator for the order template in this row.
22 VERB_ORD_SIGNER_ID VARCHAR No
The user ID of the verbal order signer for the order template in this row.
23 VERB_ORD_SIGNER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
24 VERB_ORD_MSGRCP_ID VARCHAR No
The user ID of the verbal order message recipient for the order template in this row.
25 VERB_ORD_MSGRCP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
26 VERB_ORD_MSG_ID VARCHAR No
The ID of the verbal order message.
27 VERB_ORD_SIGN_INST DATETIME (Attached) No
The date/time in external format when the verbal order was signed.
28 VERB_ORD_MODE_C_NAME VARCHAR No
The verbal order mode of the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Verbal
Standard
29 ORD_PROV_ID VARCHAR No
The provider ID of the ordering provider for the order template in this row.
30 AUTH_PROV_ID VARCHAR No
The unique identifier for the authorizing provider for the order template in this row.
31 CALC_RATE_FRM_VD_YN VARCHAR No
Indicated whether or not to calculate rate given volume and duration. "Y" indicates that the rate will be calculated. "N" indicates that rate will not be calculated.
May contain organization-specific values: No
Category Entries:
No
Yes
32 CONDITION_FLAG NUMERIC No
The condition flag for the order template in this row.
33 MED_DOSE_PP_DESC VARCHAR No
The free text description of the dose calculation for the order template in this row.
34 OTP_ISOLATION_C_NAME VARCHAR No
The isolation category for the order template in this row.
May contain organization-specific values: Yes
35 OTP_CODESTATUS_C_NAME VARCHAR No
The code status for the order template in this row.
May contain organization-specific values: Yes
Category Entries:
<Disabled>
Full Code
DNR
Partial Code
36 CODESTATUS_COMMENT VARCHAR No
The code status comments for the order template in this row.
37 DIET_C_NAME VARCHAR No
The diet specified in the order template in this row.
May contain organization-specific values: Yes
38 DIET_COMMENTS VARCHAR No
The diet comments in the order template in this row.
39 DOSE_ADJ_TYPE_C_NAME VARCHAR No
This contains the type of dose adjustment - maximum, minimum, or standardized.
May contain organization-specific values: No
Category Entries:
Maximum Dose
Minimum Dose
Minimum and Maximum Adjustment
40 DOSE_ADJ_OVERRID_YN VARCHAR No
Indicates whether dose adjustment in I OTP 34180 was overridden. "Y" indicates that dose adjustment was overridden. "N" indicates that dose adjustment was not overridden.
The category values for this column were already listed for column: CALC_RATE_FRM_VD_YN
41 EFQ_OVRD_DAY_TYPE INTEGER No
If column EFQ_OVRD_REL_DAYS in table OTP_FREQ_OV_REL_D is populated, this item specifies what the numeric values in that item represent. If this item's value is 1, then column EFQ_OVRD_CYCL_LEN stores relative days, otherwise OTP_FREQ_OV_REL_D stores weekdays.
42 EFQ_OVRD_CYCL_LEN INTEGER No
If EFQ_OVRD_DAY_TYPE is 1 (meaning the override times stored in the record are relative cycles), then this item stores the length of the cycle.
43 ORX_ID NUMERIC No
Networked Order Lookup Index Panel ID of an order template record applied to a patient.
44 ORX_ID_ORDER_LOOKUP_NAME VARCHAR No
The name (.2 item) for the order panel record.
45 CSGN_CREATE_DTTM DATETIME (UTC) No
When the cosign requirement was created (UTC Time).
46 DFI_ID NUMERIC No
The unique identifier for the Deficiency Instance record associated with the cosignature requirement for this order.
47 CSGN_RQRD_C_NAME VARCHAR No
Stores a yes/no flag for if an action requires a cosign (I OTP 34856).
May contain organization-specific values: No
Category Entries:
Yes
No
Administratively Closed
48 MEDS_ACTION_VERB_C_NAME VARCHAR No
Action verb which is used in patient sig of the order.
May contain organization-specific values: Yes
No Entries Defined
49 PRIOR_AUTH_NEEDED_YN VARCHAR No
Stores if an order needs prior authorization.
The category values for this column were already listed for column: CALC_RATE_FRM_VD_YN
50 UNROUNDED_DOSE_MIN NUMERIC No
The unrounded dose of this order. If the dose has a range (e.g. 1-2 mg), this is the lower end of the range. If the dose does not have a range, then this will store the dose.
51 UNROUNDED_DOSE_MAX NUMERIC No
The unrounded dose of this order. If the dose has a range (e.g. 1-2 mg), this is the upper end of the range. Otherwise, this is null.
52 UNROUND_DOSE_UNIT_C_NAME VARCHAR No
The dose unit category ID for the unrounded dose of this order.
The category values for this column were already listed for column: CALC_DOSE_UNIT_C_NAME
53 TO_PHARMACY_ID NUMERIC No
The pharmacy that the order will be sent to.
54 TO_PHARMACY_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
55 MLSIG_SIGTYPE_C_NAME VARCHAR No
The type of sig being used.
May contain organization-specific values: No
Category Entries:
SIMPLE
THEN
AND
THEN-AND
56 COLLECTED_BY_USER_ID VARCHAR No
This is the user who collected the specimen.
57 COLLECTED_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.