dbo.SXARCMClaimFieldConversion 
Default Table Name  SXARCMClaimFieldConversion 
Definition  This table contains data for all the fields generated in claims. 

dbo.SXARCMClaimFieldConversion Columns 
ColumnName  Domain  Datatype  NULL  Definition 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
ClaimFieldConversionID(PK)    bigint  NO  Primary key 
ClaimID(PK)(FK)    bigint  NO  A foreign key to the ClaimID column in the SXARCMClaim table. 
ClaimFormatLayoutID(FK)    int  NO  A foreign key to the ClaimFormatLayoutID column in the SXARCMClaimFormatLayout table. 
FieldValue    varchar(255)  NO  FieldValue is of ClaimFieldConversion 
CounterID    int  NO  If there are multiple records i.e. segment is repeating then this will be used to represent the sequence number of the repeating segment 
ParentClaimFieldConversionID    bigint  YES  Primary key 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
EpisodeYear(PK)(FK)    int  NO  A foreign key to the EpisodeYear column in the SXARCMClaim table. 

dbo.SXARCMClaimFieldConversion Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMClaimFieldConversionPK  PrimaryKey  ClaimID, EpisodeYear, ClaimFieldConversionID