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=c9636e57f27829896b9af09d617886da1c5fec47;hp=6c8dc7336638d45e90c4e6775d3f1fdc199fad4a;hb=dfcf6fb3150dec2b6decd76d0fc9bce133d51599;hpb=371837d00ef07cb77f7e8ff44d1ec7fbc69beff0
diff --git a/mig-xml/excel_mapping_reports.xml b/mig-xml/excel_mapping_reports.xml
index 6c8dc73..c9636e5 100644
--- a/mig-xml/excel_mapping_reports.xml
+++ b/mig-xml/excel_mapping_reports.xml
@@ -475,7 +475,8 @@
These need to be mapped to Evergreen phone types.
-
+
+
hz_borrowersbybtypes
@@ -489,8 +490,8 @@
hz_borrowersbybtypes
Borrowers by Borrower Types
- horizon
- 1
+ horizon2
+ 0
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;
@@ -507,8 +508,8 @@
hz_borrowerpincount
Borrower PINs Count
- horizon
- 1
+ horizon2
+ 0
Count of Migratable Passwords / PINs
SELECT COUNT(pin) FROM borrower_csv_clean WHERE LENGTH(pin) > 1;
@@ -525,8 +526,8 @@
hz_borrowernotesample
Borrower Note Field Samples
- horizon
- 1
+ horizon2
+ 0
Sample of Migratable Notes
SELECT borrower_note FROM borrower_csv_clean WHERE LENGTH(borrower_note) > 1 LIMIT 20;
@@ -543,8 +544,8 @@
hz_borrowernotescount
Counnt of Migratable Borrower Notes
- horizon
- 1
+ horizon2
+ 0
Count
SELECT COUNT(borrower_note) FROM borrower_csv_clean WHERE LENGTH(borrower_note) > 1;
@@ -586,8 +587,8 @@
hz_phones
Borrower Phones
- horizon
- 1
+ horizon2
+ 0
Count.Borrower Phone Position
SELECT COUNT(*), '0' FROM borrower_phone_csv_clean WHERE ord = '0'
@@ -617,8 +618,8 @@
hz_bstats
Borrower B-Stats
- horizon
- 1
+ horizon2
+ 0
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;
@@ -636,8 +637,8 @@
hz_copybycollection
Copies by Collection
- horizon
- 1
+ horizon2
+ 0
Count.Collection.Description.PAC Description
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;
@@ -654,8 +655,8 @@
hz_itemsbyitype
Items by IType
- horizon
- 1
+ horizon2
+ 0
Count.Item Type (itype).Description
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;
@@ -672,8 +673,8 @@
hz_internalnotescount
Internal/Check In Item Notes
- horizon
- 1
+ horizon2
+ 0
Count
SELECT COUNT(cki_notes) FROM item_csv_clean WHERE LENGTH(cki_notes) > 1;
@@ -690,8 +691,8 @@
hz_internalnotesample
Internal/Check In Item Notes Sample
- horizon
- 1
+ horizon2
+ 0
Count
SELECT cki_notes FROM item_csv_clean WHERE LENGTH(cki_notes) > 1 LIMIT 20;