Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The OPrognose <OPH> records contains all type of MYP activity variants

The mapping below is performed on:

  • all the OPrognose <OPH> records with <han_type> = 'B' and <han_cyclus> = 0

OPrognose XML tag

Type of mapping

HUMBLE Field

Description

n.a.

Fixed mappings

date_day = 1

date_month = 1

numberof_element_id = '2'

maintenance_type_id = '2'

activity_type_id = '5'

Default set to maintenance_type_id = ‘Correctief’ and numberof_element_id = ‘No’ and activity_type_id = 'Repair '

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

...