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 | A foreign key to the GUID column in the CV3Order table. |
IsIncluded |
Definition | Indicates whether this order is included in the order set, if applicable. 1 = True; 0 = False |
OrderCatalogSetGUID |
Definition | A foreign key to the GUID column in the CV3OrderCatalogSet table. |
MaxActivations |
Definition | The maximum number of activations of this order. This is applicable to repeat orders. |
RemainActivations |
Definition | The number of activations remaining. This is applicable to repeat orders. |
PRNReasonText |
Definition | The reason for delivering PRN medications. |
SpecialInstructions |
Definition | Any special instructions associated with the order. |
ClientGUID |
Definition | A foreign key to the GUID column in the CV3Client table. |
TemplateGUID |
Definition | The link to the order template. |
FreqFromTime |
Definition | The starting time for the coded frequency. |
FreqToTime |
Definition | The ending time for the coded frequency. |
FreqUom |
Definition | The unit of measure for the frequency from and to times. |
FreqEventModifier |
Definition | The modifier of the time. 1 = Before; 2 = After |
FreqEventCode |
Definition | A foreign key to the Code column in the CV3ScheduleEvent table. |
FreqSummaryLine |
Definition | The summary line for the display. |
UseWakingHourOnly |
Definition | Indicates that the frequency code applies to waking hours only for task generation. |
GenTaskScheduleSource |
Definition | Indicates the source where the task schedule will be generated from. |
RepeatFrequency |
Definition | The frequency of the repetition (for example, every N hours). |
RepeatUom |
Definition | The unit of measure for the repetition (for example, hour, day, etc.). |
MaxRepeats |
Definition | The maximum number of repeat orders that can be created. |
LastRequestedDtm |
Definition | The requested date and time from the last repeat order that was created. |
RepeatStartDtm |
Definition | The starting time for the repeat orders. |
RepeatStopDtm |
Definition | The ending time for the repeat orders. |
VerificationPolicyCode |
Definition | The code of the Verification Policy used by the order. |
OriginOrderTemplateGUID |
Definition | The link to the order template that was used in creating the order. |
StopAfterValue |
Definition | Stores the value of the stop after |
StopAfterOption |
Definition | Stores the Stop After option0 = None1 = Days2 = Hours3 = Minutes4 = Times |
CalcStopDateMode |
Definition | Stores value that indicates whether the stop date can be calculated by the task processing.0 = CanCalcByTask, order generates task and stop date can be calculated by task.1 = CannotCalcByTask, stop date cannot be calculated by task.2 = Backedated, order generates task but is backdated further than the period defined in the 'Backdate Task Generation' entry, do not calculated the stop date by task. |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
ReviewInterval |
Definition | The time frame after which the order has to be reviewed. Used to set the Review Date for an order. |
ReviewIntervalType |
Definition | Indicates the unit of measure for the review interval. 0 – Hours 1 – Days |
RelativeReviewInDays |
Definition | The number of days prior to the stop date that the order must be reviewed. |
IsReviewDateChangeable |
Definition | Can the review date be changed? |
AutoExtendStopDateType |
Definition | Indicates how the stop date will be extended when the order is marked as reviewed. Enumerated options are None (0), “ByStandardPolicy” (1), “ByASO” (2) |
ReviewTime |
Definition | Specifies that the next review time will be T + n hours |
ReviewDate |
Definition | Specifies that the next review date will be T + n days |
IsInformational |
Definition | Indicates that this order item is a ‘Profile order’ (for information only). |
DosingOptionGUID |
Definition | For complex dosing master orders, stores the GUID of the dosing option that the user selected for this order. This links to CV3DosingOptionGUID |
HasAttachedSchedule |
Definition | Specify an order has attached schedule information. Either be a |
HasDataNotOnForm |
Definition | Indicates whether there ate extra data items that are stored with a value, but are not linked to the order form. This is data that was not populated from the Order Entry form, but from another source: Medication Management. 0 or Null – no extra data;1 – Extra data stored in the order |
DirectDeleteItemType |
Definition | Indicates whether the specific order item can be directly deleted from the Order Entry Worksheet dialog. This type will be populated from Config Tools in Order Set Item Attributes dialog with "Allow delete from worksheet" column containing combo box with the following values - 0-Not Allowed;1-Allowed;2-Default;3-FromSet |
DirectEditItemType |
Definition | Indicates whether the specific order item can be directly modified from the Order Entry Worksheet dialog. This type will be populated from Config Tools in Order Set Item Attributes dialog with "Allow edit from worksheet" column containing combo box with the following values - 0-Not Allowed;1-Allowed;2-Default;3-FromSet |
SuspendOptionType |
Definition | An enumerated type with the following list of possible values: 0 = [Now],1 = [Actual Suspend Date/Time],2 = [After next dose or occurrence], |
SuspendDtm |
Definition | Order suspend datetime |
UnsuspendOptionType |
Definition | An enumerated type with the following list of possible values: 0 = [Unsuspend Now],1 = [User unsuspends],2 = [Suspend Duration],3 = [Actual Resume Date/Time], |
SuspendForValue |
Definition | The value portion of the suspended for duration |
SuspendForOptionType |
Definition | An enumerated type with the following list of possible values: 0 = [None],1 = [Days],2 = [Hours],3 = [Minutes],4 = [Times], |
UnsuspendDtm |
Definition | Order resume datetime |
SuspendUserGUID |
Definition | User who enters the suspend and/or unsuspend instructions |
ItemExternalIDCode |
Definition | Represents the external ID of the orders within the set |
DisplayModifierType |
Definition | An enumerated type with the following list of possible values: 0 = [Never],1 = [Always],2 = [Always(Order Entry)],3 = [When Unselected],4 = [Default],5 = [From Set], |
TransferToLocnGUID |
Definition | The location that the user is being transferred to. The GUID is taken from the CV3Location table. Default value is NULL. |
HistoricalOrderInfoSourceCode |
Definition | The information source of the order being reconciled. Values are either taken from the Code column in CCV3OrderReconcileInfoSource or are entered as free-text by the user. Default value is NULL. |
IsNoActionOnTransfer |
Definition | If this flag is true, the order will not be canceled on patient discharge. |
IsNoActionOnDischarge |
Definition | Valid values are Not applicable = 0 Times = 1 Doses = 2 Units = 3 |
IsReconcileContinueOnTransfer |
Definition | The flag will be set to true if the user selected Continue action during transfer reconciliation. If the flag is true, order status will not change on Transfer (auto-dc/cancel or auto-suspend). |
CopyToCareProviderGUIDs |
Definition | Records the CareProviderGUID(s) for CopyTo field. Can contain up to 5 GUIDs |
BlindCopyToCareProviderGUIDs |
Definition | Records the CareProviderGUID(s) for BlindCopyTo field. Can contain up to 5 GUIDs |
IsScript |
Definition |
Whether or not this order has a script |
EntrySourceType |
Definition | An enumerated type with the following list of possible values: 0 = [Not Applicable],1 = [Admission],2 = [Admission From Transfer],3 = [Transfer],4 = [Discharge],5 = [Outpatient Medication Profile], |
FollowUpComment |
Definition |
Follow Up Comment |
BodySite |
Definition |
Body Site |
FinancialClass |
Definition |
Financial Class |
ConvertedToOutpatientOrderGUID |
Definition | This column will store the converted outpatient order's GUID. This is used in import tool |
RxSequenceNum |
Definition | This column is used to store the sequence number of the prescription. |
ScriptNumber |
Definition | This column is used to store the batch or script number of the prescription (group). |
IsToBeSent |
Definition | This column stores the flag (0 or 1), refers the prescription needs to be transmitted or not. |
FutureStartDateReasonType |
Definition | Store the type of reason why the start date of this order is future date. Actual reason will be stored in CV3EnumReference table |
IsUsingForm |
Definition | If it is true, order form will be used to create, edit or view the outpatient order, otherwise inline panel will be used. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
IsWithheld |
Definition | If it is true, the outpatient order is withheld, otherwise, it's normal order |
LastPrintedOrdStatusHistGUID |
Definition | This column holds the GUID (from CV3OrderStatusHistory table) of the latest row that has been passed to report print module. Mainly applicable for OP Orders Reprint Module. |
IsNotSupplied |
Definition | If it is true, the outpatient order medication is not supplied from hospital, otherwise, it's supplied from hospital. |
InfoSource |
Definition | Sources of information for a home medication |
DSN |
Definition | The DSN generated by Order Appropriateness Tracking (OAT) system for this order. |
Score |
Definition | The Score evaluated by Order Appropriateness Tracking (OAT) system for this order based on the indication and scenario selected |
OriginalOrderName |
Definition | The origial order name submitted to Order Appropriateness Tracking (OAT) system for checking. |
OriginalOrderModifier |
Definition | The origial order modifier of the prefilled item submitted to Order Appropriateness Tracking (OAT) system for checking. |
OriginalOrderModifierVersion |
Definition | The origial order modifier version of the prefilled item submitted to Order Appropriateness Tracking (OAT) system for checking. |
OATReason |
Definition | The reason to override the decision recommended by Order Appropriateness Tracking (OAT) system. |
Cost |
Definition | The cost of this procedure assigned by Order Appropriateness Tracking (OAT) system. |
RRL |
Definition | The Relative Radiation Level (RRL) of this procedure assigned by Order Appropriateness Tracking (OAT) system. |
CDSMechanism |
Definition | The clinical decision system mechanism to determine the Order Appropriateness for this order. It might also be inbound from HL7. |
AUCSourceType |
Definition | An enumerated type with the following list of possible values: 0 = [Electronic],1 = [Manual],2 = [HL7], |
IsBypassAUCChecking |
Definition | Is Bypass AUC Checking |
BypassAUCCheckingReason |
Definition | Bypass AUC Checking Reason |
RecommendationText |
Definition | Store the recommendation text for appropriate use criteria of the order |
BypassAUCCheckingReasonModifierCode |
Definition | Store the modifier code for the reason to bypass AUC checking |
CDSMechanismGCode |
Definition | Store the G code for the CDSMechanism |
AdherenceScore |
Definition | Store the Adherence Score for AUC checking |
AdherenceScoreModifierCode |
Definition | Store the Modifier Code for the Adherence Score |
CanOverrideMaxRepeats |
Definition | Identifies whether the maximum repeat occurrences configured in the catalog master item can be overridden on order creation. |