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