knobit.org

C2 (3 points)

edu:Question

https://knobit.org/id/task/dii-mapping-value-reconciliation/C2

Also as Turtle · JSON-LD · RDF/XML

dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
owl:sameAshttps://bitbucket.org/reffa/ontology/id/task/dii-mapping-value-reconciliation/C2
rdfs:labelC2 (3 points) en
schema:hasPartdii-mapping-value-reconciliation C2: MP-24 unspecified, replaced by a prod_cd crosswalk
schema:hasPartdii-mapping-value-reconciliation C2: MP-23 reads lessee_regcode, the file has lessee_reg_no
schema:hasPartdii-mapping-value-reconciliation C2: asset_description VARCHAR(60) narrower than asset_desc VARCHAR(200)
schema:identifierC2
schema:position2
schema:textMapping entries nobody could load as written, 1 each. (a) MP-24 'map to the bank's product types' is not a rule: replaced by a crosswalk covering every observed prod_cd - FL FINANCE_LEASE, OL OPERATING_LEASE, HP HIRE_PURCHASE. (b) MP-23 reads lessee_regcode, which the LeaseMaster file does not have: the source field is lessee_reg_no. (c) MP-30 loads asset_desc VARCHAR(200) (longest observed 82 characters, LM 100008) into asset_description VARCHAR(60): reported, and the target widened to at least the source length (VARCHAR(200)) or a truncation rule raised with the target owner - not silently truncated. en

Used by

has questionLeasing contracts from two systems into one table - key collision, dropped offset and a percent cut-over (mapping on value)
schema:isPartOfdii-mapping-value-reconciliation C2: MP-24 unspecified, replaced by a prod_cd crosswalk
schema:isPartOfdii-mapping-value-reconciliation C2: MP-23 reads lessee_regcode, the file has lessee_reg_no
schema:isPartOfdii-mapping-value-reconciliation C2: asset_description VARCHAR(60) narrower than asset_desc VARCHAR(200)