Database For Statistical Classifications
Structure of Classification Items STAKLAS
| Attribute | Type and max. length | Description |
|---|---|---|
| SORT_NUMBER | number(9) | Sort number |
| CLASSLEVEL | number(9) | Level number |
| CODE | char(4000) | Code of item |
| OFFICIAL_TITLE | char(4000) | Official title |
| OFFICIAL_TITLE_EN | char(4000) | Official title in English |
| SHORT_TITLE | char(4000) | Short title |
| SHORT_TITLE_EN | char(4000) | Short title in English |
| MEDIUM_TITLE | char(4000) | Medium title |
| MEDIUM_TITLE_EN | char(4000) | Medium title in English |
| FOOTNOTES | char(4000) | Notes |
| GENERAL_NOTES | char(4000) | Explanatory notes: general notes |
| INCLUDES | char(4000) | Explanatory notes: includes |
| INCLUDES_ALSO | char(4000) | Explanatory notes: includes also |
| EXCLUDES | char(4000) | Explanatory notes: excludes |
| VALID_FROM | date | Valid from |
| VALID_TO | date | Valid to |
| LAST_UPDATE | date | Last update |
| DATE_OF_ENTER | date | Date of entry |
Problem of „leading zeroes” relating to CSV format
Save the file to a disk and import as external data from a text file. Set data format „text” for the column with code of item to display the contents of the cell, as it is specified, also with possible leading zeroes.
Example of codes with leading zeroes: 09, 0020, 075
STAKLAS represents the database for statistical classifications, which is centrally administrated by the Statistical Office of the Slovak Republic and are obligatorily used by all state authorities and reporting units performing statistical surveys.
This page provides users with a possibility to choose classification versions or related correspondance tables, view their content, and download for local use in several formats.
Navigation within STAKLAS is based on the continuous expansion of hierarchical structure, where the highest hierarchy element is the classification family and on the next levels are classifications, classification versions, and classification levels.
