dbo.CV3Order 
Default Table Name  CV3Order 
Definition  A request for something to be done for the client. An order may also be in the form of a template.
 

dbo.CV3Order 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)    HVCIDdt  NO  Unique primary key value. 
Entered    datetime  YES  The date and time the row was entered. 
Status    varchar(10)  YES  The status of the order. 
ToBeVerified    bit  NO  Indicates if this order is to be verified. 
ToBeSigned    bit  NO  Indicates if this order is to be signed. 
Name    varchar(125)  YES  The name of the order item. 
EnterRole(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3OrderRoleType table. 
UserGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3User table. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
ClientVisitGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientVisit table. 
ChartGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Chart table. 
Modifier    varchar(125)  YES  The modifier of the order item. This is copied from the Order Catalog Item. 
RequestedDtm    datetime  YES  Visit TimeZone - The date and time for which the order is requested. 
RequestedDate    varchar(20)  YES  The date for which the order is requested. 
RequestedTime    varchar(30)  YES  The time for which the order is requested. 
StopDtm    datetime  YES  Visit TimeZone - The date and time to stop the order. 
StopDate    varchar(20)  YES  The date to stop the order. 
StopTime    varchar(30)  YES  The time to stop the order. 
Duration    int  NO  The duration of the order. 
IsDurationChangeable    bit  NO  Indicates if the duration of the order can be changed. 
PerformedDtm    datetime  YES  The date and time the order was performed. 
SignificantDtm    datetime  YES  Visit TimeZone - The most recent Requested, Scheduled, or Performed Dtm. 
SignificantTime    varchar(30)  YES  The most recent Requested Time, Scheduled Time, or Performed Time. 
ScheduledDtm    datetime  YES  The date and time the order is scheduled. 
AncillaryReferenceCode    varchar(75)  YES  The accession number from Lab. 
SummaryLine    varchar(2000)  YES  The system-generated summary line of the order. 
IDCode    char(9)  YES  The system-generated, unique identifier for the order. 
TypeCode    varchar(15)  YES  The order type (Diagnostic, Medication, or Other). 
ApplicSource    varchar(5)  YES  Identifies which Eclipsys application was used to enter the information. Either CV (Sunrise Clinical Manager), ADT (ADT interface), or LAB (LAB interface) 
IsForDischarge    bit  NO  Indicates if this is a discharge order. 
HasBeenModified    bit  NO  Indicates if order has been modified. 
IsConditional    bit  NO  Indicates if this is a conditional order. 
ConditionsText    varchar(255)  YES  The conditions for the order. 
IsHeld    bit  NO  Indicates whether or not the order is a hold order. 
HoldReasonText    varchar(255)  YES  The reason for the hold order. 
IsAutoActivatable    bit  NO  Indicates if the order activates automatically. 
ActivateDateReference(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3DateReference table. 
ActivateDaysBefore    int  NO  The number of days before the reference date that the order should be activated. 
ActivateHoursBefore    int  NO  The number of hours before the reference date that the order should be activated. 
ActivateStatus    varchar(5)  YES  The status code that the order is set to once it is activated. 
MinimumStatusForActivation    varchar(5)  YES  The minimum status that the order must achieve before it is activated. 
IsAutoCompletable    bit  NO  Indicates if the order completes automatically. 
CompleteDateReference    varchar(30)  YES  The reference date used to determine when the order should be completed. This is not a true date, but a reference date such as date of surgery. 
CompleteDaysAfter    int  NO  The number of days after the reference date that the order should be completed. 
CompleteHoursAfter    int  NO  The number of hours after the reference date that the order should be completed. 
CompleteStatus    varchar(5)  YES  The status code that the order is set to once it is completed. 
MinimumStatusForCompletion    varchar(5)  YES  The minimum status that the order must achieve before it is completed. 
IsCompleteTemplate    bit  NO  If this is an order template, this flag indicates if the template is complete and no additional data is required upon order entry. 
TranspMethodCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3TransportMethod table. 
FrequencyCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3Frequency table. 
SourceCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3Source table. 
OrderPriorityCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3OrderPriority table. 
SystemOrderPriorityCode    varchar(10)  YES  The internal order priority. 
OrderStatusCode    varchar(5)  YES  The order status. 
OrderStatusLevelNum    int  NO  A level number assigned to the status. The higher the number, the further along the order is in its life cycle. 
IsPRN    bit  NO  Indicates if this is a PRN order. 
IsSuspended    bit  NO  Indicates if this order is suspended. 
IsPartOfSet    bit  NO  Indicates if this order is part of a set. 
SequenceNum    int  NO  The sequence number within a set, if applicable. 
OrderSetName    varchar(125)  YES  The name of the order set, if applicable. 
OrderSetHeading    varchar(30)  YES  The heading of the order within the order set, if applicable. 
OrderSetGUID    HVCIDdt  YES  The link to the ParentGUID on CV3OrderItemXref. 
CareProviderGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3CareProvider table. 
OrderEntryFormGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderEntryForm table. 
OrderCatalogMasterItemGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderCatalogMasterItem table. 
IsIncluded    bit  NO  Indicates whether this order is included in the order set, if applicable. 
PathwayColumnHeaderGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClinicalPathwayHeader table. 
PathwayRowHeaderGUID    HVCIDdt  YES  The link to the CV3ClinicalPathwayHeader. 
OrderSetType    int  NO  Stores the order catalog set type, if applicable. 
IsTrackVariance    bit  NO  Not used. 
IsGenericSet    bit  NO  Identifies the template representing a generic set in an order set or clinical path. 
SubSequenceNum    int  NO  The sequence number on an order inserted in a generic set. 
ModifyUserGUID    HVCIDdt  YES  Identifies the user who modified an order and caused a Pending Verify status change. 
ArrivalDtm    datetime  YES  PHI: The date and time the order arrived in the Master Active database. 
ModifiedDtm    datetime  YES  The date and time the order was last modified. 
ReqCodedTime(FK)    varchar(30)  YES  A foreign key to the Name column in the CV3CodedTime table. 
ReqTimeValue    int  YES  The time value of the event-based coded time. 
ReqTimeUom(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3UnitOfMeasure table. 
ReqTimeEventModifier    int  YES  An enumerated type with the following list of possible values: 1 = [Before],2 = [After], 
ReqTimeEventCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3ScheduleEvent table. 
VarianceType    int  YES  Not used. 
RepeatOrder    int  YES  The order type. 
IsAutoGenerated    tinyint  YES  Indicates if this order is generated by a background process. 
OrderTemplateGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Order table. 
IsApplyProtection    tinyint  YES  Determines whether to protect fields during order entry on fields with Selected Item Only protection, if applicable. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
IsOrderSet    bit  YES  Indicates whether the particular item is order set or not. 
IsAddedGenericSet    tinyint  YES  This column will indicate whether the particular item is an added generic set or not. 
OtherSessionType    int  YES  An enumerated type with the following list of possible values: 0 = [Completed], 
IsRequired    bit  YES  Indicates if the order is required in this set. 
CanBeModified    bit  YES  Indicates whether or not the order can be modified. This is applicable only to orders associated to a linked set. 
DiscCancelGroupNum    tinyint  YES  Indicates if this order should be grouped with other orders for discontinue/cancel. The column CV3OrderSet.DiscCancelGroupByGUID will help identify which orders are part of the group. 
SuspendGroupNum    tinyint  YES  Indicates if this order should be grouped for Suspend/Unsuspended behavior. 
VerifyGroupNum    tinyint  YES  Indicates if this order should be grouped with other orders for verification. 
ReleaseGroupNum    tinyint  YES  Indicates if this order should be grouped with other orders when released. 
ActivateGroupNum    tinyint  YES  Indicates if this order should be grouped with other orders when activated. 
OrderSubsetName    varchar(125)  YES  The name of the sub-set that the order belongs to. 
OrderSubsetGUID    HVCIDdt  YES  Link to CV3OrderSet.GUID This points to the sub-set that the order may belong to. (note: CV3OrderSet is a new table) 
OrderSubsetType    int  YES  Indicates the order sub-set type 
WorklistRefItemGroupNum    tinyint  YES  Indicates if this order will be used in the task worklist as a reference item 
TaskRescheduleGroupNum    tinyint  YES  Indicates if this order is grouped with other orders when tasks are rescheduled. If so, all tasks must be rescheduled at onces 
TaskGroupNum    tinyint  YES  Indicates if this order will appear grouped with other orders on the task worklist 
ReviewDtm    datetime  YES  Stores the calculated upcoming review date 
ComplexOrderType    int  YES  An enumerated type with the following list of possible values: 0 = [Regular Order],1 = [Sequential Complex Dose Master],2 = [Sequential Complex Dose Child],3 = [Concurrent Complex Dose Master],4 = [Concurrent Complex Dose Child],5 = [Multiple Frequencies Master],6 = [Multiple Frequencies Child], 
IsLinkedForDiscCancel    bit  YES  Indicates whether this order is linked in a group for dc/cancel 
IsLinkedForSuspend    bit  YES  Indicates whether this order is linked in a group for suspend/unsuspended 
CanBeSuspended    bit  YES  Indicates whether this order can be suspended. This overrides the setting of CV3OrderCatalogMasterItem 
AlternateOrderType    int  YES  An enumerated type with the following list of possible values: 0 = [Not Applicable],1 = [Historical Order],2 = [Outpatient Order], 
InitialSessionTypeCode    varchar(30)  YES  Replaces the column SessionTypeCode 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3Order Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderPK  PrimaryKey  GUID