dbo.SXAMMRecipeReport 
Default Table Name  SXAMMRecipeReport 
Definition 
This table contains Recipe's label and worksheet report 

dbo.SXAMMRecipeReport Columns 
ColumnName  Domain  Datatype  NULL  Definition 
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. 
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. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
RecipeReportID(PK)    int  NO  Auto generated unique primary key value. 
RecipeID(FK)    int  YES  A foreign key to the RecipeID column in the SXAMMRecipe table. 
RecipePrepID(FK)    int  YES  A foreign key to the RecipePrepID column in the SXAMMRecipePrep table. 
IsPreview    bit  NO  This column value indicate whether the record is for label preview 
ReportDataType    int  NO  0 = Recipe Label; 1 = Recipe Prep Lable, 2, RecipeWorksheet, 3 = RecipeWorksheetDetail 
RecipeName    varchar(250)  YES  This column holds the name of the recipe 
AlternateName    varchar(250)  YES  This column holds the alternate name of the recipe 
PrepSizeQty    numeric(14, 4)  YES  This column holds the preparation size of the recipe 
PrepUOMCode    varchar(30)  YES  This column holds the unit of measure of the prep size 
PreparationDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - Preparation Date and time 
LotNum    varchar(25)  YES  This column holds the lot number of the recipe 
StorageDescription    varchar(255)  YES  Recipe's storage condition 
ExpDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - Date and time the recipe expired 
ShowPreparedBy    bit  NO  Indicating whether to show the PreparedBy field on labels 
ShowCheckedBy    bit  NO  Indicating whether to show the CheckedBy field on labels 
CustomBarcodeIdentifier    varchar(11)  YES  Recipe's custom barcode 
LabelComment    varchar(75)  YES  This column holds the label comment of the recipe 
FacilityName    varchar(30)  YES  This column holds Facility Name of Pharmacy Location 
StreetAddress    varchar(64)  YES  This column holds the Address of Pharmacy Location 
City    varchar(100)  YES  This column holds the City of Pharmacy Location 
CountryDvsnCode    varchar(30)  YES  This column holds the State/Province of Pharmacy Location 
ZipCode    varchar(15)  YES  This column holds the Zipcode of Pharmacy Location 
PrepQty    int  YES  This column holds the quantity of the recipe 
PreCheckedDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - PreChecked Date and time 
FinalCheckedDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - Date and time the recipe had final check 
EnteredDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - Date and time the recipe was entered 
Expiration    varchar(9)  YES  This column holds the expiration period of the recipe - Example 30 days or 5 hours 
EnteredBy    HVCIDdt  YES  This column holds the user GUID of a user who entered the recipe 
PreparedBy    HVCIDdt  YES  This column holds the user GUID of a user who prepared the recipe 
PreCheckedBy    HVCIDdt  YES  This column holds the user GUID of a user who prechecked the recipe 
FinalCheckedBy    HVCIDdt  YES  This column holds the user GUID of a user who final-checked the recipe 
PhoneNumber    varchar(40)  YES  This column holds the Phone Number of Pharmacy Location 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAMMRecipeReport Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMRecipeReportPK  PrimaryKey  RecipeReportID