There is no query information regarding phone sharing. However, the Sharing Status field can be output in a constituent Export. Sharing status will output Shared (meaning it is being shared to at least one other records), Not Shared (it is not being shared to other records), Do Not Share (an indicator that this should not be shared), or Cannot be shared (set for this phone type on the Phone Types table as not available to share). Additional information, such as which records, is not available in Query or Export.

(NOTE: If you are updating from The Raiser's Edge 7.93 or earlier to the latest version, please refer to the What do I need to do to prepare for the update to The Raiser's Edge 7.95 or higher? for preparation steps regarding phones/emails.)

In The Raiser's Edge 7.93 or earlier:
  1. Optionally, create a constituent query for the desired records to Export.
  2. Start a new constituent Export.
  3. On the General tab, attach the query created in step 1 if being used. Review other settings.
  4. On the Output tab, select the following fields to output. When prompted for the number of addresses or phones, enter a number that will include all the desired records. You can also specify specific address types and set a order by option.
    • Constituent Information > Constituent ID
    • Constituent Information > Name
    • Address > Preferred Address (or All Addresses) > Import ID
    • Address > Preferred Address (or All Addresses) > Phones > Import ID
    • Address > Preferred Address (or All Addresses) > Phones > Phone number
    • Address > Preferred Address (or All Addresses) > Phones > Phone type
    • Address > Preferred Address (or All Addresses) > Phones > Sharing Status
  5. Add any additional desired fields to the Export.
  6. Run the Export.
(NOTE: Phone sharing is not available as of The Raiser's Edge 7.94 or higher.)