dbo.SXAMMDispensingPolicyDetail 
Default Table Name  SXAMMDispensingPolicyDetail 
Definition  Stores configuration for each Pharmacy Dispensing Policy 

dbo.SXAMMDispensingPolicyDetail 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. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
DispensingPolicyDetailID(PK)    int  NO  Auto generated unique primary key value. 
DispensingPolicyID(FK)    int  NO  A foreign key to the DispensingPolicyID column in the SXAMMDispensingPolicy table. 
FacilityGUID    HVCIDdt  NO  Facility Dispensing Policy is for 
LocationFunctionGroupGUID    HVCIDdt  YES  Location Function Group for the location where the Policy Detail applies. 
LocationGroupGUID    HVCIDdt  YES  Location Group for the location where the Policy Detail applies. The Dispensing Policy Detail must have either the LocationFunctionGroupGUID or the LocationGroupGUID entered. 
IsOnDemand    bit  NO  Indicate Policy is for On Demand 
OnDemandInitDispenseQty    int  YES  Default Init Dispense Quantity 
OnDemandFillQty    int  YES  Default Fill Quantity 
IsPRNOnly    bit  NO  Indicate Policy is for PRN orders 
IsOverrideDispense    bit  NO  Indicate Policy is for Override Orders 
OverrideInitDispenseQty    int  YES  Default Init Dispense Quantity 
OverrideFillQty    int  YES  Default Fill Quantity 
AutoPrintLabel    bit  NO  bit to automatically print the On Demand label 
PrintAdminTime    bit  NO  Includes Admin Times on label 
HasLockoutInterval    bit  NO  Indicates if the policy has an associated lockout interval 
LockoutValue    int  YES  Lockout time 
LockoutUOMCode    varchar(30)  YES  Indicates the lockout time UOM 
LockoutMinutes    int  YES  Lockout time converted to minutes 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
BillForRxType    int  YES  An enumerated type with the following list of possible values: 0 = [Not Billed],1 = [IP Charge Algorithm],2 = [OP Charge Algorithm],3 = [Manual Entry], 
IncludeNarcoticMeds    bit  NO  flag indicating whether Narcotic meds should be included for LOA orders 
IncludeControlledMeds    bit  NO  flag indicating whether Controlled meds should be included for LOA orders 
StartDayType    int  YES  An enumerated type with the following list of possible values: 0 = [Sunday],1 = [Monday],2 = [Tuesday],3 = [Wednesday],4 = [Thursday],5 = [Friday],6 = [Saturday], 
StartTime    smallint  YES  Stores start time of a LOA policy (smallint datatype to be consistent with SXAMMPharmacyHours OpenTime column) 
ReturnDayType    int  YES  An enumerated type with the following list of possible values: 0 = [Sunday],1 = [Monday],2 = [Tuesday],3 = [Wednesday],4 = [Thursday],5 = [Friday],6 = [Saturday], 
ReturnTime    smallint  YES  Stores return time of a LOA policy (smallint datatype to be consistent with SXAMMPharmacyHours CloseTime column) 
OrderStateType    int  YES  An enumerated type with the following list of possible values: 0 = [Suspend Meds],2 = [Do Not Suspend Meds], 
SuspendReasonCode    varchar(30)  YES  Stores reason code from CV3CodedReason 
OrderFormMessage    varchar(2000)  YES  Stores additional notes/instructions to be displayed on Leave Of Absence order form 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAMMDispensingPolicyDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAMMDispensingPolicyDetailPK  PrimaryKey  DispensingPolicyDetailID