dbo.SXAMMRecipePrep 
Default Table Name  SXAMMRecipePrep 
Definition  This table is used to hold manufacturing data while preparing recipe 

dbo.SXAMMRecipePrep 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. 
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. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated 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. 
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. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
RecipePrepID(PK)    int  NO  Auto generated unique primary key value. 
RecipeID(FK)    int  NO  A foreign key to the RecipeID column in the SXAMMRecipe table. 
LocationID    bigint  YES  This column holds foreign key reference to LocationID table of SXAINVLocation table 
PrepQty    int  NO  This column holds the prep quantity for recipe preparation 
LotNum    varchar(25)  YES  This column holds the lot number for recipe preparation 
EnteredBy    HVCIDdt  NO  This column holds the user guid of the person which initiated the recipe preparation 
ExpDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - This column holds the expiration date of the recipe preparation 
StatusType    int  YES  This column holds the enum value of the status of the preparation 
StatusReason    varchar(75)  YES  This column holds the reason for status changes 
PrepBy    HVCIDdt  YES  This column holds the user guid of the person who prepared the recipe 
PreCheckBy    HVCIDdt  YES  This column holds the user guid of the person who did precheck of the recipe 
FinalCheckBy    HVCIDdt  YES  This column holds the user guid of the person who did final check of the recipe 
PreparationDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - This column holds the datetime of when the recipe was prepared 
PrecheckedDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - This column holds the datetime of when the recipe was prechecked 
FinalCheckedDateTimeUTC    datetimeoffset(3)  YES  Facility TimeZone - This column holds the datetime of when the recipe was final checked 
IsExpTimeSet    bit  NO  This column indicates if the Expiration Time set 
MasterItemId    int  YES  This column holds the inventory item identifier with which the recipe is tracked in inventory 
PrepSizeQty    numeric(14, 4)  YES  This column holds the quantity of single preparation using the recipe 
PrepUOMCode    varchar(30)  YES  This column holds the unit of measure of the recipe 
CustomBarcodeIdentifier    varchar(11)  YES  Recipe's custom barcode 
ExpirationUnitValue    int  YES  This column holds the expiration value of the recipe 
ExpirationUOMCode    int  YES  This column holds the expiration unit of measure (days, hours, months) 
ShowOnManufQueue    bit  NO  This column indicates whether the recipe needs to be sent to manuf queue when being prepared 
IsPreChkRequired    bit  NO  This column indicates whether the recipe needs to be prechecked when being prepared 
WLPrepareUnits    numeric(9, 2)  YES  This columns indicates the workload units to be assigned for preparing this recipe 
WLPreCheckUnits    numeric(9, 2)  YES  This columns indicates the workload units to be assigned for precheck of this recipe 
WLFinalCheckUnits    numeric(9, 2)  YES  This columns indicates the workload units to be assigned for final check of this recipe 
StorageConditionID    int  YES  This column holds the foreign key ref to SXAMMStorageCondition Table 
LocationGUID    HVCIDdt  YES  Stores location of the preparation. 
Notes    varchar(75)  YES  Holds any notes user might enter for the recipe prep 
IsPatientSpecific    bit  NO  Indicates whether the recipe is patient specific 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAMMRecipePrep Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMRecipePrepPK  PrimaryKey  RecipePrepID