SiteID |
Definition | Identifies the unique distributed database ID where the row was inserted. 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. |
GenericItemID |
Definition | Auto generated unique primary key value. |
DrugID |
Definition | A foreign key to the DrugID column in the SXAMMDrug table. |
GenericItemName |
Definition | Identifies the name of the Generic Item. Ie. Ibuprofen |
StrengthDesc |
Definition | Identifies the strength of the generic item. ie. 325 mg. |
MedicationFormCode |
Definition | Identifies the Dosage/Medication Form of the Generic Item. Ie. Tablet Capsule etc. |
IsRestrictedRoute |
Definition | Identifies the Generic Item has a Restricted Route. |
IsKBAScanRequired |
Definition | Identifies if the user is allowed to ignore the scan requirement or will be required to enter an override reason when administering the item without scanning. |
VerifyRouteOnAdmin |
Definition | Identifies if the route must be verified when administration is performed. |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
IsCombination |
Definition | Identifies if the generic item is considered a combination drug. If the Generic Item contains two or more active medicinal ingredients it would be identified as Combination. |
CombinationType |
Definition | An enumerated type with the following list of possible values: 0 = [Internal],1 = [External], |
TherapeuticClassID |
Definition | A foreign key to the TherapeuticClassID column in the SXAMMTherapeuticClass table. |
IsSolution |
Definition | Identifies if the generic item is considered a solution. |
IsAdditive |
Definition | Identifies if the generic item is considered an additive. |
OrderUOMCode |
Definition | Identifies the Unit Of Measure that is to be used when displaying information during Order Entry. Links to the CV3UnitOfMeasure table via the Code. |
ScreeningUOMCode |
Definition | Identifies the Unit Of Measure that is to be used when displaying information during Screening. Links to the CV3UnitOfMeasure table via the Code. |
AdminUOMCode |
Definition | Identifies the Unit Of Measure that is to be used when displaying information during Administration. Links to the CV3UnitOfMeasure table via the Code. |
CompoundSubClassID |
Definition | A foreign key to the CompoundSubClassID column in the SXAMMCompoundSubClass table. |
CompoundCalcType |
Definition | An enumerated type with the following list of possible values: 0 = [Percent],1 = [Units], |
PreparationInstructionNote |
Definition | Identifies any preparation instructions for the generic item. |
SpecialInstructionNote |
Definition | Identifies any special instructions in relation to the generic item |
IsInvestigational |
Definition | Identifies if the generic item is investigational |
PreferredSolutionGenericItemID |
Definition | A foreign key to the GenericItemID column in the SXAMMGenericItem table. |
AutoSubGenericItemID |
Definition | A foreign key to the GenericItemID column in the SXAMMGenericItem table. |
LegalStatusType |
Definition | An enumerated type with the following list of possible values: 0 = [0 - Drug not subject to Controlled Subst],1 = [1 - No current medical use],2 = [2 - High potential for abuse],3 = [3 - Some potential for abuse],4 = [4 - Low potential for abuse],5 = [5 - Subject to state/local regulation], |
IsRestricted |
Definition | Identifies if the Generic Item is restricted |
AutoSubstitutionEffectiveDtm |
Definition | Facility TimeZone - Identifies the date and time that the auto-substitution policy is effective from |
AutoSubstitutionPolicyDesc |
Definition | Identifies the policy description for the auto-substitution policy. |
AutoSubstitutionAutoAlert |
Definition | Identifies if there is an auto-alert for the substitution policy |
IsNarcotic |
Definition | Identifies if the Generic Item is a narcotic |
IsControlled |
Definition | Identifies if the Generic Item is controlled |
DispenseSubTypeID |
Definition | A foreign key to the DispenseSubTypeID column in the SXAMMDispenseSubType table. |
ReportField1 |
Definition | Identifies additional information that the user may use to classify the generic item; these fields would be used on reports. |
ReportField2 |
Definition | Identifies additional information that the user may use to classify the generic item; these fields would be used on reports. |
ReportField3 |
Definition | Identifies additional information that the user may use to classify the generic item; these fields would be used on reports. |
DrugCatalogKey |
Definition | Identifies the drug catalog key (multum key) associated with this row. |
UpdateFromCatalog |
Definition | Indicates whether attributes from this row can be update using the Drug Catalog Import process |
BillingUOMCode |
Definition | Identifies the default UOM which will be used by Billing to create the contents of the HL7 Financial Transaction. |
SoftStopPeriod |
Definition | Identifies the period of time after the stop date of the order that the pharmacist will continue to dispense meds (for orders that require review and have not been reviewed). |
SoftStopPeriodUOMCode |
Definition | Identifies the unit of measure for the Soft Stop Period; valid values include: hours and days. |
DispensingContainerID |
Definition | A foreign key to the DispensingContainerID column in the SXAMMDispensingContainer table. |
ADMUOMCode |
Definition | Identifies the UOM which will be used to communicate to the ADM. |
AutoSubstitutionMnemonicID |
Definition | A foreign key to the MnemonicID column in the SXAMMMnemonic table. |
DefaultMnemonicID |
Definition | A foreign key to the MnemonicID column in the SXAMMMnemonic table. |
IsRegular |
Definition | Identifies if the Generic Item can be ordered for a regular order |
IsLVP |
Definition | Identifies if the Generic Item can be ordered for an LVP order |
IsIVPB |
Definition | Identifies if the Generic Item can be ordered for an IVPB order |
IsNonFormulary |
Definition | This field will be used to indicate that the Generic Item is a non-formulary item |
IsNonFormularyBillable |
Definition | This field will be used to indicate that the Generic Item is a non-formulary billable item |
CanPrintCompoundLabel |
Definition | This column holds the property "Print Compound Label" |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
RxNormCode |
Definition | The RxNorm code for the Generic Item |