Difference between revisions of "Reconcile"

From IMSMA Wiki
Jump to: navigation, search
Line 5: Line 5:
 
# Approve.
 
# Approve.
  
The major steps consist in their turn of several subtasks which may be carried out by one or more different persons and/or stakeholders in the Mine Action programme. For data quality purposes, it is important that the data is adequately checked. With multiple permission levels for the Approval, different users can be assigned different permissions, allowing Mine Action Programmes to implement a data-entry workflow that distinguishes between data '''entry''' and data '''verification''' roles.  
+
The major steps consist in their turn of several subtasks which may be carried out by one or more different persons and/or stakeholders in the Mine Action programme. For data quality purposes, it is important that the data is adequately checked. With multiple permission levels for the Approval workflow, different users can be assigned different permissions, allowing Mine Action Programmes to implement a data-entry workflow that distinguishes between data '''entry''' and data '''verification''' roles.  
 
{|  
 
{|  
 
|- valign="top"
 
|- valign="top"
Line 152: Line 152:
 
</div>
 
</div>
 
=== Save===__NOEDITSECTION__  
 
=== Save===__NOEDITSECTION__  
The first step in the Approval is done by the Data Entry staff and saves the Data Entry Form. It may now be found in the Workbench. Until a Data Entry Form is approved, it exists only in the Workbench and does not update any Summaries. The report can still be modified or deleted.
+
The first step in the Approval workflow is done by the Data Entry staff and saves the Data Entry Form. It may now be found in the Workbench. Until a Data Entry Form is approved, it exists only in the Workbench and does not update any Summaries. The report can still be modified or deleted.
  
 
=== Peer review===__NOEDITSECTION__  
 
=== Peer review===__NOEDITSECTION__  

Revision as of 18:32, 13 March 2015

The Data Entry process consists of three major steps:

  1. Reconile
  2. Data Entry
  3. Approve.

The major steps consist in their turn of several subtasks which may be carried out by one or more different persons and/or stakeholders in the Mine Action programme. For data quality purposes, it is important that the data is adequately checked. With multiple permission levels for the Approval workflow, different users can be assigned different permissions, allowing Mine Action Programmes to implement a data-entry workflow that distinguishes between data entry and data verification roles.

Data Entry Process
Reconcile 1 Does it exists in DB?
2 Select Action
3 Select template
Data Entry 4 Data Entry itself
5 Link(s)?
Approve 6 Save
7 Peer-review
8 Submit
9 Final review/Data QA
10 Approve

Reconcile

Reconcile means "to make two sets of numbers add up to the same total" which with IMSMA terms is process of getting all different subsets of Mine Action information in a country (e.g. operators' clearance information) to a correct and coherent national database.

New or existing item

Before a data entry may start, both at data providers such as operators and at National Mine Action Authority, the first and very important task is to determine if the piece of information that is received on a paper or as MAxml, does it already exist in the database or not?

New information are of two different types:

  • information about a new item
For example a Land or a Victim that is previously not reported/entered into IMSMANG. The Land might have been contaminated 10 years ago or the Victim injured 5 years ago but from our IMSMANG perspective it is new due to it is not in the database.
  • new information about an existing item
For example a polygon of an existing Land that previously did not have that recorded in the database or a correction of date of birth for an existing Victim.

The report that is received in both cases may not look any different so it is vital that the process of new information classification is thorough. Read more about Summary items and Data Entry Forms here.

SopIcon.png It should be outlined in the Data Entry SOP whose responsibility it is to determine if it is a new item or updating information about an existing item.

Select Data Entry Action

Summary window toolbar

Data Entry Actions
Type Name When to use Action
From Data Entry menu Reconcile as New Only for New Locations New
Reconcile as Existing Item Is not recommended anymore (Replace/Combine) Replace/Combine
From Summary window Add from Summary Window Not for New Locations New
Update from Summary Window To update existing data Update
Delete from Summary Window If the item should be Deleted from the database Delete
Other Reconcile Actions Link to Existing Item Link may be used in combination which several of the other Actions Link
Reassign Item to another Location Special updating Action when to which Location an item is assigned Change Location
Unlink Items Special updating Action when items need to be Unlinked Unlink
Unapprove a Data Entry Form If this Action is used, all traceability and transparency is lost N/A
Recon tab Add from non-Location.png

Example of Reconciliation Tab

Depending on which Action you choose the Reconciliation tab of the Data Entry Form will be populated different. The Actions in the From Summary window and Other Actions automatically populates the Reconciliation tab.

New 6.0.png Add, Update and Delete from Summary window were added in version 6.0.

Select Data Entry Form template

Next decision is to choose which template to use for the Data Entry. It might be appropriate to have more than one Data Entry template for one item, e.g. one for the information about the Victim and another template for Victim Needs Assessment. The item Activity is an example where each process has their own template, i.e. Non-Technical Survey, Technical Survey, EOD Spot Task, Completion Report, Post-Clearance Survey, etc.

Select Template New.png

Select Template for New Data Entry Form window

Data Entry

An important part of the Data Entry is of cause the template itself and that is both collecting the data that is required and that the design of the template makes is easy to do Data Entry and give guidance that enhances/ensures high data quality such as required fields.

Data Entry itself

Fig42.png

For more information on how to do data entry, see Use the Data Entry Form Editor Window.

Warning.jpg When updating information the updating Data Entry Form's Date of information must be a later date than the Data Entry Form(s) that created the information since the calculation of the Summary item(s) are based on Date of Information. If the date is earlier or the same, no change of the Summary items occur.

Links?

Example Relationships Among Items

Note: Connections to Country Structure and Location have been omitted from the example

The last step of the Data Entry is to specify on the Reconciliation tab if the item should be linked to another item. In IMSMANG the links implicate a relationship between the items. For example:

  • a link between an Activity and a Victim means that the Victim is a Demining Victim;
  • a link between two Victims means that they are family.

Approve

WB Status.png

Data Entry Form Statuses / Approval workflow

Save

The first step in the Approval workflow is done by the Data Entry staff and saves the Data Entry Form. It may now be found in the Workbench. Until a Data Entry Form is approved, it exists only in the Workbench and does not update any Summaries. The report can still be modified or deleted.

Peer review

The next step in the Approval workflow is to have another person to review the contents of the Data Entry Form.

Submit

When the Data Entry staff feels that the contents of the Data Entry Form has good enough data quality for the last review, they click on the button Submit and the status changes. The Data Entry Form is still in the Workbench.

Final review

If the Data Verifier does not consider the content of the Data Entry Form to meet the Data Quality standard of the Mine Action programme e.g. a QM item should always be linked to an Activity then the Data Entry Form will be Rejected.

Approve

When the Data Verifier is satisfied with the Data Quality then the Data Entry Form is approved and it will trigger an update of an existing item (Summary) or creating of a new item depending of chosen Action.