Where is the Contact Data Held?

1: [dbo].[Contacts] table contains this information.
 - link from [dbo].[Claims].[ContactID] to [dbo].[Contacts].[ID]
 - The required fields are: Title, FirstName, MiddleName, LastName.
 - MailMerge fields are: ClientContactTitle, ClientContactFirstName, ClientContactMiddleName, ClientContactLastName.

2: Current Tab
   [dbo].[Contacts] table contains this information.
 - link from [dbo].[Claims].[ContactID] to [dbo].[Contacts].[ID]
 - The required fields are: Address1, Address2, Address3, Address4, Address5, Address6, Address7, Address8, PCD
 - MailMerge fields are: ClientContactAddress1, ClientContactAddress2, ClientContactAddress3, ClientContactAddress4, ClientContactAddress5, ClientContactAddress6,
                                  ClientContactAddress7, ClientContactAddress8, ClientContactPCD
   Old Tab
   [dbo].[Contacts] table contains this information.
 - link from [dbo].[Claims].[ContactID] to [dbo].[Contacts].[ID]
 - The required fields are: PreviousAddress1, PreviousAddress2, PreviousAddress3, PreviousAddress4, PreviousAddress5, PreviousAddress6, PreviousAddress7, PreviousAddress8,
                                     PreviousAddressPCD
 - MailMerge fields are: ClientContactPreviousAddress1, ClientContactPreviousAddress2, ClientContactPreviousAddress3, ClientContactPreviousAddress4, ClientContactPreviousAddress5,
                                  ClientContactPreviousAddress6, ClientContactPreviousAddress7, ClientContactPreviousAddress8, ClientContactPreviousAddressPCD
   Old2 Tab
   [dbo].[Addresses] table contains this information.
 - link from [dbo].[Claims].[ContactID] to [dbo].[ContactAddresses].[ContactID] where AddressTypeID = 1
 - link from [dbo].[ContactAddresses].[AddressID] to [dbo].[Addresses].[ID]
 - The required fields are: Address1, Address2, Address3, Address4, Address5, Address6, Address7, Address8, PCD
 - MailMerge fields are: ClientContactPrev2Address1, ClientContactPrev2Address2, ClientContactPrev2Address3, ClientContactPrev2Address4, ClientContactPrev2Address5,
                                  ClientContactPrev2Address6, ClientContactPrev2Address7, ClientContactPrev2Address8, ClientContactPrev2PCD
   Old3 Tab
   [dbo].[Addresses] table contains this information.
 - link from [dbo].[Claims].[ContactID] to [dbo].[ContactAddresses].[ContactID] where AddressTypeID = 2
 - link from [dbo].[ContactAddresses].[AddressID] to [dbo].[Addresses].[ID]
 - The required fields are: Address1, Address2, Address3, Address4, Address5, Address6, Address7, Address8, PCD
 - MailMerge fields are: ClientContactPrev3Address1, ClientContactPrev3Address2, ClientContactPrev3Address3, ClientContactPrev3Address4, ClientContactPrev3Address5,
                                  ClientContactPrev3Address6, ClientContactPrev3Address7, ClientContactPrev3Address8, ClientContactPrev3PCD

3: [dbo].[Contacts] table contains this information.
 - link from [dbo].[Claims].[ContactID] to [dbo].[Contacts].[ID]
 - The required fields are: PhoneHome, PhoneWork, PhoneMobile, Email, DateOfBirth
 - MailMerge fields are: ClientContactPhoneHome, ClientContactPhoneWork, ClientContactPhoneMobile, ClientContactEmail, ClientContactDateOfBirth

4: [dbo].[Contacts] table contains this information.
 - link from [dbo].[Claims].[ContactID] to [dbo].[Contacts].[ID]
 - The required fields are: SecondTitle, SecondFirstName, SecondMiddleName, SecondLastName
 - MailMerge fields are: ClientContactSecondTitle, ClientContactSecondFirstName, ClientContactSecondMiddleName, ClientContactSecondLastName.

5: [dbo].[ClientContacts] table contains this information.
 - link from [dbo].[Claims].[Contactid] to [dbo].[ClientContacts].[id]
 - link from the second [dbo].[ClientContacts].[Contactid] to [dbo].[Contacts].[id]
 - The required fields are: Address1, Address2, Address3, Address4, Address5, Address6, Address7, Address8, PCD
 - MailMerge fields are: SecondContactAddress1, SecondContactAddress2, SecondContactAddress3, SecondContactAddress4, SecondContactAddress5, SecondContactAddress6,
                                  SecondContactAddress7, SecondContactAddress8, SecondContactPCD

6: [dbo].[contacts] table contains this information.
 - link from [dbo].[claims].[contactid] to [dbo].[contacts].[id]
 - The required fields are: SecondPhoneHome, SecondPhoneWork, SecondPhoneMobile, SecondEmail, SecondDateOfBirth
 - MailMerge fields are: ClientContactSecondPhoneHome, ClientContactSecondPhoneWork, ClientContactSecondPhoneMobile, ClientContactSecondEmail, ClientContactSecondDateOfBirth

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.