C1 (4 points)
https://knobit.org/id/task/dii-mapping-value-reconciliation/C1
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dii-mapping-value-reconciliation/C1 |
| rdfs:label | C1 (4 points) en |
| schema:hasPart | dii-mapping-value-reconciliation C1: CORE and LeaseMaster keys collide on 100004, key qualified by source |
| schema:hasPart | dii-mapping-value-reconciliation C1: MP-29 drops the UTC offset of signed_at, LM 100008 signed on 2026-10-01 |
| schema:hasPart | dii-mapping-value-reconciliation C1: MP-07 ignores the int_margin percent cut-over, split on booking_date |
| schema:hasPart | dii-mapping-value-reconciliation C1: margins of CORE 100001 and 100004 converted from percent to fraction |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | Values the draft mapping silently changes, 1 each. (a) Key collision: MP-01 and MP-21 load CORE contract_no and LeaseMaster LM_ID unqualified into contract_key; the ranges overlap (100001-163420 and 100001-121877) and 100004 is in both samples - two different contracts (lessees 10998877 and 40123456), so the MERGE overwrites CORE 100004 with LeaseMaster's row. Reported (key-collision naming MP-01 or MP-21) and fixed with a source-qualified key (e.g. a 'CORE-' / 'LM-' prefix) or a key cross-reference. (b) Dropped offset: MP-29 cuts the Z from signed_at with SUBSTR and casts to TIMESTAMP, so the Europe/Tallinn session reads UTC as local time; LM 100008, signed 2026-09-30T21:30:00Z, was signed on 2026-10-01 at 00:30 Tallinn time (+03:00), not on 30 September at 21:30. Reported (time-zone-dropped) and fixed by keeping the offset (cast to TIMESTAMP WITH TIME ZONE, or convert from UTC explicitly with the zone recorded). (c) Meaning change: MP-07 copies int_margin although the profile records it as a percentage for contracts booked before 2024-01-01; reported (meaning-change-ignored) and the mapping split at the cut-over on booking_date (divide by 100 before it, copy from it). (d) Scale converted in the right direction on the sample: CORE 100001 2.75 becomes 0.0275 and CORE 100004 3.1 becomes 0.031 (booked 2023-12-28, although its value date is 2024-01-02). en |