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. |
MnemonicComponentDoseID |
|
int |
NO |
Auto generated unique primary key value. |
MnemonicComponentID |
|
int |
NO |
A foreign key to the MnemonicComponentID column in the SXAMMMnemonicComponent table. |
DoseNum |
|
numeric(14, 4) |
YES |
Identifies the Dose that is to be administered for this Component. |
MaxDoseNum |
|
numeric(14, 4) |
YES |
Identifies the Maximum Dose that is to be administered (only used for PRN Orders). |
DoseUOMCode |
|
varchar(30) |
YES |
Identifies the Unit of Measure associated with the Dose Number and Max Dose Number.
,Links to the CV3UnitOfMeasure table via Code. |
WeightSurfaceAreaDoseType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [kg],1 = [kg (ideal)],2 = [kg (adjusted)],3 = [m2],4 = [m2 (ideal)],5 = [m2 (adjusted)],6 = [Flat Dose],7 = [AUC (Cockcroft-Gault adjusted)],8 = [AUC (Cockcroft-Gault ideal)],9 = [AUC (Cockcroft-Gault)],10 = [AUC (Jelliffe adjusted)],11 = [AUC (Jelliffe ideal)],12 = [AUC (Jelliffe no BSA)],13 = [AUC (Jelliffe)],14 = [AUC (measured CrCl)],15 = [AUC (St. Jude's modified-Peds)], |
ConditionDesc |
|
varchar(255) |
YES |
Identifies the condition that a variable dose is being entered for.
Example, some generic items may have different doses depending on the patient's blood pressure or blood sugar level. |
FromValue |
|
numeric(14, 4) |
YES |
Identifies the low value for the specified Condition (includes the unit of measure, if applicable) |
ToValue |
|
numeric(14, 4) |
YES |
Identifies the high value for the specified Condition (includes the unit of measure, if applicable) |
CallPhysicianForDose |
|
bit |
NO |
Identifies if the physician must be called for the dose, given a particular condition. |
MSrepl_tran_version |
|
uniqueidentifier |
NO |
Optimistic lock identifier. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |