Human resources module for managing:
Employees
interviews
Competencies
Trainings
Note : This module is only available in French
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.
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
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
-
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
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
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
-
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
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
-
RH_DFR_ETAT
D Requested
A Accepted
R Refused
RHEntretien business object definition
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
-
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
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
-
RH_ENT_ETAT
BR Draft
CP Completed
VC Validated by employee
VE Validated by evaluator
RHFormationSuivie business object definition
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
-
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
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
-
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
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
-
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
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
-
RH_OSR_TYPE
QLT Qualitatif
QTT Quantitatif
AUT Autre
RHService business object definition
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
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
-
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
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
-
RH_CMP_TYPE
TEC Technique
FON Fonctionelle
ENC Encadrement
LNG Langue
AUT Autre
RHCampagne business object definition
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
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
-
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