Fieldreport ID and Dates

fieldreport table Database column dateofreport reportreceiveddate reportcompleteddate reportverifieddate verifiedby dataentrydate GUI name Date of Information Data Entry Date Submitted Date Approved Date Approved by Last updated GUI GUI Action Entered in DEF (Age of Information) (there are no checks in the code that this date is before the others) Clicking on Save (might be NULL if DEF is imported) Clicking on Submit (might be NULL if button is not clicked) Clicking on Approve (bug in 5.x could cause NULL) Clicking on Approve (bug in 5.x could caused NULL) e.g. switching template Example 2011-09-11 2011-10-04 2011-10-05 2011-10-06 2011-10-06 2014-06-19 Template:NavBox Hub