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. |
Name |
Definition | The name of the component. |
Dosage |
Definition | The dosage (or lower range of the dosage). |
Uom |
Definition | The unit of measure associated with the dosage. |
SequenceNum |
Definition | The order that this component appears in order review. |
IsTemplate |
Definition | Indicates if this component is associated to a template order. 1 = True; 0 = False. Will be true if ClientGUID is zero |
OrderCatalogMasterItemGUID |
Definition | A foreign key to the GUID column in the CV3OrderCatalogMasterItem table. |
OrderGUID |
Definition | A foreign key to the GUID column in the CV3Order table. |
ClientGUID |
Definition | A foreign key to the GUID column in the CV3Client table. |
DosageTo |
Definition | The upper range of the dosage. |
ConditionDose |
Definition | The dosage text for a variable dose. |
Type |
Definition | An enumerated type with the following list of possible values: 0 = [Additive],1 = [Variable Dose],2 = [Calculated Dose (Not Used)],3 = [AdditiveCalc (Not Used)],4 = [Base Solution],5 = [Non-Formulary Item], |
CalcRequestedDose |
Definition | The dose per unit as specified by the user. For example, 10 mg/m2 (length = length of Cv3Order.Dosage). |
CalcActualDose |
Definition | The actual dose per unit. This is re-calculated from the ordered dose if the user changes it. |
CalcUOMPer |
Definition | Either mg or m2. |
CalcOverrideReason |
Definition | The reason that the calculated or pre-filled dose was changed. |
CalcTotalDailyDose |
Definition | The dose x frequency. |
CalcInfo |
Definition | The string generated by MLM that explains how the dosage was calculated. |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |