When data was converted as of the implementation of the 18.07 release, if there was a number in the Home phone or Fax phone field (both in MSHIST), these will be converted to records in the MASTPH database. However, work, cell, and previous phone numbers for closed memberships, stored in MASTRL, were NOT converted to the new MASTPH table for closed memberships. The data was not deleted, but there is no way to maintain it nor is it visible from closed member inquiry or maintenance screens.

Going forward, however, when memberships are closed the system will create records for ALL of that member’s contact numbers (including “work” and “cell” and “previous”) in the MASTPH table, with a closed account sequence # to indicate they match a closed membership record.