NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "The table '''fieldreport''' contains amongst other fields, 5 important date fields. {| |- valign="top" | {| class="wikitable" | width="150pt" align="center" style="background..."
The table '''fieldreport''' contains amongst other fields, 5 important date fields.
{|
|- valign="top"
|
{| class="wikitable"
| width="150pt" align="center" style="background:#f0f0f0;"|'''column'''
| width="150pt" align="center" style="background:#f0f0f0;"|'''used as'''
| align="center" style="background:#f0f0f0;"|'''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
|}
{|
|- valign="top"
|
{| class="wikitable"
| width="150pt" align="center" style="background:#f0f0f0;"|'''column'''
| width="150pt" align="center" style="background:#f0f0f0;"|'''used as'''
| align="center" style="background:#f0f0f0;"|'''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
|}
