2.5.2. Hierarchical codelists

Context and motivation

Values in AFD codelists do not always supply the level of detail individual parties or processes require. While some parties or processes can handle a global level, others require a very detailed level.

An example of this is the codelist AFDSCL (damage classifications). Sometimes the classification collision suffices, but for other parties the specific classification collision with fixed object or even collision with a fixed object and damage to the bodywork is more relevant. This requires a method to model the relationship between data within a codelist.

The following hierarchical codelists exist:

• AFDSCL – AFD Damage classification (NL: AFD Schadeclassificatie)
• SBIAFD – SBI-AFD code (NL: Codering SBI-AFD)
• ADNBRA – Businessline (NL: ADN Branchecode)
  

In the example below you can find a more extended description of AFDSCL

In AFD 2.0 Online you can find a complete and up-to-date overview of all codelists. More documentation on the use of SIVI AFS is available in chapter Where to find elements of SIVI AFS.

Example: AFDSCL

The codelist AFD Damage classification (AFDSCL) has been drawn up for unequivocal registration and reporting of causes of damage. The optimization of damage classifications was necessary because the former codelists of SIVI, CIS and individual parties’ own code lists contained many different codes, and were insufficiently clear and/or fine-grained for facilitating proper damage analysis. This had an impact on supervision, product development, statistics and fraud detection.
Just as default AFD codelists, AFDSCL is (a) in dutch and (b) available as a standard “flat” codelist within the AFD Data catalog. An excerpt is shown in the table below:

In addition, a hierarchy is supplied with this codelist. This allows damage classifications to be queried and registered in varying degrees of detail. The hierarchy supports (1) the development of simpler dialogs to select a code value and (2) the aggregation of data when performing analysis and reporting. A visual representation of (an excerpt of) the hierarchy in AFDSCL can be seen below:

Available downloads

As mentioned above, the hierarchical codelist standard is a technical addition to the relevant AFD codelists. The codelists retain their known flat structure of code value with description, but are supplied with a hierarchical table as a supplement.
For each hierarchical codelist, the following files are made available as downloads:

• A detailed explanation of the (hierarchical) codelist (pdf)
• A zip file containing the following:
  • Default “flat” AFD codelist (JSON)
  • Hierarchy of the codelist (JSON)
  • Mapping to/from other codelists (JSON)
• An overview of all code values, descriptions, hierarchy and mappings in one table (Excel)
  

The standard is a technical addition to the relevant AFD codelists. The codelists retain their known flat structure of code value with description, but are supplied with a hierarchical table as a supplement.