Reference & Data Model
Project member (project_member)
A project member is a role in the project team. With an assigned employee the role is filled; without an employee it is a resource demand with skill requirements.
Purpose
Section titled “Purpose”The project member connects an employee with exactly one project and describes their function there: role, lead flag, hourly rate and place in the team hierarchy. The same row can initially be unfilled („Ressourcenbedarf“, resource demand) and later be filled by assigning an employee. (Transactional data)
Where in the app
Section titled “Where in the app”Project › tab „Ressourcen“ (Resources) › switch „Team“ (org chart, Guides › OrgaFlow). Create via „Projektmitglied oder Ressourcenbedarf hinzufügen“ (Add project member or resource demand) → „Neues Projektmitglied“ (New project member) or „Neuer Ressourcenbedarf“ (New resource demand). Double-clicking a node opens the side panel with „Updaten“ (Update), „Zuweisungen“ (Assignments) and „Skills“ or „Erforderliche Skills“ (Required skills). Also Projekt & Portfolio › Ressourcenplanung (Resource planning) › „Organigram“ (Guides › Resource planning). The project manager is automatically created as a project member with the role „Projektleiter“ when the project is created (Guides › Assemble the team).
Fields
Section titled “Fields”| Field | Technical | Type | Required | Meaning | Notes |
|---|---|---|---|---|---|
| Employee | employee_id |
Reference | no | Person filling the role. Empty = resource demand | An employee can be chosen only once per project (already chosen ones are greyed out) |
| Project role | role |
Text | no | Free text, e.g. „Bauleitung“. Empty on create → position of the employee | |
| Role description | role_description |
Text | no | Free text | |
| Leadership position | leader |
Yes/No | yes | Flag „Leiter“ (lead) | Project manager: always Yes |
| has a supervisor | has_parent |
Yes/No | yes | Flag whether the role reports to someone | Display/checkbox only; the actual hierarchy comes from the connecting line (parent) |
| Project hourly rate | hourly_rate |
Amount | no | Hourly rate of this person in this project | Takes precedence over the employee’s „Stundenkosten“ (hourly costs) for personnel costs |
| Currency | currency |
Text | no | Currency of the hourly rate, default „EUR“ | |
| Parent member | parent_id |
Reference | no | Project member this role reports to | Set by drawing a line in the org chart, cleared by removing the line |
| Skills | via project_member_skill_map |
Reference (n:m) | no | For an unfilled role: required skills | Tab „Erforderliche Skills“ / dialog „Skills ändern“ (Change skills) |
Relations
Section titled “Relations”| Related to | Kind | Required | On archive | On delete |
|---|---|---|---|---|
| Project | belongs to | no (always set) | archived along | deleted along |
| Employee | belongs to | no | — | deleted along (employee deleted → membership gone) |
| Project member (parent) | belongs to (parent) / has many (children) |
no | kept | reference cleared |
| Skill | n:m via project_member_skill_map |
no | kept | deleted along |
| Employee usage | has many | — | archived along | deleted along |
Mapping table skill requirement (project_member_skill_map)
Section titled “Mapping table skill requirement (project_member_skill_map)”Connects a project member with a skill. For an unfilled role the entry means „this role needs this skill“. Resource matching compares these skills with the skills of the employees (employee_skill_map, see Skill) and shows the share of fulfilled requirements. The counter „mal vorhanden“ (times present) shows how many filled project members have the skill.
States
Section titled “States”No status field. The business state follows from employee_id:
Resource demand (employee_id empty) ──„Ressourcen-Matching“ / „Projektmitglied wechseln“──► Project member (employee_id set)Filling via matching cannot be reversed in the user interface; the role’s usages are kept.
Rules & automation
Section titled “Rules & automation”- An unfilled member can be assigned to usages but cannot receive a booking („Buchung hinzufügen“ shows a warning).
- The Optimizer plans unfilled roles with full capacity and warns „Unbesetzt“ (unfilled); it does not match skills.
- The project hourly rate values planned personnel costs and actual personnel costs. If it is missing, the employee’s „Stundenkosten“ apply.
„Aktuelle Auslastung“ (current utilization) on the node (confirmed bookings of the next 30 days ÷ available hours), utilization curve per member – see Resources & workload.