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)
In the example below you can find a more extended description of
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:
|A0418||Aanrijding met afgevallen lading|
|A0420||Aanrijding met afgevallen lading blikschade|
|A0422||Aanrijding met afgevallen lading ruitschade|
|A0600||Aanrijding met vast object|
|A0604||Aanrijding met vast object bevriezing|
|A0606||Aanrijding met vast object bevriezing blikschade|
|A0608||Aanrijding met vast object bevriezing ruitschade|
|A0610||Aanrijding met vast object bijzondere manoeuvre|
|A0612||Aanrijding met vast object bijz manoeuvre bliksch.|
|A0614||Aanrijding met vast object bijz manoeuvre ruitsch.|
|A0616||Aanrijding met vast object lekke band|
|A0618||Aanrijding met vast object lekke band blikschade|
|A0620||Aanrijding met vast object lekke band ruitschade|
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:
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.