The table fieldreport contains amongst other fields, 5 important date fields.
| column
|
used as
|
comment
|
| dateofreport |
Date of Information |
Is selected by the user
|
| reportreceiveddate |
Data Entry Date |
Is set when the user clicks on the Save button
|
| reportcompleteddate |
Submitted Date |
Is set when the user clicks on the Submit button
|
| reportverifieddate |
Approved Date |
Is set when the user clicks on the Approve button or when the report is automatically approved at import
|
| dataentrydate |
Last updated |
Is changed when e.g. the template is switched
|
|
