XAGEJ01_1.4.2
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Age at 31 July in reporting year | XAGEJ01 | 1.4.2 | 2 | Char |
Valid entries
Dependent fields
- XAGRPJ01
Depend upon fields
- BIRTHDTE
Additional information
Age as at 31 July in reporting period. For example, during the reporting period 1 August 2001 to 31 July 2002, age will be as at 31 July 2002.
Definition:
00 Student.BIRTHDTE is >= (YYY1-1)-08-01
01 Student.BIRTHDTE is between (YYY1-1)-08-01 and (YYY1)-07-31 inclusive
02 Student.BIRTHDTE is between (YYY1-2)-08-01 and (YYY1-1)-07-31 inclusive
etc
18 Student.BIRTHDTE is between (YYY1-18)-08-01 and (YYY1-17)-07-31 inclusive
19 Student.BIRTHDTE is between (YYY1-19)-08-01 and (YYY1-18)-07-31 inclusive
20 Student.BIRTHDTE is between (YYY1-20)-08-01 and (YYY1-19)-07-31 inclusive
etc
95 Student.BIRTHDTE is between (YYY1-95)-08-01 and (YYY1-94)-07-31 inclusive
99 Student.BIRTHDTE is Null in Cyy051 or Cyy054; or 9999-12-31 in Cyy051 (a legacy default entry which may be present if switches are applied)
Technical Specification
In order to derived this field, the number of whole years between Student.BIRTHDTE and 31 July Y1+1 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 Institution.RECID.)
Cyy051.Student.BIRTHDTE or Cyy054.Student.BIRTHDTE | DIFF (internal value) | XAGEJ01 |
---|---|---|
Cyy051 Student record: Null or 9999-12-31 (if validation is switched to allow legacy default codes through) | 99 | |
Cyy054 AP student record: Null | ||
Otherwise | >= 0 and < 99 | DIFF |
>= 99 | 98 | |
< 0 | 00 |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.