panSL main page

All panSL samples

Hiring process

Could theoretically be used for administering the hiring process for new positions.
The schema is belived to work best when relatively few persons apply for a position.

Try out this schema now! (please allow a few seconds for your new database to be initialized.)

Name Essential
Designation / Designations Many
Applicant, Employee, Reference
EMail_address EMail
Responsibilities | Is_responsible_for | _
Position_responsibility RelationMany
Applications | Has_applied | Application_person RelationMany
Evaluations | Is_involved_in | Evaluation_person RelationMany

Name Essential
Responsible_person | Has_responsible_person | _
Position_responsibility RelationOne
Announcements | Has_been_announced | _
Position_announcement RelationMany
Applications | Has_applications | Application_position RelationMany

Announced_date Date Essential
Application_limit Date
Position | Is_about | Position_announcement RelationOne Essential
Applications | Has_applications | _
Application_announcement RelationMany

Received_date Date Essential
Applicant | Made_by | Application_person RelationOne Essential
Position | Is_about | Application_position RelationOne Essential
Announcement | Is_about | Application_announcement RelationOne
Evaluations | Has | Evaluation_application RelationMany

Evaluation_date Date Essential
Application | Is_about | Evaluation_application RelationOne
Persons | Involves | Evaluation_person RelationMany Essential
Type_of_evaluation Essential
Evaluation_of_education, Reference, Interview, _

Result_evaluation Essential
Nothing, Not_qualified, Qualified, Offered_position, _
Denied_position, Accepted_offer, Hired

ER-diagram (beta)

Note that in addition to generation of ER-Diagram the panSL Implementation AgoRapide may also be used to also generate database-schema (SQL) and source code for a variety of programming languages, tools and development architectures.

Last updated 2012-05-02