Differences

This shows you the differences between two versions of the page.

--- evergreen-reports:borrower_list_reports [2010/09/02 16:51] – terlaga
+++ evergreen-reports:borrower_list_reports [2011/03/08 22:10] (current) – removed bshum
@@ Line 1: / Line 1: @@
-====== Borrower List Reports ======
-===== Borrowers with Email Addresses by Home Library =====
-**Submission Notes:**
-This report was created and submitted on 5/20/10 by Amy Terlaga of Bibliomation, Inc. (with assistance from Benjamin Shum)
-**Version**:  Evergreen v.1.6.0.2
-**Data Sources Used**:
-**Running Tips/Guidelines**:  This report is designed to list those patrons from a specific library with email addresses in their patron record.
-To run this report, change the **'ORG'** to the shortname of the home library in question.
-----------------------
-SELECT actor.card.barcode, actor.usr.first_given_name, actor.usr.family_name, actor.usr.email, actor.org_unit.name
-  FROM actor.usr, actor.org_unit, actor.card
-  WHERE actor.usr.home_ou = actor.org_unit.id
-  AND actor.card.id = actor.usr.card
-  AND actor.org_unit.shortname = **'ORG'**
-  AND ((actor.usr.email != '')
-  AND (actor.usr.email IS NOT NULL))
-ORDER BY family_name;
-------------------------
-===== K-12 Student List with Homeroom Stat =====
-**Submission Notes:**
-This report was created and submitted on 9/2/10 by Amy Terlaga of Bibliomation, Inc. (with some assistance from Mike Rylander)
-**Version**:  Evergreen v.1.6.0.2
-**Data Sources Used**:
-**Running Tips/Guidelines**:  This report is designed to list all borrowers from a specific k-12 library, including barcode, name, street1 address, patron profile group, and homeroom stat category.
-To run this report, change the [ORG] to the shortname of the home library in question and change the [stat cat id #] to the stat cat id # for your homeroom information.
-----------------------
-SELECT acard.barcode AS "Barcode", au.family_name AS "Last Name", au.first_given_name AS "First Name", aua.street1 AS "Street1",
-	pgt.name AS "Group Profile", asceum.stat_cat_entry AS "Homeroom", aou.name AS "Library Name"
-   FROM actor.usr au
-   INNER JOIN actor.org_unit aou ON au.home_ou = aou.id
-   INNER JOIN actor.card acard ON acard.id = au.card
-   INNER JOIN actor.usr_address aua ON au.id = aua.usr
-   INNER JOIN permission.grp_tree pgt ON au.profile = pgt.id
-   LEFT OUTER JOIN actor.stat_cat_entry_usr_map asceum ON asceum.target_usr = au.id
-   LEFT OUTER JOIN actor.stat_cat astat ON asceum.stat_cat = astat.id
-   WHERE aou.shortname = '[ORG]'::text AND asceum.stat_cat = '[stat cat id #]'
-   ORDER BY 4, 2, 1
-----------------------
-Back to [[evergreen-reports:borrower_reports|Borrower Reports]] page