migration_test_report
Generate an end-to-end migration test report that validates source to staging to target maps, producing a pass/fail verdict with actionable fix guidance for specific fields and records.
Instructions
Generate a complete end-to-end migration test report covering all three layers:
Source (Jira/SF) → Staging Table → Target Table (ServiceNow)Combines the existing validate tool (fill-rate check) with deep reconciliation to produce a single pass/fail report with actionable fix guidance.
Use this after a test migration of 5–50 records before running the full migration. Returns a human-readable verdict + specific fields/records that need fixing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| platform | Yes | Source platform | |
| source_records | Yes | The source records that were migrated | |
| staging_table | Yes | SN staging/import table name | |
| target_table | Yes | SN target table name (e.g. incident) | |
| field_mappings | Yes | Three-layer field mapping: source → staging → SN target | |
| correlation_field | Yes | SN target field holding the source ID (e.g. u_jira_key) | |
| source_id_field | Yes | Field in source records that is the unique ID (e.g. key, Id) | |
| transform_rules | No | ||
| date_fields | No |