Example of the report's structure for the general project
schedule report.
In this, the Subproject table is a higher-ranking table and
other tables may be added as lower ranking ones.
| 1 |
Id |
TEXT |
ID Number |
| 2 |
LevelFact |
NUMERIC |
Structure depth |
| 3 |
LevelPlan |
NUMERIC |
|
| 4 |
Name |
TEXT |
Name |
| 5 |
Code |
TEXT |
Code |
| 6 |
CalendarFact |
TEXT |
Assigned calendars |
| 7 |
CalendarPlan |
TEXT |
|
| 8 |
CategoryFact |
TEXT |
Category |
| 9 |
CategoryPlan |
TEXT |
|
| 10 |
CountEmployeeFact |
NUMERIC |
Number of assigned employees |
| 11 |
CountEmployeePlan |
NUMERIC |
|
| 12 |
CountEmployeeRoleFact |
NUMERIC |
Number of assigned roles |
| 13 |
CountEmployeeRolePlan |
NUMERIC |
|
| 14 |
CountMachineFact |
NUMERIC |
Number of allocated machines |
| 15 |
CountMachinePlan |
NUMERIC |
|
| 16 |
CountMachineRoleFact |
NUMERIC |
Number of allocated machine types |
| 17 |
CountMachineRolePlan |
NUMERIC |
|
| 18 |
CountMaterialFact |
NUMERIC |
Number of allocated materials |
| 19 |
CountMaterialPlan |
NUMERIC |
|
| 20 |
CountTeamFact |
NUMERIC |
Number of assigned teams |
| 21 |
CountTeamPlan |
NUMERIC |
|
| 22 |
StatusFact |
TEXT |
Status |
| 23 |
StatusPlan |
TEXT |
|
| 24 |
LabourIntensityFact |
NUMERIC |
Effort |
| 25 |
LabourIntensityPlan |
NUMERIC |
|
| 26 |
LabourIntensityDoneFact |
NUMERIC |
Completed effort |
| 27 |
LabourIntensityDonePlan |
NUMERIC |
|
| 28 |
LabourIntensityUnDoneFact |
NUMERIC |
Open effort |
| 29 |
LabourIntensityUnDonePlan |
NUMERIC |
|
| 30 |
DurationFact |
NUMERIC |
Duration |
| 31 |
DurationPlan |
NUMERIC |
|
| 32 |
DurationDoneFact |
NUMERIC |
Completed duration |
| 33 |
DurationDonePlan |
NUMERIC |
|
| 34 |
DurationUnDoneFact |
NUMERIC |
Open duration |
| 35 |
DurationUnDonePlan |
NUMERIC |
|
| 36 |
StartFact |
Date |
Start |
| 37 |
StartPlan |
Date |
|
| 38 |
FinishFact |
Date |
Finish |
| 39 |
FinishPlan |
Date |
|
| 40 |
ReserveStartFact |
Date |
Latest possible start |
| 41 |
ReserveStartPlan |
Date |
|
| 42 |
ReserveFinishFact |
Date |
Latest possible finish |
| 43 |
ReserveFinishPlan |
Date |
|
| 44 |
DiffReserveStartFact |
NUMERIC |
Possible time buffer before start |
| 45 |
DiffReserveStartPlan |
NUMERIC |
|
| 46 |
DiffReserveFinishFact |
NUMERIC |
Possible time buffer before finish |
| 47 |
DiffReserveFinishPlan |
NUMERIC |
|
| 48 |
ExtraCostFact |
NUMERIC |
Fixed costs |
| 49 |
ExtraCostPlan |
NUMERIC |
|
| 50 |
PersonCostFact |
NUMERIC |
Personnel costs |
| 51 |
PersonCostPlan |
NUMERIC |
|
| 52 |
PersonalTypFact |
NUMERIC |
Which personnel resource is assigned |
| 53 |
PersonalTypPlan |
NUMERIC |
|
| 54 |
PhysicalVolumenMetricFact |
TEXT |
Measurement unit of the labour output |
| 55 |
PhysicalVolumenMetricPlan |
TEXT |
|
| 56 |
PhysicalVolumenNormaFact |
NUMERIC |
Norm of labour output |
| 57 |
PhysicalVolumenNormaPlan |
NUMERIC |
|
| 58 |
PhysicalVolumeDoneFact |
NUMERIC |
Completed quantity |
| 59 |
PhysicalVolumeDonePlan |
NUMERIC |
|
| 60 |
PhysicalVolumeFact |
NUMERIC |
Quantity of labour output |
| 61 |
PhysicalVolumePlan |
NUMERIC |
|
| 62 |
PhysicalVolumeUnDoneFact |
NUMERIC |
Open quantity of labour output |
| 63 |
PhysicalVolumeUnDonePlan |
NUMERIC |
|
| 64 |
PrimaryCalendarFact |
BOOLEAN |
Whether an own calendar defines the activity |
| 65 |
PrimaryCalendarPlan |
BOOLEAN |
|
| 66 |
PrimaryStartFact |
BOOLEAN |
Start of activity with start of shift |
| 67 |
PrimaryStartPlan |
BOOLEAN |
|
| 68 |
PercentFact |
NUMERIC |
Percentage of completion |
| 69 |
PercentPlan |
NUMERIC |
|
| 70 |
Pos |
NUMERIC |
Position of the allocated resource |
| 71 |
PriorityFact |
NUMERIC |
Priority |
| 72 |
PriorityPlan |
NUMERIC |
|
| 73 |
MaterialCostFact |
NUMERIC |
Material costs |
| 74 |
MaterialCostPlan |
NUMERIC |
|
| 75 |
MachineCostFact |
NUMERIC |
Machine type costs |
| 76 |
MachineCostPlan |
NUMERIC |
|
| 77 |
TotalCostFact |
NUMERIC |
Shared costs |
| 78 |
TotalCostPlan |
NUMERIC |
|
| 79 |
NotesFact |
TEXT |
Notes |
| 80 |
TotalCostPlan |
NUMERIC |
|
| 81 |
CriticalFact |
BOOLEAN |
Whether activity is critical |
| 82 |
CriticalPlan |
BOOLEAN |
|
| 83 |
UserField1Fact |
TEXT |
User-defined fields |
| 84 |
UserField1Plan |
TEXT |
|