# we don't want invalid dates in the db (mysql has a bad habit of inserting 0000-00-00
$data{'dateofbirth'} = undef if( not $data{'dateofbirth'} );
$data{'debarred'} = undef if ( not $data{'debarred'} );
+ $data{'guarantorid'} = undef if ( not $data{'guarantorid'} );
# get only the columns of Borrower
my @columns = $schema->source('Borrower')->columns;