# Patron Check Out History

**URL:** https://forum.innovativeusers.org/t/patron-check-out-history/1235
**Category:** Polaris Repository
**Tags:** polaris-patrons, cp-migration
**Created:** [June 2, 2023, 9:05pm UTC](https://forum.innovativeusers.org/t/patron-check-out-history/1235 "2023-06-02T21:05:19Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![system](https://forum.innovativeusers.org/uploads/db7787/original/2X/8/8519ee8eef6492f310ea87d4ce482d931f01eef2.png) [@system](https://forum.innovativeusers.org/u/system)
#### Post date: [June 2, 2023, 9:05pm UTC](https://forum.innovativeusers.org/t/patron-check-out-history/1235/1 "2023-06-02T21:05:19Z")

</div>

# Patron Check Out History

This query was written to prove a point. No matter how much you hide your item record and patron record history, Polaris always retains check out histories in the PolarisTransactions database. This is a basic query to pull all items checked out by a patron during a given period of time.

```SQL SELECT pr.PatronFullName, br.BrowseTitle

FROM  
PolarisTransactions.Polaris.TransactionHeaders th WITH (NOLOCK)

INNER JOIN  
PolarisTransactions.Polaris.TransactionDetails td1 WITH (NOLOCK) ON td1.TransactionID = th.TransactionID  
INNER JOIN  
PolarisTransactions.Polaris.TransactionDetails td2 WITH (NOLOCK) ON td2.TransactionID = th.TransactionID  
INNER JOIN --SubTypeID 38 = The unique item record ID  
Polaris.Polaris.CircItemRecords cir WITH (NOLOCK) ON cir.ItemRecordID = td1.numValue AND td1.TransactionSubTypeID = 38  
INNER JOIN --SubTypeID 6 = The unique patron record ID  
Polaris.Polaris.PatronRegistration pr ON pr.PatronID = td2.numValue AND td2.TransactionSubTypeID = 6  
INNER JOIN  
Polaris.Polaris.BibliographicRecords br WITH (NOLOCK) ON cir.AssociatedBibRecordID = br.BibliographicRecordID

WHERE  
th.TransactionTypeID = 6001 --code for item checkout  
AND  
td2.numValue = 000000 --put a patron ID here  
AND – Adjust dates as needed  
th.TranClientDate BETWEEN ‘2021-01-01 00:00:00.000’ AND ‘2021-12-31 23:59:59.999’

```auto

```