dbo.CV3OrderAddnlInfo 
Default Table Name  CV3OrderAddnlInfo 
Definition  Additional information about an order. 

dbo.CV3OrderAddnlInfo Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  YES  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
RepFlags    tinyint  YES  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  YES  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    datetime  YES  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  YES  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    datetime  YES  The date and time that the row was created and will be based on the Enterprise time zone. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
GUID(PK)(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Order table. 
IsIncluded    bit  NO  Indicates whether this order is included in the order set, if applicable. 1 = True; 0 = False 
OrderCatalogSetGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderCatalogSet table. 
MaxActivations    int  NO  The maximum number of activations of this order. This is applicable to repeat orders. 
RemainActivations    int  NO  The number of activations remaining. This is applicable to repeat orders. 
PRNReasonText    varchar(255)  YES  The reason for delivering PRN medications. 
SpecialInstructions    varchar(2000)  YES  Any special instructions associated with the order. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
TemplateGUID    HVCIDdt  YES  The link to the order template. 
FreqFromTime    int  YES  The starting time for the coded frequency. 
FreqToTime    int  YES  The ending time for the coded frequency. 
FreqUom    varchar(30)  YES  The unit of measure for the frequency from and to times. 
FreqEventModifier    int  YES  The modifier of the time. 1 = Before; 2 = After 
FreqEventCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3ScheduleEvent table. 
FreqSummaryLine    varchar(255)  YES  The summary line for the display. 
UseWakingHourOnly    tinyint  YES  Indicates that the frequency code applies to waking hours only for task generation. 
GenTaskScheduleSource    int  YES  Indicates the source where the task schedule will be generated from. 
RepeatFrequency    int  YES  The frequency of the repetition (for example, every N hours). 
RepeatUom    varchar(30)  YES  The unit of measure for the repetition (for example, hour, day, etc.). 
MaxRepeats    int  YES  The maximum number of repeat orders that can be created. 
LastRequestedDtm    datetime  YES  The requested date and time from the last repeat order that was created. 
RepeatStartDtm    datetime  YES  The starting time for the repeat orders. 
RepeatStopDtm    datetime  YES  The ending time for the repeat orders. 
VerificationPolicyCode    varchar(30)  YES  The code of the Verification Policy used by the order. 
OriginOrderTemplateGUID    HVCIDdt  YES  The link to the order template that was used in creating the order. 
StopAfterValue    int  YES  Stores the value of the stop after 
StopAfterOption    int  YES  Stores the Stop After option0 = None1 = Days2 = Hours3 = Minutes4 = Times 
CalcStopDateMode    int  YES  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    uniqueidentifier  YES  Optimistic lock identifier. 
ReviewInterval    int  YES  The time frame after which the order has to be reviewed. Used to set the Review Date for an order. 
ReviewIntervalType    int  YES  Indicates the unit of measure for the review interval. 0 – Hours 1 – Days 
RelativeReviewInDays    int  YES  The number of days prior to the stop date that the order must be reviewed. 
IsReviewDateChangeable    bit  YES  Can the review date be changed? 
AutoExtendStopDateType    int  YES  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    varchar(30)  YES  Specifies that the next review time will be T + n hours 
ReviewDate    varchar(20)  YES  Specifies that the next review date will be T + n days 
IsInformational    bit  YES  Indicates that this order item is a ‘Profile order’ (for information only). 
DosingOptionGUID    HVCIDdt  YES  For complex dosing master orders, stores the GUID of the dosing option that the user selected for this order. This links to CV3DosingOptionGUID 
HasAttachedSchedule    bit  YES  Specify an order has attached schedule information. Either be a freq or a daily freq with adjusted admin times 
HasDataNotOnForm    bit  YES  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    int  YES  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    int  YES  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    int  YES  An enumerated type with the following list of possible values: 0 = [Now],1 = [Actual Suspend Date/Time],2 = [After next dose or occurrence], 
SuspendDtm    datetime  YES  Order suspend datetime 
UnsuspendOptionType    int  YES  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    int  YES  The value portion of the suspended for duration 
SuspendForOptionType    int  YES  An enumerated type with the following list of possible values: 0 = [None],1 = [Days],2 = [Hours],3 = [Minutes],4 = [Times], 
UnsuspendDtm    datetime  YES  Order resume datetime 
SuspendUserGUID    HVCIDdt  YES  User who enters the suspend and/or unsuspend instructions 
ItemExternalIDCode    varchar(60)  YES  Represents the external ID of the orders within the set 
DisplayModifierType    tinyint  YES  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    HVCIDdt  YES  The location that the user is being transferred to. The GUID is taken from the CV3Location table. Default value is NULL. 
HistoricalOrderInfoSourceCode    varchar(30)  YES  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    bit  YES  If this flag is true, the order will not be canceled on patient discharge. 
IsNoActionOnDischarge    bit  YES  Valid values are

Not applicable = 0
Times = 1
Doses = 2
Units = 3
 
IsReconcileContinueOnTransfer    bit  YES  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    varchar(100)  YES  Records the CareProviderGUID(s) for CopyTo field. Can contain up to 5 GUIDs 
BlindCopyToCareProviderGUIDs    varchar(100)  YES  Records the CareProviderGUID(s) for BlindCopyTo field. Can contain up to 5 GUIDs 
IsScript    bit  NO 
Whether or not this order has a script 
EntrySourceType    int  YES  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    varchar(60)  YES 
Follow Up Comment 
BodySite    varchar(255)  YES 
Body Site 
FinancialClass    varchar(255)  YES 
Financial Class 
ConvertedToOutpatientOrderGUID    HVCIDdt  YES  This column will store the converted outpatient order's GUID. This is used in import tool 
RxSequenceNum    varchar(10)  YES  This column is used to store the sequence number of the prescription. 
ScriptNumber    varchar(50)  YES  This column is used to store the batch or script number of the prescription (group). 
IsToBeSent    bit  NO  This column stores the flag (0 or 1), refers the prescription needs to be transmitted or not. 
FutureStartDateReasonType    int  YES  Store the type of reason why the start date of this order is future date. Actual reason will be stored in CV3EnumReference table 
IsUsingForm    bit  NO  If it is true, order form will be used to create, edit or view the outpatient order, otherwise inline panel will be used. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsWithheld    bit  NO  If it is true, the outpatient order is withheld, otherwise, it's normal order 
LastPrintedOrdStatusHistGUID    HVCIDdt  YES  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    bit  NO  If it is true, the outpatient order medication is not supplied from hospital, otherwise, it's supplied from hospital. 
InfoSource    varchar(2000)  YES  Sources of information for a home medication 
DSN    varchar(50)  YES  The DSN generated by Order Appropriateness Tracking (OAT) system for this order. 
Score    varchar(5)  YES  The Score evaluated by Order Appropriateness Tracking (OAT) system for this order based on the indication and scenario selected 
OriginalOrderName    varchar(125)  YES  The origial order name submitted to Order Appropriateness Tracking (OAT) system for checking. 
OriginalOrderModifier    varchar(125)  YES  The origial order modifier of the prefilled item submitted to Order Appropriateness Tracking (OAT) system for checking. 
OriginalOrderModifierVersion    varchar(40)  YES  The origial order modifier version of the prefilled item submitted to Order Appropriateness Tracking (OAT) system for checking. 
OATReason    varchar(255)  YES  The reason to override the decision recommended by Order Appropriateness Tracking (OAT) system. 
Cost    varchar(20)  YES  The cost of this procedure assigned by Order Appropriateness Tracking (OAT) system. 
RRL    varchar(25)  YES  The Relative Radiation Level (RRL) of this procedure assigned by Order Appropriateness Tracking (OAT) system. 
CDSMechanism    varchar(125)  YES  The clinical decision system mechanism to determine the Order Appropriateness for this order. It might also be inbound from HL7. 
AUCSourceType    int  NO  An enumerated type with the following list of possible values: 0 = [Electronic],1 = [Manual],2 = [HL7], 
IsBypassAUCChecking    bit  NO  Is Bypass AUC Checking 
BypassAUCCheckingReason    varchar(255)  YES  Bypass AUC Checking Reason 
RecommendationText    varchar(50)  YES  Store the recommendation text for appropriate use criteria of the order 
BypassAUCCheckingReasonModifierCode    varchar(250)  YES  Store the modifier code for the reason to bypass AUC checking 
CDSMechanismGCode    varchar(250)  YES  Store the G code for the CDSMechanism 
AdherenceScore    varchar(50)  YES  Store the Adherence Score for AUC checking 
AdherenceScoreModifierCode    varchar(250)  YES  Store the Modifier Code for the Adherence Score 
CanOverrideMaxRepeats    bit  NO  Identifies whether the maximum repeat occurrences configured in the catalog master item can be overridden on order creation. 

dbo.CV3OrderAddnlInfo Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderAddnlInfoPK  PrimaryKey  GUID