SiteID |
Definition | Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. |
RepFlags |
Definition | Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. |
Build |
Definition | Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. |
TouchedBy |
Definition | Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. |
TouchedWhen |
Definition | The date and time that the row was last updated and will be based on the Enterprise time zone. |
CreatedBy |
Definition | Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. |
CreatedWhen |
Definition | The date and time that the row was created and will be based on the Enterprise time zone. |
Active |
Definition | Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. |
GUID |
Definition | Unique primary key value. |
OrderGUID |
Definition | Primary key |
IsTemplate |
Definition | Indicate whether the order is an order template. |
ComplexOrderType |
Definition | Indicates the order type for the child order 2 – Sequential Complex Dose Child Order;4 – Concurrent Complex Dose Child Order;6 – Multiple Frequencies Child Order |
SequenceNumber |
Definition | Indicate the sequence that the orders will be created. |
DosageLow |
Definition | Store the dosage low |
DosageHigh |
Definition | Store the dosage high |
Uom |
Definition | Store the uom. |
OrderRouteCode |
Definition | Store the order route code |
OrderRouteModifierCode |
Definition | Store the order route modifier code |
FrequencyCode |
Definition | Store the frequency code |
FreqFromTime |
Definition | Store the frequency from time value if |
FreqToTime |
Definition | Store the frequency to time value if |
FreqUom |
Definition | Store the frequency uom if |
FreqEventModifierType |
Definition | Store the event modifier for event based frequency code |
FreqEventCode |
Definition | Store the event code for event based frequency code |
StopAfterValue |
Definition | Store the duration value |
StopAfterOptionType |
Definition | Store the duration uom 1 – Days;2 – Hours; 3 – Minutes; 4 – Times |
RequestedDate |
Definition | Store the requested date of the child order |
RequestedTime |
Definition | Store the requested time for time critical child order |
ReqCodedTime |
Definition | Store the coded requested time for time critical order |
ReqTimeValue |
Definition | Store the time value for requested time of event based type |
ReqTimeUom |
Definition | Store the uom of the time value for requested time of event based type. |
ReqTimeEventModifierType |
Definition | Store the event modifier for requested time of event based type |
ReqTimeEventCode |
Definition | Store the event time code for requested time of event based type |
StopDate |
Definition | Store the stop date of the child order |
StopTime |
Definition | Store the stop time of the child order |
EstimatedStopDtm |
Definition | Estimate stop date/time of the child order. This should be calculated and updated when the estimated stop date/time is calculated for the master order. This field is mainly used by CDS. |
CalcDoseMethod |
Definition | Indicate the method used for calculated dose 0 – Per dose; 1 – Daily Dose |
CalcRequestedDose |
Definition | Store the requested calculated dose |
CalcUOMPer |
Definition | Store the uom per requested dose. |
CalcActualDose |
Definition | Store the actual dose used for the calculated dose |
CalcOverrideReason |
Definition | Store the override dose reason |
CalcTotalDailyDose |
Definition | Store the total daily dose |
CalcInfo |
Definition | Store the calculated dose information |
IsPRN |
Definition | Indicate whether the order instance should be a PRN order |
PRNReasonText |
Definition | For PRN order instance, store the PRN reason. |
ChildOrderGUID |
Definition | Store the Order GUID for child order created from this component. |
EstimatedRequestedDtm |
Definition | Estimate requested date/time of the child order. This should be calculated and updated when the estimated stop date/time is calculated for the master order. This field is mainly used by CDS. |
DataItemCode1 |
Definition | Stores the first data item code returned from call MLM |
DataItemValue1 |
Definition | Stores the value returned for DataItemCode1 from call MLM |
DataItemCode2 |
Definition | Stores the second data item code returned from call MLM |
DataItemValue2 |
Definition | Stores the value returned for DataItemCode2 from call MLM |
DataItemCode3 |
Definition | Stores the third data item code returned from call MLM |
DataItemValue3 |
Definition | Stores the value returned for DataItemCode3 from call MLM |
DataItemCode4 |
Definition | Stores the fourth data item code returned from call MLM |
DataItemValue4 |
Definition | Stores the value returned for DataItemCode4 from call MLM |
DataItemCode5 |
Definition | Stores the fifth data item code returned from call MLM |
DataItemValue5 |
Definition | Stores the value returned for DataItemCode5 from call MLM |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |