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. |
Entered |
Definition | Visit TimeZone - The date and time the row was entered |
Status |
Definition | The status of the order |
ToBeVerified |
Definition | Indicates if this order is to be verified |
ToBeSigned |
Definition | Indicates if this order is to be signed |
EnterRole |
Definition | The role of the person who entered the order (CV3OrderRoleType) |
UserGUID |
Definition | A link to the user |
ClientVisitGUID |
Definition | A link to the Client Visit |
ClientGUID |
Definition | A link to the Client |
ChartGUID |
Definition | Link to the CV3Chart table |
Name |
Definition | The name of the order form |
Modifier |
Definition | The modifier of the order item. This is copied from the order Catalog Item |
RequestedDtm |
Definition | Visit TimeZone - The date and time for which the order is requested |
RequestedDate |
Definition | The date for which the order is requested |
RequestedTime |
Definition | The time for which the order is requested |
StopDtm |
Definition | Visit TimeZone - The date to stop the order |
StopDate |
Definition | The date and time to stop the order |
StopTime |
Definition | The time to stop the order |
Duration |
Definition | The duration of the order |
IsDurationChangeable |
Definition | Indicates if the duration of the order can be changed |
PerformedDtm |
Definition | Visit TimeZone - The date and time the order was performed |
SignificantDtm |
Definition | Visit TimeZone - The most recent Requested, Scheduled or Performed dtm |
SignificantTime |
Definition | The most recent Requested, Scheduled or Performed dtm |
ScheduledDtm |
Definition | Visit TimeZone - The date and time the order is scheduled |
AncillaryReferenceCode |
Definition | The accession number from the lab |
SummaryLine |
Definition | The system generated summary line of the order |
IDCode |
Definition | The system generated unique identifier for the order |
TypeCode |
Definition | The order type (Diagnostic, Medication or Other) |
ApplicSource |
Definition | Identifies which Eclipsys application was used to enter the information: CV-Sunrise Clinical Manager; ADT-ADT Interface or LAB-LAB Interface |
IsForDischarge |
Definition | Indicates if this is a discharge order |
HasBeenModified |
Definition | Indicates if the order has been modified |
IsConditional |
Definition | Indicates if this is a conditional order |
ConditionsText |
Definition | The conditions of the order |
IsHeld |
Definition | indicates whether or not the order is a held order |
HoldReasonText |
Definition | The reason for the hold order |
IsAutoActivatable |
Definition | Indicates if the order activates automatically |
ActivateDateReference |
Definition | 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 |
Definition | The number of days before the reference date that the order should be activated |
ActivateHoursBefore |
Definition | The number of hours before the reference date that the order should be activated |
ActivateStatus |
Definition | The status code that the order is set to once it is activated |
MinimumStatusForActivation |
Definition | The minimum status that the order must achieve before it is activated |
IsAutoCompletable |
Definition | Indicates if the order completes automatically |
CompleteDateReference |
Definition | 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 |
Definition | The number of days after the reference date that the order should be completed. |
CompleteHoursAfter |
Definition | The number of hours after the reference date that the order should be completed. |
CompleteStatus |
Definition | The status code that the order is set to once it is completed. |
MinimumStatusForCompletion |
Definition | The minimum status that the order must achieve before it is completed. |
IsCompleteTemplate |
Definition | If this is an order template, this flag indicates if the template is complete and no additional data is required upon order entry. |
TranspMethodCode |
Definition | The method of transport (CV3TransportMethod) |
FrequencyCode |
Definition | The frequency for this order e.g. q4h (CV3Frequency) |
SourceCode |
Definition | The source of the order (CV3Source) |
OrderPriorityCode |
Definition | Order Priority Code (CV3OrderPriority) |
SystemOrderPriorityCode |
Definition | The internal order priority. |
OrderStatusCode |
Definition | The order status. |
OrderStatusLevelNum |
Definition | A level number assigned to the status. The higher the number, the further along the order is in its life cycle. |
IsPRN |
Definition | Indicates if this is a PRN order. |
IsSuspended |
Definition | Indicates if this order is suspended. |
IsPartOfSet |
Definition | Indicates if this order is part of a set. |
SequenceNum |
Definition | The sequence number within a set, if applicable. |
OrderSetName |
Definition | The name of the order set, if applicable. |
OrderSetHeading |
Definition | The heading of the order within the order set, if applicable. |
OrderSetGUID |
Definition | The link to the ParentGUID on CV3OrderItemXref. |
CareProviderGUID |
Definition | Link to the Care Provider (CV3CareProvider) |
OrderEntryFormGUID |
Definition | The link to the form used to enter the order (CV3OrderEntryForm) |
OrderCatalogMasterItemGUID |
Definition | The link to the order catalog master item (CV3OrderCatalogMasterItem) |
IsIncluded |
Definition | Indicates whether this order is included in the order set, if applicable. |
PathwayColumnHeaderGUID |
Definition | The link to clinical pathway header (CV3ClinicalPathwayHeader) |
PathwayRowHeaderGUID |
Definition | The link to the CV3ClinicalPathwayHeader. |
OrderSetType |
Definition | Stores the order catalog set type, if applicable. |
IsTrackVariance |
Definition | Not used. |
IsGenericSet |
Definition | Identifies the template representing a generic set in an order set or clinical path. |
SubSequenceNum |
Definition | The sequence number on an order inserted in a generic set. |
ModifyUserGUID |
Definition | Identifies the user who modified an order and caused a Pending Verify status change. |
ArrivalDtm |
Definition | Visit TimeZone - The date and time the order arrived in the Master Active database. |
ModifiedDtm |
Definition | Visit TimeZone - The date and time the order was last modified. |
ReqCodedTime |
Definition | The coded time for which the order was requested (CV3CodedTime) |
ReqTimeValue |
Definition | The time value of the event-based coded time. |
ReqTimeUom |
Definition | The unit of measure for the event-based coded time (CV3UnitOfMeasure) |
ReqTimeEventModifier |
Definition | 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 |
Definition | The modifier of the time. |
VarianceType |
Definition | Not used. |
RepeatOrder |
Definition | The order type. |
IsAutoGenerated |
Definition | Indicates if this order is generated by a background process. |
OrderTemplateGUID |
Definition | The GUID of the pre-filled order item that this order was created from, if applicable (CV3Order) |
IsApplyProtection |
Definition | Determines whether to protect fields during order entry on fields with Selected Item Only protection, if applicable. |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
IsOrderSet |
Definition | Indicates whether the particular item is order set or not. |
IsAddedGenericSet |
Definition | This column will indicate whether the particular item is an added generic set or not. |
OtherSessionType |
Definition | Internal order session type enumerator (0 - Completed |
IsRequired |
Definition | Indicates if the order is required in this set. |
CanBeModified |
Definition | Indicates whether or not the order can be modified. This is applicable only to orders associated to a linked set. |
DiscCancelGroupNum |
Definition | 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 |
Definition | Indicates if this order should be grouped for Suspend/Unsuspended behavior. |
VerifyGroupNum |
Definition | Indicates if this order should be grouped with other orders for verification. |
ReleaseGroupNum |
Definition | Indicates if this order should be grouped with other orders when released. |
ActivateGroupNum |
Definition | Indicates if this order should be grouped with other orders when activated. |
OrderSubsetName |
Definition | The name of the sub-set that the order belongs to. |
OrderSubsetGUID |
Definition | Link to CV3OrderSet.GUID This points to the sub-set that the order may belong to. (note: CV3OrderSet is a new table) |
OrderSubsetType |
Definition | Indicates the order sub-set type |
WorklistRefItemGroupNum |
Definition | Indicates if this order will be used in the task worklist as a reference item |
TaskRescheduleGroupNum |
Definition | Indicates if this order is grouped with other orders when tasks are rescheduled. If so, all tasks must be rescheduled at onces |
TaskGroupNum |
Definition | Indicates if this order will appear grouped with other orders on the task worklist |
ReviewDtm |
Definition | Visit TimeZone - Stores the calculated upcoming review date |
ComplexOrderType |
Definition | 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 |
Definition | Indicates whether this order is linked in a group for dc/cancel |
IsLinkedForSuspend |
Definition | Indicates whether this order is linked in a group for suspend/unsuspended |
CanBeSuspended |
Definition | Indicates whether this order can be suspended. This overrides the setting of CV3OrderCatalogMasterItem |
AlternateOrderType |
Definition | Used to distinguish Historical Orders (0 = not applicable; 1 = Historical order) |
InitialSessionTypeCode |
Definition | The session type used during order entry |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |