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. |
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. |
OrderID |
|
bigint |
NO |
Auto generated unique primary key value. |
OrderGUID |
|
HVCIDdt |
NO |
A foreign key to the GUID column in the CV3Order table. |
OrderDesc |
|
varchar(2000) |
NO |
Identifies the description of the order. |
OrderNum |
|
varchar(40) |
NO |
Identifies the Order Number. May be used for linking the RxOrder to an Order in an external Pharmacy Module |
MSrepl_tran_version |
|
uniqueidentifier |
NO |
Optimistic lock identifier. |
DispenseSubTypeID |
|
int |
YES |
A foreign key to the DispenseSubTypeID column in the SXAMMDispenseSubType table. |
OrderSetID |
|
int |
YES |
A foreign key to the OrderSetID column in the SXAMMOrderSet table. |
PrintOnMAR |
|
bit |
NO |
Identifies if the Order should be printed on the MAR. |
IsTitrate |
|
bit |
NO |
Titrating deals with creating solutions – as in some powder dissolved in some liquid. |
IsPatientOwned |
|
bit |
NO |
Patient owns the medication - no dispensing will be performed |
PerfectedByGUID |
|
HVCIDdt |
YES |
User who perfected the order (will be NULL if smart selected) |
IsPerfected |
|
bit |
NO |
Smart Selection or Pharmacist have defined required order option components. |
VerifiedByGUID |
|
HVCIDdt |
YES |
User who MM verified the order |
VerifiedDtm |
|
datetime |
YES |
Visit TimeZone - Identifies the date/time the Order Version was Pharmacy Verified. |
IsFreeText |
|
bit |
NO |
Drug does not exist in drug catalog |
TherapeuticClassID |
|
int |
YES |
A foreign key to the TherapeuticClassID column in the SXAMMTherapeuticClass table. |
SmartSelectionProcessingNotes |
|
varchar(4000) |
YES |
Identifies notes that are processed and put together by Smart Selection. These notes are to be used when attempting to identify the business processing/rules that occurred when Smart Selection processed Order. |
HasBeenVerified |
|
bit |
NO |
Flag indicating that the order has been verified |
IsTPN |
|
bit |
NO |
Identifies if the order is a TPN. |
IsQuickCharge |
|
bit |
YES |
Flag to indicate that the order is for a quick charge |
IsNonFormulary |
|
bit |
YES |
This field will be used to indicate if the order placed was a non-formulary order |
IsOnDemand |
|
bit |
YES |
Indicator that the order is On Demand |
FillQtyOriginType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [Calculated],1 = [Manual],2 = [PolicyOnDemand],3 = [PolicyOverride], |
FillQty |
|
numeric(14, 4) |
YES |
Fill Quantity either manually entered or the result of a Dispensing Policy Detail |
DispensingPolicyDetailID |
|
int |
YES |
A foreign key to the DispensingPolicyDetailID column in the SXAMMDispensingPolicyDetail table. |
CanPrintPrepLabel |
|
bit |
NO |
This column indicates if Prep Label will be printed for the order |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
IsNonPharmacyOrder |
|
bit |
NO |
Indicates whether an order is/was fulfilled/serviced by a hospital pharmacy |