modified several procedures to default null to fields in flat_tables whose observations have been voided