Changes

Data quality checks before upgrading to V6.0

133 bytes added, 08:15, 11 November 2016
no edit summary
===Missing Date of Information (mandatory)===__NOEDITSECTION__
[[Image:Missing date info3.png|800px|center]]
<div align="center">
'' Example showing the importance of Date of Information''
</div>
''Date of Information'' (stored in table ''fieldreport'') is used when {{IMSMANG}} calculates the Summary (former Current view) item/window. If this data is missing then the result may not be as the expected when the Summary item is updated. This field also is base for which DEF is possible to Unapprove in updating chain. On this page you find '''[[Missing Date of Information|MySQL queries]]''' for checking if you need to populate this date. I have also added a query for checking if any ''Date of Information'' is in the '''future''' e.g. year 2024.
6,632
edits