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