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 |
|
int |
NO |
Auto generated unique primary key value. |
RecipeID |
|
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. |