X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fresource_mate.xml;h=e58e5723abcf30051eb4cda92cf4fdf959bcd0c7;hp=d79091cdfe394c53630ee3281b333f1a1cafc66f;hb=a8f3b4894c409e7568658ab9c8b51d17e46cb469;hpb=337680650a86c2fb1c5d5bddfb4053a56fb9964b
diff --git a/mig-xml/resource_mate.xml b/mig-xml/resource_mate.xml
index d79091c..e58e572 100644
--- a/mig-xml/resource_mate.xml
+++ b/mig-xml/resource_mate.xml
@@ -6,7 +6,7 @@
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,SUM(amount) FROM MIGSCHEMA.money_billing_legacy GROUP BY 2; query itself, MIGSCHEMA will be replaced
+ SELECT COUNT(id),x_migrate,SUM(amount) FROM money_billing_legacy GROUP BY 2; query itself, will be replaced
Arbitrary note that can be included in the entries.
-->
@@ -19,7 +19,7 @@
0
Circulations in Extract
Count of Circs.Status
- SELECT COUNT(id), l_is_checked_out FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2
+ SELECT COUNT(id), l_is_checked_out FROM asset_copy_legacy GROUP BY 2
@@ -32,7 +32,7 @@
assets
0
Count.Resource Type
- SELECT COUNT(*), l_resource_type FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(*), l_resource_type FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
@@ -41,7 +41,7 @@
assets
0
Count.Location
- SELECT COUNT(*), l_location FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2
+ SELECT COUNT(*), l_location FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
@@ -49,8 +49,8 @@
Count of Copies in Extract by Category
assets
0
- Count.Location
- SELECT COUNT(*), l_location FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2
+ Count.Category
+ SELECT COUNT(*), l_category FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
@@ -58,8 +58,8 @@
Count of Copies in Extract by Status
assets
0
- Count.Location
- SELECT COUNT(*), l_status FROM MIGSCHEMA.asset_copy_legacy GROUP BY 2 ORDER BY 2
+ Count.Status
+ SELECT COUNT(*), l_status FROM asset_copy_legacy GROUP BY 2 ORDER BY 2
@@ -72,7 +72,7 @@
money
0
Count
- SELECT COUNT(*) FROM MIGSCHEMA.fines
+ SELECT COUNT(*) FROM fines
@@ -81,7 +81,7 @@
money
0
First Name.Last Name.Fine Amount
- SELECT first_given_name, family_name, amount FROM MIGSCHEMA.fines WHERE au_id IS NULL ORDER BY 2, 1
+ SELECT first_given_name, family_name, amount FROM fines WHERE au_id IS NULL ORDER BY 2, 1
@@ -90,7 +90,7 @@
money
0
First Name.Last Name.Fine Amount
- SELECT first_given_name, family_name, amount FROM MIGSCHEMA.fines WHERE multi_au IS TRUE ORDER BY 2, 1
+ SELECT first_given_name, family_name, amount FROM fines WHERE multi_au IS TRUE ORDER BY 2, 1
@@ -103,7 +103,7 @@
bibs
0
Count
- SELECT COUNT(eg) FROM MIGSCHEMA.bib_id_map
+ SELECT COUNT(eg) FROM bib_id_map
@@ -114,12 +114,12 @@
actors
0
Count.Address Component
- SELECT COUNT(id), 'Address 1' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_address_1) > 1
- UNION ALL SELECT COUNT(id), 'Address 2' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_address_2) > 1
- UNION ALL SELECT COUNT(id), 'City' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_city) > 1
- UNION ALL SELECT COUNT(id), 'State' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_state) > 1
- UNION ALL SELECT COUNT(id), 'County' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_country) > 1
- UNION ALL SELECT COUNT(id), 'Zip Code' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_zip_code) > 1
+ SELECT COUNT(id), 'Address 1' FROM actor_usr_legacy WHERE LENGTH(l_address_1) > 1
+ UNION ALL SELECT COUNT(id), 'Address 2' FROM actor_usr_legacy WHERE LENGTH(l_address_2) > 1
+ UNION ALL SELECT COUNT(id), 'City' FROM actor_usr_legacy WHERE LENGTH(l_city) > 1
+ UNION ALL SELECT COUNT(id), 'State' FROM actor_usr_legacy WHERE LENGTH(l_state) > 1
+ UNION ALL SELECT COUNT(id), 'County' FROM actor_usr_legacy WHERE LENGTH(l_country) > 1
+ UNION ALL SELECT COUNT(id), 'Zip Code' FROM actor_usr_legacy WHERE LENGTH(l_zip_code) > 1
@@ -129,7 +129,7 @@
actors
0
Count.Expiration Year
- SELECT COUNT(id), RIGHT(BTRIM(l_membership_expiry),4) FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), RIGHT(BTRIM(l_membership_expiry),4) FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;
@@ -139,7 +139,7 @@
actors
0
Count.Barcode Length
- SELECT COUNT(id), LENGTH(l_barcode) FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), LENGTH(l_barcode) FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;
@@ -149,7 +149,7 @@
actors
0
Count
- SELECT COUNT(id) FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_birthdate) > 1;
+ SELECT COUNT(id) FROM actor_usr_legacy WHERE LENGTH(l_birthdate) > 1;
@@ -159,7 +159,7 @@
actors
0
Count.Group
- SELECT COUNT(id), l_user_group FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), l_user_group FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;
@@ -169,7 +169,7 @@
actors
0
Count.Access
- SELECT COUNT(id), l_access_if_applicable FROM MIGSCHEMA.actor_usr_legacy GROUP BY 2 ORDER BY 2;
+ SELECT COUNT(id), l_access_if_applicable FROM actor_usr_legacy GROUP BY 2 ORDER BY 2;
@@ -179,10 +179,10 @@
actors
0
Count.Address Component
- SELECT COUNT(id), 'email' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_e_mail) > 1
- UNION ALL SELECT COUNT(id), 'Phone (home)' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_phone_home) > 1
- UNION ALL SELECT COUNT(id), 'Phone (work)' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_phone_work) > 1
- UNION ALL SELECT COUNT(id), 'Phone (cell)' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_phone_cell) > 1
+ SELECT COUNT(id), 'email' FROM actor_usr_legacy WHERE LENGTH(l_e_mail) > 1
+ UNION ALL SELECT COUNT(id), 'Phone (home)' FROM actor_usr_legacy WHERE LENGTH(l_phone_home) > 1
+ UNION ALL SELECT COUNT(id), 'Phone (work)' FROM actor_usr_legacy WHERE LENGTH(l_phone_work) > 1
+ UNION ALL SELECT COUNT(id), 'Phone (cell)' FROM actor_usr_legacy WHERE LENGTH(l_phone_cell) > 1
@@ -192,8 +192,8 @@
actors
0
Count.Sample
- SELECT COUNT(id), 'All Comments' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_comments) > 1
- UNION ALL SELECT NULL, l_comments FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_comments) > 1 LIMIT 10
+ SELECT COUNT(id), 'All Comments' FROM actor_usr_legacy WHERE LENGTH(l_comments) > 1
+ UNION ALL SELECT NULL, l_comments FROM actor_usr_legacy WHERE LENGTH(l_comments) > 1 LIMIT 10
@@ -203,8 +203,8 @@
actors
0
Count.Sample
- SELECT COUNT(id), 'All Notes' FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1
- UNION ALL SELECT NULL, l_circulation_note FROM MIGSCHEMA.actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 LIMIT 10
+ SELECT COUNT(id), 'All Notes' FROM actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1
+ UNION ALL SELECT NULL, l_circulation_note FROM actor_usr_legacy WHERE LENGTH(l_circulation_note) > 1 LIMIT 10