<report>
<name>name of report</name>
<iteration value='0' /> which version, the first version to run is 0, first backup is 1, then so on
- <tag>Money</tag> arbitrary tags, each should go in separate tag
+ <tag>money</tag> arbitrary tags, each should go in separate tag
<report_title>Migrated Billings</report_title> title used in the asciidoc output
<heading column='1'>Number of Billings.Migrated.Total</heading> period delimited
<query>SELECT COUNT(id),x_migrate::TEXT,SUM(amount) FROM MIGSCHEMA.money_billing_legacy GROUP BY 2;</query> query itself, MIGSCHEMA will be replaced
<!-- CIRC REPORTS -->
<report>
<name>circ_count</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Open Circulations</report_title>
<heading>Circulation Status.Migrated.Count of Circs</heading>
<report>
<name>circ_count</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Open Circulations</report_title>
<heading>Circulation Status.Count of Circs</heading>
<!-- intent is to add a report by circulated and item status
<report>
<name>circ_count_by_item_status</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Open Circulations</report_title>
<heading>Circulation Status.Migrated.Count of Circs</heading>
-->
<report>
<name>circ_by_orgunit</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Circulations by Org Unit</report_title>
<heading>Circulations Count.Migrated.Org Unit</heading>
<report>
<name>circ_by_orgunit</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Circulations by Org Unit</report_title>
<heading>Circulations Count.Org Unit</heading>
<report>
<name>circs_by_duration</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Migrated Circulations by Duration, Fine and Max Fine</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine.Migrated</heading>
<report>
<name>circs_by_duration</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Circulations by Duration, Fine and Max Fine</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine</heading>
<report>
<name>circs_by_usrgroup</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Circulations by Rules and Patron Group</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine.User Group.Matchpoints</heading>
<report>
<name>circs_by_usrgroup</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Circulations by Rules and Patron Group</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine.User Group.Matchpoints</heading>
<report>
<name>circs_by_circmod</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Circulations by Rules and Circulation Modifier</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine.Circulation Modifier.Matchpoints</heading>
<report>
<name>circs_by_circmod</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Circulations by Rules and Circulation Modifier</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine.Circulation Modifier.Matchpoints</heading>
<report>
<name>circs_by_orgunit</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Circulations by Rules and Org Unit</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine.Library Branch</heading>
<report>
<name>circs_by_orgunit</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Circulations by Rules and Org Unit</report_title>
<heading>Count of Circs.Duration.Fine.Max Fine.Library Branch</heading>
<report>
<name>non_cat_circs</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Non-Cataloged Circulation</report_title>
<heading>Circulations Count.Migrated</heading>
<report>
<name>non_cat_circs</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Non-Cataloged Circulation</report_title>
<heading>Circulations Count</heading>
<report>
<name>in_house</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>In House Use</report_title>
<heading>In House Use Records.Migrated</heading>
<report>
<name>in_house</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>In House Use</report_title>
<heading>In House Use Records</heading>
<report>
<name>circs_missing_rules</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>1</iteration>
<report_title>Circs Missing Rules</report_title>
<heading>Count.Field Missing</heading>
<report>
<name>circ_open_by_item_status</name>
- <tag>Circs</tag>
+ <tag>circs</tag>
<iteration>0</iteration>
<report_title>Open Circulation and Status of Linked Items</report_title>
<heading>Count.Status</heading>
<report>
<name>holds</name>
- <tag>Holds</tag>
+ <tag>holds</tag>
<iteration>0</iteration>
<report_title>Migrated Holds</report_title>
<heading>Hold Type.Hold Count.Migrated</heading>
<report>
<name>holds_bytype</name>
- <tag>Holds</tag>
+ <tag>holds</tag>
<iteration>0</iteration>
<report_title>Migrated Holds By Type</report_title>
<heading>Hold Type.Hold Count.Migrated</heading>
<report>
<name>transit_open_by_item_status</name>
- <tag>Holds</tag>
+ <tag>holds</tag>
<iteration>0</iteration>
<report_title>Transit Copy Records and Status of Linked Items</report_title>
<heading>Count.Status</heading>
<report>
<name>transit_copies_by_status</name>
- <tag>Holds</tag>
+ <tag>holds</tag>
<iteration>0</iteration>
<report_title>Status of Items with Count of Open In Transits</report_title>
<heading>Count.Status.Count of Open Transits</heading>
<report>
<name>hold_copies_by_status</name>
- <tag>Holds</tag>
+ <tag>holds</tag>
<iteration>0</iteration>
<report_title>Captured Holds with Status of Items</report_title>
<heading>Count of Captured Hold.Status of Item</heading>
<report>
<name>hold_depth</name>
- <tag>Holds</tag>
+ <tag>holds</tag>
<iteration>0</iteration>
<report_title>Depth of Unfilled Holds</report_title>
<heading>Count.Depth</heading>
<report>
<name>asset_copy_count</name>
<report_title>Count of Copies by Library</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Copy Count.Library.Migrated</heading>
<query>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</query>
<report>
<name>asset_deleted_copies</name>
<report_title>Deleted Copies</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Copy Count.Deleted.Migrated</heading>
<query>SELECT COUNT(ac.id), ac.deleted::TEXT, ac.x_migrate::TEXT FROM MIGSCHEMA.asset_copy_legacy ac GROUP BY 2, 3</query>
<report>
<name>asset_copies_by_status</name>
<report_title>Copies by Status</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Copy Count.Status.Migrated</heading>
<query>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</query>
<report>
<name>asset_circ_mod_copies_count</name>
<report_title>Copies by Circulation Modifier</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Copy Count.Circulation Modifier.Migrated</heading>
<query>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</query>
<report>
<name>asset_copy_notes</name>
<report_title>Copy Notes</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Note Count.Public.Migrated</heading>
<query>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</query>
<report>
<name>asset_copy_notes</name>
<report_title>Copy Notes</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Note Count.Public</heading>
<query>SELECT COUNT(acnote.id), acnote.pub::TEXT FROM MIGSCHEMA.asset_copy_note acnote GROUP BY 2 ORDER BY 2</query>
<report>
<name>asset_vols_by_lib</name>
<report_title>Volumes by Library</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Volume Count.Library.Migrated</heading>
<query>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</query>
<report>
<name>asset_vols_by_lib</name>
<report_title>Volumes by Library</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Volume Count.Library</heading>
<query>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</query>
<report>
<name>asset_cops_by_loc</name>
<report_title>Copies by Location</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Copy Count.Library.Migrated</heading>
<query>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</query>
<report>
<name>asset_cops_by_loc_and_org</name>
<report_title>Copies by Location</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Copy Count.Library.Circ Library.Migrated</heading>
<query>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</query>
<report>
<name>asset_barcode_lengths</name>
<report_title>Barcode Lengths by Library</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Count of Barcode.Barcode Length.Library</heading>
<query>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</query>
<report>
<name>asset_barcode_patterns</name>
<report_title>Common Barcode Starting Patterns</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Count of Barcodes (greater than 10).Left 60% of Characters</heading>
<query>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</query>
<report>
<name>asset_barcode_incumbent_collisions</name>
<report_title>Copy Barcode Incumbent Collisions</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Collision Count</heading>
<query>SELECT COUNT(id) FROM MIGSCHEMA.asset_copy_legacy WHERE x_migrate = TRUE AND barcode ~* 'collision' and barcode ~* 'incumbent'</query>
<report>
<name>asset_barcode_incumbent_collisions</name>
<report_title>Copy Barcode Incumbent Collisions</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Collision Count</heading>
<query>SELECT COUNT(id) FROM MIGSCHEMA.asset_copy WHERE barcode ~* 'collision' and barcode ~* 'incumbent'</query>
<report>
<name>asset_barcode_internal_collisions</name>
<report_title>Copy Barcode Internal Collisions</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Collision Count</heading>
<query>SELECT COUNT(id) FROM MIGSCHEMA.asset_copy_legacy WHERE x_migrate = TRUE AND barcode ~* 'collision' and barcode ~* 'internal'</query>
<report>
<name>asset_barcode_internal_collisions</name>
<report_title>Copy Barcode Internal Collisions</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Collision Count</heading>
<query>SELECT COUNT(id) FROM MIGSCHEMA.asset_copy WHERE barcode ~* 'collision' and barcode ~* 'internal'</query>
<report>
<name>asset_barcode_collisions_shortlist</name>
<report_title>Copy Barcode Collisions (first 20)</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Collision List</heading>
<query>SELECT ac.barcode FROM MIGSCHEMA.asset_copy_legacy ac WHERE ac.barcode ~* 'collision' ORDER BY 1 LIMIT 20</query>
<report>
<name>asset_barcode_collisions_shortlist</name>
<report_title>Copy Barcode Collisions (first 20)</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Collision List</heading>
<query>SELECT ac.barcode FROM MIGSCHEMA.asset_copy ac WHERE ac.barcode ~* 'collision' ORDER BY 1 LIMIT 20</query>
<report>
<name>asset_barcode_collision_patterns</name>
<report_title>Common Copy Barcode Collision Patterns</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters</heading>
<query>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</query>
<report>
<name>asset_barcode_collision_patterns</name>
<report_title>Common Copy Barcode Collision Patterns</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters</heading>
<query>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</query>
<report>
<name>asset_stat_cats</name>
<report_title>Copy Statistical Categories</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Stat Cat Count.Library.Statistical Category</heading>
<query>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</query>
<report>
<name>asset_stat_cats</name>
<report_title>Copy Statistical Categories</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Stat Cat Count.Library.Statistical Category</heading>
<query>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</query>
<report>
<name>asset_stat_cat_entries</name>
<report_title>Copy Stat Cat User Entries</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Copy Stat Count.Library.Statistical Category</heading>
<query>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</query>
<report>
<name>asset_stat_cat_entries</name>
<report_title>Copy Stat Cat User Entries</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>1</iteration>
<heading>Copy Stat Count.Library.Statistical Category</heading>
<query>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.
<report>
<name>asset_copy_tags</name>
<report_title>Copy Tags</report_title>
- <tag>Assets</tag>
+ <tag>assets</tag>
<iteration>0</iteration>
<heading>Tag Count.Copy Tag Type.Copy Tag Label.Staff Note.Public</heading>
<query>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</query>
<report>
<name>money_billing_voided</name>
<report_title>Bills Voided And Not</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>money_billing_voided</name>
<report_title>Bills Voided And Not</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>1</iteration>
<heading>Count.Voided.Sum</heading>
<query>SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM MIGSCHEMA.money_billing a GROUP BY 2 ORDER BY 2, 3</query>
<report>
<name>money_billing_by_type</name>
<report_title>Bills by Type</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Billing Type.Migrated</heading>
<query>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</query>
<report>
<name>money_billing_by_type</name>
<report_title>Bills by Type</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>1</iteration>
<heading>Count.Billing Type</heading>
<query>SELECT COUNT(a.id), a.billing_type FROM MIGSCHEMA.money_billing a GROUP BY 2 ORDER BY 2</query>
<report>
<name>money_cash_payment</name>
<report_title>Cash Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>money_cash_payment</name>
<report_title>Cash Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>1</iteration>
<heading>Count.Voided.Sum</heading>
<query>SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM MIGSCHEMA.money_cash_payment a GROUP BY 2 ORDER BY 2</query>
<report>
<name>money_check_payment</name>
<report_title>Check Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>money_forgive_payment</name>
<report_title>Forgive Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>money_forgive_payment</name>
<report_title>Forgive Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>1</iteration>
<heading>Count.Voided.Sum</heading>
<query>SELECT COUNT(a.id), a.voided::TEXT, SUM(a.amount) FROM MIGSCHEMA.money_forgive_paymen a GROUP BY 2 ORDER BY 2</query>
<report>
<name>money_goods_payment</name>
<report_title>Goods Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>money_work_payment</name>
<report_title>Work Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>money_credit_card_payment</name>
<report_title>Credit Card Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>money_credit_payment</name>
<report_title>Credit Payments</report_title>
- <tag>Money</tag>
+ <tag>money</tag>
<iteration>0</iteration>
<heading>Count.Voided.Sum.Migrated</heading>
<query>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</query>
<report>
<name>bibs</name>
<report_title>Extracted Bibliographic Records</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>0</iteration>
<heading>Count.Deleted.Migrated</heading>
<query>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</query>
<report>
<name>bibs</name>
<report_title>Extracted Bibliographic Records</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>1</iteration>
<heading>Count</heading>
<query>SELECT COUNT(eg) FROM MIGSCHEMA.bib_id_map</query>
<report>
<name>bibswovolumes</name>
<report_title>Bibliographic Records Without Volumes</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>0</iteration>
<heading>Count</heading>
<query>SELECT COUNT(eg) FROM MIGSCHEMA.bib_id_map where eg::INTEGER NOT IN (SELECT DISTINCT record FROM MIGSCHEMA.asset_call_number)</query>
<report>
<name>bibs_notes</name>
<report_title>Bib Record Notes</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>0</iteration>
<heading>Count.Migrated</heading>
<query>SELECT COUNT(b.id), b.x_migrate::TEXT FROM MIGSCHEMA.biblio_record_note_legacy b GROUP BY 2</query>
<report>
<name>bibs_notes</name>
<report_title>Bib Record Notes</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>1</iteration>
<heading>Count</heading>
<query>SELECT COUNT(b.id) FROM MIGSCHEMA.biblio_record_note b</query>
<report>
<name>bibs_peers</name>
<report_title>Peer Bib Copies</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>0</iteration>
<heading>Count.Migrated</heading>
<query>SELECT COUNT(b.id), b.x_migrate::TEXT FROM MIGSCHEMA.biblio_peer_bib_copy_map_legacy b GROUP BY 2</query>
<report>
<name>bibs_peers</name>
<report_title>Peer Bib Copies</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>1</iteration>
<heading>Count</heading>
<query>SELECT COUNT(b.id) FROM MIGSCHEMA.biblio_peer_bib_copy_map b</query>
<report>
<name>bibs_parts</name>
<report_title>Monograph Parts</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>0</iteration>
<heading>Count.Migrated</heading>
<query>SELECT COUNT(b.id), b.x_migrate::TEXT FROM MIGSCHEMA.biblio_monograph_part_legacy b GROUP BY 2</query>
<report>
<name>bibs_parts</name>
<report_title>Monograph Parts</report_title>
- <tag>Bibs</tag>
+ <tag>bibs</tag>
<iteration>1</iteration>
<heading>Count</heading>
<query>SELECT COUNT(b.id) FROM MIGSCHEMA.biblio_monograph_part b</query>
<report>
<name>usrsbyorg</name>
<report_title>Patrons by Home Org</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count.Library.Deleted.Migrated</heading>
<query>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</query>
<report>
<name>usrsbypgt</name>
<report_title>Patrons by Permission Group</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count.Permission Group.Migrated</heading>
<query>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</query>
<report>
<name>active_usrs</name>
<report_title>Patron by Active Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count of Users.Active.Migrated</heading>
<query>SELECT COUNT(id), active::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2, 3</query>
<report>
<name>active_usrs</name>
<report_title>Patrons by Active Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count of Users.Active</heading>
<query>SELECT COUNT(id), active::TEXT FROM MIGSCHEMA.actor_usr GROUP BY 2</query>
<report>
<name>active_usr_barcodes</name>
<report_title>Patron Barcodes by Active Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count of Barcodes.Active.Migrated</heading>
<query>SELECT COUNT(id), active::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_card_legacy GROUP BY 2, 3</query>
<report>
<name>active_usr_barcodes</name>
<report_title>Patron Barcodes by Active Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count of Barcodes.Active</heading>
<query>SELECT COUNT(id), active::TEXT FROM MIGSCHEMA.actor_card GROUP BY 2</query>
<report>
<name>usr_barcode_lengths</name>
<report_title>Barcode Lengths by Library</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count of Barcode.Barcode Length.Library</heading>
<query>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</query>
<report>
<name>usr_barcode_lengths</name>
<report_title>Barcode Lengths by Library</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count of Barcode.Barcode Length.Library</heading>
<query>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</query>
<report>
<name>usr_barcode_patterns</name>
<report_title>Common Barcode Starting Patterns</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count of Barcodes (greater than 10).Left 60% of Characters</heading>
<query>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</query>
<report>
<name>usr_barcode_patterns</name>
<report_title>Common Barcode Starting Patterns</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count of Barcodes (greater than 10).Left 60% of Characters</heading>
<query>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</query>
<report>
<name>usr_barcode_collisions</name>
<report_title>Patron Barcode Collisions</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Collision Count</heading>
<query>SELECT COUNT(acard.id) FROM MIGSCHEMA.actor_card_legacy acard WHERE barcode ~* 'collision' AND x_migrate = TRUE</query>
<report>
<name>usr_barcode_collisions</name>
<report_title>Patron Barcode Collisions</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Collision Count</heading>
<query>SELECT COUNT(acard.id) FROM MIGSCHEMA.actor_card acard WHERE barcode ~* 'collision'</query>
<report>
<name>usr_barcode_collision_shortlist</name>
<report_title>Patron Barcode Collisions (first 20)</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Collision List</heading>
<query>SELECT acard.barcode FROM MIGSCHEMA.actor_card_legacy acard WHERE acard.barcode ~* 'collision' AND acard.x_migrate = TRUE ORDER BY 1 LIMIT 20</query>
<report>
<name>usr_barcode_collision_shortlist</name>
<report_title>Patron Barcode Collisions (first 20)</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Collision List</heading>
<query>SELECT acard.barcode FROM MIGSCHEMA.actor_card acard WHERE acard.barcode ~* 'collision' ORDER BY 1 LIMIT 20</query>
<report>
<name>usr_barcode_collision_patterns</name>
<report_title>Common Patron Barcode Collision Patterns</report_title> a.x_migrate
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters</heading>
<query>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</query>
<report>
<name>usr_barcode_collision_patterns</name>
<report_title>Common Patron Barcode Collision Patterns</report_title> a.x_migrate
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Number of Barcodes Matching Pattern Greater than 10.Left 60% of Characters</heading>
<query>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</query>
<report>
<name>usr_addressses_status</name>
<report_title>Patron Addresses by Valid Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count.Valid.Migrated</heading>
<query>SELECT COUNT(aua.id), valid::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_address_legacy aua GROUP BY 2, 3</query>
<report>
<name>usr_addressses_status</name>
<report_title>Patron Addresses by Valid Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count.Valid</heading>
<query>SELECT COUNT(aua.id), valid::TEXT FROM MIGSCHEMA.actor_usr_address aua GROUP BY 2</query>
<report>
<name>usr_addresses_pending</name>
<report_title>Patron Addresses by Pending Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count of Addresses.Pending.Migrated</heading>
<query>SELECT COUNT(aua.id), pending::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_address_legacy aua GROUP BY 2, 3</query>
<report>
<name>usr_addresses_pending</name>
<report_title>Patron Addresses by Pending Status</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count of Addresses.Pending</heading>
<query>SELECT COUNT(aua.id), pending::TEXT FROM MIGSCHEMA.actor_usr_address aua GROUP BY 2</query>
<report>
<name>usr_messages</name>
<report_title>Patron Messages</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count.Deleted.Migrated</heading>
<query>SELECT COUNT(aum.id), deleted::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_message_legacy aum GROUP BY 2, 3</query>
<report>
<name>usr_messages</name>
<report_title>Patron Messages</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count.Deleted</heading>
<query>SELECT COUNT(aum.id), deleted::TEXT FROM MIGSCHEMA.actor_usr_message_legacy aum GROUP BY 2</query>
<report>
<name>usr_notes</name>
<report_title>Patron Notes</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Count.Public.Migrated</heading>
<query>SELECT COUNT(aun.id), pub::TEXT, x_migrate::TEXT FROM MIGSCHEMA.actor_usr_note_legacy aun GROUP BY 2, 3</query>
<report>
<name>usr_notes</name>
<report_title>Patron Notes</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Count.Public</heading>
<query>SELECT COUNT(aun.id), pub::TEXT FROM MIGSCHEMA.actor_usr_note aun GROUP BY 2</query>
<report>
<name>usr_stat_cats</name>
<report_title>Patron Statistical Categories</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Stat Cat Count.Library.Statistical Category.Migrated</heading>
<query>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</query>
<report>
<name>usr_stat_cats</name>
<report_title>Patron Statistical Categories</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Stat Cat Count.Library.Statistical Category</heading>
<query>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</query>
<report>
<name>usr_stat_cat_entries</name>
<report_title>Patron Stat Cat User Entries</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>0</iteration>
<heading>Patron Stat Count.Library.Statistical Category.Migrated</heading>
<query>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</query>
<report>
<name>usr_stat_cat_entries</name>
<report_title>Patron Stat Cat User Entries</report_title>
- <tag>Actors</tag>
+ <tag>actors</tag>
<iteration>1</iteration>
<heading>Patron Stat Count.Library.Statistical Category</heading>
<query>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</query>
<report>
<name>fund_count</name>
<iteration>0</iteration>
- <tag>Acq</tag>
+ <tag>acq</tag>
<report_title>Migrated Funds</report_title>
<heading>Number of Funds.Migrated</heading>
<query>SELECT COUNT(id), x_migrate::TEXT FROM MIGSCHEMA.acq_fund_legacy GROUP BY 2;</query>
<report>
<name>fund_count</name>
<iteration>1</iteration>
- <tag>Acq</tag>
+ <tag>acq</tag>
<report_title>Migrated Funds</report_title>
<heading>Number of Funds</heading>
<query>SELECT COUNT(id) FROM MIGSCHEMA.acq_fund;</query>
<report>
<name>invoice_count</name>
<iteration>0</iteration>
- <tag>Acq</tag>
+ <tag>acq</tag>
<report_title>Migrated Invoices</report_title>
<heading>Number of Invoices.Migrated</heading>
<query>SELECT COUNT(id), x_migrate::TEXT FROM MIGSCHEMA.acq_invoice_legacy GROUP BY 2;</query>
<report>
<name>invoice_count</name>
<iteration>1</iteration>
- <tag>Acq</tag>
+ <tag>acq</tag>
<report_title>Migrated Invoices</report_title>
<heading>Number of Funds</heading>
<query>SELECT COUNT(id) FROM MIGSCHEMA.acq_invoice;</query>
projects / migration-tools.git / commitdiff