---
sourceDocument: Brazil ServiceNow AI Platform Administration
sourceDocumentLink: https://www.servicenow.com/docs/r/platform-administration

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Normalization and transformation data jobs

# Normalization and transformation data jobs {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Normalization and transformation data jobs

In ServiceNow, normalization and transformation data jobs are used to change field values systematically during data normalization and transformation processes.
Administrators must manually trigger these data jobs to apply field changes, as all transformation records default to Test mode, which prevents immediate application of changes.
Many data jobs include a rollback option to undo changes after execution.
Show full answer Show less  
If the Field Normalization plugin is active, normalization occurs automatically on record insertions based on defined rules. Without this plugin, normalization relies on data jobs that save previous values to enable rollbacks if needed.

## Key Data Jobs and Their Uses

* **Pending value collection:** Collects field values for upcoming normalization runs; it does not change data and thus has no rollback option.
* **Normal value change:** Applies normalization when a normal value changes; supports rollback to revert to previous values.
* **Alias application:** Normalizes fields matching an alias; supports rollback to restore prior values.
* **Rule application:** Normalizes fields matching a rule; supports rollback to revert changes.
* **Coalesce too normal:** Normalizes reference fields by consolidating duplicates to a single record reference; rollback restores duplicate records but not prior references.
* **Transform application:** Applies transformations based on defined conditions; cannot be run while in Test mode and supports rollback to restore previous field values.

## Practical Considerations for ServiceNow Customers

Administrators should be aware that transformation records start in Test mode, requiring manual activation of data jobs to apply changes. The rollback feature in most data jobs provides safety to revert unintended modifications. Activating the Field Normalization plugin automates normalization on record inserts, reducing the need for manual jobs.

Understanding each data job's role helps administrators manage data quality effectively, ensuring consistent and accurate field values across records while maintaining the ability to undo changes if necessary.  
The system uses data jobs to change field values during normalization and
transformation.

Administrators must manually start data jobs that apply field changes. All transformation
records open in Test mode by default, which blocks administrators from running manual data jobs
that apply changes to existing data. Most data jobs have a roll back option to revert changes
after the job completes. By default, the system provides these data jobs.  
Note:  
If the Field Normalization plugin is active, the normalization engine executes on insert of
records into a table according to normalization rules. To learn more about this plugin, see
[Activate Field Normalization](https://www.servicenow.com/docs/ZBxZIKX_P0KPQZqRCFpmKA "Activate the Field Normalization [com.snc.field_normalization] plugin to install demo data and activate related plugins if they are not already active.").

If the Field Normalization plugin is not active, a data job runs to normalize the values. The
data job saves the previous values in the rolled back fields to revert them if necessary.  
{#normalization-data-jobs__table_k41_fxn_x1b__entry__3}

| Name | Used for | Description |
|-|-|-|
| Pending value collection | Normalization | The system runs this job to collect field values that will change during the next field normalization run. The system runs this job whenever you insert or update a field normalization record. Since this data job does not change any field values, there is no roll back option. |
| Normal value change | Normalization | Run this job to rerun field normalization and update field values when you change a normal value. The system creates this job whenever you change a normal value. Roll back the data job to revert the normalized fields to the previous normal value. |
| Alias application | Normalization | Run this job to normalize all field values that match an alias. The system creates this job whenever you create or update an alias. Roll back the data job to revert normalized fields to their previous values. |
| Rule application | Normalization | Run this job to normalize all field values that match a rule. The system creates this job whenever you create or update a rule. Roll back the data job to revert normalized fields to their previous values. |
| Coalesce too normal | Normalization | Run this job to normalize the reference field values by replacing references to multiple duplicate records with one reference to a normalized record. The system creates this job whenever you change a normal value that applies to a reference field. Roll back the data job to restore the duplicate records as valid options. The rollback does not restore references to the previous records. |
| Transform application | Transformation | Run this job to transform all field values that match the transformation conditions. You cannot start this job while the Transformation record is in Test mode. The system creates this job whenever you create or update a transformation record. Roll back the data job to revert transformed fields to their previous values. |
[ ]

{#normalization-data-jobs__table_k41_fxn_x1b}