Common data > Common tables > 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

    SEEREFERTTO 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

    Fields

    The following fields are present on this tab :

    Block number 1

    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.
    SEEINFOThe 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.
    SEEINFOThe title of the subdivision is defined in the countryrecord

    Close

     

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation