Details about ages are held, mainly associated with a particular event such as 'Age at Entry'. Additional contextual fields are held as below.
|Column Name||Data Type||Description||Derivation|
|age_sk||integer||This uniquely identifies the age record.||The value increments each time a record is entered into the table.|
|age||varchar||The age, or 'INVALID'/ 'UNKNOWN' if the age is outside the expected range. Valid values are 16-100.|
|age_num||integer||The age in a numeric field, for easier sorting. Invalid has an associated value of '-2', and Unknown '-1'|
|under_21||varchar||YES' if under 21, and 'NO' if not.|
|age_band||varchar||'16-20', '21-24', '25-34', '35-44', '45-54', '55-64' and '65+'|
|age_band_outreach||varchar||'16-20', '21-24', '25+'||Required by Outreach team.|