@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/dii-mapping-value-reconciliation/C1> a edu:Question ;
    rdfs:label "C1 (4 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/dii-mapping-value-reconciliation/C1> ;
    schema:hasPart <https://knobit.org/id/register/data-integration#DI-250>,
        <https://knobit.org/id/register/data-integration#DI-251>,
        <https://knobit.org/id/register/data-integration#DI-252>,
        <https://knobit.org/id/register/data-integration#DI-253> ;
    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 .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-integration#DI-250> rdfs:label "dii-mapping-value-reconciliation C1: CORE and LeaseMaster keys collide on 100004, key qualified by source"@en .

<https://knobit.org/id/register/data-integration#DI-251> rdfs:label "dii-mapping-value-reconciliation C1: MP-29 drops the UTC offset of signed_at, LM 100008 signed on 2026-10-01"@en .

<https://knobit.org/id/register/data-integration#DI-252> rdfs:label "dii-mapping-value-reconciliation C1: MP-07 ignores the int_margin percent cut-over, split on booking_date"@en .

<https://knobit.org/id/register/data-integration#DI-253> rdfs:label "dii-mapping-value-reconciliation C1: margins of CORE 100001 and 100004 converted from percent to fraction"@en .