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 |
|
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 |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3OrderRoleType table. |
UserGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3User table. |
ClientGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3Client table. |
ClientVisitGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3ClientVisit table. |
ChartGUID |
|
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 |
|
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 |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3TransportMethod table. |
FrequencyCode |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3Frequency table. |
SourceCode |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3Source table. |
OrderPriorityCode |
|
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 |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3CareProvider table. |
OrderEntryFormGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3OrderEntryForm table. |
OrderCatalogMasterItemGUID |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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. |