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