Geographic subdivisions

This function is used to define by country and by geographic subdivision level the codes that allow the subdivisions of a level to be identified.

For instance for France, the first subdivision is used to define all the regional codes and the second subdivision is used to define all the department-related codes.

Subdivisions are namely used in the Business Intelligence module in order to conduct analyses by geographic dimension type.

Prerequisite

Refer to documentation Implementation

Screen management

This screen will be used to specify a country, a subdivision level (e.g. region or Department for France) and for this subdivision, all the codes and titles of the elements for this subdivision.

Entry screen

Block number 1

Country (field CRY)

This code is used to identify the country associated with the information.

In the country table, which controls this field, there is a certain number of characteristics useful to perform controls on dependent information, and especially :

  • the telephone number format
  • the format of the number identifying a company or an activity (SIRET, NAF in France)
  • the postal code format
  • the format of the bank ID number
Subdivision (field TYP)

This field is used to select the subdivision level (Subdivision 1 or Subdivision 2) to be displayed or defined.
The subdivision levels and their titles are defined in the Country record.

Grid

field COD

This column is used to enter the list of codes of the selected subdivision.

Note:

The title of the subdivision is defined in the countryrecord.
field INTIT

This column is used to enter the title that corresponds to each code of the selected subdivision.

Note:

The title of the subdivision is defined in the countryrecord

Error messages

The only error messages are the generic ones.

Tables used

Refer to documentation Implementation