Skip to content

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.

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)

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).

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)
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.

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.

  • 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.

Employee usage · Employee · Skill · Guides › Skill matching