<name>circ_count</name>
<tag>circs</tag>
<iteration>0</iteration>
- <report_title>Open Circulations</report_title>
- <heading>Circulation Status.Migrated.Count of Circs</heading>
- <query>SELECT 'Closed Circulations', x_migrate::TEXT, COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NOT NULL GROUP BY 2 UNION ALL SELECT 'Open Circulations', x_migrate::TEXT, COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL GROUP BY 2</query>
+ <report_title>Migrated Circulations</report_title>
+ <heading>Circulation Status.Count of Circs</heading>
+ <query>SELECT 'Closed Circulations', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NOT NULL AND x_migrate
+ UNION ALL SELECT 'Open Circulations', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL AND x_migrate</query>
+ </report>
+
+ <report>
+ <name>circ_count_unmigrated</name>
+ <tag>circs</tag>
+ <iteration>0</iteration>
+ <report_title>Open Un-migrated Circulations</report_title>
+ <heading>Circulation Status.Count of Circs</heading>
+ <query>SELECT 'No Matching User', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL AND x_migrate = FALSE AND usr IS NULL
+ UNION ALL SELECT 'No Matching Item', COUNT(id) FROM action_circulation_legacy WHERE xact_finish IS NULL AND x_migrate = FALSE AND target_copy IS NULL </query>
</report>
<report>
</report>
<report>
+ <name>asset_precat</name>
+ <report_title>Precats (AKA Copies Without Bibs)</report_title>
+ <tag>assets</tag>
+ <iteration>0</iteration>
+ <heading>Copy Count.Migating</heading>
+ <query>SELECT COUNT(ac.id), ac.x_migrate::TEXT FROM asset_copy_legacy ac WHERE ac.x_bre_id = -1 GROUP BY 2</query>
+ </report>
+
+ <report>
<name>asset_circ_mod_copies_count</name>
<report_title>Copies by Circulation Modifier</report_title>
<tag>assets</tag>
<query>SELECT COUNT(map.id), tag.tag_type, tag.label, tag.staff_note, tag.pub FROM asset_copy_tag tag JOIN asset_copy_tag_copy_map map ON map.tag = tag.id GROUP BY 2,3,4,5 ORDER BY 2,3</query>
</report>
+ <report>
+ <name>asset_copy_alerts</name>
+ <report_title>Copy Alerts</report_title>
+ <tag>assets</tag>
+ <iteration>0</iteration>
+ <heading>Alert Count.Alert Type</heading>
+ <query>SELECT COUNT(*), cat.name FROM asset_copy_alert aca JOIN config.copy_alert_type cat ON cat.id = aca.alert_type GROUP BY 2</query>
+ </report>
+
<!-- MONEY REPORTS -->
<report>
<report_title>Extracted Bibliographic Records</report_title>
<tag>bibs</tag>
<iteration>0</iteration>
- <heading>Count.Deleted.Migrated</heading>
- <query>SELECT COUNT(bre.id), bre.deleted::TEXT, bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3</query>
+ <heading>Count.Sourcee.Migrated</heading>
+ <query>SELECT COUNT(bre.id), bre.x_source, bre.x_migrate::TEXT FROM biblio_record_entry_legacy bre GROUP BY 2, 3 ORDER BY 2, 3</query>
<note>False means the records are not deleted.</note>
</report>
<report>
- <name>bibs</name>
- <report_title>Extracted Bibliographic Records</report_title>
- <tag>bibs</tag>
- <iteration>1</iteration>
- <heading>Count</heading>
- <query>SELECT COUNT(id) FROM biblio_record_entry_stage WHERE x_migrate = TRUE</query>
- </report>
-
- <report>
<name>bibswovolumes</name>
<report_title>Bibliographic Records Without Volumes</report_title>
<tag>bibs</tag>