--- title: "Target Report Remediation" slug: "target-report-remediation" updated: 2024-10-17T15:01:15Z published: 2024-10-17T15:01:15Z canonical: "skthelp.syniti.com/target-report-remediation" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Target Report Remediation This topic is related to the following sections: - [Mappings](/v1/docs/mappings) - [Create Reports](/v1/docs/create-reports) - [Maintain Target Reports](/v1/docs/maintain-target-reports) - [Reporting Features](/v1/docs/reporting-features) ## About Target Report Remediation Target Report Remediation is the act of running a target report against a field contains Check Table values or Required values in order for the data to save in the load to the target system. The remediation of a field reports the invalid entry, and then as a secondary step, update the field to a valid entry that prevents the record from failing due to this field. The theory is to prevent unnecessary errors during loading to the target system. Fields marked for Remediation have the following criteria: - The field is a required field in the target system - The field remediation must not also produce an error. The Remediation process supports Dynamic Remediation (Use of sub views in the report to provide a min value or a value that depends upon other values, etc.). Remediations are based upon the selected 'Remediation Field' that is stored within the Target Report Details page. **Dynamic Remediation** - the remediated value is derived and may be contingent upon other criteria. The user must build the remediation to supply a correct value for each situation. - An example would be defaulting the correct State value based upon the Country value - Calculate it as (MIN(REGIO) where COUNTRY = xxx). - Another example is to set a static value as the aliased field within the view - 'US' as Country In the case of a **Dynamic Remediation**, the user builds an additional view using the _010 extension that is added to the report. This view determines a value to load as the remediated value. The Remediated Value field has an alias of "XX_REMEDIATE" where the XX represents the field to remediate. The field Remediate Value is left blank within Migration Report Details page. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=16%2B7pEVIwK6WU6aqh09J0HZPzCwr3yUCTMTk6953SB0%3D)Mappings: Target Reports: Remediation View build ## Project Setup Release Remediation **Target Report Remediation** is activated at the Release level within Project Setup. In this way, the entire Release has active or inactive remediation. During the first few Mock loads, the remediation flag in the Release should be toggled active as shown below: ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_1.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=kgidb5tikeLTnMTuxMnxPHBiY7zBgAfzfW5dj%2FmuO6k%3D)Project Setup: Release: Remediation Enabled Within the Project Setup page, each Release provides a Toggle for **Remediation**. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=7QOu%2FU3%2Fz%2Fwy33qUJ4RRvcGyKLO9LVBqj%2FVA7AKcbng%3D)Project Setup: Remediation flag If the Remediation toggle is on the Project Setup page is set to active, all reports with remediation of a field display the field and the remediated field as shown below. Downloading this report provides the same columns. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/target Report Remediation_2B.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=Hk5L2ofcBdtXgMClfBBiiLesHN8cUvkoFew%2F4DF8l%2Fs%3D)Target Report: Field Remediation Active If the Remediation toggle on the Project Setup page is set to inactive, all reports with remediation of a field display without the remediated field column, and downloads of the reports do not include the remediated column. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_2C.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=riHaakf3%2BA3NZClA%2Bkf1LXcJpKcqSaggNYFg1AcAN9U%3D)Target Report: Field Remediation Inactive ## Target Report Remediation fields Follow pathway: **Migrate > Mappings > Targets > Reports** to view this section. Select a report of type that provides for remediation (See section [Readiness Flags for Reporting and Remediation](/v1/docs/target-report-remediation#readiness-flags-for-reporting-and-remediation)) and click on the **Edit** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/99c7d371-6ed3-4f32-afa7-b21632b0b1eb.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=z5ATs9LbW6N9rGV3nt5V1AqbeBH%2B1dfyByBe3VT2cd0%3D) icon to view the details. Within target report details, the user may elect to enter a Remediation Field value. Should remediation be set to active at the Release level, the conversion process runs these reports capturing the records that are invalid or missing a value. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_3.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=3GM329Fbwy5uW2tdAHDBdS8T%2F%2By4TgIzVIQERNKWyLs%3D)Target Reports: Details: Remediation > [!NOTE] > Note > > If the field for remediation update (Ex: ABDC_REMEDIATE) is not included within the report view, the Save fails. ## Remediation Execution Flag Target reports that have a remediation field value assigned, and the proper set up of the associated view, display in the Target Reports page with a Remediation Field ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/022be7bb-0755-43b4-8383-ba362c92104b.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=IU6qnCKxZUScUelTrXg5kLL5qE0yJH4TmDdCUSeNgvY%3D) icon. Once the is processed, should the report contain rows of data for remediation, this icon displays as a Processed Remediation Field ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/5243b43d-3fb2-4927-bd38-71fd06286186.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=SPok5xJHHaQxHgdVtRjBOFG9%2BSRBTHQ4QEgd47zehGM%3D) icon. The date of processing and count of records updated is provided in the hover details for the icon. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_9.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=h107f3u%2FDTv4Ea6akohr7min6XsOEo95Ua1Uvuv7lhc%3D)Target Reports: Remediation Execution Flag If the Remediation toggle on the Project Setup page is set to inactive, the ETL processing displays the Remediate Execution Flag as not processed. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_10.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=Ptkvxws6ZdkQXkIFnYg9C4TpjChZEYXNdh9TxBiS4OE%3D)Target Reports: Remediation Execution Flag status > [!NOTE] > Note > > If the Target Reports Refresh icon or Refresh All Reports button is executed, these remediation values are reset to blank. The refreshing of reports through Target Reports page only updates the report, and does not process remediation. ## Remediation Report Details During the execution of ETL processing either through Data Services or within Migrate these remediation reports update the Remediate Field with the Remediate Value in the target table. This may over write an invalid entry or enter a value where the field is null or blank. Within SQL Server, database REPORT stores the target reports and the snapshot of the data stored at the time it was run. This stores the information from prior to the Remediation update that changes field values. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_6.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=lf7U8Gkmg66CSpySfsRMelePjnBx3SQQatJ93wEhkp4%3D)SQL Server: REPORT database: Report Details Display ## Readiness Flags for Reporting and Remediation Finally, the target table for the conversion also stores details of the remediation. During the processing in the ETL, an update rule adds the Error Log messages stored at the Report level within field **Error Log Msg**. For those fields that are remediated, the Error Message contains both the Type of Report and an 'R' to indicate that Remediation was run for that field. Within section [Administer > Advanced > Report Types](/v1/docs/report-types) the Stage Ready Report Type defaults as allow remediation. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=kpNscJLTKanCSa5uNXh9gWpVCSVUR094HCoWnCcJgqo%3D)Report Types: Allow for Remediation This action is modifiable for the remaining reports. Target Report Types are: B - Business Ready D - Data Ready S - Stage Ready T - Target Ready Field ZERROR_LOG concatenates all of the errors produced during the running of target reports into the field. ![null](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Target Report Remediation_7.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A30%3A17Z&se=2026-11-17T20%3A30%3A17Z&sr=b&sp=r&sig=fP0OH%2BQocDz22To%2BUpJJw1SdTiDMhepSw7TiXzcpqOQ%3D)SQL Server: Target Table: Error Messaging