Changes

Data quality checks before upgrading to V6.0

208 bytes added, 15:17, 10 November 2016
no edit summary
===Missing Date of Information (mandatory)===__NOEDITSECTION__
''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. Note that ''Last updated'' gets updated eThis field also is base for which DEF is possible to Unapprove in updating chain.g. when templates are switched and should 'On this page you find ''NOT''' be used for setting Date of Information [[Missing Date of Information|(query)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. '''Note''' that ''Last updated'' gets updated e.g. when templates are switched and should '''NOT''' be used for setting ''Date of Information'' .
===Missing Local ID (mandatory)===__NOEDITSECTION__
6,632
edits