L TMPV2 table data fixes
Jump to navigation
Jump to search
will be addressed by Re-import of TmpV2 data from Julie's Export 2014-09-08
Several data points went wrong on import. This article lists them and their fixes.
No Transfer Date without items
There are entries for No Transfer Date without items... need to look into...
Diffs
in cent not in mdb
query 2_tmp_in_cent_not_mdb D_Tmp_ID HSC_H4H-3856-8707 STB_E5-11012-8038
Appear to exist in centralized but not in tmp.mdb
in mdb not in cent
query 2_tmp_in_mdb_not_cent yikes 9050 of them!
missing postal codes
Postal code collection 54 admitted since start are missing pcs in .mdb, and 390 are missing them in cent.
- email to Trish and Pagasa Ttenbergen 11:33, 2014 July 4 (CDT)