ZREF_CONFTE_1.1.2
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Scaled contract REF FTE | ZREF_CONFTE | 1.1.2 | Number |
Dependent fields
- ZREF_CONPOP
- ZREF_FTE
- ZREF_POP
Depend upon fields
- none
Additional information
Contract FTE scaled up according to REF definitions for each contract in CYY025_CONTRACT.
For C18025 YY=18 and YYYY=2018
Technical Specification
For each contract in CYY025_CONTRACT create a YEAR_MARKER field to identify those who worked the whole year and a CONTRACT_DAYS field to count the number of days of the year the contract lasted.
STARTCON | ENDCON | YEAR_MARKER | CONTRACT_DAYS |
---|---|---|---|
< 01-AUG-YYYY | 0 | ||
<=01-AUG-YYYY or NULL | >= 31-JUL-YYYY+1 or null | 1 | 365 |
>= 01-AUG-YYYY AND < 31-JUL-YYYY+1 | 0 | ENDCON-31-JUL-YYYY | |
> 01-AUG-YYYY AND <= 31-JUL-YYYY+1 | 0 | (NVL(ENDCON,31-JUL-YYYY+1)-STARTCON)+1 | |
>31-JUL-YYYY+1 | 0 |
Then for each contract scale the FTE as follows:
CONTRACT_DAYS | MOEMP | YEAR_MARKER | ZREF_CONFTE |
---|---|---|---|
0 | 0 | ||
1, 2 | 100 | ||
3 | 1 | CONFTE | |
0 | CONFTE/(CON_DAYS/365) | ||
4 | 0, 1 | CONFTE/(30/52) | |
5, 6 | 0 |
Only produced for 2018/19 Staff data.
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.