Phone Number Datatables Question

I'm querying data for phone numbers belonging to Persons in CRM.  I'm linking the Phone and PhoneLink tables by PhoneID, and have a couple of questions:

1.  The way I understand it is, if the Phon_Deleted field is anything but NULL, the phone number has been deleted.  Is this correct?

2.  I'm using a particular 'Person' to test - in CRM, this person has no phone numbers, but when I query the data, I get a couple of phone numbers as results (omitting deleted phone numbers using the above logic).  Are there any other fields in the data that would cause the phone numbers to NOT show up in CRM that I should be filtering by in my query to get matching results?

Thanks in advance for any help.

Parents Reply Children
No Data