Tables for project resources
The file directory (…Rillsoft
Project/Reports/Resource/…lst)
These tables allow you to gain information of the project
regarding to its project resources.
The following reports have been especially designed for project
resources:
- Roles
- Teams
- Employees
- Material
- Machine types
- Machinery
You can view the structure of the report in the menu item
View / Window / Table structure.
Example of the report's structure for the general project
resource - employee report.
The Project resources table is a higher-ranking table and other
tables may be added as lower ranking ones.
Roles
- EmployeeRole shows resource roles
- EmployeeRoleTask shows information on activity for selected
role
EmployeeRole
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Cost |
NUMERIC |
Unit price |
| 4 |
Rank |
TEXT |
Qualification |
| 5 |
Name |
TEXT |
Name |
| 6 |
Notes |
TEXT |
Notes |
| 7 |
TotalCost |
NUMERIC |
Costs within the project |
| 8 |
TotalVolume |
NUMERIC |
Efforts within the project |
| 9 |
Start |
Date |
Start of assigment |
| 10 |
Finish |
Date |
Finish of assignment |
Teams
- Team shows resource team
- TeamTask shows information on activity for selected team
Team
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Cost |
NUMERIC |
Unit price |
| 4 |
Calendar |
TEXT |
Calendar |
| 5 |
Holiday |
TEXT |
Non-working days |
| 6 |
Group |
TEXT |
Name of group |
| 7 |
Name |
TEXT |
Name |
| 8 |
Notes |
TEXT |
Notes |
| 9 |
TotalCost |
NUMERIC |
Costs within the project |
| 10 |
TotalVolume |
NUMERIC |
Efforts within the project |
| 11 |
Start |
Date |
Start of assigment |
| 12 |
Finish |
Date |
Finish of assignment |
Employees
- Employee shows resource employees
- EmployeeTask shows information on activity for selected
employees
Employee
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Cost |
NUMERIC |
Unit price |
| 4 |
Calendar |
TEXT |
Calendar |
| 5 |
Holiday |
TEXT |
Non-working days |
| 6 |
EmployeerRole |
TEXT |
Name of group |
| 7 |
Team |
TEXT |
Name of group |
| 8 |
Name |
TEXT |
Name |
| 9 |
Notes |
TEXT |
Notes |
| 10 |
TotalCost |
NUMERIC |
Costs within the project |
| 11 |
TotalVolume |
NUMERIC |
Efforts within the project |
| 12 |
Start |
Date |
Start of assigment |
| 13 |
Finish |
Date |
Finish of assignment |
Material
- Material shows resource material
- MaterialTask shows information on activity for selected
materials
Material
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Cost |
NUMERIC |
Unit price |
| 4 |
Group |
TEXT |
Name of group |
| 5 |
Name |
TEXT |
Name |
| 6 |
Notes |
TEXT |
Notes |
| 7 |
Metric |
TEXT |
Measurement unit |
| 8 |
TotalCost |
NUMERIC |
Costs within the project |
| 9 |
TotalAmount |
NUMERIC |
Used quantity within the project |
| 10 |
Start |
Date |
Start of assigment |
| 11 |
Finish |
Date |
Finish of assignment |
Machine types
- MachineRole shows resource machine type
- MachineRoleTask shows information on activity for selected
machine types
MachineRole
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Cost |
NUMERIC |
Unit price |
| 4 |
Group |
TEXT |
Name of group |
| 5 |
Name |
TEXT |
Name |
| 6 |
Notes |
TEXT |
Notes |
| 7 |
Metric |
TEXT |
Measurement unit |
| 8 |
TotalCost |
NUMERIC |
Costs within the project |
| 9 |
TotalVolume |
NUMERIC |
Efforts within the project |
| 10 |
ShareId |
NUMERIC |
Shared machine type |
| 11 |
Start |
Date |
Start of assigment |
| 12 |
Finish |
Date |
Finish of assignment |
Machinery
- Machine shows resource machinery
- MachineTask shows information on activity for selected
machine
Machine
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Cost |
NUMERIC |
Unit price |
| 4 |
MachineRole |
TEXT |
Machine type |
| 5 |
Name |
TEXT |
Name |
| 6 |
Notes |
TEXT |
Notes |
| 7 |
TotalCost |
NUMERIC |
Costs within the project |
| 8 |
TotalVolume |
NUMERIC |
Efforts within the project |
| 9 |
ShareId |
NUMERIC |
Shared machine |
| 10 |
Start |
Date |
Start of assigment |
| 11 |
Finish |
Date |
Finish of assignment |
Additional tables
The following tables may be subordinated to every project
resource table.
| 1 |
TaskEmployeeRole |
Resource roles |
| 2 |
TaskTeam |
Resource teams |
| 3 |
TaskEmployee |
Employees |
| 4 |
TaskMaterial |
Materials |
| 5 |
TaskMachineRole |
Machine roles |
| 6 |
TaskMachine |
Machinery |
See also:
Table structure for
project schedule,
Table structure for
project resources,
Table structure for
resource pool,
Variables.
|