Skip to content

Latest commit

 

History

History
572 lines (454 loc) · 51.7 KB

README.md

File metadata and controls

572 lines (454 loc) · 51.7 KB
Raw

RH module definition

Quality Gate Status

Introduction

Human resources module for managing:

  • Employees
  • interviews
  • Competencies
  • Trainings

Note: This module is only available in French

Import

To import this module:

  • Create a module named RH
  • Set the settings as:
{
	"type": "git",
	"origin": {
		"uri": "https://github.com/simplicitesoftware/module-rh.git"
	}
}
  • Click on the Import module button.

Load data

Some sample data is provided as a module's dataset.

Open this dataset and click on the Apply button after having imported the module and made a full clear cache.

RHCollaborateurCompetence business object definition

Fields

Name Type Required Updatable Personal Description
rhColCmpColId link to RHCollaborateur id yes* yes -
Ref. rhColCmpColId.rhColCivilite enum(10) using RH_CIVILITE list -
Ref. rhColCmpColId.rhColMatricule regexp(20) -
Ref. rhColCmpColId.rhColNom char(100) -
Ref. rhColCmpColId.rhColPrenom char(100) -
Ref. rhColCmpColId.rhColSrvId id -
Ref. rhColSrvId.rhSrvCode regexp(20) -
Ref. rhColSrvId.rhSrvLibelle char(50) -
Ref. rhColCmpColId.rhColTitre char(100) -
rhColCmpCmpId link to RHCompetence id yes* yes -
Ref. rhColCmpCmpId.rhCmpNom char(100) -
Ref. rhColCmpCmpId.rhCmpType enum(3) using RH_CMP_TYPE list -
rhColCmpNiveau int(11) yes yes -
rhColCmpCommentaires notepad(50000) yes -

Lists

  • RH_CIVILITE
    • MLLE Mademoiselle
    • MME Madame
    • M Monsieur
  • RH_CMP_TYPE
    • TEC Technique
    • FON Fonctionelle
    • ENC Encadrement
    • LNG Langue
    • AUT Autre

RHCollaborateurHistoric business object definition

Fields

Name Type Required Updatable Personal Description
row_ref_id link to RHCollaborateur id yes* Record row ID
row_idx int(11) yes* yes History record index
created_by_hist char(100) yes* Created by
created_dt_hist datetime yes* Created date
rhColSrvId link to RHService id yes yes -
Ref. rhColSrvId.rhSrvCode regexp(20) -
rhColDateDebutSrv date yes yes -
rhColTitre char(100) yes -

RHDemandeFormation business object definition

Fields

Name Type Required Updatable Personal Description
rhDfrColId link to RHCollaborateur id yes* yes -
Ref. rhDfrColId.rhColMatricule regexp(20) -
Ref. rhDfrColId.rhColCivilite enum(10) using RH_CIVILITE list -
Ref. rhDfrColId.rhColNom char(100) -
Ref. rhDfrColId.rhColPrenom char(100) -
Ref. rhDfrColId.rhColSrvId id -
Ref. rhColSrvId.rhSrvLibelle char(50) -
Ref. rhColSrvId.rhSrvCode regexp(20) -
Ref. rhDfrColId.rhColTitre char(100) -
rhDfrFrmId link to RHFormation id yes* yes -
Ref. rhDfrFrmId.rhFrmCode regexp(30) -
Ref. rhDfrFrmId.rhFrmType enum(3) using RH_FRM_TYPE list -
Ref. rhDfrFrmId.rhFrmLibelle char(100) -
Ref. rhDfrFrmId.rhFrmPeriode multi(20) using RH_TRIMESTRE list -
rhDfrEtat enum(1) using RH_DFR_ETAT list yes yes -
rhDfrMotivation html(50000) yes -
rhDfrPeriodeSouhaitee enum(2) using RH_TRIMESTRE list yes -
rhDfrDIF boolean yes -

Lists

  • RH_CIVILITE
    • MLLE Mademoiselle
    • MME Madame
    • M Monsieur
  • RH_FRM_TYPE
    • AUV Audiovisuel
    • MKT Marketing
    • BUR Bureatutique
    • INF Informatique
    • WEB Internet
    • GES Gestion
    • CMP Comptabilité
    • REH Ressources Humaines
    • DRT Droit
    • AUT Autre
  • RH_TRIMESTRE
    • T1 Trimestre 1
    • T2 Trimestre 2
    • T3 Trimestre 3
    • T4 Trimestre 4
  • RH_DFR_ETAT
    • D Requested
    • A Accepted
    • R Refused

RHDemandeFormationHistoric business object definition

Fields

Name Type Required Updatable Personal Description
row_ref_id link to RHDemandeFormation id yes* Record row ID
row_idx int(11) yes* yes History record index
created_by_hist char(100) yes* Created by
created_dt_hist datetime yes* Created date
rhDfrEtat enum(1) using RH_DFR_ETAT list yes yes -

Lists

  • RH_DFR_ETAT
    • D Requested
    • A Accepted
    • R Refused

RHEntretien business object definition

Fields

Name Type Required Updatable Personal Description
rhEntCpgId link to RHCampagne id yes* yes -
Ref. rhEntCpgId.rhCpgAnnee int(11) -
Ref. rhEntCpgId.rhCpgDateDebut date -
Ref. rhEntCpgId.rhCpgDateFin date -
rhEntDate datetime yes yes -
rhEntDuree int(11) yes yes -
rhEntEtat enum(2) using RH_ENT_ETAT list yes yes -
rhEntURLCode char(50) -
rhEntURL url(255) -
rhEntColId link to RHCollaborateur id yes* yes -
Ref. rhEntColId.rhColMatricule regexp(20) -
Ref. rhEntColId.rhColCivilite enum(10) using RH_CIVILITE list -
Ref. rhEntColId.rhColNom char(100) -
Ref. rhEntColId.rhColPrenom char(100) -
Ref. rhEntColId.rhColSrvId id -
Ref. rhColSrvId.rhSrvCode regexp(20) -
Ref. rhColSrvId.rhSrvLibelle char(50) -
Ref. rhEntColId.rhColTitre char(100) -
rhEntEvlId link to RHCollaborateur id yes yes -
Ref. rhEntEvlId.rhColMatricule regexp(20) -
Ref. rhEntEvlId.rhColCivilite enum(10) using RH_CIVILITE list -
Ref. rhEntEvlId.rhColNom char(100) -
Ref. rhEntEvlId.rhColPrenom char(100) -
Ref. rhEntEvlId.rhColUsrId id -
Ref. rhColUsrId.usr_login regexp(100) yes Login
rhEntBilanEvaluateur html(50000) yes -
rhEntBilanCollaborateur html(50000) -
rhEntEvaluation enum(3) using RH_ENT_EVALUATION list yes -
rhEntSuivi boolean yes -

Lists

  • RH_ENT_ETAT
    • BR Draft
    • CP Completed
    • VC Validated by employee
    • VE Validated by evaluator
  • RH_CIVILITE
    • MLLE Mademoiselle
    • MME Madame
    • M Monsieur
  • RH_ENT_EVALUATION
    • APP A++
    • AP A+
    • A A
    • AM A-
    • BP B+
    • B B
    • BM B-
    • C C
    • D D

RHEntretienHistoric business object definition

Fields

Name Type Required Updatable Personal Description
row_ref_id link to RHEntretien id yes* Record row ID
row_idx int(11) yes* yes History record index
created_by_hist char(100) yes* Created by
created_dt_hist datetime yes* Created date
rhEntEtat enum(2) using RH_ENT_ETAT list yes yes -

Lists

  • RH_ENT_ETAT
    • BR Draft
    • CP Completed
    • VC Validated by employee
    • VE Validated by evaluator

RHFormationSuivie business object definition

Fields

Name Type Required Updatable Personal Description
rhFrsColId link to RHCollaborateur id yes* yes -
Ref. rhFrsColId.rhColMatricule regexp(20) -
Ref. rhFrsColId.rhColCivilite enum(10) using RH_CIVILITE list -
Ref. rhFrsColId.rhColNom char(100) -
Ref. rhFrsColId.rhColPrenom char(100) -
Ref. rhFrsColId.rhColSrvId id -
Ref. rhColSrvId.rhSrvCode regexp(20) -
Ref. rhFrsColId.rhColTitre char(100) -
Ref. rhColSrvId.rhSrvLibelle char(50) -
rhFrsFrmId link to RHFormation id yes* yes -
Ref. rhFrsFrmId.rhFrmCode regexp(30) -
Ref. rhFrsFrmId.rhFrmType enum(3) using RH_FRM_TYPE list -
Ref. rhFrsFrmId.rhFrmLibelle char(100) -
Ref. rhFrsFrmId.rhFrmPeriode multi(20) using RH_TRIMESTRE list -
rhFsrDate date yes yes -
rhFrsEvaluation enum(3) using RH_FRS_EVALUATION list yes yes -
rhFrsCommentaires html(50000) yes -

Lists

  • RH_CIVILITE
    • MLLE Mademoiselle
    • MME Madame
    • M Monsieur
  • RH_FRM_TYPE
    • AUV Audiovisuel
    • MKT Marketing
    • BUR Bureatutique
    • INF Informatique
    • WEB Internet
    • GES Gestion
    • CMP Comptabilité
    • REH Ressources Humaines
    • DRT Droit
    • AUT Autre
  • RH_TRIMESTRE
    • T1 Trimestre 1
    • T2 Trimestre 2
    • T3 Trimestre 3
    • T4 Trimestre 4
  • RH_FRS_EVALUATION
    • 1 Très utile
    • 2 Moyennement utile
    • 3 Faiblement utile

RHObjectifFutur business object definition

Fields

Name Type Required Updatable Personal Description
rhOfuEntId link to RHEntretien id yes* -
Ref. rhOfuEntId.rhEntCpgId id -
Ref. rhEntCpgId.rhCpgAnnee int(11) -
Ref. rhOfuEntId.rhEntEtat enum(2) using RH_ENT_ETAT list -
Ref. rhOfuEntId.rhEntColId id -
Ref. rhEntColId.rhColMatricule regexp(20) -
Ref. rhEntColId.rhColCivilite enum(10) using RH_CIVILITE list -
Ref. rhEntColId.rhColNom char(100) -
Ref. rhEntColId.rhColPrenom char(100) -
rhOfuNumero int(11) yes* -
rhOfuType enum(30) using RH_OPA_OFU_TYPE list yes yes -
rhOfuObjectif html(50000) yes -

Lists

  • RH_ENT_ETAT
    • BR Draft
    • CP Completed
    • VC Validated by employee
    • VE Validated by evaluator
  • RH_CIVILITE
    • MLLE Mademoiselle
    • MME Madame
    • M Monsieur
  • RH_OPA_OFU_TYPE
    • SFA Savoir faire
    • SET Savoir être
    • AUT Autre

RHObjectifPasse business object definition

Fields

Name Type Required Updatable Personal Description
rhOpaEntId link to RHEntretien id yes* -
Ref. rhOpaEntId.rhEntCpgId id -
Ref. rhEntCpgId.rhCpgAnnee int(11) -
Ref. rhOpaEntId.rhEntEtat enum(2) using RH_ENT_ETAT list -
Ref. rhOpaEntId.rhEntColId id -
Ref. rhEntColId.rhColMatricule regexp(20) -
Ref. rhEntColId.rhColCivilite enum(10) using RH_CIVILITE list -
Ref. rhEntColId.rhColNom char(100) -
Ref. rhEntColId.rhColPrenom char(100) -
rhOpaNumero int(11) yes* -
rhOpaType enum(30) using RH_OPA_OFU_TYPE list yes yes -
rhOpaObjectif html(50000) yes -
rhOpaNiveauAtteinte enum(1) using RH_OPA_NIVEAUATTEINTE list yes -
rhOpaCommentaires html(50000) yes -

Lists

  • RH_ENT_ETAT
    • BR Draft
    • CP Completed
    • VC Validated by employee
    • VE Validated by evaluator
  • RH_CIVILITE
    • MLLE Mademoiselle
    • MME Madame
    • M Monsieur
  • RH_OPA_OFU_TYPE
    • SFA Savoir faire
    • SET Savoir être
    • AUT Autre
  • RH_OPA_NIVEAUATTEINTE
    • 1 Excellent
    • 2 Bon
    • 3 Moyen
    • 4 Insuffisant

RHObjectifService business object definition

Fields

Name Type Required Updatable Personal Description
rhOsrCpgId link to RHCampagne id yes* yes -
Ref. rhOsrCpgId.rhCpgAnnee int(11) -
Ref. rhOsrCpgId.rhCpgDateDebut date -
Ref. rhOsrCpgId.rhCpgDateFin date -
rhOsrSrvId link to RHService id yes* yes -
Ref. rhOsrSrvId.rhSrvCode regexp(20) -
Ref. rhOsrSrvId.rhSrvLibelle char(50) -
rhOsrNumero int(11) yes* -
rhOsrType enum(3) using RH_OSR_TYPE list yes yes -
rhOsrObjectif html(50000) yes -
rhOsrPieceJointe document yes -

Lists

  • RH_OSR_TYPE
    • QLT Qualitatif
    • QTT Quantitatif
    • AUT Autre

RHService business object definition

Fields

Name Type Required Updatable Personal Description
rhSrvCode regexp(20) yes* yes -
rhSrvLibelle char(50) yes yes -
rhSrvLogo image yes -
rhSrvDescription html(50000) yes -

RHCollaborateur business object definition

Fields

Name Type Required Updatable Personal Description
rhColMatricule regexp(20) yes* yes -
rhColCivilite enum(10) using RH_CIVILITE list yes yes -
rhColNom char(100) yes yes -
rhColPrenom char(100) yes yes -
rhColUsrId link to User id yes -
Ref. rhColUsrId.usr_login regexp(100) yes Login
rhColPhoto image yes -
rhColDateNaissance date yes yes -
rhColEmail email(50) yes -
rhColTelephone phone(20) yes -
rhColMobile phone(20) yes -
rhColFax phone(20) yes -
rhColAdresse char(100) yes -
rhColComplement char(100) yes -
rhColCodePostal regexp(10) yes -
rhColVille char(50) yes -
rhColCoords geocoords yes -
rhColStatut enum(3) using RH_COL_STATUT list yes yes -
rhColDateDebut date yes yes -
rhColDateFin date yes -
rhColSrvId link to RHService id yes yes -
Ref. rhColSrvId.rhSrvCode regexp(20) -
Ref. rhColSrvId.rhSrvLibelle char(50) -
rhColDateDebutSrv date yes yes -
rhColTitre char(100) yes -

Lists

  • RH_CIVILITE
    • MLLE Mademoiselle
    • MME Madame
    • M Monsieur
  • RH_COL_STATUT
    • CDI Contrat à Durée Indéterminée
    • CDD Contrat à Durée Déterminée
    • STG Stage
    • APP Apprenti

RHCompetence business object definition

Fields

Name Type Required Updatable Personal Description
rhCmpNom char(100) yes* yes -
rhCmpType enum(3) using RH_CMP_TYPE list yes yes -
rhCmpDescription html(50000) yes -

Lists

  • RH_CMP_TYPE
    • TEC Technique
    • FON Fonctionelle
    • ENC Encadrement
    • LNG Langue
    • AUT Autre

RHCampagne business object definition

Fields

Name Type Required Updatable Personal Description
rhCpgAnnee int(11) yes* yes -
rhCpgDateDebut date yes yes -
rhCpgDateFin date yes yes -
rhCpgDescription html(50000) yes -
rhCpgNotice document yes -

RHFormation business object definition

Fields

Name Type Required Updatable Personal Description
rhFrmCode regexp(30) yes* yes -
rhFrmType enum(3) using RH_FRM_TYPE list yes yes -
rhFrmLibelle char(100) yes yes -
rhFrmDisponible boolean yes yes -
rhFrmDescription html(50000) yes -
rhFrmProgramme document yes -
rhFrmPeriode multi(20) using RH_TRIMESTRE list yes -
rhFrmCout float(11, 2) yes -

Lists

  • RH_FRM_TYPE
    • AUV Audiovisuel
    • MKT Marketing
    • BUR Bureatutique
    • INF Informatique
    • WEB Internet
    • GES Gestion
    • CMP Comptabilité
    • REH Ressources Humaines
    • DRT Droit
    • AUT Autre
  • RH_TRIMESTRE
    • T1 Trimestre 1
    • T2 Trimestre 2
    • T3 Trimestre 3
    • T4 Trimestre 4

RHEntretienCollab external object definition