Tables for resource pool
The file directory (…Rillsoft
Project/Reports/Reference/…lst)
Rillsoft Project allows you to generate resource reports from
the resource pool.
| 1 |
ReferenceCalendar
|
Calendar |
| 2 |
ReferenceCalendarExeption
|
Non-working days in the calendar |
| 3 |
ReferenceCostExeption
|
Changes to costs |
| 4 |
ReferenceEmployeeRole
|
Roles |
| 5 |
ReferenceTeam
|
Teams |
| 6 |
ReferenceEmployee
|
Employees |
| 7 |
ReferenceMaterial
|
Materials |
| 8 |
ReferenceMachineRole
|
Machine types |
| 9 |
ReferenceMachine
|
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 monthly employee -
holiday report.
This table is a higher-ranking table and other tables may be
added to the Resource table as lower ranking ones.
ReferenceCalendar
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Name |
TEXT |
Name |
| 4 |
Notes |
TEXT |
Notes |
ReferenceCalendarExeption
You can use this information to print out the holidays of
employees.
| 1 |
Day1…365 |
NUMERIC |
All days of the year |
| 2 |
Month01…12 |
NUMERIC |
All months of the year |
| 3 |
MonthDay01_01…01_31 |
NUMERIC |
All days of the 1st month |
| 4 |
MonthDay02_01…02_31 |
NUMERIC |
All days of the 2nd month |
| 5 |
MonthDay03_01…03_31 |
NUMERIC |
All days of the 3rd month |
| 6 |
MonthDay04_01…04_31 |
NUMERIC |
All days of the 4th month |
| 7 |
MonthDay05_01…05_31 |
NUMERIC |
All days of the 5th month |
| 8 |
MonthDay06_01…06_31 |
NUMERIC |
All days of the 6th month |
| 9 |
MonthDay07_01…07_31 |
NUMERIC |
All days of the 7th month |
| 10 |
MonthDay08_01…08_31 |
NUMERIC |
All days of the 8th month |
| 11 |
MonthDay09_01…09_31 |
NUMERIC |
All days of the 9th month |
| 12 |
MonthDay10_01…10_31 |
NUMERIC |
All days of the 10th month |
| 13 |
MonthDay11_01…11_31 |
NUMERIC |
All days of the 11th month |
| 14 |
MonthDay12_01…12_31 |
NUMERIC |
All days of the 12th month |
| 15 |
Quarter1…4 |
NUMERIC |
All quarter of the year |
| 16 |
Week1…53 |
NUMERIC |
All weeks of the year |
ReferenceCostExeption
| 1 |
Coefficient |
NUMERIC |
Proportional coefficient |
| 2 |
Cost |
NUMERIC |
Changed costs |
| 3 |
Time |
Date |
Date of change |
ReferenceEmployeeRole
| 1 |
Id |
TEXT |
ID Number |
| 2 |
Code |
TEXT |
Code |
| 3 |
Cost |
NUMERIC |
Costs |
| 4 |
Rank |
TEXT |
Qualification |
| 5 |
Name |
TEXT |
Name |
| 6 |
Notes |
TEXT |
Notes |
ReferenceTeam
| 1 |
Calendar |
TEXT |
Calendar |
| 2 |
Id |
TEXT |
ID Number |
| 3 |
Code |
TEXT |
Code |
| 4 |
Cost |
NUMERIC |
Costs |
| 5 |
Group |
TEXT |
Name of group |
| 6 |
Name |
TEXT |
Name of team |
| 7 |
Notes |
TEXT |
Notes |
| 8 |
Productivity |
TEXT |
ID Number |
ReferenceEmployee
| 1 |
Calendar |
TEXT |
Calendar |
| 2 |
Id |
TEXT |
ID Number |
| 3 |
Code |
TEXT |
Code |
| 4 |
Cost |
NUMERIC |
Costs |
| 5 |
Efficiency |
NUMERIC |
Productivity |
| 6 |
Name |
TEXT |
Name |
| 7 |
Notes |
TEXT |
Notes |
| 8 |
EmployeeRole |
TEXT |
Role |
| 9 |
Team |
TEXT |
Team |
| 12 |
WorkStartDate |
Date |
Entry date to the company |
| 13 |
WorkFinishDate |
Date |
Leaving date |
ReferenceMaterial
| 1 |
Code |
TEXT |
Code |
| 2 |
Cost |
NUMERIC |
Costs |
| 3 |
Group |
TEXT |
Group |
| 4 |
Id |
TEXT |
ID Number |
| 5 |
Metric |
TEXT |
Measurement unit for materials |
| 6 |
Name |
TEXT |
Name |
| 7 |
Notes |
TEXT |
Notes |
ReferenceMachineRole
| 1 |
Code |
TEXT |
Code |
| 2 |
Cost |
NUMERIC |
Costs |
| 3 |
Group |
TEXT |
Group |
| 4 |
Id |
TEXT |
ID Number |
| 5 |
Metric |
TEXT |
Measurement unit for machine types |
| 6 |
Name |
TEXT |
Name |
| 7 |
Notes |
TEXT |
Notes |
ReferenceMachine
| 1 |
Code |
TEXT |
Code |
| 2 |
Cost |
NUMERIC |
Costs |
| 3 |
Id |
TEXT |
ID Number |
| 4 |
MachineRole |
TEXT |
Machine type |
| 5 |
Name |
TEXT |
Name |
| 6 |
Notes |
TEXT |
Notes |
| 7 |
Team |
TEXT |
Team |
See also:
Table structure for
project schedule,
Table structure for
project resources,
Table structure for
resource pool,
Variables.
|