Querying for Juvenile Patrons without a Parental Acknowledgement

Do you need a list of the juvenile patrons in your system that do not yet have the NLS Parental Acknowledgement?
The instructions are now available for download:

• Query-JuvenilesWithoutParentalAck-2024.docx
• Query-JuvenilesWithoutParentalAck-2024.pdf

Still have Parental Acknowledgement questions? See the  NLS Parental Acknowledgement FAQ  or let us know!

Excellent point, thank you! Accounts that are suspended in KLAS are still active in PIMMS, so NLS doesn't know the difference.

For notices sent out locally, I personally would be inclined to skip Suspended patrons and let the block go into affect (since they are blocked/Inactive anyways), and just get the Acknowledgement if they resume service. However, you could also run a separate list for Suspended patrons (status equals S instead of A in both queries) and tailor the mailing or email's wording to reference that they are not an active patron. Running a separate list for Suspended will also give you an idea of how many Suspended juvenile patrons you have who NLS may be emailing.

And for another perspective, Nancy's read on data coming back from those NLS notifications was that these people didn't know they were suspended, and were acting like they still wanted service. So maybe this is a good reason to go ahead and contact them and get some of those accounts re-activated!

I agree that the birthdate is the issue here--you'll need to leave that out for institutions.
Query A would be all Active institutions with Patron Type | In | IS,IP (or whatever list of codes applies to your database), no birthdate.
Query B would take the same criteria from A, and add the Preference criteria on the Advanced Search tab. 

Note: of course, the second part will only work once the Preferences can actually be added to the Institutional records (which is coming, pending the work to be able to sync that info with PIMMS). For now, if you're tracking pre-authorizations with a note type, you can use that in Query B, or you can use just Query A without any merges for your list of who to contact.