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 |
|
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 |