Turnover Report

Overview The Turnover Report provides turnover information for salaried positions for the
selected time period. The report consists of two parts: Turnover and Summary by
Separation Reason Code/Class Code. You can obtain turnover data from Jan. 1,
2007, to the previous month of the current year. As an example, if you need
turnover data for fiscal year 2019-2020, you will need to run the report on or after
July 1, 2020, and the report will contain data from July 2019 through June 2020.
For turnover data prior to Jan. 1, 2007, please contact the People First Data
Warehouse team at [email protected]. The Data
Warehouse provides the separation data in this report, which is valid as of the
previous day.

Access the Turnover Report from the Reports tile in the HR Reports section of
the People First system. The report returns both a PDF and Excel format when
processed. The PDF format is presented in one tab and the Excel format is
presented in a separate tab within the report.

Refer to the Running Reports in People First instructional guide for additional
information on processing data warehouse reports.

Definitions The report includes the following fields:

• Class Code – Pulled from the monthly history file for the position

• Class Title – Based on the class code for the position using the current class
code. Note: If the class title has changed since Jan. 1, 2007, it will reflect the
current class title as stored in the Broadband Crosswalk

• Beginning Period Number of Positions – Total number of full-time equivalent

(FTE) position values for the beginning date

• Beginning Period Number of Vacant Positions – Total vacant positions for the
beginning date

• Beginning Period Percentage of Vacant Positions – Number of vacant

positions divided by the number of positions and multiplied by 100

• Ending Period Number of Positions – Total FTE positions for the ending date

• Ending Period Number of Vacant Positions – Total vacant positions for the
ending date

• Ending Period Percentage of Vacant Positions – Number of vacant positions

divided by the number of positions and multiplied by 100

• Average Number of Positions – Beginning number of positions plus the

ending number of positions divided by two

Page 1
Last Updated on August 13, 2024
Turnover Report
• Number of Separations – Total separations for the given dates, data comes
from the employee transaction view and is based on the dates selected. If
this report is run for dates between Jan. 1, 2007, and July 31, 2010,
interagency transfers in which the exiting agency did not process a
separation action (PAR) will not be included

• Turnover Percentage – Number of separations divided by the average

number of positions and then multiplied by 100. This number is specific to the
report begin date and end date range

The Summary by Separation Reason Code/Class Code includes the following

fields:

• Class Code – Pulled from the monthly history file for the position
• Move to Private Sector (51) – Number of separations for the class code and
separation reason code 51

• Move within St of Florida Gov (52) – Number of separations for the class
code and separation reason code 52

• Other (53) – Number of separations for the class code and separation reason
code 53

• Failed Probationary Period (55) – Number of separations for the class code
and separation reason code 55

• Retirement (56) – Number of separations for the class code and separation
reason code 56

• Layoff (57) – Number of separations for the class code and separation
reason code 57

• End of Appointment Period (58) – Number of separations for the class code
and separation reason code 58

• Dismissal (59) – Number of separations for the class code and separation
reason code 59

• Death of Employee (60) – Number of separations for the class code and
separation reason code 60

• Death of Employee Line of Duty (61) – Number of separations for the class
code and separation reason code 61

• Abandonment (62) – Number of separations for the class code and

separation reason code 62

• Move to Non St of Florida Gov (63) – Number of separations for the class
code and separation reason code 63

• Dismissal – Emp Also Retires (64) – Number of separations for the class
code and separation reason code 64

• Legislative Directed Transfer (65) – Number of separations for the class code
and separation reason code 65

Page 2
Last Updated on August 13, 2024
Turnover Report
Filters The report uses the following filters:

• Agency Code – Required filter, defaults to your agency. Users with specific
security role codes (refer to the Authorization section) can process the report
statewide by selecting the ALL AGENCIES filter
• Org Code (From-To) – Required filter; defaults to “All”. To process the report
for one org code, enter the org code in the “From” and the same org code in
the “To” org code fields. To process the report for a range of org codes, enter
an org code in both the “From” and “To” org code fields. Click the Refresh
Values button to see all available org code selections

• Budget Entity Code (From-To) – Required filter; defaults to “All”. To process

the report for one budget entity code, enter the budget entity code in the
“From” and the same budget entity code in the “To” budget entity code fields.
To process the report for a range of budget entity codes, enter a budget
entity code in both the “From” and “To” budget entity code fields. Click the
Refresh Values button to see all available budget entity code selections

• Pay Plan – Required filter; defaults to “All”. Only pay plans used within your
agency will be available for selection. To select one or more pay plans, hold
the CTRL key and select the applicable codes. Click the Refresh Values
button to see all available pay plan selections

• Class Code – Required filter; defaults to “All”. To select one or more class
codes, hold the CTRL key and select the applicable codes. Click the Refresh
Values button to see all available class code selections

• CBU – Required filter; defaults to “All”. To select one or more CBUs, hold the
CTRL key and select the applicable codes. Click the Refresh Values button
to see all available CBU selections

• County Code – Required filter; defaults to “All”. The county is based on

Headquarter County for the position. To select one or more county codes,
hold the CTRL key and select the applicable codes. Click the Refresh Values
button to see all available county code selections

• Begin Date – Required filter; defaults to the first day of the current calendar
year. The date entered in this field must be the first day of any previous
month. Failure to enter the first day of a previous month will result in invalid
data (zeroes) in the beginning period information. The earliest allowable date
is Jan. 1, 2007

• End Date – Required filter. The date entered in this field must be the last
day of any previous month. Failure to enter the last day of a previous
month will result in invalid data (zeroes) in the ending period information.
Note: A turnover report cannot be produced for the current month since the
monthly history file is produced the first day of the following month. For
example, turnover data for the month of July 2020 is not available until Aug.
1, 2020

• Reason Code – Required filter; defaults to separation reason codes 51, 53,
62 and 63. To select one or more reason codes, hold the CTRL key and
select the applicable codes. Click the Refresh Values button to see all
available reason code selections

Page 3
Last Updated on August 13, 2024
Turnover Report
Sort Hierarchy The report uses the following sort sequence:

Turnover:
• Class Code
• Class Title

Summary by Separation Reason Code/Class Code:

• Class Code

Totals The report includes the following totals:

Summary by Separation Reason Code/Class Code:
• Class Totals – Total number of separations by class code

Special Notes The following special notes apply to the report:

• The report does not include OPS positions

• A Turnover Report cannot be produced for the current month since the
monthly history file is not produced until the first day of the following month

• The earliest date you can enter is Jan. 1, 2007

• If report is run for dates between Jan. 1, 2007, and July 31, 2010,
interagency transfers in which the exiting agency did not process a
separation action (PAR) will not be included

• The abolishment of positions or agency divestitures will result in a

percentage greater than 100

• When submitting turnover information for competitive pay purposes, use only
separation codes 51, 53, 62 and 63

Authorization Users with the following security role codes have access to the report:

• B, R, T, U, K – access to own agency

• A, C, D, F, G, H, I, M, N, S, X and Y – access statewide (all agencies)

Process Steps Step 1: Select Manager landing page > Reports > HR Reports

Step 2: Select Turnover Report

Step 3: Select/Enter filter values

Step 4: Select OK to run the report – the OK button will not be enabled until all
required prompts are completed

To view the report, click the Export button and select the report you want to view
(defaults with all reports selected). Select the file type (defaults to PDF) to match
the type of report you selected to view and click OK. A pop-up box will appear in
the lower left corner (Chrome) or bottom of the screen (IE). PDF reports are
formatted for printing, while Excel reports are unformatted so that the user can
work with the data as needed.

Page 4
Last Updated on August 13, 2024
Turnover Report
Selection
Criteria Sample Below is a sample of the Selection Criteria screen and the available filters:

Report Sample For best results, print this report as landscape, letter size. Below is a sample of
an Adobe Acrobat (PDF) report.

Page 5
Last Updated on August 13, 2024
Turnover Report

Page 6
Last Updated on August 13, 2024
Turnover Report
Summary by Separation Reason Code/Class Code

Page 7
Last Updated on August 13, 2024