| Table Name: | MPRessourcenPool |
| View Name: | MARIResourcePool |
| Group: | Group: ResourcePool |
| Description: | Resource Pool: Master Data |
| ClassID: | 48. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| RessourcenNummer | ResourcePoolID NVARCHAR (20) Primary |
||
| PoolType | PoolType INT Index |
0=Standard; 1=Pseudo Pool | clsImportResourcePool_ePoolType |
| Bezeichnung | Description NVARCHAR (50) |
Name of the pool | |
| Geschaeftsbereich | BusinessUnitID INT |
Standard business unit for the pool: Used for authorization | MPSetupGeschaeftsbereich.GeschaeftsbereichID |
| StandardMitarbeiter | StandardEmployee NVARCHAR (20) |
Standard employee. Used for the cost rate in the planning process. (Mandnatory for CostTyp=0) | MPPersonenstamm.Personalnummer |
| Verantwortlicher | PoolManager1 NVARCHAR (20) |
First responsible empoyee | MPPersonenstamm.Personalnummer |
| Vertreter | PoolManager2 NVARCHAR (20) |
Second responsible employee | MPPersonenstamm.Personalnummer |
| Plankapazitaet | PlanCapacity NUMERIC(19,6) |
100%=100 | |
| GruppenID | PoolGroup1 INT Index |
Group 1 | MPGruppen.GruppenID (WHERE GruppenArt=10005) clsImportGroups_eGroupType |
| GruppenID2 | PoolGroup2 INT |
Group 2 | MPGruppen.GruppenID (WHERE GruppenArt=10030) clsImportGroups_eGroupType |
| GruppenID3 | PoolGroup3 INT |
Group 3 | MPGruppen.GruppenID (WHERE GruppenArt=10031) clsImportGroups_eGroupType |
| KostenTyp | CostType INT |
By standard employee (=0) or by pool (=1) | clsImportResourcePool_ePoolCostRateType |
| KalenderID | CalendarID INT Index |
MPKalender.KalenderID | |
| eMail NVARCHAR (200) |
Workflow email | ||
| Ikone | Icon INT |
||
| Farbe | Color INT |
||
| Erstanlage | CreateDate Datetime |
Creation date | |
| ErstanlageID | CreateUser NVARCHAR (4) |
Creation user id | MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |
| Aenderung | ChangeDate Datetime |
change date | |
| AenderungID | ChangeUser NVARCHAR (4) |
change user id | MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| RessourcenMemo | ResourceMemo NTEXT |
Fre Memo for the pool | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPLeistungPool | Service Master: Master Data Pool link |
| MPPersonenPool | Employee Master: Employee Pool link |
| MPRessourcenPoolKostensaetze | Resource Pool: Cost Rates |