Derivation tables

The derivation tables are available in excel format.

(Cells for unallowable combinations of codes have been filled using the priority order rules and are shaded.)

Matrix format

Arranges the combinations of SOC codes and Employment Status codes in a matrix.

A warning on statistical software

The derivation tables contain values with decimal places that relate to the operational sub-categories. Using the tables in most statistical software can result in some precision problems if the variables are defined as numeric and used in calculations. It is recommended to define the NS-SEC variables as nominal.

Tables for deriving NS-SEC from SOC2000

The tables are available to download as Excel documents.

Tables for deriving NS-SEC based on SOC90

Full method NS-SEC Operational Categories

Derivation table for the Full Method - NS-SEC Operational Categories Excel version 71.2 Kb Excel sheet

Full method NS-SEC Analytic Classes

Derivation table for the Full Method - NS-SEC Analytic Classes Excel version 70.7 Kb Excel sheet

Reduced method NS-SEC Operational Categories

Derivation table for the Reduced Method - NS-SEC Operational Categories Excel version 70.7 Kb Excel sheet

Reduced method NS-SEC Analytic Classes

Derivation table for the Reduced Method - NS-SEC Analytic Classes Excel version 84 Kb Excel sheet