XAGEA01_1.7.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Age at 31 August in reporting year | XAGEA01 | 1.7.1 | 2 | Char |
Valid entries
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) or 1900-01-01 in Cyy025 (where it has not been possible to identify a governor’s date of birth at all, providers can return a dummy date of birth of 1900-01-01).
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 Student Alternative record: Null | ||
Cyy025 Staff record:Null, or 9999-12-31 or 1901-01-01 (if validation is switched to allow legacy default codes through) or 1900-01-01 | ||
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
Contact Liaison by email or on +44 (0)1242 388 531.