Flight Risk Survey

The Flight Risk Survey report uses the Flight Risk Survey topic to show a list of all of the answers available for each question on the flight risk survey, which managers complete for their employees in the Flight Risk screen in People. It shows the total number of employees that each answer was selected for, and how many of those employees are still employed or now have terminated status. You can use the report to see if there is a correlation between the answers that managers select for their employees and the current employment status of those employees.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Engagement Level	Yes	A to Z
Question
Answer
Total
Still Employed
% Still Employed
Terminated
% Terminated		Largest to Smallest

Custom Fields

Engagement Level

The Engagement Level field shows the categories for the coaching engagement level aligned with the questions provided in the flight risk survey. The custom field uses the following expression:

CASE
    WHEN EmployeeFlightRiskSurvey.Question = '1. Does the employee understand the strategic goals of the broader organization?' THEN 'Alignment to company vision'
    WHEN EmployeeFlightRiskSurvey.Question = '2. Does the employee know what <he/she> should do to help the company meet its goals and objectives?' THEN 'Alignment to company vision'
    WHEN EmployeeFlightRiskSurvey.Question = '3. Can the employee see a clear link between <his/her> work and the company''s goals and objectives?' THEN 'Alignment to company vision'
    WHEN EmployeeFlightRiskSurvey.Question = '5. Does the team inspire the employee to do <his/her> best work?' THEN 'Relationship with manager/peers'
    WHEN EmployeeFlightRiskSurvey.Question = '6. Does the employee have good working relationships with members of <his/her> team?' THEN 'Relationship with manager/peers'
    WHEN EmployeeFlightRiskSurvey.Question = '7. Does the employee have the appropriate amount of information to make correct decisions about <his/her> work?' THEN 'Effectiveness in role'
    WHEN EmployeeFlightRiskSurvey.Question = '8. Does the employee have the training, tools and resources (including time) to effectively complete <his/her> work?' THEN 'Effectiveness in role'
    WHEN EmployeeFlightRiskSurvey.Question = '9. When something unexpected comes up in the employees work, does <he/she> usually know who to ask for help?' THEN 'Effectiveness in role'
    WHEN EmployeeFlightRiskSurvey.Question = '4. Is the employee proud to be a member of <his/her> team?' THEN 'Relationship with manager/peers'
    ELSE ' '
END

Total

The Total field shows the total answers received for a question on the flight risk survey. The custom field uses the following expression:

SUM(CASE
        WHEN EmploymentStatusGroup.ShortName = 'Active' THEN 1
        WHEN EmploymentStatusGroup.ShortName = 'Inactive' THEN 1
        WHEN EmploymentStatusGroup.ShortName = 'Terminated' THEN 1
        WHEN EmploymentStatusGroup.ShortName = 'Pre-Start' THEN 1
    END)

Still Employed

The Still Employed field shows the number of employees that are still active as of the end of the report time period. The custom field uses the following expression:

SUM(CASE WHEN EmploymentStatusGroup.ShortName = 'Active' THEN 1 ELSE 0 END)

% Still Employed

The % Still Employed field shows the percentage of employees that are still active as of the report time period. The custom field uses the following expression:

SUM(CASE
        WHEN EmploymentStatusGroup.ShortName = 'Active' THEN 1.0
        ELSE 0.0
    END) / SUM(CASE
                   WHEN EmploymentStatusGroup.ShortName = 'Active' THEN 1.0
                   WHEN EmploymentStatusGroup.ShortName = 'Inactive' THEN 1.0
                   WHEN EmploymentStatusGroup.ShortName = 'Terminated' THEN 1.0
                   WHEN EmploymentStatusGroup.ShortName = 'Pre-Start' THEN 1.0
               END) * 100.0

Terminated

The Terminated field shows the total count of employees who have left the organization after the flight risk survey was taken. The custom field uses the following expression:

SUM(CASE WHEN EmploymentStatusGroup.ShortName = 'Terminated' THEN 1 ELSE 0 END)

% Terminated

The % Terminated field shows the percentage of terminated employees that had left the organization after the flight risk survey was taken. The custom field uses the following expression:

SUM(CASE
        WHEN EmploymentStatusGroup.ShortName = 'Terminated' THEN 1.0
        ELSE 0.0
    END) / SUM(CASE
                   WHEN EmploymentStatusGroup.ShortName = 'Active' THEN 1.0
                   WHEN EmploymentStatusGroup.ShortName = 'Inactive' THEN 1.0
                   WHEN EmploymentStatusGroup.ShortName = 'Terminated' THEN 1.0
                   WHEN EmploymentStatusGroup.ShortName = 'Pre-Start' THEN 1.0
               END) * 100.0

Filters

The template contains the following filters: