Flexible importing of enumerations / q-names

The value of a data point may be restricted to values within an enumeration or q-name. Each enumeration item will have two components:

1. The label (e.g. "SWEDEN", or "Life [split applicable]")
2. The XBRL ID (e.g. "eba_GA:SE", or "s2c_PU:x10")

When exporting to XBRL, DPM Authority will always insert the XBRL Tag ID.

When importing data from source systems, DPM Authority will accept any of the following 3:

1. The label (e.g. "SWEDEN", or "Life [split applicable]")
2. The XBRL ID (e.g. "eba_GA:SE", or "s2c_PU:x10")
3. The truncated XBRL ID (e.g. "SE" or "x10")

This flexibility allows the mixed use of components in your source data. For example:

• the source data may have countries as 2 digit ISO codes. This would prevent the need to transform "SE" into either "eba_GA:SE" or "SWEDEN".
• However in the second example, since the truncated ID of "x10" may not mean anything to the user, the source data could use the label instead - such as "Life [split applicable]"

Generation of Excel import templates

Excel Import Template Cell Validation

Whilst DPM Authority can read data using any of the three formats described above, when the Excel Import Template is generated, only one format can be used for Excel cell validation purposes. The format can be set in a new setting found in the File - Options form:

The default value will be the XBRL tag label but this can be changed by the user.

Please note that the import template is protected without a password. It is possible to unprotect a worksheet and remove the Excel cell validation. This would allow you to (for example) use labels everywhere except for currencies and countries where you could use their ISO codes instead.