Mapping MYP 'preventief' <OPH>

n.a.

Fixed mappings

date_day = 1

date_month = 1

numberof_element_id = '2'

maintenance_type_id = '1'

activity_type_id = '7'

Default set to maintenance_type_id = ‘Preventief’ and numberof_element_id = ‘No’ and activity_type_id = 'Preventive'

han_cyclus

Direct mapping

cyclus

han_opm

Direct mapping

remark

han_totaal

Functional mapping

expected_amount

Replace ‘,' and '.’ in the OPrognose field

han_hvhreken

Functional mapping

numberof

Replace ‘,' and '.’ in the OPrognose field

han_prijs

Functional mapping

expected_unit_amount

Replace ‘,' and '.’ in the OPrognose field

han_startjaar

Functional mapping

expected_start_date

Maps to ‘01-01-’ + han_startjaar

han_tekst

han_activiteit

Functional mapping

label

Use han_activiteit when avaible otherwise use han_tekst