Consolidating/Removing additional patron addresses from records

• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
We recently performed a survey of the usage on certain fields in the patron database. One of the conclusions we came to was that we should only keep one mailing address per patron. We will modify our patron load for future patrons.

However, we need to find a good way to trim down the records on existing patrons. What is the best way to go about this?

Thanks,
Natalie

ps - I like the planned activity fields! I'll use them for this ticket for the extra contact info. [ <Jerry Specht > ]
[ <Jerry Specht > ]

Resolution:
I can think of two ways to do this:

1. p_file_20. Resend the patron records with the following for the address you want to delete:

ADDR-REC with ADDR-REC-ACTION "D" (Delete) / ADDR-REC-TYPE

2. SQL.

• Article last edited: 10/8/2013