📘

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

recruiting organization_compliance 🛡️ RLS Protected

Applicant management <unk> Process and API documentation derived from code.

Fachliche Bestimmung: Applicant management <unk> process and API documentation derived from code. It includes all registered processes, capabilities, state machines, APIs and tables for simulations and reviews.

⚡ Workflows and life cycles (1) 🗄️ Data models and fields (6) 🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. (35) 🛡️ Regulatory and compliance

⚡ Workflows and life cycles

Applications `status:recruiting_application`

The following information is provided by the Commission on the basis of the information provided by the Member States:

1. new

new

Status of the state machine

2. screening

Screening

Status of the application for the condition machine.

3. interview

Interview

The status of the application for the status machine.

4. offer

- the

Status of the tendering machine

5. hired

- employed

Status of the applicant

6. rejected

Rejected

Status of the application for the condition machine

7. withdrawn

withdrawn

Status of the application for the status machine

🗄️ Data models and fields

RecruitingApplicationInterviews recruiting_application_interviews RLS Aktiv

13 Fields and columns

Tabelle recruiting_application_interviews

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`application_id`	`UUID`	Ja *	FK ➔ recruiting_applications.id	Feld application_id
`scheduled_at`	`DATETIME`	Ja *	-	Feld scheduled_at
`interviewer_id`	`UUID`	Nein	-	Feld interviewer_id
`mode`	`VARCHAR(32)`	Ja *	-	Feld mode
`location`	`VARCHAR(255)`	Nein	-	Feld location
`feedback`	`TEXT`	Nein	-	Feld feedback
`rating`	`INTEGER`	Nein	-	Feld rating
`completed`	`BOOLEAN`	Ja *	-	Feld completed
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

RecruitingApplicationNotes recruiting_application_notes RLS Aktiv

8 Fields and columns

Tabelle recruiting_application_notes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`application_id`	`UUID`	Ja *	FK ➔ recruiting_applications.id	Feld application_id
`author_id`	`UUID`	Nein	-	Feld author_id
`body`	`TEXT`	Ja *	-	Feld body
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

RecruitingApplications recruiting_applications RLS Aktiv

23 Fields and columns

Tabelle recruiting_applications

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`candidate_id`	`UUID`	Ja *	FK ➔ recruiting_candidates.id	Feld candidate_id
`vacancy_id`	`UUID`	Ja *	FK ➔ recruiting_job_vacancies.id	Feld vacancy_id
`applied_at`	`DATETIME`	Ja *	-	Feld applied_at
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`stage`	`VARCHAR(64)`	Nein	-	Feld stage
`source`	`VARCHAR(48)`	Ja *	-	Feld source
`cover_letter`	`TEXT`	Nein	-	Feld cover_letter
`resume_document_id`	`UUID`	Nein	-	Feld resume_document_id
`notes`	`TEXT`	Nein	-	Feld notes
`consent_given`	`BOOLEAN`	Ja *	-	Feld consent_given
`consent_at`	`DATETIME`	Nein	-	Feld consent_at
`decided_at`	`DATETIME`	Nein	-	Feld decided_at
`rejection_reason`	`TEXT`	Nein	-	Feld rejection_reason
`hired_user_id`	`UUID`	Nein	-	Feld hired_user_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

RecruitingCandidateSkills recruiting_candidate_skills RLS Aktiv

9 Fields and columns

Tabelle recruiting_candidate_skills

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`candidate_id`	`UUID`	Ja *	FK ➔ recruiting_candidates.id	Feld candidate_id
`skill_name`	`VARCHAR(128)`	Ja *	-	Feld skill_name
`proficiency`	`INTEGER`	Ja *	-	Feld proficiency
`certified`	`BOOLEAN`	Ja *	-	Feld certified
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

RecruitingCandidates recruiting_candidates RLS Aktiv

20 Fields and columns

Tabelle recruiting_candidates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`first_name`	`VARCHAR(128)`	Ja *	-	Feld first_name
`last_name`	`VARCHAR(128)`	Ja *	-	Feld last_name
`email`	`VARCHAR(320)`	Ja *	-	Feld email
`phone`	`VARCHAR(64)`	Nein	-	Feld phone
`address_text`	`TEXT`	Nein	-	Feld address_text
`summary`	`TEXT`	Nein	-	Feld summary
`linkedin_url`	`VARCHAR(255)`	Nein	-	Feld linkedin_url
`source`	`VARCHAR(48)`	Ja *	-	Feld source
`resume_document_id`	`UUID`	Nein	-	Feld resume_document_id
`confidence`	`NUMERIC(4, 3)`	Nein	-	Feld confidence
`anonymized_at`	`DATETIME`	Nein	-	Feld anonymized_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

RecruitingJobVacancies recruiting_job_vacancies RLS Aktiv

24 Fields and columns

Tabelle recruiting_job_vacancies

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`description`	`TEXT`	Nein	-	Feld description
`department`	`VARCHAR(128)`	Nein	-	Feld department
`location`	`VARCHAR(255)`	Nein	-	Feld location
`employment_type`	`VARCHAR(48)`	Ja *	-	Feld employment_type
`salary_min`	`NUMERIC(14, 2)`	Nein	-	Feld salary_min
`salary_max`	`NUMERIC(14, 2)`	Nein	-	Feld salary_max
`salary_period`	`VARCHAR(16)`	Ja *	-	Feld salary_period
`status`	`VARCHAR(32)`	Ja *	-	Feld status
`publication_id`	`UUID`	Nein	-	Feld publication_id
`required_skills`	`JSONB`	Ja *	-	Feld required_skills
`pipeline_stages`	`JSONB`	Ja *	-	Feld pipeline_stages
`opened_at`	`DATETIME`	Ja *	-	Feld opened_at
`closed_at`	`DATETIME`	Nein	-	Feld closed_at
`owner_id`	`UUID`	Nein	-	Feld owner_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata