Gov Data Integration Data Model v1.0.0.0

---

Introduces comprehensive data integration capabilities including identifier management, sync operations, value mapping, and commit policies.

Nov-11, 2025

This release introduces comprehensive data integration capabilities to support system-to-system data synchronization, transformation, and governance workflows.

• Integration Identifier
  • Added new table to track external system identifiers and their mapping to target system records with fields: External Key, First Seen Date Time, Last Seen Date Time, Source System Key, Target ID, Target Table, Identifier ID.
• Integration Ledger
  • Added new table to maintain audit trail of data integration activities and certification status with fields: Aspect Key, Certified Date Time, Ledger Aspect, Ledger Status, Notes, Source System Key, Target ID, Target Table, Ledger ID.
• Integration Sync Job
  • Added new table to manage and track data synchronization job execution with fields: Direction, Entity Type, Job Status, Source System Key, Submitted Date Time, Job ID.
• Integration Sync Item
  • Added new table to record individual field-level changes processed during sync operations with fields: Applied Date Time, Field Name, Integration Sync Job, New Value, Process Message, Target ID, Target Table, Item ID.
• Integration Value Map
  • Added new table to define mappings between source system codes and canonical values with fields: Canonical Code Value, Code List, Confidence, Map ID, Source Code, Source Label, Source System Key.
• Integration Commit Policy
  • Added new table to configure data commit rules and authoritative source policies with fields: Authoritative Sources, Auto Certify, Commit Mode, Field Name, Policy ID, Stale After Days, Target Table.
• Choice sets / Option Sets
  • Added choice sets: Ledger Aspect and Integration Commit Mode.