Versions Compared

Key

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

...

Column

Description

Data type

Insured name

Full name of the person insured

string

Insured NISZ

National insurance number of the person insured

string

Insured Birthdate

Date of birth of the person insured

date

Line items

We consider different types of lines

  • header lines → if header fields can be repeated, we also provide them as header lines so that they can be associated to the right note

  • detail lines → there are two types of detail lines

    • Those which do not include a subtotal: Detail_MUT

      • Often included date, nomeclature number, description, …

      • But never a TK amount (actual paid amount)

    • Those which do include a subtotal: Item_With_Subtotal

      • Include a TK amount

  • subtotal → this is the subtotal for a note. There can be multiple subtotals per document

  • total → this is the total for the document “there can be only one”

Relation between detail_MUT, Item_With_Subtotal, and subtotal

  • a detail_MUT line does not have the column “TK amount” (amount actually paid)

  • a subtotal line only has amounts (no description, nomenclature code, …)

  • sometimes a line contains information both on the detail line and on the subtotal. This is done when the note consists of exactly one item

  • An Item_With_Subtotal therefore has the fields of a detail_MUT line (description, nomenclature code) and the fields of a subtotal line (notably TK amount)

  • An Item_With_Subtotal line cannot be summed up in another subtotal line (it can be summed up into the document total)

detail_MUT

Table name: detail_MUT

...