Modifying the data model

This page summarizes all the changes made to the ODF data model from version 4.1.0 to 4.3.0.

Training / Career
Container
List ofELP
ELP
Person
Component
Teaching hours
Reference tables
1. New reference tables
2. Reference table Nature (Container), Nature (ELP), Nature diploma and Diploma

Training / Career

Field label	Créa.	Modif.	Delete	Training	Course	Description	Migration
Mandatory entry level	x			x	x	This element specifies whether the entry level described in the 'Entry level' field is mandatory or indicative only.	None, field created for LHEO export
Work-study arrangements	x			x	x	This element specifies the organization of the work-study program: dates and duration of periods spent at the center or on the company premises.	None, field created for LHEO export
Expected results	x			x	x	This element describes the expected results of the training (title, diploma, certificate, attestation, etc.) and specifies the recognition or validation procedures.	None, field created for LHEO export
Certification training	x			x	x	This element indicates whether the training leads to certification (diploma, title or qualification certificate).	None, field created for LHEO export
FORMACODE reference system	x			x	x	This element contains a FORMACODE code.	None, field created for LHEO export
Testimonial		x		x	x	Add a "role" field to repeater entries (title, role, illustration, rich text)	Add to renderings HTML, PDF if necessary.
Contact merge		x		x	x	Managers and administrative contacts have been merged into a single contact repeater.	Technical, graphical and data migration
Apogée export code	x			x	x	Apogee export code as [codApogee]-[versionApogee]	None, field created for Apogée export
Cycle	x			x	x	Training cycle	None, field created for Apogée export
Start of validation	x			x	x	Validation start date	None, field created for Apogée export
End of validation	x			x	x	Validation end date	None, field created for Apogée export
Start of recruitment	x			x	x	Recruitment start date	None, field created for Apogée export
End of recruitment	x			x	x	Recruitment end date	None, field created for Apogée export
Authorized listing plans	x				x	Authorized listing plans	None, field created for Apogée export
CIP list	x				x	CIP list	None, field created for Apogée export
Stage duration	x				x	Stage duration	None, field created for Apogée export
Skills required		x		x	x	Becomes a skills drop-down list instead of a skills block drop-down list	Technical, graphical and data migration
Skills acquired			x			Field removed from the model. Skills at the level of a training course or pathway are auto-calculated: gathers all the skills of their sub-competencies. ELP	Technical, graphical and data migration

Container

Field label	Créa.	Modif.	description	Migration
Apogée export code	x		Apogee export code as [codApogee]-[versionApogee]	None, field created for Apogée export
Cycle	x		Stage cycle	None, field created for Apogée export
Authorized listing plans	x		Authorized listing plans	None, field created for Apogée export
CIP list	x		CIP list	None, field created for Apogée export
Stage duration	x		Stage duration	None, field created for Apogée export
SISE cycle code	x		Cycle SISE code	None, field created for Apogée export
Component	x		Affiliated component (fields provided for stages)	None, field created for Apogée export

List ofELP

Field label	Créa.	Modif.	description	Migration
Apogée export code	x		Apogée export code	None, field created for Apogée export

ELP

Field label	Créa.	Modif.	description	Migration
Apogée export code	x		Apogée export code	None, field created for Apogée export
CIP list	x		CIP list	None, field created for Apogée export
Teaching discipline	x		Drop-down list of teaching disciplines (reference table). Used to calculate teaching potential.	None, field created for piloting
Skills required		x	Becomes a skills drop-down list instead of a skills block drop-down list	Technical, graphical and data migration
Skills acquired		x	Becomes a repeater of skill blocks: Skills block (Ref table - simple) Skills (repeater) : Skill (Ref table - simple) Acquisition level (Table de ref - simple)	Technical, graphical and data migration

Person

Field label	Créa.	Modif.	Description	Migration
Avatar	x		Add an image file (avatar) to contacts	To be added if necessary to the HTML and/or PDF rendering of contacts

Component

Field label	Créa.	Modif.	Description	Migration
SIRET number	x		Organization's SIRET number.	None, field created for LHEO export
Apogée export code	x		Apogée export code	None, field created for Apogée export
CGE code	x		CGE code	None, field created for Apogée export
Teacher potential	x		Repeater of teaching discipline and teaching potential. Used to calculate teaching potential.	None, field created for piloting

Teaching hours

Field label	Créa.	Modif.	Description	Migration
Teaching discipline	x		Drop-down list of teaching disciplines (reference table). Used to calculate teaching potential.	None, field created for piloting

Reference tables

New reference tables

Period type (odf-enumeration.PeriodType)
Acquisition level (for skills) (odf-enumeration.SkillAcquisitionLevel)
Teaching disciplines (odf-enumeration.TeachingDiscipline)

Reference table Nature (Container), Nature (ELP), Nature diploma and Diploma

Field label	Créa.	Modif.	description	Migration
Apogée export code	x		Apogée export code	None, field created for Apogée export