Data Processing

Data processing is the second step in the data ingestion process. The Data processing module allows users to review and approve submitted data and source documents in preparation for publishing to the FEWS NET Data Warehouse.

Submitted data can be used to build visualizations in the FEWS NET Website CMS. Once published, data becomes available for users with the appropriate permissions to view and export in the FEWS NET Data Explorer.

From the Data processing module, the following actions can be performed:

Display or edit an existing Data Collection.
Display or edit the data for an existing Collection Period.

Display or edit an existing Data Collection

The Data Collections screen allows you to submit, review, publish, and view an entire Data Collection. A Data Collection is a set of Data Points added in a single import. It may contain multiple Data Series or Collection Periods.

The Data Collections screen lists the currently available collections in a grid format with the following columns:

Source Document: the name of the Source Document as defined in the Data entry process
Document Type: the Domain or data type qualification that the data is being submitted under
Collection Date: the Collection Date of the submitted Data Collection
File: A link to the submitted file. Because data can be entered manually, not all collections have a file available.
Status: status types include Draft, Submitted, Under review, and Published
Publication name: the name of the publication that the Data Source Document came from
Status changed: indicator of when the status was last updated
Data point count: indicator of file size as represented by the number of Data Points submitted in the Data Collection

Under the heading, Select data collection to change, there is a search bar. Beneath it, available years are listed from 1960 to 2022. There is an action dropdown list, and a button to add data collection. The grid displays available collections.

Navigating the data collections table

In addition to a free text criteria search bar, filters can also be applied. To set filter criteria, locate the Filter menu. A search bar is available to narrow the filter options. Once a filter is selected from the list, the system will automatically apply the filter and display the results.

The filter menu is located on the right-hand side of the page. At the top is a button to hide the filter pane.

Editing the status information of a Data Collection

The Data Collection status can be changed in two ways:

From the table view, use the checkboxes to select one or more data collections and select a status from the Action dropdown:
1. Delete will delete the Data Collection. If deleted, it cannot be recovered.
2. Submit will update the status to Submitted.
3. Publish will update the status to Published.
4. Review will update the status to Under review.
Select the Data Collection from the table to navigate to the Change Data Collection screen.
1. Modify the data in the Change Data Collection page as needed and select a Save option.
2. Select Submit (for Data Collections in Draft or Under review status) or Review (for Data Collections that are Published).

The modifiable fields for the FEWS NET, Afghanistan Key Messages Update, Afghanistan 2023-01-31 data collection includes Geographic Unit, Classification Scale, Scenario, Is Accounting for Assistance, Status, Phase, Description and Previous Value.

Viewing the change history of a Data Collection

When various events are performed against data within a Data Collection, including the addition of new data, updates, and deletion of data in the system, they are tracked for auditing purposes.

To view the change history of a Data Collection:

Select the Data Collections for which the change history is needed.
Locate and select the History button.

The change history screen shows the date and time, user, message and record. Hover over each entry in the Record column for more detail.

Display or edit the data for an existing Collection Period

The Collection Periods screen allows you to view and edit a single Collection Period.

The Collection Periods screen lists the currently available collections in a grid format with the following columns:

Collection: the name of the Data Collection as defined in the Data entry process
Start date: the start date of the Collection Period
Period date: the last day of the Collection Period
Schedule: the schedule on which the data is collected
Collection Status: status types include Draft, Submitted, Under Review, and Published
Status changed: indicator of when the status was last updated
Data point count: the number of data points included in the Collection Period

View and edit a Collection Period

To view and edit a Collection Period:

Select the Collection Period to be updated.
On the Change Collection Period page, you can:
1. Add notes to a Collection Period.
2. View the history of the Collection Period.
3. Edit the status and values of specific Data Points within the Collection Period.
Select one of the Save options.