Field-level flow
Source row, canonical record and target payload at a glance. Flow thickness scales with the count of field names that line up between adjacent stages.
Thicker bands mean more shared field names (case-insensitive) between adjacent stages; a uniform medium band is shown when no names overlap, and unavailable stages are greyed out with the reason inline.
1 · Source
sits
- STU_CODE
- S-20881
- STU_HUSID
- 1234567890123
- STU_SURNAME
- Patel
- STU_FORENAME
- Alice
- STU_DOB
- 2003-04-12
- STU_DOMICILE
- XF
2 · Canonical
Student
- id
- S-20881
- entityType
- Student
- husid
- 1234567890123
- lastName
- Patel
- firstName
- Alice
- dateOfBirth
- 2003-04-12
- domicile
- XF
3 · Quality Rules
2 passed · 1 flagged
- HUSID.FORMATHUSID is 13 digits
- BIRTHDTE.FORMATValid ISO date
- POSTCODE.UK_FORMATPOSTCODE missing for UK domicile (record S-20881)
4 · Target
hesa-data-futures · Student
- HUSID
- 1234567890123
- SURNAME
- Patel
- BIRTHDTE
- 2003-04-12
- DOMICILE
- XF
Provenance
Cross-system identity and effective-dating resolved for this record.
Reconciled alt-ids
- banner-oracle/pidm=82045
- sits-oracle/stu-code=S-20881
Effective dating: status-driven
current