Skip to main content

ZREF_CONFTE_1.1.2

Back to C18025

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

Date Version Notes
2019-05-02 1.1.2 Technical specification amended to account for members of staff that have a contract start date of 31st July YYYY.
2018-01-01 1.1.1 Created for C18025

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