dbo.CV3OrderReconcileDtl 
Default Table Name  CV3OrderReconcileDtl 
Definition  Contains Order reconciliation details. Each row represents an action taken on an order during a particular reconciliation 

dbo.CV3OrderReconcileDtl Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  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)  NO  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  NO  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  NO  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  NO  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. 
ReconcileGUID    HVCIDdt  NO  Link to GUID column of the CV3OrderReconcile table. 
OrderGUID    HVCIDdt  NO  The GUID of an order that was actioned during the order reconciliation. 
OrderVisitType    int  NO  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    int  NO  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    varchar(2000)  YES  PHI: The comment selected from the Comment drop down or entered by the user. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
ActionReason    varchar(200)  YES  User can enter a reason for the pre-transfer action if the action is DC/Cancel, DC/Reorder or Suspend. 
RequestedByGUID    HVCIDdt  YES  User can select requesting provider and a source for the reconciliation action. 
SourceCode    varchar(30)  YES  User can select requesting provider and a source for the reconciliation action. 
IsReplaced    bit  NO  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    HVCIDdt  YES  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    varchar(200)  YES  If the reconciliation action was replaced, system provided reason will be set so that a user knows why this action was performed. 
IsToReconcile    bit  NO  Set to TRUE if the outpatient order is to be reconciled (moved to Orders to Reconcile list in the Order Reconciliation manager). 
ReconcileItemType    int  YES  An enumerated type with the following list of possible values: 0 = [Order],1 = [Prescription],2 = [Unsaved Prescription],3 = [Outpatient Order], 
ReviewOnUpdatePendingType    int  YES  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    HVCIDdt  YES  Id of the Care Provider that requested the reconciliation. 
ItemSideType    int  YES 
which side of grid (from / to) the item should be displayed 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
SummaryLine    varchar(4000)  YES  Summary Line for order 
OrderStatusCode    varchar(5)  YES  Status code for order 
TherapeuticCategory    varchar(255)  YES  Therapeutic category for order 
LastDoseTaken    varchar(1000)  YES  Last Dose Taken 
ItemFlags    int  YES  Bitpacked flags for order 
MultumDrugID    varchar(255)  YES  Multum drug ID 
FollowUpReason    varchar(100)  YES  Follow up reason for reconciled item. 
InfoSource    varchar(2050)  YES  Info source for order 
RxStatusType    int  YES  Status type for home med 
OrderSignificantDtm    datetime  YES  Significant date for order 
OrderStopDtm    datetime  YES  Stop date for order 
OrderSignificantTime    varchar(30)  YES  Used for readonly mode to store snapshot of the order.SignificantTime 
OrderStopTime    varchar(30)  YES  Used for readonly mode to store snapshot of the order.StopTime 

dbo.CV3OrderReconcileDtl Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderReconcileDtlPK  PrimaryKey  GUID