dbo.SXAMMGenericItem 
Default Table Name  SXAMMGenericItem 
Definition  This entity contains information about a Generic Item. A Generic Item is a child of a Drug. A Generic Item has Strength, Route and Form attributes to further define the Drug. An example of a Generic Item is Ibuprofen 200mg Oral Tablet and Ibuprofen 400mg
This Table holds the records of table generic item 

dbo.SXAMMGenericItem Columns 
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. 
GenericItemID(PK)    int  NO  Auto generated unique primary key value. 
DrugID(FK)    int  NO  A foreign key to the DrugID column in the SXAMMDrug table. 
GenericItemName    varchar(250)  NO  Identifies the name of the Generic Item. Ie. Ibuprofen 
StrengthDesc    varchar(250)  NO  Identifies the strength of the generic item. ie. 325 mg. 
MedicationFormCode    varchar(30)  NO  Identifies the Dosage/Medication Form of the Generic Item. Ie. Tablet Capsule etc. 
IsRestrictedRoute    bit  NO  Identifies the Generic Item has a Restricted Route. 
IsKBAScanRequired    bit  NO  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    bit  NO  Identifies if the route must be verified when administration is performed. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
IsCombination    bit  NO  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    int  YES  An enumerated type with the following list of possible values: 0 = [Internal],1 = [External], 
TherapeuticClassID(FK)    int  YES  A foreign key to the TherapeuticClassID column in the SXAMMTherapeuticClass table. 
IsSolution    bit  NO  Identifies if the generic item is considered a solution. 
IsAdditive    bit  NO  Identifies if the generic item is considered an additive. 
OrderUOMCode    varchar(30)  YES  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    varchar(30)  YES  Identifies the Unit Of Measure that is to be used when displaying information during Screening. Links to the CV3UnitOfMeasure table via the Code. 
AdminUOMCode    varchar(30)  YES  Identifies the Unit Of Measure that is to be used when displaying information during Administration. Links to the CV3UnitOfMeasure table via the Code. 
CompoundSubClassID(FK)    int  YES  A foreign key to the CompoundSubClassID column in the SXAMMCompoundSubClass table. 
CompoundCalcType    int  YES  An enumerated type with the following list of possible values: 0 = [Percent],1 = [Units], 
PreparationInstructionNote    varchar(2000)  YES  Identifies any preparation instructions for the generic item. 
SpecialInstructionNote    varchar(2000)  YES  Identifies any special instructions in relation to the generic item 
IsInvestigational    bit  NO  Identifies if the generic item is investigational 
PreferredSolutionGenericItemID(FK)    int  YES  A foreign key to the GenericItemID column in the SXAMMGenericItem table. 
AutoSubGenericItemID(FK)    int  YES  A foreign key to the GenericItemID column in the SXAMMGenericItem table. 
LegalStatusType    int  YES  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    bit  NO  Identifies if the Generic Item is restricted 
AutoSubstitutionEffectiveDtm    datetime  YES  Facility TimeZone - Identifies the date and time that the auto-substitution policy is effective from 
AutoSubstitutionPolicyDesc    varchar(1000)  YES  Identifies the policy description for the auto-substitution policy. 
AutoSubstitutionAutoAlert    bit  NO  Identifies if there is an auto-alert for the substitution policy 
IsNarcotic    bit  NO  Identifies if the Generic Item is a narcotic 
IsControlled    bit  NO  Identifies if the Generic Item is controlled 
DispenseSubTypeID(FK)    int  YES  A foreign key to the DispenseSubTypeID column in the SXAMMDispenseSubType table. 
ReportField1    varchar(100)  YES  Identifies additional information that the user may use to classify the generic item; these fields would be used on reports. 
ReportField2    varchar(100)  YES  Identifies additional information that the user may use to classify the generic item; these fields would be used on reports. 
ReportField3    varchar(100)  YES  Identifies additional information that the user may use to classify the generic item; these fields would be used on reports. 
DrugCatalogKey    varchar(40)  YES  Identifies the drug catalog key (multum key) associated with this row. 
UpdateFromCatalog    bit  NO  Indicates whether attributes from this row can be update using the Drug Catalog Import process 
BillingUOMCode    varchar(30)  YES  Identifies the default UOM which will be used by Billing to create the contents of the HL7 Financial Transaction. 
SoftStopPeriod    numeric(5, 0)  YES  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    varchar(30)  YES  Identifies the unit of measure for the Soft Stop Period; valid values include: hours and days. 
DispensingContainerID(FK)    int  YES  A foreign key to the DispensingContainerID column in the SXAMMDispensingContainer table. 
ADMUOMCode    varchar(30)  YES  Identifies the UOM which will be used to communicate to the ADM. 
AutoSubstitutionMnemonicID(FK)    int  YES  A foreign key to the MnemonicID column in the SXAMMMnemonic table. 
DefaultMnemonicID(FK)    int  YES  A foreign key to the MnemonicID column in the SXAMMMnemonic table. 
IsRegular    bit  NO  Identifies if the Generic Item can be ordered for a regular order 
IsLVP    bit  NO  Identifies if the Generic Item can be ordered for an LVP order 
IsIVPB    bit  NO  Identifies if the Generic Item can be ordered for an IVPB order 
IsNonFormulary    bit  NO  This field will be used to indicate that the Generic Item is a non-formulary item 
IsNonFormularyBillable    bit  NO  This field will be used to indicate that the Generic Item is a non-formulary billable item 
CanPrintCompoundLabel    bit  NO  This column holds the property "Print Compound Label" 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
RxNormCode    varchar(20)  YES  The RxNorm code for the Generic Item 

dbo.SXAMMGenericItem Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMGenericItemPK  PrimaryKey  GenericItemID