X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fexcel_mapping_reports.xml;h=6c8dc7336638d45e90c4e6775d3f1fdc199fad4a;hp=88b070063fdc3f147591e5496da8478e59f0ff38;hb=371837d00ef07cb77f7e8ff44d1ec7fbc69beff0;hpb=680a58667165f6840d0d62cafc322871856c4bd7
diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml
index 88b0700..6c8dc73 100644
--- a/mig-xml/excel_mapping_reports.xml
+++ b/mig-xml/excel_mapping_reports.xml
@@ -491,13 +491,13 @@
Borrowers by Borrower Types
horizon
1
- Count.Borrower Type
- SELECT COUNT(id), btype FROM borrower_csv_clean GROUP BY 2 ORDER BY 2;
+ Count.Borrower Type.Description
+ SELECT COUNT(*), a.btype, b.descr FROM borrower_csv_clean a JOIN btype_csv_clean b ON b.btype = a.btype GROUP BY 2, 3 ORDER BY 2;
- hz_borrowerpinsamples
- Borrower PINs Samples
+ hz_borrowerpincount
+ Borrower PINs Count
horizon
0
Count of Migratable Passwords / PINs
@@ -505,8 +505,8 @@
- hz_borrowerpinsamples
- Borrower PINs Samples
+ hz_borrowerpincount
+ Borrower PINs Count
horizon
1
Count of Migratable Passwords / PINs
@@ -527,8 +527,8 @@
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;
+ Sample of Migratable Notes
+ SELECT borrower_note FROM borrower_csv_clean WHERE LENGTH(borrower_note) > 1 LIMIT 20;
@@ -542,11 +542,11 @@
hz_borrowernotescount
- Counnt of Migratable Borrower NOtes
+ 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;
+ SELECT COUNT(borrower_note) FROM borrower_csv_clean WHERE LENGTH(borrower_note) > 1;
@@ -639,7 +639,7 @@
horizon
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;
+ SELECT COUNT(*), a.collection, c.descr, c.pac_descr FROM item_csv_clean a JOIN collection_csv_clean c ON c.collection = a.collection GROUP BY 2, 3, 4 ORDER BY 2, 3, 4;
@@ -657,7 +657,7 @@
horizon
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;
+ SELECT COUNT(*), 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;