| Table Name: | MPPersonenPool |
| View Name: | MARIEmployeesPool |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: Employee Pool link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
Unique Employee ID formatted in the settings of MARI Projekt Example "E200" | MPPersonenstamm.Personalnummer |
| RessourcenNummer | ResourcePoolID NVARCHAR (20) Primary |
Unique Resource Pool ID formatted in the settings of MARI Projekt Example "R200" | MPRessourcenPool.RessourcenNummer |
| GueltigAb | ValidFrom INT Primary |
Period in the time organisation of MARI Projekt 2006012 YYYYMMM | MPPerioden.PeriodeJahr |
| PlanungsTyp | PlanningType SMALLINT |
Type of Planning (0=No Planning, 1=Planning) | clsImportEmployeePoolLink_ePoolLinkPlanningType |
| Prioritaet | Prio SMALLINT |
Priority: 1=higest, 2, 3, 4... | |
| Kenntnisse | Knowledge NVARCHAR (200) |
Special Knowledge for this pool | |
| Kapazitaet | Capacity SMALLINT |
Capacity 100 = 100% | |
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | AdditionalPoolInformaton NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |