Where is the Claim Data Held?

1: [dbo].[Claims] table contains this information.\
– The required fileld is: ClientClaimID\
– Mailmerge Field – With the client ref: ClaimDetailsClaimRef – Without the client ref: ClaimDetailsClientClaimID

2: [dbo].[Claims] table contains this information.\
– The required fileld is: AlternativeRef\
– Mailmerge Field – ClaimDetailsAlternativeRef

3: [dbo].[Contacts] table contains this information.\
– Link from [dbo].[Claims].[BankID] to [dbo].[Banks].[ID}\
– Link from [dbo].[Banks].[ContactID} to [dbo].[Contacts].[ID}\
– The required fileld is: CompanyName\
– Mailmerge Field – ClaimDetailsBankName

4: [dbo].[Contacts] table contains this information.\
– Link from [dbo].[Claims].[BranchID] to [dbo].[Banks].[ID}\
– Link from [dbo].[Banks].[ContactID} to [dbo].[Contacts].[ID}\
– The required fileld is: CompanyName\
– Mailmerge Field – ClaimDetailsBranchName

5: This is held in 2 bits.\
a: Claim Type\
[dbo].[MatterTypes] table contains this information.\
– Link from [dbo].[Claims].[MatterTypeID] to [dbo].[MaterTypes].[ID}\
– Mailmerge Field – ClaimDetailsClaimTypeDescription\
b: Rate\
[dbo].[MatterTypeRates] table contains this information.\
– Link from [dbo].[Claims].[MatterTypeRateID] to [dbo].[MaterTypeRates].[ID}\
– Mailmerge Field – ClaimDetailsourCommissionPercentage

6: [dbo].[Claims] table contains this information.\
– The required fileld is: AccountNumber\
– Mailmerge Field – ClaimDetailsAccountNumber

7: [dbo].[Claims] table contains this information.\
– The required fileld is: AccountName\
– Mailmerge Field – ClaimDetailsAccountName

8: [dbo].[Claims] table contains this information.\
– The required fileld is: BankRef\
– Mailmerge Field – ClaimDetailsBankRef

9: [dbo].[Statuses] table contains this information.\
– Link from [dbo].[Claims].[StatusID] to [dbo].[Statuses].[ID}\
– The required fileld is: Description\
– Mailmerge Field – ClaimDetailsStatusDescription

10: [dbo].[Claims] table contains this information.\
– The required fileld is: PurposeOfLoan\
– Mailmerge Field – ClaimDetailsPurposeOfLoan