Changes

Jump to: navigation, search

Data quality checks before upgrading to V6.0

46 bytes added, 23:26, 12 November 2016
no edit summary
Due to changed behaviour of migration/import scripts in version 5.08.02 and a bug in 5.08.04 approval information may be missing. Note that ''Last updated'' gets updated e.g. when templates are switched and should not be used for setting Approved Date. If the Data Entry Form that misses Approved Date is an Activity or Education then you might be able to use End date [[Missing approval information|(query)]].
{This '''[[Fieldreport ID and Dates | class="wikitable"|-! Column !! Old label !! New label|-| reportReceivedDate|| Initiated || Data Entry Date|-| reportCompletedDate|| Submitted || Submitted Date|-| reportVerifiedDate|| Approved || Approved Date|-| dateofreport|| Date of Report || Date page ]]]''' provides an overview of Information|-| dataentrydate|| Last updated || (no change)|-|}the fields in the table ''fieldreport''.
===Missing Date of Information (mandatory)===__NOEDITSECTION__
'''Note''' that ''Last updated'' gets updated e.g. when templates are switched and should '''NOT''' be used for setting ''Date of Information'' .
This '''[[Fieldreport ID and Dates | page ]]]''' provides an overview of the fields in the table ''fieldreport''.
===Missing Local ID (DEF, items, Auxiliary data and Task)(mandatory)===__NOEDITSECTION__
In some database also Form ID and the items' local ID have been missing. If Form ID is null then the [[Empty Reconciliation Tab#Case 2 The tab is highlighted and no error message in the log | '''Reconciliation tab will be empty''']] and it is not possible to see which ''Action'' was used. The [[Missing Local ID|queries]] also include Auxiliary data and Task.
 
This '''[[Fieldreport ID and Dates | page ]]]''' provides an overview of the fields in the table ''fieldreport''.
===Data Entry Form Templates===__NOEDITSECTION__
6,632
edits

Navigation menu