Web Content Display Web Content Display

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.