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

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

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

  • detail lines → this is the most granular detail line, which includes a description etc.

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 is both a detail line and a 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

detail_MUT

Table name: detail_MUT

...