Recodes and user defined fields
If the tables available in standard Census products do not meet a user's needs, then user defined customised tables can be created. Customised tables often require the use of recodes, tailored to the user's requirements. Recodes re-group fields in a classification. More complex user defined fields are new fields that can be created based on conditions applied to existing fields. User defined fields can be created from two or more fields in a database or can consist of mathematical functions.
A recode example:
Standard Labour force status classification
1 Employed, worked full-time
2 Employed, worked part-time
3 Employed, away from work
4 Unemployed, looking for full-time work
5 Unemployed, looking for part-time work
6 Not in the labour force
& Not stated
@ Not applicable
V Overseas visitor
Recoded Labour Force Classification
3 Not in the labour force
& Not stated
The recoded Labour Force Classification was recoded by:
- Grouping all employed persons (codes 1, 2 and 3) to be one item called Employed
- Grouping unemployed persons (codes 4 and 5) to be one item called Unemployed
- Including Not in the labour force (code 6) and Not stated (code &) as single items
- Excluding Not applicable and Overseas visitors from the recode.
This recode can now be used with other standard or recoded classifications.
A User Defined Field example:
- Selecting Registered Nurse from the Occupation classification
- Creating a recode for age by grouping ages 25-40.
These two selections can be combined using a User Defined Field function and labelling this as 'Registered Nurses aged 25-40 years'. This could then be used in creating a variety of tables about this group.