dbo.SXARCMERCalculationDetail 
Default Table Name  SXARCMERCalculationDetail 
Definition  Represents expected reimbursement calculation details 

dbo.SXARCMERCalculationDetail 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. 
CalculationDetailID(PK)    bigint  NO  Auto generated unique primary key value. 
MethodTypeID    int  NO  Represents calculation selected method type 
QualifiedOnDate    varchar(50)  YES  Represents calculation's qualified on date. 
IsFinalCalculation    bit  NO  Represents if final calculation results or not 
FlowThruAmount    SXACurrencyDt  NO  Represents the calculated Flow Thru amount 
PRAmount    SXACurrencyDt  NO  Represents the calculated Patient responsibility amount 
ReimbursementMethodDetailID(FK)    int  YES  A foreign key to the ReimbursementMethodDetailID column in the SXARCMEReimbursementMethodDetail table. 
CalculationID(FK)    bigint  YES  A foreign key to the CalculationID column in the SXARCMERCalculation table. 
ReimbursementAmount    SXACurrencyDt  NO  Expected reimbursement amount. 
TotalCoveredAmount    SXACurrencyDt  NO  Expected reimbursement total covered amount. 
IsException    int  NO  Was exception method used for expected reimbursement calculation. 
IsStoploss    int  NO  Was stop loss used. 
AddOnAmount    SXACurrencyDt  NO  Expected reimbursement add on amount. 
WithHoldAmount    SXACurrencyDt  NO  Expected reimbursement withhold amount. 
TotalReimbursementAmount    SXACurrencyDt  NO  saves the total reimbursement amount. 
BenefitExcess    SXACurrencyDt  NO  Represents benefit excess which is total er amount - remaining benefits 
WriteOffBasedOnAllowedAmount    SXACurrencyDt  NO  It store amount allowed based on off 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXARCMERCalculationDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMERCalculationDetailPK  PrimaryKey  CalculationDetailID