👤
- il numero di persone
employees
organization_compliance
🛡️ RLS Protected
Data di base, contratti di lavoro (NachwG), data di lavoro con indicazioni di lavoro, assenze e eAU/EFZG.
Fachliche Bestimmung: Divisione personale operativa: contratto di lavoro, tempo di ingresso (regole di pausa del lavoro), assenza (recurso per malattia incl. § 9 BUrlG), qualifiche e contatti di emergenza.
⚡ Flussi di lavoro e cicli di vita (2)
🗄️ Modelli di dati (5)
🔌 Punto di partenza (UI & API) (11)
🛡️ Regolamentazione e conformità
⚡ Flussi di lavoro e cicli di vita
Stampolo, vacanza e notifica di malattia
hr_time_and_absence
- il numero di persone che hanno ricevuto un'assistenza autonoma,
1. CLOCK_IN
Semplare
POST /api/v1/h/clock-in è in funzione.
Aktionen: arbzg_warnings
2. CLOCK_OUT
Semplice
Conclusione con indicazioni di pausa secondo l'ArbZG.
Aktionen: time_summary
3. ABSENCE_REQUEST
Proposta di decisione
- vacanza/sopra vacanza, come richiesto.
Aktionen: vacation_balance
4. ABSENCE_APPROVE
Permetto
Il gestore approva/rifie; malato con status di eAU.
Aktionen: eau_status, efzg_exhausted
Ordine d'uso: subagento di materie prime
plan:command_employee_crud_subagent
Controllato piano duraturo (durable_plan), inizio: manual_command.
1. employee_crud_subagent
employee_crud_subagent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: employee_crud_subagent
🗄️ Modelli di dati
HrAbsences
hr_absences
RLS Aktiv
24 Feltri / colonne
Tabelle hr_absences
| Feldname | Tipo di dati | Dati | Schlüssel | Importanza professionale |
|---|---|---|---|---|
employee_id
|
UUID |
Ja * | FK ➔ organization_users.id | Feld employee_id |
absence_type
|
VARCHAR(48) |
Ja * | - | Feld absence_type |
status
|
VARCHAR(48) |
Ja * | - | Feld status |
start_date
|
DATE |
Ja * | - | Feld start_date |
end_date
|
DATE |
Ja * | - | Feld end_date |
days
|
NUMERIC(5, 1) |
Ja * | - | Feld days |
half_day
|
BOOLEAN |
Ja * | - | Feld half_day |
notes
|
TEXT |
Nein | - | Feld notes |
requested_by_id
|
UUID |
Nein | FK ➔ users.id | Feld requested_by_id |
decided_by_id
|
UUID |
Nein | FK ➔ users.id | Feld decided_by_id |
decided_at
|
DATETIME |
Nein | - | Feld decided_at |
decision_note
|
TEXT |
Nein | - | Feld decision_note |
eau_status
|
VARCHAR(48) |
Ja * | - | Feld eau_status |
eau_retrieved_at
|
DATETIME |
Nein | - | Feld eau_retrieved_at |
is_child_sick
|
BOOLEAN |
Ja * | - | Feld is_child_sick |
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 |
HrEmergencyContacts
hr_emergency_contacts
RLS Aktiv
14 Feltri / colonne
Tabelle hr_emergency_contacts
| Feldname | Tipo di dati | Dati | Schlüssel | Importanza professionale |
|---|---|---|---|---|
employee_id
|
UUID |
Ja * | FK ➔ organization_users.id | Feld employee_id |
name
|
VARCHAR(255) |
Ja * | - | Feld name |
relationship
|
VARCHAR(128) |
Nein | - | Feld relationship |
phone
|
VARCHAR(64) |
Ja * | - | Feld phone |
priority
|
INTEGER |
Ja * | - | Feld priority |
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 |
HrEmploymentContracts
hr_employment_contracts
RLS Aktiv
29 Feltri / colonne
Tabelle hr_employment_contracts
| Feldname | Tipo di dati | Dati | Schlüssel | Importanza professionale |
|---|---|---|---|---|
employee_id
|
UUID |
Ja * | FK ➔ organization_users.id | Feld employee_id |
contract_type
|
VARCHAR(48) |
Ja * | - | Feld contract_type |
status
|
VARCHAR(48) |
Ja * | - | Feld status |
position_title
|
VARCHAR(255) |
Ja * | - | Feld position_title |
job_description
|
TEXT |
Nein | - | Feld job_description |
workplace
|
VARCHAR(255) |
Nein | - | Feld workplace |
start_date
|
DATE |
Ja * | - | Feld start_date |
end_date
|
DATE |
Nein | - | Feld end_date |
probation_months
|
INTEGER |
Nein | - | Feld probation_months |
weekly_hours
|
NUMERIC(5, 2) |
Nein | - | Feld weekly_hours |
salary_type
|
VARCHAR(48) |
Ja * | - | Feld salary_type |
salary_amount
|
NUMERIC(10, 2) |
Nein | - | Feld salary_amount |
vacation_days_per_year
|
INTEGER |
Nein | - | Feld vacation_days_per_year |
notice_period_employee
|
VARCHAR(255) |
Nein | - | Feld notice_period_employee |
notice_period_employer
|
VARCHAR(255) |
Nein | - | Feld notice_period_employer |
tariff_agreement
|
VARCHAR(255) |
Nein | - | Feld tariff_agreement |
terminated_at
|
DATE |
Nein | - | Feld terminated_at |
termination_effective_date
|
DATE |
Nein | - | Feld termination_effective_date |
document_id
|
UUID |
Nein | FK ➔ documents.id | Feld document_id |
notes
|
TEXT |
Nein | - | Feld notes |
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 |
HrQualifications
hr_qualifications
RLS Aktiv
17 Feltri / colonne
Tabelle hr_qualifications
| Feldname | Tipo di dati | Dati | Schlüssel | Importanza professionale |
|---|---|---|---|---|
employee_id
|
UUID |
Ja * | FK ➔ organization_users.id | Feld employee_id |
name
|
VARCHAR(255) |
Ja * | - | Feld name |
issuer
|
VARCHAR(255) |
Nein | - | Feld issuer |
acquired_at
|
DATE |
Nein | - | Feld acquired_at |
expires_at
|
DATE |
Nein | - | Feld expires_at |
document_id
|
UUID |
Nein | FK ➔ documents.id | Feld document_id |
is_required
|
BOOLEAN |
Ja * | - | Feld is_required |
notes
|
TEXT |
Nein | - | Feld notes |
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 |
HrTimeEntries
hr_time_entries
RLS Aktiv
23 Feltri / colonne
Tabelle hr_time_entries
| Feldname | Tipo di dati | Dati | Schlüssel | Importanza professionale |
|---|---|---|---|---|
employee_id
|
UUID |
Ja * | FK ➔ organization_users.id | Feld employee_id |
work_date
|
DATE |
Ja * | - | Feld work_date |
started_at
|
DATETIME |
Ja * | - | Feld started_at |
ended_at
|
DATETIME |
Nein | - | Feld ended_at |
break_minutes
|
INTEGER |
Ja * | - | Feld break_minutes |
kind
|
VARCHAR(48) |
Ja * | - | Feld kind |
status
|
VARCHAR(48) |
Ja * | - | Feld status |
work_order_id
|
UUID |
Nein | FK ➔ work_orders.id | Feld work_order_id |
project_id
|
UUID |
Nein | FK ➔ projects.id | Feld project_id |
description
|
TEXT |
Nein | - | Feld description |
warnings
|
JSONB |
Ja * | - | Feld warnings |
approved_by_id
|
UUID |
Nein | FK ➔ users.id | Feld approved_by_id |
approved_at
|
DATETIME |
Nein | - | Feld approved_at |
correction_of_id
|
UUID |
Nein | FK ➔ hr_time_entries.id | Feld correction_of_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 |
🔌 Punto di partenza (UI & API)
| Art | Metodo | Punto finale / percorso | Titel & Zweck | Il diritto |
|---|---|---|---|---|
| ⚡ REST API | GET | /api/v1/directory/colleagues |
list_colleagues
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | GET | /api/v1/employees |
list_employees
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | GET | /api/v1/employees/stats |
employee_stats
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | GET | /api/v1/employees/{employee_id} |
get_employee
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | GET | /api/v1/employees/{employee_id}/permissions |
get_employee_permissions
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | GET | /employees |
employees_page
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | GET | /employees/new |
employee_create_page
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | GET | /employees/{employee_id} |
employee_edit_page
Semantic binding: not_evaluated; mutation=False
|
employees
|
| ⚡ REST API | PATCH | /api/v1/employees/{employee_id} |
update_employee
Semantic binding: not_evaluated; mutation=True
|
employees
|
| ⚡ REST API | POST | /api/v1/employees |
create_employee
Semantic binding: not_evaluated; mutation=True
|
employees
|
| ⚡ REST API | POST | /api/v1/employees/{employee_id}/deactivate |
deactivate_employee
Semantic binding: not_evaluated; mutation=True
|
employees
|
🛡️ Regolamentazione e conformità
Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:
- Articolo 3
- BURlG § 9
- FESG
- Capacità di produzione
- RLS Isolamento dei clienti
Moduli collegati: