]po[ Employee Evaluation

Employee Evaluation extends the Simple Survey Package by providing support for the grouping of questions, multi-panel and multi-tab screens. It also provides exhaustive reporting, several portlets that show status reports and other statistical information.

Data Model

Extension tables

• Holds evaluation 'campaigns' and their principle attributes

        Table "public.im_employee_evaluation_processes"
          Column          |          Type          | Modifiers
--------------------------+------------------------+-----------
 id                       | integer                | not null
 name                     | character varying(100) | not null
 project_id               | integer                | not null
 survey_name              | character varying(100) | not null
 workflow_key             | character varying(50)  |
 line_break_function      | character varying(50)  |
 validation_function      | character varying(50)  |
 transition_name_printing | character varying(50)  |
 evaluation_year          | integer                | not null
 status                   | character varying(50)  | not null
Indexes:
    "im_employee_evaluation_processes_pkey" PRIMARY KEY, btree (id)
    "im_employee_evaluation_processes_project_id_key" UNIQUE, btree (project_id)
Check constraints:
    "im_employee_evaluation_processes_status_ck" CHECK (status::text = ANY (ARRAY['Current'::character varying, 'Next'::character varying, 'Finished'::character varying]::text[]))
Foreign-key constraints:
    "project_id_fk" FOREIGN KEY (project_id) REFERENCES im_projects(project_id)

• Questions might be combined differently throughout survey stages

Table "public.im_employee_evaluation_group_questions_map"
   Column    |  Type   | Modifiers
-------------+---------+-----------
 id          | integer | not null
 group_id    | integer |
 question_id | integer |
 sort_key    | integer |
Indexes:
    "im_employee_evaluation_group_questions_map_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "group_id_fk" FOREIGN KEY (group_id) REFERENCES im_employee_evaluation_groups(group_id)
    "question_id_fk" FOREIGN KEY (question_id) REFERENCES survsimp_questions(question_id)

• Group names might be shown
• Two group types are supported: tab, panel

    Table "public.im_employee_evaluation_groups"
    Column     |          Type          | Modifiers
---------------+------------------------+-----------
 group_id      | integer                | not null
 group_name    | character varying(100) |
 grouping_type | character varying(50)  |
Indexes:
    "im_employee_evaluation_groups_pkey" PRIMARY KEY, btree (group_id)
Referenced by:
    TABLE "im_employee_evaluation_group_questions_map" CONSTRAINT "group_id_fk" FOREIGN KEY (group_id) REFERENCES im_employee_evaluation_groups(group_id)
    TABLE "im_employee_evaluation_panel_group_map" CONSTRAINT "group_id_fk" FOREIGN KEY (group_id) REFERENCES im_employee_evaluation_groups(group_id)

• Build hirarchical structure of groups
• Questions can be grouped with one header questions where no answer is expected

Table "public.im_employee_evaluation_questions_tree"
       Column       |  Type   | Modifiers
--------------------+---------+-----------
 id                 | integer | not null
 parent_question_id | integer |
 child_question_id  | integer |
Indexes:
    "im_employee_evaluation_questions_tree_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "child_question_id_fk" FOREIGN KEY (child_question_id) REFERENCES survsimp_questions(question_id)
    "parent_question_id_fk" FOREIGN KEY (parent_question_id) REFERENCES survsimp_questions(question_id)

Reference 

Related Object Types

• [Simple Surveys]

Related Packages

• Simple Surveys 

Package Documentation