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. 

ReconcileGUID 
Definition  Link to GUID column of the CV3OrderReconcile table. 

OrderGUID 
Definition  The GUID of an order that was actioned during the order reconciliation. 

OrderVisitType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Outpatient],2 = [Inpatient],3 = [Previous Visit],4 = [Discharge],5 = [Discharge Prescription], 

ReconcileActionType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Needs Further Review],2 = [Replaced],3 = [Entered as New Order],4 = [Entered as New Order with Prescription],5 = [DC/Cancel],6 = [DC/Reorder],7 = [Suspend],8 = [Unsuspend],9 = [Modify],10 = [Release],11 = [Continue],12 = [Reorder],13 = [Do Not Continue],14 = [Manually Entered Comment],15 = [],16 = [],17 = [Auto-Reviewed],18 = [DC/Cancel and Replace],19 = [Resume/Renew],20 = [Reconciled With Existing],21 = [Create Inpatient Order],22 = [Not Required],23 = [Continue and Modify],24 = [Patient Choice],25 = [Create Prescription],26 = [Continue As],27 = [Replace with Home Medication],28 = [Replace with Prescription],29 = [Add to Outpatient Medication Profile],30 = [Continue As and Modify],31 = [Continue as Suspend],32 = [Reorder as Suspend],33 = [Replace with Inpatient Order],34 = [Replace and Suspend],35 = [Discontinue],36 = [Create Prescription As Withhold], 

ReconcileComment 
Definition  PHI: The comment selected from the Comment drop down or entered by the user. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

ActionReason 
Definition  User can enter a reason for the pre-transfer action if the action is DC/Cancel, DC/Reorder or Suspend. 

RequestedByGUID 
Definition  User can select requesting provider and a source for the reconciliation action. 

SourceCode 
Definition  User can select requesting provider and a source for the reconciliation action. 

IsReplaced 
Definition  If the maintenance action is performed on the order that has pre-transfer reconciliation action entered, the reconciliation action will be replaced. The IsReplaced flag will be set to TRUE. Reconciliation action will not be performed when the Pre-Transfer reconciliation is confirmed, but the action will be displayed in the reconciliation document. 

ReplacedWithActionGUID 
Definition  If the maintenance action is performed on the order that has pre-transfer reconciliation action entered, the reconciliation action can be replaced with another reconciliation action. Set the ReplacedWithActionGUID to the GUID of the reconciliation action that replaced this action. This is a foreign key into the table CV3OrderReconcileDtl 

ReplacedReason 
Definition  If the reconciliation action was replaced, system provided reason will be set so that a user knows why this action was performed. 

IsToReconcile 
Definition  Set to TRUE if the outpatient order is to be reconciled (moved to Orders to Reconcile list in the Order Reconciliation manager). 

ReconcileItemType 
Definition  An enumerated type with the following list of possible values: 0 = [Order],1 = [Prescription],2 = [Unsaved Prescription],3 = [Outpatient Order], 

ReviewOnUpdatePendingType 
Definition  An enumerated type with the following list of possible values: 0 = [No review],1 = [Review action not mandatory],2 = [Review action mandatory],3 = [Review action modified and not mandatory],4 = [Review action modified and mandatory],5 = [Review action discontinued and not manda],6 = [Review action discontinued and mandatory], 

ReconciliationProviderGUID 
Definition  Id of the Care Provider that requested the reconciliation. 

ItemSideType 
Definition 
which side of grid (from / to) the item should be displayed 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

SummaryLine 
Definition  Summary Line for order 

OrderStatusCode 
Definition  Status code for order 

TherapeuticCategory 
Definition  Therapeutic category for order 

LastDoseTaken 
Definition  Last Dose Taken 

ItemFlags 
Definition  Bitpacked flags for order 

MultumDrugID 
Definition  Multum drug ID 

FollowUpReason 
Definition  Follow up reason for reconciled item. 

InfoSource 
Definition  Info source for order 

RxStatusType 
Definition  Status type for home med 

OrderSignificantDtm 
Definition  Significant date for order 

OrderStopDtm 
Definition  Stop date for order 

OrderSignificantTime 
Definition  Used for readonly mode to store snapshot of the order.SignificantTime 

OrderStopTime 
Definition  Used for readonly mode to store snapshot of the order.StopTime