Fieldreport ID and Dates

fieldreport table Database column fieldreport_localid dateofreport reportreceiveddate reportcompleteddate reportverifieddate verifiedby dataentrydate GUI name Form ID Date of Information Data Entry Date Submitted Date Approved Date Approved by Last updated GUI GUI Action Entered in DEF (either using button or typing) 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 DEF-456 2011-09-11 oldest 2011-10-04 2011-10-05 2011-10-06 newest emma 2014-06-19 Rule Mandatory Mandatory Good to have Nice to have Mandatory Mandatory What-ever Template:NavBox Hub