If you need to run a local report, please see the following:
📌 Note: Make sure you test this thoroughly using examples from your front-end update telephone numbers and emails, and confirm the listed tables work as you'd expect.
You'll find the main tables for phone numbers are:
Select * from MO_TELEPHONE_NUMBERS
Select * from MO_PERSON_TELEPHONE_NUMBERS
You can join these two tables to search by Person ID and view the relevant fields:
Select mptn.PERSON_ID, mtn.*
from MO_TELEPHONE_NUMBERS mtn
join MO_PERSON_TELEPHONE_NUMBERS mptn ON mtn.TELEPHONE_NUMBER_ID = mptn.TELEPHONE_NUMBER_ID
--where
--Person_ID =
There's also an audit version of that table:
Select * from AUD_MO_TELEPHONE_NUMBERS
For email, this is included in the following table:
Select * from Mo_persons
--where
--Person_ID =
There's also an audit version of that table:
Select * from AUD_MO_PERSONS