[Babase] Lists of data the conversion changes
Karl O. Pinc
babase@www.eco.princeton.edu
Thu, 14 Apr 2005 19:41:01 +0000
This should be a compliation of everything that
gets silently altered in the conversion.
Stuff like all blanks changed to zeros.
We want this list because these changes should be
reviewed to be sure we don't lose any information.
All blank numeric columns are converting to 0
in the new db. The ones listed below are the
ones I do explicitly in the conversion. Maybe somebody
should look at all the numeric columns?
BIOGRAPH.Status = '' --> 0
BIOGRAPH.Dcause = '' --> 0
Every numeric column in BIOGRAPH that's empty becomes 0.
(Bstatus is the only other one on BIOGRAPH.)
BIOGRAPH.Mstatus = '' --> 'K'
(I dont' think there is a 'K' now, so there should not be an issue.)
CENSUS.Cen = '' --> FALSE
All 0 numeric values in the PREGS table become NULL.
(The only possiblity is RESUME.)
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein