dbo.SXARxProduct 
Default Table Name  SXARxProduct 
Definition  This table holds the actual products that can be ordered from pharmacy. 

dbo.SXARxProduct 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. 
ProductID(PK)    int  NO  Auto generated unique primary key value. 
NDC    char(20)  NO  The national drug code, unique to manufacturer, generic item, and package size. It can be used to identify the product in the drug vendor's database. 
BrandName    varchar(255)  NO  The name by which the product is known 
GenericItemID(FK)    int  NO  A foreign key to the GenericItemID column in the SXARxGenericItem table. 
ManufacturerID(FK)    int  YES  A foreign key to the ManufacturerID column in the SXARxManufacturer table. 
InnerPackageSize    numeric(15, 3)  NO  inner package size 
InnerPackageSizeUOMID(FK)    int  YES  A foreign key to the RxUOMID column in the SXARxUnitOfMeasure table. 
OuterPackageSize    numeric(15, 3)  YES  outer packaging size 
IsUnitDose    bit  NO  An indicator whether this product is packaged for unit dose 
IsRepackaged    bit  NO  An indicator whether this product is repackaged from a product by another manufacturer 
AWP    numeric(10, 2)  NO  Average wholesale price. This usually drives what the hospital charges for the drug. 
ObsoleteDate    datetime  YES  Enterprise TimeZone - The date when this product is no longer available from the manufacturer 
IsMultidose    bit  NO  An indicator whether this product is a multi dose package 
IsOTC    bit  NO  A Indicator whether this product is available to the general public (over the counter) 
OrangeBookCode(FK)    char(2)  NO  A foreign key to the OrangeBookCode column in the SXARxOrangeBook table. 
DrugCatalogKey    varchar(255)  YES  The unique identifier for this data in the drug vendor`s database. This is the NDC code. 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXARxProduct Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARxProductPK  PrimaryKey  ProductID