Skip to content

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