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 |
|
int |
NO |
Auto generated unique primary key value. |
RecipeID |
|
int |
YES |
A foreign key to the RecipeID column in the SXAMMRecipe table. |
RecipePrepID |
|
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. |