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.
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
MademoiselleMME
MadameM
Monsieur
RH_CMP_TYPE
TEC
TechniqueFON
FonctionelleENC
EncadrementLNG
LangueAUT
Autre
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 | - |
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
MademoiselleMME
MadameM
Monsieur
RH_FRM_TYPE
AUV
AudiovisuelMKT
MarketingBUR
BureatutiqueINF
InformatiqueWEB
InternetGES
GestionCMP
ComptabilitéREH
Ressources HumainesDRT
DroitAUT
Autre
RH_TRIMESTRE
T1
Trimestre 1T2
Trimestre 2T3
Trimestre 3T4
Trimestre 4
RH_DFR_ETAT
D
RequestedA
AcceptedR
Refused
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
RequestedA
AcceptedR
Refused
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
DraftCP
CompletedVC
Validated by employeeVE
Validated by evaluator
RH_CIVILITE
MLLE
MademoiselleMME
MadameM
Monsieur
RH_ENT_EVALUATION
APP
A++AP
A+A
AAM
A-BP
B+B
BBM
B-C
CD
D
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
DraftCP
CompletedVC
Validated by employeeVE
Validated by evaluator
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
MademoiselleMME
MadameM
Monsieur
RH_FRM_TYPE
AUV
AudiovisuelMKT
MarketingBUR
BureatutiqueINF
InformatiqueWEB
InternetGES
GestionCMP
ComptabilitéREH
Ressources HumainesDRT
DroitAUT
Autre
RH_TRIMESTRE
T1
Trimestre 1T2
Trimestre 2T3
Trimestre 3T4
Trimestre 4
RH_FRS_EVALUATION
1
Très utile2
Moyennement utile3
Faiblement utile
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
DraftCP
CompletedVC
Validated by employeeVE
Validated by evaluator
RH_CIVILITE
MLLE
MademoiselleMME
MadameM
Monsieur
RH_OPA_OFU_TYPE
SFA
Savoir faireSET
Savoir êtreAUT
Autre
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
DraftCP
CompletedVC
Validated by employeeVE
Validated by evaluator
RH_CIVILITE
MLLE
MademoiselleMME
MadameM
Monsieur
RH_OPA_OFU_TYPE
SFA
Savoir faireSET
Savoir êtreAUT
Autre
RH_OPA_NIVEAUATTEINTE
1
Excellent2
Bon3
Moyen4
Insuffisant
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
QualitatifQTT
QuantitatifAUT
Autre
Name | Type | Required | Updatable | Personal | Description |
---|---|---|---|---|---|
rhSrvCode |
regexp(20) | yes* | yes | - | |
rhSrvLibelle |
char(50) | yes | yes | - | |
rhSrvLogo |
image | yes | - | ||
rhSrvDescription |
html(50000) | yes | - |
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
MademoiselleMME
MadameM
Monsieur
RH_COL_STATUT
CDI
Contrat à Durée IndéterminéeCDD
Contrat à Durée DéterminéeSTG
StageAPP
Apprenti
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
TechniqueFON
FonctionelleENC
EncadrementLNG
LangueAUT
Autre
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 | - |
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
AudiovisuelMKT
MarketingBUR
BureatutiqueINF
InformatiqueWEB
InternetGES
GestionCMP
ComptabilitéREH
Ressources HumainesDRT
DroitAUT
Autre
RH_TRIMESTRE
T1
Trimestre 1T2
Trimestre 2T3
Trimestre 3T4
Trimestre 4