# Circulation Counts with Transaction Logs

**URL:** https://forum.innovativeusers.org/t/circulation-counts-with-transaction-logs/2474
**Category:** Polaris
**Tags:** polaris-circ, leap, sql
**Created:** [May 14, 2025, 3:23pm UTC](https://forum.innovativeusers.org/t/circulation-counts-with-transaction-logs/2474 "2025-05-14T15:23:05Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![jagoodwin](https://forum.innovativeusers.org/letter_avatar_proxy/v4/letter/j/41988e/32.png) [@jagoodwin](https://forum.innovativeusers.org/u/jagoodwin)
#### Post date: [May 14, 2025, 3:23pm UTC](https://forum.innovativeusers.org/t/circulation-counts-with-transaction-logs/2474/1 "2025-05-14T15:23:05Z")

</div>

We are a new Polaris site and are trying to recreate some of our circulation reporting. We specifically want to separate initial checkouts from renewals. Seems straight forward enough with TransactionSubTypes, but then we ran into subtype 145 code 51 ‘Leap Checkout and Renewal’. Does anyone have a work around to indicate which are renewals? We are a strictly LEAP system, so this accounts for a significant portion of our circulation actions.

---

<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: [May 14, 2025, 4:15pm UTC](https://forum.innovativeusers.org/t/circulation-counts-with-transaction-logs/2474/2 "2025-05-14T16:15:26Z")

</div>

Those transactions with a 145/51 should **ALSO have a 124/1** if they are a renewal:

 ![image](https://forum.innovativeusers.org/uploads/db7787/original/2X/1/10f9e6f2cf90afb3c89cbea0b71b2a4b77743052.png)

So, the 145/51 is just additional information stating that this transaction was performed via Leap.

Just a heads up that this will be much easier after you upgrade to 7.8: [https://portal.productboard.com/iii/6-innovative-product-status-board-new/c/221-add-renewals-count-to-item-statistics-](https://portal.productboard.com/iii/6-innovative-product-status-board-new/c/221-add-renewals-count-to-item-statistics-)

Also, during the upgrade, the system will go back and retroactively calculate information on existing item records.