dbo.CV3OutpatientOrder 
Default Table Name  CV3OutpatientOrder 
Definition  Stores outpatient orders. 

dbo.CV3OutpatientOrder 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 
To match CV3Order and CV3AlternateOrder 
Status    varchar(10)  YES 
To match CV3Order and CV3AlternateOrder 
ToBeVerified    bit  NO 
To match CV3Order and CV3AlternateOrder 
ToBeSigned    bit  NO 
To match CV3Order and CV3AlternateOrder 
EnterRole    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
UserGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
ClientVisitGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
ClientGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
ChartGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
Name    varchar(125)  YES 
To match CV3Order and CV3AlternateOrder 
Modifier    varchar(125)  YES 
To match CV3Order and CV3AlternateOrder 
RequestedDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
RequestedDate    varchar(20)  YES 
To match CV3Order and CV3AlternateOrder 
RequestedTime    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
StopDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
StopDate    varchar(20)  YES 
To match CV3Order and CV3AlternateOrder 
StopTime    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
Duration    int  NO 
To match CV3Order and CV3AlternateOrder 
IsDurationChangeable    bit  NO 
To match CV3Order and CV3AlternateOrder 
PerformedDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
SignificantDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
SignificantTime    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
ScheduledDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
AncillaryReferenceCode    varchar(75)  YES 
To match CV3Order and CV3AlternateOrder 
SummaryLine    varchar(2000)  YES 
To match CV3Order and CV3AlternateOrder 
IDCode    char(9)  YES 
To match CV3Order and CV3AlternateOrder 
TypeCode    varchar(15)  YES 
To match CV3Order and CV3AlternateOrder 
ApplicSource    varchar(5)  YES 
To match CV3Order and CV3AlternateOrder 
IsForDischarge    bit  NO 
To match CV3Order and CV3AlternateOrder 
HasBeenModified    bit  NO 
To match CV3Order and CV3AlternateOrder 
IsConditional    bit  NO 
To match CV3Order and CV3AlternateOrder 
ConditionsText    varchar(255)  YES 
To match CV3Order and CV3AlternateOrder 
IsHeld    bit  NO 
To match CV3Order and CV3AlternateOrder 
HoldReasonText    varchar(255)  YES 
To match CV3Order and CV3AlternateOrder 
IsAutoActivatable    bit  NO 
To match CV3Order and CV3AlternateOrder 
ActivateDateReference    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
ActivateDaysBefore    int  NO 
To match CV3Order and CV3AlternateOrder 
ActivateHoursBefore    int  NO 
To match CV3Order and CV3AlternateOrder 
ActivateStatus    varchar(5)  YES 
To match CV3Order and CV3AlternateOrder 
MinimumStatusForActivation    varchar(5)  YES 
To match CV3Order and CV3AlternateOrder 
IsAutoCompletable    bit  NO 
To match CV3Order and CV3AlternateOrder 
CompleteDateReference    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
CompleteDaysAfter    int  NO 
To match CV3Order and CV3AlternateOrder 
CompleteHoursAfter    int  NO 
To match CV3Order and CV3AlternateOrder 
CompleteStatus    varchar(5)  YES 
To match CV3Order and CV3AlternateOrder 
MinimumStatusForCompletion    varchar(5)  YES 
To match CV3Order and CV3AlternateOrder 
IsCompleteTemplate    bit  NO 
To match CV3Order and CV3AlternateOrder 
TranspMethodCode    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
FrequencyCode    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
SourceCode    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
OrderPriorityCode    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
SystemOrderPriorityCode    varchar(10)  YES 
To match CV3Order and CV3AlternateOrder 
OrderStatusCode    varchar(5)  YES 
To match CV3Order and CV3AlternateOrder 
OrderStatusLevelNum    int  NO 
To match CV3Order and CV3AlternateOrder 
IsPRN    bit  NO 
To match CV3Order and CV3AlternateOrder 
IsSuspended    bit  NO 
To match CV3Order and CV3AlternateOrder 
IsPartOfSet    bit  NO 
To match CV3Order and CV3AlternateOrder 
SequenceNum    int  NO 
To match CV3Order and CV3AlternateOrder 
OrderSetName    varchar(125)  YES 
To match CV3Order and CV3AlternateOrder 
OrderSetHeading    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
OrderSetGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
CareProviderGUID    HVCIDdt  YES  To match CV3Order and CV3AlternateOrder 
OrderEntryFormGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
OrderCatalogMasterItemGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
IsIncluded    bit  NO 
To match CV3Order and CV3AlternateOrder 
PathwayColumnHeaderGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
PathwayRowHeaderGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
OrderSetType    int  NO 
To match CV3Order and CV3AlternateOrder 
IsTrackVariance    bit  NO 
To match CV3Order and CV3AlternateOrder 
IsGenericSet    bit  NO 
To match CV3Order and CV3AlternateOrder 
SubSequenceNum    int  NO 
To match CV3Order and CV3AlternateOrder 
ModifyUserGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
ArrivalDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
ModifiedDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
ReqCodedTime    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
ReqTimeValue    int  YES 
To match CV3Order and CV3AlternateOrder 
ReqTimeUom    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
ReqTimeEventModifier    int  YES 
To match CV3Order and CV3AlternateOrder 
ReqTimeEventCode    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
VarianceType    int  YES 
To match CV3Order and CV3AlternateOrder 
RepeatOrder    int  YES 
To match CV3Order and CV3AlternateOrder 
IsAutoGenerated    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
OrderTemplateGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
IsApplyProtection    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
IsOrderSet    bit  YES 
To match CV3Order and CV3AlternateOrder 
IsAddedGenericSet    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
OtherSessionType    int  YES 
To match CV3Order and CV3AlternateOrder 
IsRequired    bit  YES 
To match CV3Order and CV3AlternateOrder 
CanBeModified    bit  YES 
To match CV3Order and CV3AlternateOrder 
DiscCancelGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
SuspendGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
VerifyGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
ReleaseGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
ActivateGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
OrderSubsetName    varchar(125)  YES 
To match CV3Order and CV3AlternateOrder 
OrderSubsetGUID    HVCIDdt  YES 
To match CV3Order and CV3AlternateOrder 
OrderSubsetType    int  YES 
To match CV3Order and CV3AlternateOrder 
WorklistRefItemGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
TaskRescheduleGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
TaskGroupNum    tinyint  YES 
To match CV3Order and CV3AlternateOrder 
ReviewDtm    datetime  YES 
To match CV3Order and CV3AlternateOrder 
ComplexOrderType    int  YES 
To match CV3Order and CV3AlternateOrder 
IsLinkedForDiscCancel    bit  YES 
To match CV3Order and CV3AlternateOrder 
IsLinkedForSuspend    bit  YES 
To match CV3Order and CV3AlternateOrder 
CanBeSuspended    bit  YES 
To match CV3Order and CV3AlternateOrder 
AlternateOrderType    int  NO 
To match CV3Order and CV3AlternateOrder 
InitialSessionTypeCode    varchar(30)  YES 
To match CV3Order and CV3AlternateOrder 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3OutpatientOrder Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OutpatientOrderPK  PrimaryKey  GUID