From: Rogan Hamby Date: Fri, 2 Mar 2018 16:41:36 +0000 (-0500) Subject: fix syntax in evergreen staged table xml X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=c3ab7a7f4fe4dd7aa0d0c55f1ca31b7cb32e34ab;hp=af66e5408e31e25bc6fed62b99cc39be95d480ef fix syntax in evergreen staged table xml --- diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 1d55356..8d37e60 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -31,7 +31,7 @@ name of report which version, the first version to run is 0, first backup is 1, then so on - Money arbitrary tags, each should go in separate tag + money arbitrary tags, each should go in separate tag Migrated Billings title used in the asciidoc output Number of Billings.Migrated.Total period delimited SELECT COUNT(id),x_migrate::TEXT,SUM(amount) FROM MIGSCHEMA.money_billing_legacy GROUP BY 2; query itself, MIGSCHEMA will be replaced @@ -42,7 +42,7 @@ circ_count - Circs + circs 0 Open Circulations Circulation Status.Migrated.Count of Circs @@ -51,7 +51,7 @@ circ_count - Circs + circs 1 Open Circulations Circulation Status.Count of Circs @@ -60,7 +60,7 @@ circ_by_orgunit - Circs + circs 0 Circulations by Org Unit Circulations Count.Migrated.Org Unit @@ -78,7 +78,7 @@ circ_by_orgunit - Circs + circs 1 Circulations by Org Unit Circulations Count.Org Unit @@ -87,7 +87,7 @@ circs_by_duration - Circs + circs 0 Migrated Circulations by Duration, Fine and Max Fine Count of Circs.Duration.Fine.Max Fine.Migrated @@ -96,7 +96,7 @@ circs_by_duration - Circs + circs 1 Circulations by Duration, Fine and Max Fine Count of Circs.Duration.Fine.Max Fine @@ -105,7 +105,7 @@ circs_by_usrgroup - Circs + circs 0 Circulations by Rules and Patron Group Count of Circs.Duration.Fine.Max Fine.User Group.Matchpoints @@ -114,7 +114,7 @@ circs_by_usrgroup - Circs + circs 1 Circulations by Rules and Patron Group Count of Circs.Duration.Fine.Max Fine.User Group.Matchpoints @@ -123,7 +123,7 @@ circs_by_circmod - Circs + circs 0 Circulations by Rules and Circulation Modifier Count of Circs.Duration.Fine.Max Fine.Circulation Modifier.Matchpoints @@ -132,7 +132,7 @@ circs_by_circmod - Circs + circs 1 Circulations by Rules and Circulation Modifier Count of Circs.Duration.Fine.Max Fine.Circulation Modifier.Matchpoints @@ -142,7 +142,7 @@ circs_by_orgunit - Circs + circs 0 Circulations by Rules and Org Unit Count of Circs.Duration.Fine.Max Fine.Library Branch @@ -151,7 +151,7 @@ circs_by_orgunit - Circs + circs 1 Circulations by Rules and Org Unit Count of Circs.Duration.Fine.Max Fine.Library Branch @@ -160,7 +160,7 @@ non_cat_circs - Circs + circs 0 Non-Cataloged Circulation Circulations Count.Migrated @@ -169,7 +169,7 @@ non_cat_circs - Circs + circs 1 Non-Cataloged Circulation Circulations Count @@ -178,7 +178,7 @@ in_house - Circs + circs 0 In House Use In House Use Records.Migrated @@ -187,7 +187,7 @@ in_house - Circs + circs 1 In House Use In House Use Records @@ -196,7 +196,7 @@ circs_missing_rules - Circs + circs 1 Circs Missing Rules Count.Field Missing @@ -211,7 +211,7 @@ circ_open_by_item_status - Circs + circs 0 Open Circulation and Status of Linked Items Count.Status @@ -222,7 +222,7 @@ holds - Holds + holds 0 Migrated Holds Hold Type.Hold Count.Migrated @@ -231,7 +231,7 @@ holds_bytype - Holds + holds 0 Migrated Holds By Type Hold Type.Hold Count.Migrated @@ -240,7 +240,7 @@ transit_open_by_item_status - Holds + holds 0 Transit Copy Records and Status of Linked Items Count.Status @@ -249,7 +249,7 @@ transit_copies_by_status - Holds + holds 0 Status of Items with Count of Open In Transits Count.Status.Count of Open Transits @@ -258,7 +258,7 @@ hold_copies_by_status - Holds + holds 0 Captured Holds with Status of Items Count of Captured Hold.Status of Item @@ -267,7 +267,7 @@ hold_depth - Holds + holds 0 Depth of Unfilled Holds Count.Depth @@ -279,7 +279,7 @@ asset_copy_count Count of Copies by Library - Assets + assets 0 Copy Count.Library.Migrated SELECT COUNT(ac.id), aou.name, ac.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_legacy ac JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2, 3 ORDER BY 2, 3 @@ -288,7 +288,7 @@ asset_deleted_copies Deleted Copies - Assets + assets 0 Copy Count.Deleted.Migrated SELECT COUNT(ac.id), ac.deleted::TEXT, ac.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_legacy ac GROUP BY 2, 3 @@ -297,7 +297,7 @@ asset_copies_by_status Copies by Status - Assets + assets 0 Copy Count.Status.Migrated SELECT COUNT(ac.id), cs.name, ac.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_legacy ac JOIN config.copy_status cs ON cs.id = ac.status GROUP BY 2, 3 ORDER BY 2, 3 @@ -306,7 +306,7 @@ asset_circ_mod_copies_count Copies by Circulation Modifier - Assets + assets 0 Copy Count.Circulation Modifier.Migrated SELECT COUNT(ac.id), ac.circ_modifier, ac.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_legacy ac GROUP BY 2, 3 ORDER BY 2, 3 @@ -315,7 +315,7 @@ asset_copy_notes Copy Notes - Assets + assets 0 Note Count.Public.Migrated SELECT COUNT(acnote.id), acnote.pub::TEXT, acnote.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_note_legacy acnote GROUP BY 2, 3 ORDER BY 2, 3 @@ -324,7 +324,7 @@ asset_copy_notes Copy Notes - Assets + assets 1 Note Count.Public SELECT COUNT(acnote.id), acnote.pub::TEXT FROM MIGSCHEMA.asset_copy_note acnote GROUP BY 2 ORDER BY 2 @@ -333,7 +333,7 @@ asset_vols_by_lib Volumes by Library - Assets + assets 0 Volume Count.Library.Migrated SELECT COUNT(acn.id), aou.name, acn.x_migrate::TEXT FROM MIGSCHEMA.asset_call_number_legacy acn JOIN MIGSCHEMA.actor_org_unit_legacy aou ON aou.id = acn.owning_lib GROUP BY 2, 3 ORDER BY 2, 3 @@ -342,7 +342,7 @@ asset_vols_by_lib Volumes by Library - Assets + assets 1 Volume Count.Library SELECT COUNT(acn.id), aou.name FROM MIGSCHEMA.asset_call_number acn JOIN actor.org_unit aou ON aou.id = acn.owning_lib GROUP BY 2 ORDER BY 2 @@ -351,7 +351,7 @@ asset_cops_by_loc Copies by Location - Assets + assets 0 Copy Count.Library.Migrated SELECT COUNT(ac.id), acl.name, ac.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_legacy ac JOIN asset.copy_location acl ON acl.id = ac.location GROUP BY 2, 3 ORDER BY 2, 3 @@ -360,7 +360,7 @@ asset_cops_by_loc_and_org Copies by Location - Assets + assets 0 Copy Count.Library.Circ Library.Migrated SELECT COUNT(ac.id), acl.name, aou.name, ac.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_legacy ac JOIN asset.copy_location acl ON acl.id = ac.location JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2, 3, 4 ORDER BY 2, 3, 4 @@ -369,7 +369,7 @@ asset_barcode_lengths Barcode Lengths by Library - Assets + assets 0 Count of Barcode.Barcode Length.Library SELECT COUNT(ac.id), LENGTH(ac.barcode), aou.name FROM MIGSCHEMA.asset_copy_legacy ac JOIN actor.org_unit aou ON aou.id = ac.circ_lib WHERE ac.x_migrate = TRUE GROUP BY 2, 3 ORDER BY 3, 2 @@ -378,7 +378,7 @@ asset_barcode_patterns Common Barcode Starting Patterns - Assets + assets 0 Count of Barcodes (greater than 10).Left 60% of Characters SELECT COUNT(ac.id), LEFT(ac.barcode,(ROUND(LENGTH(ac.barcode)*.6))::INT) FROM MIGSCHEMA.asset_copy_legacy ac WHERE ac.x_migrate = TRUE GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2 @@ -387,7 +387,7 @@ asset_barcode_incumbent_collisions Copy Barcode Incumbent Collisions - Assets + assets 0 Collision Count SELECT COUNT(id) FROM MIGSCHEMA.asset_copy_legacy WHERE x_migrate = TRUE AND barcode ~* 'collision' and barcode ~* 'incumbent' @@ -397,7 +397,7 @@ asset_barcode_incumbent_collisions Copy Barcode Incumbent Collisions - Assets + assets 1 Collision Count SELECT COUNT(id) FROM MIGSCHEMA.asset_copy WHERE barcode ~* 'collision' and barcode ~* 'incumbent' @@ -407,7 +407,7 @@ asset_barcode_internal_collisions Copy Barcode Internal Collisions - Assets + assets 0 Collision Count SELECT COUNT(id) FROM MIGSCHEMA.asset_copy_legacy WHERE x_migrate = TRUE AND barcode ~* 'collision' and barcode ~* 'internal' @@ -417,7 +417,7 @@ asset_barcode_internal_collisions Copy Barcode Internal Collisions - Assets + assets 1 Collision Count SELECT COUNT(id) FROM MIGSCHEMA.asset_copy WHERE barcode ~* 'collision' and barcode ~* 'internal' @@ -427,7 +427,7 @@ asset_barcode_collisions_shortlist Copy Barcode Collisions (first 20) - Assets + assets 0 Collision List SELECT ac.barcode FROM MIGSCHEMA.asset_copy_legacy ac WHERE ac.barcode ~* 'collision' ORDER BY 1 LIMIT 20 @@ -437,7 +437,7 @@ asset_barcode_collisions_shortlist Copy Barcode Collisions (first 20) - Assets + assets 1 Collision List SELECT ac.barcode FROM MIGSCHEMA.asset_copy ac WHERE ac.barcode ~* 'collision' ORDER BY 1 LIMIT 20 @@ -447,7 +447,7 @@ asset_barcode_collision_patterns Common Copy Barcode Collision Patterns - Assets + assets 0 Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters SELECT COUNT(ac.id), LEFT(ac.barcode,(ROUND(LENGTH(ac.barcode)*.6))::INT) FROM MIGSCHEMA.asset_copy_legacy ac WHERE barcode ~* 'collision' GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2 @@ -456,7 +456,7 @@ asset_barcode_collision_patterns Common Copy Barcode Collision Patterns - Assets + assets 1 Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters SELECT COUNT(ac.id), LEFT(ac.barcode,(ROUND(LENGTH(ac.barcode)*.6))::INT) FROM MIGSCHEMA.asset_copy ac WHERE barcode ~* 'collision' GROUP BY 2 HAVING COUNT(ac.id) > 10 ORDER BY 2 @@ -465,7 +465,7 @@ asset_stat_cats Copy Statistical Categories - Assets + assets 0 Stat Cat Count.Library.Statistical Category SELECT COUNT(ac_sc.id), aou.name, ac_sc.name FROM MIGSCHEMA.asset_stat_cat_legacy ac_sc JOIN actor.org_unit aou ON aou.id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 @@ -474,7 +474,7 @@ asset_stat_cats Copy Statistical Categories - Assets + assets 1 Stat Cat Count.Library.Statistical Category SELECT COUNT(ac_sc.id), aou.name, ac_sc.name FROM MIGSCHEMA.asset_stat_cat ac_sc JOIN actor.org_unit aou ON aou.id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 @@ -483,7 +483,7 @@ asset_stat_cat_entries Copy Stat Cat User Entries - Assets + assets 0 Copy Stat Count.Library.Statistical Category SELECT COUNT(map.id), aou.name, ac_sc.name FROM MIGSCHEMA.asset_stat_cat_entry_copy_map_legacy map JOIN MIGSCHEMA.asset_stat_cat_legacy ac_sc ON ac_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou.id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 @@ -492,7 +492,7 @@ asset_stat_cat_entries Copy Stat Cat User Entries - Assets + assets 1 Copy Stat Count.Library.Statistical Category SELECT COUNT(map.id), aou.name, ac_sc.name FROM MIGSCHEMA.asset_stat_cat_entry_copy_map map JOIN MIGSCHEMA.asset_stat_cat ac_sc ON ac_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou. @@ -502,7 +502,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 asset_copy_tags Copy Tags - Assets + assets 0 Tag Count.Copy Tag Type.Copy Tag Label.Staff Note.Public SELECT COUNT(map.id), tag.tag_type, tag.label, tag.staff_note, tag.pub FROM MIGSCHEMA.asset_copy_tag tag JOIN MIGSCHEMA.asset_copy_tag_copy_map map ON map.tag = tag.id GROUP BY 2,3,4,5 ORDER BY 2,3 @@ -513,7 +513,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_billing_voided Bills Voided And Not - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_billing_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -522,7 +522,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_billing_voided Bills Voided And Not - Money + money 1 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM MIGSCHEMA.money_billing a GROUP BY 2 ORDER BY 2, 3 @@ -531,7 +531,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_billing_by_type Bills by Type - Money + money 0 Count.Billing Type.Migrated SELECT COUNT(a.id), a.billing_type, a.x_migrate::TEXT FROM MIGSCHEMA.money_billing_legacy a GROUP BY 2, 3 ORDER BY 2, 3 @@ -540,7 +540,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_billing_by_type Bills by Type - Money + money 1 Count.Billing Type SELECT COUNT(a.id), a.billing_type FROM MIGSCHEMA.money_billing a GROUP BY 2 ORDER BY 2 @@ -549,7 +549,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_cash_payment Cash Payments - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_cash_payment_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -558,7 +558,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_cash_payment Cash Payments - Money + money 1 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM MIGSCHEMA.money_cash_payment a GROUP BY 2 ORDER BY 2 @@ -567,7 +567,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_check_payment Check Payments - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_check_payment_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -576,7 +576,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_forgive_payment Forgive Payments - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_forgive_payment_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -585,7 +585,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_forgive_payment Forgive Payments - Money + money 1 Count.Voided.Sum SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM MIGSCHEMA.money_forgive_paymen a GROUP BY 2 ORDER BY 2 @@ -594,7 +594,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_goods_payment Goods Payments - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_goods_payment_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -603,7 +603,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_work_payment Work Payments - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_work_payment_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -612,7 +612,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_credit_card_payment Credit Card Payments - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_credit_card_payment_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -621,7 +621,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 money_credit_payment Credit Payments - Money + money 0 Count.Voided.Sum.Migrated SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount), a.x_migrate::TEXT FROM MIGSCHEMA.money_credit_payment_legacy a GROUP BY 2, 4 ORDER BY 2, 4 @@ -633,7 +633,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs Extracted Bibliographic Records - Bibs + bibs 0 Count.Deleted.Migrated SELECT COUNT(bre.id), bre.deleted::TEXT, bre.x_migrate::TEXT FROM MIGSCHEMA.biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3 @@ -643,7 +643,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs Extracted Bibliographic Records - Bibs + bibs 1 Count SELECT COUNT(eg) FROM MIGSCHEMA.bib_id_map @@ -652,7 +652,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibswovolumes Bibliographic Records Without Volumes - Bibs + bibs 0 Count SELECT COUNT(eg) FROM MIGSCHEMA.bib_id_map where eg::INTEGER NOT IN (SELECT DISTINCT record FROM MIGSCHEMA.asset_call_number) @@ -661,7 +661,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_notes Bib Record Notes - Bibs + bibs 0 Count.Migrated SELECT COUNT(b.id), b.x_migrate::TEXT FROM MIGSCHEMA.biblio_record_note_legacy b GROUP BY 2 @@ -670,7 +670,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_notes Bib Record Notes - Bibs + bibs 1 Count SELECT COUNT(b.id) FROM MIGSCHEMA.biblio_record_note b @@ -679,7 +679,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_peers Peer Bib Copies - Bibs + bibs 0 Count.Migrated SELECT COUNT(b.id), b.x_migrate::TEXT FROM MIGSCHEMA.biblio_peer_bib_copy_map_legacy b GROUP BY 2 @@ -688,7 +688,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_peers Peer Bib Copies - Bibs + bibs 1 Count SELECT COUNT(b.id) FROM MIGSCHEMA.biblio_peer_bib_copy_map b @@ -697,7 +697,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_parts Monograph Parts - Bibs + bibs 0 Count.Migrated SELECT COUNT(b.id), b.x_migrate::TEXT FROM MIGSCHEMA.biblio_monograph_part_legacy b GROUP BY 2 @@ -706,7 +706,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs_parts Monograph Parts - Bibs + bibs 1 Count SELECT COUNT(b.id) FROM MIGSCHEMA.biblio_monograph_part b @@ -717,7 +717,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usrsbyorg Patrons by Home Org - Actors + actors 0 Count.Library.Deleted.Migrated SELECT COUNT(au.id), aou.name, au.deleted::TEXT, au.x_migrate::TEXT FROM MIGSCHEMA.actor_usr_legacy au JOIN actor.org_unit aou ON aou.id = au.home_ou GROUP BY 2, 3, 4 ORDER BY 2, 3, 4 @@ -726,7 +726,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usrsbypgt Patrons by Permission Group - Actors + actors 0 Count.Permission Group.Migrated SELECT COUNT(au.id), pgt.name, au.x_migrate::TEXT FROM MIGSCHEMA.actor_usr_legacy au JOIN permission.grp_tree pgt ON pgt.id = au.profile GROUP BY 2, 3 ORDER BY 2, 3 @@ -735,7 +735,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 active_usrs Patron by Active Status - Actors + actors 0 Count of Users.Active.Migrated SELECT COUNT(id), active::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2, 3 @@ -744,7 +744,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 active_usrs Patrons by Active Status - Actors + actors 1 Count of Users.Active SELECT COUNT(id), active::TEXT FROM MIGSCHEMA.actor_usr GROUP BY 2 @@ -753,7 +753,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 active_usr_barcodes Patron Barcodes by Active Status - Actors + actors 0 Count of Barcodes.Active.Migrated SELECT COUNT(id), active::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_card_legacy GROUP BY 2, 3 @@ -762,7 +762,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 active_usr_barcodes Patron Barcodes by Active Status - Actors + actors 1 Count of Barcodes.Active SELECT COUNT(id), active::TEXT FROM MIGSCHEMA.actor_card GROUP BY 2 @@ -771,7 +771,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_lengths Barcode Lengths by Library - Actors + actors 0 Count of Barcode.Barcode Length.Library SELECT COUNT(acard.id), LENGTH(acard.barcode), aou.name FROM MIGSCHEMA.actor_card_legacy acard JOIN MIGSCHEMA.actor_usr_legacy au ON au.id = acard.usr JOIN actor.org_unit aou ON aou.id = au.home_ou WHERE acard.x_migrate = TRUE GROUP BY 2, 3 ORDER BY 3, 2 @@ -780,7 +780,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_lengths Barcode Lengths by Library - Actors + actors 1 Count of Barcode.Barcode Length.Library SELECT COUNT(acard.id), LENGTH(acard.barcode), aou.name FROM MIGSCHEMA.actor_card acard JOIN MIGSCHEMA.actor_usr au ON au.id = acard.usr JOIN actor.org_unit aou ON aou.id = au.home_ou GROUP BY 2, 3 ORDER BY 3, 2 @@ -789,7 +789,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_patterns Common Barcode Starting Patterns - Actors + actors 0 Count of Barcodes (greater than 10).Left 60% of Characters SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM MIGSCHEMA.actor_card_legacy acard WHERE acard.x_migrate = TRUE GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2 @@ -798,7 +798,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_patterns Common Barcode Starting Patterns - Actors + actors 1 Count of Barcodes (greater than 10).Left 60% of Characters SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM MIGSCHEMA.actor_card acard GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2 @@ -807,7 +807,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_collisions Patron Barcode Collisions - Actors + actors 0 Collision Count SELECT COUNT(acard.id) FROM MIGSCHEMA.actor_card_legacy acard WHERE barcode ~* 'collision' AND x_migrate = TRUE @@ -816,7 +816,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_collisions Patron Barcode Collisions - Actors + actors 1 Collision Count SELECT COUNT(acard.id) FROM MIGSCHEMA.actor_card acard WHERE barcode ~* 'collision' @@ -825,7 +825,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_collision_shortlist Patron Barcode Collisions (first 20) - Actors + actors 0 Collision List SELECT acard.barcode FROM MIGSCHEMA.actor_card_legacy acard WHERE acard.barcode ~* 'collision' AND acard.x_migrate = TRUE ORDER BY 1 LIMIT 20 @@ -835,7 +835,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_collision_shortlist Patron Barcode Collisions (first 20) - Actors + actors 1 Collision List SELECT acard.barcode FROM MIGSCHEMA.actor_card acard WHERE acard.barcode ~* 'collision' ORDER BY 1 LIMIT 20 @@ -845,7 +845,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_collision_patterns Common Patron Barcode Collision Patterns a.x_migrate - Actors + actors 0 Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM MIGSCHEMA.actor_card_legacy acard WHERE acard.barcode ~* 'collision' AND acard.x_migrate = TRUE GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2 @@ -854,7 +854,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_barcode_collision_patterns Common Patron Barcode Collision Patterns a.x_migrate - Actors + actors 1 Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters SELECT COUNT(acard.id), LEFT(acard.barcode,(ROUND(LENGTH(acard.barcode)*.6))::INT) FROM MIGSCHEMA.actor_card acard WHERE acard.barcode ~* 'collision' GROUP BY 2 HAVING COUNT(acard.id) > 10 ORDER BY 2 @@ -863,7 +863,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_addressses_status Patron Addresses by Valid Status - Actors + actors 0 Count.Valid.Migrated SELECT COUNT(aua.id), valid::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_address_legacy aua GROUP BY 2, 3 @@ -872,7 +872,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_addressses_status Patron Addresses by Valid Status - Actors + actors 1 Count.Valid SELECT COUNT(aua.id), valid::TEXT FROM MIGSCHEMA.actor_usr_address aua GROUP BY 2 @@ -881,7 +881,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_addresses_pending Patron Addresses by Pending Status - Actors + actors 0 Count of Addresses.Pending.Migrated SELECT COUNT(aua.id), pending::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_address_legacy aua GROUP BY 2, 3 @@ -890,7 +890,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_addresses_pending Patron Addresses by Pending Status - Actors + actors 1 Count of Addresses.Pending SELECT COUNT(aua.id), pending::TEXT FROM MIGSCHEMA.actor_usr_address aua GROUP BY 2 @@ -899,7 +899,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_messages Patron Messages - Actors + actors 0 Count.Deleted.Migrated SELECT COUNT(aum.id), deleted::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_message_legacy aum GROUP BY 2, 3 @@ -908,7 +908,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_messages Patron Messages - Actors + actors 1 Count.Deleted SELECT COUNT(aum.id), deleted::TEXT FROM MIGSCHEMA.actor_usr_message_legacy aum GROUP BY 2 @@ -917,7 +917,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_notes Patron Notes - Actors + actors 0 Count.Public.Migrated SELECT COUNT(aun.id), pub::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_note_legacy aun GROUP BY 2, 3 @@ -926,7 +926,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_notes Patron Notes - Actors + actors 1 Count.Public SELECT COUNT(aun.id), pub::TEXT FROM MIGSCHEMA.actor_usr_note aun GROUP BY 2 @@ -935,7 +935,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_stat_cats Patron Statistical Categories - Actors + actors 0 Stat Cat Count.Library.Statistical Category.Migrated SELECT COUNT(au_sc.id), aou.name, au_sc.name, au_sc.x_migrate::TEXT FROM MIGSCHEMA.actor_stat_cat_legacy au_sc JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3, 4 ORDER BY 2, 3, 4 @@ -944,7 +944,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_stat_cats Patron Statistical Categories - Actors + actors 1 Stat Cat Count.Library.Statistical Category SELECT COUNT(au_sc.id), aou.name, au_sc.name FROM MIGSCHEMA.actor_stat_cat au_sc JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3 ORDER BY 2, 3 @@ -953,7 +953,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_stat_cat_entries Patron Stat Cat User Entries - Actors + actors 0 Patron Stat Count.Library.Statistical Category.Migrated SELECT COUNT(map.id), aou.name, au_sc.name, map.x_migrate::TEXT FROM MIGSCHEMA.actor_stat_cat_entry_usr_map_legacy map JOIN MIGSCHEMA.actor_stat_cat_legacy au_sc ON au_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3, 4 ORDER BY 2,3, 4 @@ -962,7 +962,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 usr_stat_cat_entries Patron Stat Cat User Entries - Actors + actors 1 Patron Stat Count.Library.Statistical Category SELECT COUNT(map.id), aou.name, au_sc.name FROM MIGSCHEMA.actor_stat_cat_entry_usr_map map JOIN MIGSCHEMA.actor_stat_cat au_sc ON au_sc.id = map.stat_cat JOIN actor.org_unit aou ON aou.id = au_sc.owner GROUP BY 2, 3 ORDER BY 2,3 @@ -972,7 +972,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 fund_count 0 - Acq + acq Migrated Funds Number of Funds.Migrated SELECT COUNT(id), x_migrate::TEXT FROM MIGSCHEMA.acq_fund_legacy GROUP BY 2; @@ -981,7 +981,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 fund_count 1 - Acq + acq Migrated Funds Number of Funds SELECT COUNT(id) FROM MIGSCHEMA.acq_fund; @@ -990,7 +990,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 invoice_count 0 - Acq + acq Migrated Invoices Number of Invoices.Migrated SELECT COUNT(id), x_migrate::TEXT FROM MIGSCHEMA.acq_invoice_legacy GROUP BY 2; @@ -999,7 +999,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 invoice_count 1 - Acq + acq Migrated Invoices Number of Funds SELECT COUNT(id) FROM MIGSCHEMA.acq_invoice;