dbo.CV3AlternateOrder 
Default Table Name  CV3AlternateOrder 
Definition  These orders have a lot of the same characteristics as CV3order entries. However we do not want them included in most of the reports, order views, MLM processing etc. 

dbo.CV3AlternateOrder 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  Visit TimeZone - 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 
EnterRole    varchar(30)  YES  The role of the person who entered the order (CV3OrderRoleType) 
UserGUID    HVCIDdt  YES  A link to the user 
ClientVisitGUID    HVCIDdt  YES  A link to the Client Visit 
ClientGUID    HVCIDdt  YES  A link to the Client 
ChartGUID    HVCIDdt  YES  Link to the CV3Chart table 
Name    varchar(125)  YES  The name of the order form 
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 to stop the order 
StopDate    varchar(20)  YES  The date and time 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  Visit TimeZone - 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, Scheduled or Performed dtm 
ScheduledDtm    datetime  YES  Visit TimeZone - The date and time the order is scheduled 
AncillaryReferenceCode    varchar(75)  YES  The accession number from the 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: 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 the order has been modified 
IsConditional    bit  NO  Indicates if this is a conditional order 
ConditionsText    varchar(255)  YES  The conditions of the order 
IsHeld    bit  NO  indicates whether or not the order is a held order 
HoldReasonText    varchar(255)  YES  The reason for the hold order 
IsAutoActivatable    bit  NO  Indicates if the order activates automatically 
ActivateDateReference    varchar(30)  YES  The reference date used to determine when the order should be activated. This is a true date but a reference data such as ordered fate and time 
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    varchar(30)  YES  The method of transport (CV3TransportMethod) 
FrequencyCode    varchar(30)  YES  The frequency for this order e.g. q4h (CV3Frequency) 
SourceCode    varchar(30)  YES  The source of the order (CV3Source) 
OrderPriorityCode    varchar(30)  YES  Order Priority Code (CV3OrderPriority)  
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    HVCIDdt  YES  Link to the Care Provider (CV3CareProvider) 
OrderEntryFormGUID    HVCIDdt  YES  The link to the form used to enter the order (CV3OrderEntryForm) 
OrderCatalogMasterItemGUID    HVCIDdt  YES  The link to the order catalog master item (CV3OrderCatalogMasterItem) 
IsIncluded    bit  NO  Indicates whether this order is included in the order set, if applicable.  
PathwayColumnHeaderGUID    HVCIDdt  YES  The link to clinical pathway header (CV3ClinicalPathwayHeader)  
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  Visit TimeZone - The date and time the order arrived in the Master Active database. 
ModifiedDtm    datetime  YES  Visit TimeZone - The date and time the order was last modified. 
ReqCodedTime    varchar(30)  YES  The coded time for which the order was requested (CV3CodedTime)  
ReqTimeValue    int  YES  The time value of the event-based coded time. 
ReqTimeUom    varchar(30)  YES  The unit of measure for the event-based coded time (CV3UnitOfMeasure)  
ReqTimeEventModifier    int  YES  when the requested time of an order is based on an event, this value indicates if it is before or after the event (1 = before; 2 = after) 
ReqTimeEventCode    varchar(30)  YES  The modifier of the time. 
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    HVCIDdt  YES  The GUID of the pre-filled order item that this order was created from, if applicable (CV3Order) 
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  Internal order session type enumerator (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  Visit TimeZone - Stores the calculated upcoming review date 
ComplexOrderType    int  YES  Define the type of order: 0 or NULL 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 Mater; 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  NO  Used to distinguish Historical Orders (0 = not applicable; 1 = Historical order) 
InitialSessionTypeCode    varchar(30)  YES  The session type used during order entry 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3AlternateOrder Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3AlternateOrderPK  PrimaryKey  GUID