Build 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

DispensingPolicyDetailID 
Definition  Auto generated unique primary key value. 

DispensingPolicyID 
Definition  A foreign key to the DispensingPolicyID column in the SXAMMDispensingPolicy table. 

FacilityGUID 
Definition  Facility Dispensing Policy is for 

LocationFunctionGroupGUID 
Definition  Location Function Group for the location where the Policy Detail applies. 

LocationGroupGUID 
Definition  Location Group for the location where the Policy Detail applies. The Dispensing Policy Detail must have either the LocationFunctionGroupGUID or the LocationGroupGUID entered. 

IsOnDemand 
Definition  Indicate Policy is for On Demand 

OnDemandInitDispenseQty 
Definition  Default Init Dispense Quantity 

OnDemandFillQty 
Definition  Default Fill Quantity 

IsPRNOnly 
Definition  Indicate Policy is for PRN orders 

IsOverrideDispense 
Definition  Indicate Policy is for Override Orders 

OverrideInitDispenseQty 
Definition  Default Init Dispense Quantity 

OverrideFillQty 
Definition  Default Fill Quantity 

AutoPrintLabel 
Definition  bit to automatically print the On Demand label 

PrintAdminTime 
Definition  Includes Admin Times on label 

HasLockoutInterval 
Definition  Indicates if the policy has an associated lockout interval 

LockoutValue 
Definition  Lockout time 

LockoutUOMCode 
Definition  Indicates the lockout time UOM 

LockoutMinutes 
Definition  Lockout time converted to minutes 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

BillForRxType 
Definition  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 
Definition  flag indicating whether Narcotic meds should be included for LOA orders 

IncludeControlledMeds 
Definition  flag indicating whether Controlled meds should be included for LOA orders 

StartDayType 
Definition  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 
Definition  Stores start time of a LOA policy (smallint datatype to be consistent with SXAMMPharmacyHours OpenTime column) 

ReturnDayType 
Definition  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 
Definition  Stores return time of a LOA policy (smallint datatype to be consistent with SXAMMPharmacyHours CloseTime column) 

OrderStateType 
Definition  An enumerated type with the following list of possible values: 0 = [Suspend Meds],2 = [Do Not Suspend Meds], 

SuspendReasonCode 
Definition  Stores reason code from CV3CodedReason 

OrderFormMessage 
Definition  Stores additional notes/instructions to be displayed on Leave Of Absence order form 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.