]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.

(Please click on the hexagons for more information)


Data Model

Extension tables

im_employee_evaluation_processes
  • 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)

im_employee_evaluation_group_questions_map
  • 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)

im_employee_evaluation_group_questions_map
  • 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)

im_employee_evaluation_questions_tree
  • 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

 

Package Documentation

Package 'intranet-employee-evaluation' is not installed on this server, so there is no documentation available.  
  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com