Adding task custom fields


Administrators can define custom fields for data change requests to use for data stewardship purposes. For example, custom fields can be created to track data quality and correctness, or for data stewards to provide additional information during DCR processing like call verification attempt date and time.

These custom fields will display on add requests and change requests if data stewards and data managers are given access to the fields. The fields are for internal use only; they are not added to the change request API response and cannot be seen by the user that submits the DCR.

This feature is enabled by default in your Network instance.

Create a field

Add task custom fields so they display on data change requests.

Example

Add two fields to track data quality:

  • QA Approver - a field to select a data manager as an approver
  • QA Approval Time - a field for the approver to specify the date that the quality check was completed

To create a task custom field:

  1. In the Admin console, click Data Model > Task Custom Fields.
  2. Click Create Custom Field.

  3. Type a relevant Name and Description.
  4. Select the field Type. For example, if you create a field for a QA Approver, choose the User type which contains the list of active Network users.

  5. The field is Enabled by default. Clear this setting if you do not want the task custom field to display on data change requests yet.
  6. In the Permitted Users section, click the Add users link to specify the users that will have access to the field.
  7. In the Select users dialog, search for and select the users. These users will have access to view the field and edit the field value. Click Apply.
  8. In the Labels section, enter the field name that will display on the data change request page. To add a label for more languages, click Add Language.
  9. Save your changes.

The field is enabled by default and is now listed on the Task Custom Fields page. The order that the fields are listed on the page is the order that they will display on data change requests. Administrators can use the handle to reorder the fields.

Data stewards and data managers with access to the fields will see the fields on data change requests. For more information, see Stewarding task custom fields.

Reporting

Users with access to the SQL Query Editor (Reports) can see task custom field values when they run reports on change requests. If users do not have access to the task custom fields, the columns display but they do not contain data.

For example, run the following query to view the data change requests that have an 'F' data quality status for a specific data steward.

SELECT
        *
    FROM
        change_request
    WHERE
        qa_status__c = 'F'
        AND assignee__c = 'wendy.smith@verteo.com'

Logs

Administrators can view changes to the fields and values in the following logs

  • System Audit Log - Tracks new fields and updates to existing fields are tracked.
  • Task Audit log - Tracks changes that are made to field values on data change requests.