mostly pdo updates and data entry submission