X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fexcel_mapping_reports.xml;fp=mig-xml%2Fexcel_mapping_reports.xml;h=398ee4b7b5df6cd17b8c1f73298213577f4e03d5;hp=2c101b735f9946dc178e0c60aba1a67e2e518788;hb=ed08c6980961532b1376d37a215d18c769f187b9;hpb=2b587ddbb20cc567e3435c6d936e1521eb380047
diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml
index 2c101b7..398ee4b 100644
--- a/mig-xml/excel_mapping_reports.xml
+++ b/mig-xml/excel_mapping_reports.xml
@@ -475,6 +475,8 @@
These need to be mapped to Evergreen phone types.
+
+
hz_borrowersbybtypes
Borrowers by Borrower Types
@@ -485,13 +487,30 @@
+ hz_borrowersbybtypes
+ Borrowers by Borrower Types
+ horizon
+ 1
+ Count.Borrower Type
+ SELECT COUNT(id), btype FROM borrower_csv_clean GROUP BY 2 ORDER BY 2;
+
+
+
hz_borrowerpinsamples
Borrower PINs Samples
horizon
0
- Sample PINs
- SELECT l_borrower_pin FROM actor_usr_legacy WHERE LENGTH(l_borrower_pin) > 1 LIMIT 20;
- Only 16 PINS defined.
+ Count of Migratable Passwords / PINs
+ SELECT COUNT(l_borrower_pin) FROM actor_usr_legacy WHERE LENGTH(l_borrower_pin) > 1;
+
+
+
+ hz_borrowerpinsamples
+ Borrower PINs Samples
+ horizon
+ 1
+ Count of Migratable Passwords / PINs
+ SELECT COUNT(pin) FROM borrower_csv_clean WHERE LENGTH(pin) > 1;
@@ -499,9 +518,35 @@
Borrower Note Field Samples
horizon
0
- Count
+ Sample of Migratable Notes
SELECT l_borrower_borrower_note FROM actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1 LIMIT 20;
- 19,473
+
+
+
+ hz_borrowernotesample
+ Borrower Note Field Samples
+ horizon
+ 1
+ Sampel of Migratable Notes
+ SELECT l_borrower_borrower_note FROM actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1 LIMIT 20;
+
+
+
+ hz_borrowernotescount
+ Count of Migratable Borrower Notes
+ horizon
+ 0
+ Count
+ SELECT COUNT(l_borrower_borrower_note) FROM actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1;
+
+
+
+ hz_borrowernotescount
+ Counnt of Migratable Borrower NOtes
+ horizon
+ 1
+ Count
+ SELECT COUNT(l_borrower_borrower_note) FROM actor_usr_legacy WHERE LENGTH(l_borrower_borrower_note) > 1;
@@ -511,7 +556,6 @@
0
Count
SELECT l_borrower_note2 FROM actor_usr_legacy WHERE LENGTH(l_borrower_note2) > 1 LIMIT 20;
- 78
@@ -521,7 +565,6 @@
0
Count
SELECT l_borrower_note3 FROM actor_usr_legacy WHERE LENGTH(l_borrower_note3) > 1 LIMIT 20;
- Only 6.
@@ -538,7 +581,21 @@
UNION ALL SELECT l_borrower_phone_4_phone_type AS b FROM actor_usr_legacy) x
GROUP BY 2 ORDER BY 2
- Ordinal phones will have to be combined.
+
+
+
+ hz_phones
+ Borrower Phones
+ horizon
+ 1
+ Count.Borrower Phone Position
+
+ SELECT COUNT(*), '0' FROM borrower_phone_csv_clean WHERE ord = '0'
+ UNION ALL SELECT COUNT(*), '1' FROM borrower_phone_csv_clean WHERE ord = '1'
+ UNION ALL SELECT COUNT(*), '2' FROM borrower_phone_csv_clean WHERE ord = '2'
+ UNION ALL SELECT COUNT(*), '3' FROM borrower_phone_csv_clean WHERE ord = '3'
+ UNION ALL SELECT COUNT(*), '4' FROM borrower_phone_csv_clean WHERE ord = '4'
+
@@ -558,6 +615,16 @@
+ hz_bstats
+ Borrower B-Stats
+ horizon
+ 1
+ Count.B-Stat.Description
+ SELECT COUNT(*), a.bstat, b.descr FROM borrower_bstat_csv_clean a JOIN bstat_csv_clean b ON b.bstat = a.bstat GROUP BY 2, 3;
+
+
+
+
hz_copybycollection
Copies by Collection
horizon
@@ -566,13 +633,13 @@
SELECT COUNT(id), l_collection FROM asset_copy_legacy GROUP BY 2 ORDER BY 2;
-
- hz_copyfieldexamples
- Sample Copy Field Values
+
+ hz_copybycollection
+ Copies by Collection
horizon
- 0
- Field
- SELECT l_copy FROM asset_copy_legacy WHERE LENGTH(l_copy) > 1 LIMIT 30;
+ 1
+ Count.Collection.Description.PAC Description
+ SELECT COUNT(*), a.collection, b.descr, b.pac_descr FROM item_csv_clean a JOIN from collection_csv_clean c ON c.collection = a.collection GROUP BY 2, 3, 4 ORDER BY 2, 3, 4;
@@ -583,35 +650,52 @@
Count.Item Type (itype)
SELECT COUNT(id), l_itype FROM asset_copy_legacy GROUP BY 2 ORDER BY 2;
-
+
- hz_volfieldexamples
- Sample Volume Field Values
+ hz_itemsbyitype
+ Items by IType
horizon
- 0
- Field
- SELECT l_volume FROM asset_copy_legacy WHERE LENGTH(l_volume) > 1 LIMIT 30;
-
+ 1
+ Count.Item Type (itype).Description
+ SELECT COUNT(id), a.itype, b.descr FROM item_csv_clean a JOIN itype_csv_clean b ON b.itype = a.itype GROUP BY 2, 3 ORDER BY 2;
-
-
- hz_iteminhouseuses
- Item In House Uses
+
+
+ hz_internalnotescount
+ Internal/Check In Item Notes
horizon
0
- Count.Number of Uses
- SELECT COUNT(id), l_n_inhouse_uses FROM asset_copy_legacy GROUP BY 2 ORDER BY 2;
+ Count
+ SELECT COUNT(l_internal_note) FROM asset_copy_legacy WHERE LENGTH(l_internal_note) > 1;
+
+
+
+ hz_internalnotescount
+ Internal/Check In Item Notes
+ horizon
+ 1
+ Count
+ SELECT COUNT(cki_notes) FROM item_csv_clean WHERE LENGTH(cki_notes) > 1;
hz_internalnotesample
- Internal Item Notes
+ Internal/Check In Item Notes Sample
horizon
0
- Sample Note
- SELECT l_internal_note FROM asset_copy_legacy WHERE LENGTH(l_internal_note) > 1 LIMIT 30;
+ Count
+ SELECT l_internal_note FROM asset_copy_legacy WHERE LENGTH(l_internal_note) > 1 LIMIT 20;
-
+
+
+ hz_internalnotesample
+ Internal/Check In Item Notes Sample
+ horizon
+ 1
+ Count
+ SELECT cki_notes FROM item_csv_clean WHERE LENGTH(cki_notes) > 1 LIMIT 20;
+
+