Skip to main content

XAGEA01_1.6.1

Back to C17054

Field description Field abbreviation Field version Field length Field type
Age at 31 August in reporting year XAGEA01 1.6.1 2 Char

Valid entries

Code Label
00 Less than 1 year old
01 1 year old
02 2 years old
03 3 years old
04 4 years old
05 5 years old
06 6 years old
07 7 years old
08 8 years old
09 9 years old
10 10 years old
11 11 years old
12 12 years old
13 13 years old
14 14 years old
15 15 years old
16 16 years old
17 17 years old
18 18 years old
19 19 years old
20 20 years old
21 21 years old
22 22 years old
23 23 years old
24 24 years old
25 25 years old
26 26 years old
27 27 years old
28 28 years old
29 29 years old
30 30 years old
31 31 years old
32 32 years old
33 33 years old
34 34 years old
35 35 years old
36 36 years old
37 37 years old
38 38 years old
39 39 years old
40 40 years old
41 41 years old
42 42 years old
43 43 years old
44 44 years old
45 45 years old
46 46 years old
47 47 years old
48 48 years old
49 49 years old
50 50 years old
51 51 years old
52 52 years old
53 53 years old
54 54 years old
55 55 years old
56 56 years old
57 57 years old
58 58 years old
59 59 years old
60 60 years old
61 61 years old
62 62 years old
63 63 years old
64 64 years old
65 65 years old
66 66 years old
67 67 years old
68 68 years old
69 69 years old
70 70 years old
71 71 years old
72 72 years old
73 73 years old
74 74 years old
75 75 years old
76 76 years old
77 77 years old
78 78 years old
79 79 years old
80 80 years old
81 81 years old
82 82 years old
83 83 years old
84 84 years old
85 85 years old
86 86 years old
87 87 years old
88 88 years old
89 89 years old
90 90 years old
91 91 years old
92 92 years old
93 93 years old
94 94 years old
95 95 years old
96 96 years old
97 97 years old
98 Over 97 years old
99 Unknown age

Dependent fields

  • XAGRP601
  • XAGRPA01
  • XAGRPB01

Depend upon fields

  • BIRTHDTE

Additional information

Age as at 31 August in reporting period. For example during the reporting period 1 August 2012 to 31 July 2013, age will be as at 31 August 2012.

Definition:

Note that BIRTHDTE is either Student.BIRTHDTE from Cyy051 or Cyy054, or Person.BIRTHDTE from Cyy025

00 BIRTHDTE is > (YYY1-1)-08-31
01 BIRTHDTE is between (YYY1-2)-09-01 and (YYY1-1)-08-31 inclusive
02 BIRTHDTE is between (YYY1-3)-09-01 and (YYY1-2)-08-31 inclusive
etc.
18 BIRTHDTE is between (YYY1-19)-09-01 and (YYY1-18)-08-31 inclusive
19 BIRTHDTE is between (YYY1-20)-09-01 and (YYY1-19)-08-31 inclusive
20 BIRTHDTE is between (YYY1-21)-09-01 and (YYY1-20)-08-31 inclusive
21 BIRTHDTE is between (YYY1-22)-09-01 and (YYY1-21)-08-31 inclusive
etc.
95 BIRTHDTE is between (YYY1-96)-09-01 and (YYY1-95)-08-31 inclusive
99 BIRTHDTE is Null in Cyy051, Cyy054 or Cyy025; 9999-12-31 in Cyy051 or Cyy025; or 1901-01-01 in Cyy025 (the latter two codes being legacy default entries which may be present if switches are applied)

Technical Specification

In order to derive this field, the number of whole years between BIRTHDTE and 31 August Y1 must be known. This value is called DIFF. For example, Y1=2001 in the 2001-02 reporting period and is obtained by concatenating the first two digits from year in the system date with the first two digits of the collection's RECID.

Cyy051.Student.BIRTHDTE, Cyy054.Student.BIRTHDTE or Cyy025.Person.BIRTHDTE DIFF (internal value) XAGEA01
Cyy051 Student record: Null or 9999-12-31 (if validation is switched to allow legacy default codes through) 99
Cyy054 AP student record: Null
Cyy025 Staff record:Null, or 9999-12-31 or 1901-01-01 (if validation is switched to allow legacy default codes through)
Otherwise >= 0 and < 99 DIFF
>= 99 98
< 0 00

(Note: Staff 9999-12-31 and 1901-01-01 are not recognised default BIRTHDTE codes for the Staff 2012/13 collection onwards. They have been retained in the Technical specification to derive to 99 'Unknown age' solely on the premise that if Business rule errors are switched to allow these legacy codes through, they will be correctly allocated to Unknown age, rather than 00 'Less than 1 year old' or 98 'Over 97 years old').

Revision history

Date Version Notes
2014-10-16 1.6.1 Technical specification amended to allow for the use of this field in the Cyy054 AP student record.
2013-01-17 1.5.1 Technical specification amended to account for switch to XML format in Staff record for 2012/13. Additional information BIRTHDTE example format changed to ISO 8601 yyyy-mm-dd.
2011-01-31 1.4.1 Technical specifcation amended to account for potential future value in Student record.
2010-11-08 1.3.4 Additional information for valid entry 99 added where validation is switched. No change to function.
2010-04-09 1.3.3 Minor text amendments. Valid entries listed in full. No change to function.
2009-03-17 1.3.2 Format amended. Colons removed from valid entries. Field type added.
2007-01-12 1.2.1 Amended spec to deal with new default code 01/01/1901.
2002-04-30 1.1.2 Clarification of reporting year in technical spec.
1998-10-26 1.1.1 Created
1994-01-01 1.3.1 Amended to deal with changed reporting of unknown birth date between student and staff streams.

Contact Liaison by email or on +44 (0)1242 388 531.