XSFTE01_2.2.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Staff full-time equivalent activity by cost centre | XSFTE01 | 2.2.1 | 7 | Char |
Dependent fields
- XSFPE01
- XSAFPE01
Depend upon fields
- CONFTE
- ACTSOC
- CCENTRE
- CCPROP
Additional information
The datasets table Cyy025_CC is the cost centre table created as part of the HESA Staff record.
This derived field produces the first pass of the Cyy025_CC table, populating the table with ContractKEY, ACTSOC and CCENTRE as well as creating XSFTE01.
XSFTE01 is the total staff full-time equivalence (FTE) for the year, derived from the contract of employment, proportioned to each activity's cost centre.
Technical Specification
Cyy025_CC
This table holds cost centre data created from the Staff Contract entity for XSFTE01, as follows:
Do not create a record if Contract.CONFTE = 000.0*
(* Note: The length of Contract.CONFTE is a maximum of 5 characters (nnn.n), however the move to XML enables data to be returned with or without leading zeros or the decimal place, e.g. '000.0', '00.0', '0.0' or '0') are equally acceptable).
** |
For each occurrence (maximum of six) of the Activity entity (Activity.ACTSOC, Activity.CCENTRE and Activity.CCPROP) create a record in the Cyy025_CC table containing: Contract.ContractKEY, Activity.ACTSOC, Activity.CCENTRE, XSFTE01 = ROUND((Activity.CCPROP/100)*Contract.CONFTE) |
** This is the 'first pass' of the creation of the cost centre table. Subsequent 'passes' are required for the creation of the dependent fields XSFPE01 and XSAFPE01, as detailed in the individual field specifications.
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.