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