# Who Modified a Patron Registration

**URL:** https://forum.innovativeusers.org/t/who-modified-a-patron-registration/2403
**Category:** Polaris Repository
**Tags:** sql, polaris-sql, polaris
**Created:** [April 2, 2025, 2:05pm UTC](https://forum.innovativeusers.org/t/who-modified-a-patron-registration/2403 "2025-04-02T14:05:25Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![CyberpunkLibrarian](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/cyberpunklibrarian/32/1168_2.png) [@CyberpunkLibrarian](https://forum.innovativeusers.org/u/CyberpunkLibrarian)
#### Post date: [April 2, 2025, 2:05pm UTC](https://forum.innovativeusers.org/t/who-modified-a-patron-registration/2403/1 "2025-04-02T14:05:25Z")

</div>

Keeping in mind that you really can’t see what modifications were made to a patron registration, you can at least see who made the modification.

```auto
SELECT
    th.TransactionID,
    th.TranClientDate AS [Date],
    o.Name AS [Modified At],
    pu.Name AS [Modified By],
    w.DisplayName AS [Workstation],
    patron.numValue AS [PatronID],
    pr.PatronFullName AS [Patron Name],
    leap.numValue AS [Modified via Leap]
FROM
    PolarisTransactions.Polaris.TransactionHeaders th WITH (NOLOCK)
INNER JOIN -- Get the PatronID
    PolarisTransactions.Polaris.TransactionDetails patron WITH (NOLOCK)
    ON (th.TransactionID = patron.TransactionID AND patron.TransactionSubTypeID = 6)
LEFT JOIN -- Find out what was modified via Leap
    PolarisTransactions.Polaris.TransactionDetails leap WITH (NOLOCK)
    ON (th.TransactionID = leap.TransactionID AND leap.TransactionSubTypeID = 315)
INNER JOIN -- Get the patron name
    Polaris.Polaris.PatronRegistration pr WITH (NOLOCK)
    ON (pr.PatronID = patron.numValue)
INNER JOIN -- Get the library name
    Polaris.Polaris.Organizations o WITH (NOLOCK)
    ON (o.OrganizationID = th.OrganizationID)
INNER JOIN -- Get the staff member
    Polaris.Polaris.PolarisUsers pu WITH (NOLOCK)
    ON (pu.PolarisUserID = th.PolarisUserID)
INNER JOIN -- Get the workstation
    Polaris.Polaris.Workstations w WITH (NOLOCK)
    ON (w.WorkstationID = th.WorkstationID)
WHERE -- Pop in your PatronID here
    patron.numValue = 2985799
AND -- Patron registration modified
    th.TransactionTypeID = 2003
AND -- Adjust dates as desired
    th.TranClientDate BETWEEN '2024-01-01 00:00:00.000' AND '2024-12-30 23:59:59.999'

```

---

<div class="post-metadata">

### Author: ![wesochuck](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/wesochuck/32/499_2.png) [@wesochuck](https://forum.innovativeusers.org/u/wesochuck)
#### Post date: [November 3, 2025, 6:27pm UTC](https://forum.innovativeusers.org/t/who-modified-a-patron-registration/2403/2 "2025-11-03T18:27:07Z")

</div>

> [@CyberpunkLibrarian](#):
>
> you really can’t see what modifications were made to a patron registration

If you’d like to see this improved, consider voting and commenting on: [patron account edit history – Innovate with us](https://ideas.iii.com/forums/951742-ils-polaris/suggestions/49847307-patron-account-edit-history)