3 CREATE OR REPLACE VIEW reporter.classic_current_circ AS
4 SELECT cl.shortname AS circ_lib,
6 circ.xact_start AS xact_start,
7 circ_type.type AS circ_type,
10 ol.shortname AS owning_lib_name,
12 lfm.value AS lit_form,
13 ifm.value AS item_form,
14 itm.value AS item_type,
15 sl.name AS shelving_location,
16 g.name AS profile_group,
17 dem.general_division AS demographic_general_division,
20 cn.label AS call_number_label,
21 call_number_dewey(cn.label) AS dewey,
22 hl.id AS patron_home_lib,
23 hl.shortname AS patron_home_lib_shortname,
24 paddr.county AS patron_county,
25 paddr.city AS patron_city,
26 paddr.post_code AS patron_zip,
27 sce1.value AS stat_cat_1,
28 sce2.value AS stat_cat_2
29 FROM action.circulation circ
30 JOIN reporter.circ_type circ_type ON (circ.id = circ_type.id)
31 JOIN asset.copy cp ON (cp.id = circ.target_copy)
32 JOIN asset.copy_location sl ON (cp.location = sl.id)
33 JOIN asset.call_number cn ON (cp.call_number = cn.id)
34 JOIN actor.org_unit ol ON (cn.owning_lib = ol.id)
35 JOIN metabib.rec_descriptor rd ON (rd.record = cn.record)
36 JOIN actor.org_unit cl ON (circ.circ_lib = cl.id)
37 JOIN actor.usr p ON (p.id = circ.usr)
38 JOIN actor.org_unit hl ON (p.home_ou = hl.id)
39 JOIN permission.grp_tree g ON (p.profile = g.id)
40 JOIN reporter.demographic dem ON (dem.id = p.id)
41 JOIN actor.usr_address paddr ON (paddr.id = p.billing_address)
42 LEFT JOIN config.language_map lm ON (rd.item_lang = lm.code)
43 LEFT JOIN config.lit_form_map lfm ON (rd.lit_form = lfm.code)
44 LEFT JOIN config.item_form_map ifm ON (rd.item_form = ifm.code)
45 LEFT JOIN config.item_type_map itm ON (rd.item_type = itm.code)
46 LEFT JOIN asset.stat_cat_entry_copy_map sc1 ON (sc1.owning_copy = cp.id AND sc1.stat_cat = 1)
47 LEFT JOIN asset.stat_cat_entry sce1 ON (sc1.stat_cat_entry = sce1.id)
48 LEFT JOIN asset.stat_cat_entry_copy_map sc2 ON (sc2.owning_copy = cp.id AND sc2.stat_cat = 2)
49 LEFT JOIN asset.stat_cat_entry sce2 ON (sc2.stat_cat_entry = sce2.id) ;