dbo.SXARCMClaimEdit 
Default Table Name  SXARCMClaimEdit 
Definition  This table will store different edits(rules) related to claim. These edits(rules) will be evaluated in order to identify whether there are errors. 

dbo.SXARCMClaimEdit 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. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
ClaimEditID(PK)    int  NO  Auto generated unique primary key value. 
Name    nvarchar(30)  NO  Name of the Claim Edit 
ClaimFormatOption    int  NO  claim format option 
ClaimEditCategoryID(FK)    int  NO  A foreign key to the ClaimEditCategoryID column in the SXARCMClaimEditCategory table. 
ClaimEditSubCategoryID(FK)    int  YES  A foreign key to the ClaimEditSubCategoryID column in the SXARCMClaimEditSubCategory table. 
IsPreBill    bit  NO  Evaluated before the billing request is processed 
IsPrimaryInsuranceEdit    bit  NO  Edit only when Insurance is Primary 
IsSystemDefined    bit  NO  Indicates if the record is system defined 
ShortErrorMessege    nvarchar(250)  YES  Stores Claim Edit Short Error Message 
LongErrorMessege    nvarchar(2000)  YES  Stores Claim Edit Long Error Message 
ClaimSeverityID(FK)    int  NO  A foreign key to the ClaimSeverityID column in the SXARCMClaimSeverity table. 
RuleUID    uniqueidentifier  NO  Pointer to the rule, this rule is evaluate in order to determine whether there is error or not, if the result of the rule is false then it indicates that there is error. 
IsHardCoded    bit  NO  Flag to determine whether the edit definition is defined in SFM code 
BusinessRuleID    bigint  YES  Its stored RuleID for ClaimEdit and referring from SXAVWFRule 
IsExternalDynamic    bit  NO  Used only for external edits, thus default is 0 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
CanOverride    bit  NO  Specifies whether the edit can be overridden in claim correction 

dbo.SXARCMClaimEdit Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMClaimEditPK  PrimaryKey  ClaimEditID