Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Sv translation
languageen

Table of Contents

Tables

allocation_slices_monthly

This table contains information about how many hours a resource is allocated on a project per month.

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id).
project_codecharacter varying(2048)Link to Project (table generalproject.id / scenarioproject.projectid)
slice_datedateFirst day of a month the allocation occurs
resource_codecharacter varying(2048)Link to the resource (table resource.id)
project_rolecharacter varying(2048)Link to the role (table resource.id)
allocationdoubleAllocation in hours

allocation_slices_weekly

This table contains information about how many hours a resource is allocated on a project per week.

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id).
project_codecharacter varying(2048)Link to Project (table generalproject.id / scenarioproject.projectid)
slice_datedateFirst day of a week (Monday) the allocation occurs
resource_codecharacter varying(2048)Link to the resource (table resource.id)
project_rolecharacter varying(2048)Link to the role (table resource.id)
allocationdoubleAllocation in hours

capacity_slices_monthly

This table contains information about how many hours a resource is available per month.

Column
Type
Description
scenario_idintegerLink to the scenario (Table scenario.id).
slice_datedateFirst day of a month the capacity occurs
resource_codecharacter varying(2048)Link to the resource (Table resource.id)
capacitydoubleCapacity in hours

capacity_slices_weekly

This table contains information about how many hours a resource is available per week.

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id).
slice_datedateFirst day of a week the capacity occurs
resource_codecharacter varying(2048)Link to the resource (table resource.id)
capacitydoubleCapacity in hours

base_calendar_capacity_slices_monthly

This table gives information about work time of a full time resource in a specific month. It can be used to calculate the FTE.

Column
Type
Description
slice_datedateFirst day of a month the capacity occurs
capacitydoubleCapacity in hours

base_calendar_capacity_slices_weekly

This table gives information about the work time of a full time resource in a specific week. It can be used to calculate the FTE.

Column
Type
Description
slice_datedateFirst day of a month the capacity occurs
capacitydoubleCapacity in hours

obs

This table contains data of the flat representation of each organizational unit (level 1 to level10)

Column
Type
Description
fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
Level1character varying(2048)The name of the unit on level 1
Level2character varying(2048)The name of the unit on level 2
...  
Level10character varying(2048)The name of the unit on level 10
obsidintegerLink to the obs unit (table obsunit.internalid)

portfolio_project

This table contains the link between projects and portoflios to determine which portfolio contains which projects

Column
Type
Description
portfolio_idintegerLink to the portoflio (table portfolio.internalid)
project_idcharacter varying(4096)Link to the project (table generalproject.id)

portfolio_resource

This table contains the link between resources and portoflios to determine which portfolio contains which resources

Column
Type
Description
portfolio_idintegerLink to the portoflio (table portfolio.internalid)
resource_idcharacter varying(4096)Link to the resource (table resource.id)

Views

businessgoal_overview

The view contains data about project, allocation, cost, benefit, etc. related to busioness goals per month.

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
businessgoalcharacter varying(2048)Name of the business goal
businessgoal_colorcharacter varying(2048)Color of the business goal
project_codecharacter varying(2048)Link to the project (table generalproject.id)
startdatedateProject start date
finishdatedateProject finish date
slice_datedateFirst day of a month
alllocationdoubleAllocation in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours
benefitdoubleExpected benefit in this month for this project
capexdoubleCAPEX in this month for this project
opexdoubleOPEX in this month for this project
prj_countintegerNumber of project for this business goals in this month
scenario_nametextName of the scenario

businessgoal_project

This view contains the link between projects and business goals. One project can only be linked to one business goal.

Column
Type
Description
businessgoal_codecharacter varying(2048)Link to the portoflio (table portfolio.internalid)
project_codecharacter varying(2048)Link to the project (table generalproject.id)
businessgaol_titlecharacter varying(2048)Name of the business goal
businessgoal_colorcharacter varying(2048)Color of the business goal

generalprojectcustomfields

This view contains the values of the custom fields of the projects. The view gets automatically extended with new custom fields as soon as they are created.

Column
Type
Description
projectidcharacter varying(2048)Link to the project (table generalproject.id)
cust_customfieldnamedata type of custom fieldValue of a custom field

lookup

This view contains the values of the custom fields of the projects. The view gets automatically extended with new custom fields as soon as they are created. The new columns will always be appended to the view.

Column
Type
Description
repository_idintegerLink to the repository (table repository.id)
cust_customfieldnamedata type of custom fieldValue of a custom field

milestones

This view contains the values of the custom fields of the projects. The view gets automatically extended with new custom fields as soon as they are created. The new columns will always be appended to the view.

Column
Type
Description
milestoneidcharacter varying(2048)Link to the task (table generaltask.id)
titlecharacter varying(2048)Title of the milestone
scenario_idintegerLink to the scenario (table scenario.id)
milestonetypecharacter varying(2048)Milestone type

obs_project

This view contains the link between obs unit and project.

Column
Type
Description
obs_fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
project_codecharacter varying(2048)Link to the project (table generalproject.id)

obs_resource

This view contains the link between obs unit and resource.

Column
Type
Description
obs_fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
resource_codecharacter varying(2048)Link to the resource (table resource.id)

portfolio_budget

Column
Type
Description
portfolio_idintegerLink to the portfolio (table portfolio.internalid)
slice_datedate

First day of a month

amount_keycharacter varying(255)Finance type (CAPEX, OPEX or BENEFIT)
amountdoubleThe respective amount regarding the finance type

project_obs_levels

Column
Type
Description
typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
fqncharacter varying(4096)

Unique code of the obsunit (full path of the codes concatinated by "/")

unit_idintegerLink to the obs unit (table obs.obsid)
project_codecharacter varying(2048)Link to the project (table generalproject.id)
level_1character varying(2048)The name of the unit on level 1
level_2character varying(2048)The name of the unit on level 2
...  
level_10character varying(2048)The name of the unit on level 10

project_resource_alloc_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of a month
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
project_namecharacter varying(2048)Name of the project

project_resource_alloc_obs_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
project_namecharacter varying(2048)Name of the project
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of a month
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

project_resource_alloc_obs_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
project_namecharacter varying(2048)Name of the project
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of the week (Monday)
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

project_resource_alloc_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of the week (Monday)
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
project_namecharacter varying(2048)Name of the project

project_resource_slicedata_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
resource_codecharacter varyingLink to the resource (table resource.id)
project_codecharacter varyingLink to the project (table generalproject.id)
project_rolecharacter varyingLink to the role (table resource.id)
slice_datetimestamp without time zoneFirst day of a month
allocationhoursdoubleAllocation in hours
capacityhoursdoubleCapacity in hours
financetypecharacter varyingCAPEX, OPEX or BENEFIT
costdoubleThe respective amount regarding the finance type

project_resource_slicedata_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
resource_codecharacter varyingLink to the resource (table resource.id)
project_codecharacter varyingLink to the project (table generalproject.id)
project_rolecharacter varyingLink to the role (table resource.id)
slice_datetimestamp without time zoneFirst day of the week (Monday)
allocationhoursdoubleAllocation in hours
capacityhoursdoubleCapacity in hours
financetypecharacter varyingCAPEX, OPEX or BENEFIT
costdoubleThe respective amount regarding the finance type

projectfinance_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
finance_datetimestamp without time zoneThe point in time of the financial event
amountdoubleThe respective amount regarding the finance type
financetypecharacter varying(255)CAPEX, OPEX or BENEFIT

projectfinance_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
finance_datetimestamp without time zoneThe point in time of the financial event
amountdoubleThe respective amount regarding the finance type
financetypecharacter varying(255)CAPEX, OPEX or BENEFIT

projects

Column
Type
Description
codecharacter varying(2048)Link to the project (table generalproject.id)
namecharacter varying(2048)The name of the project
manager_codecharacter varying(2048)Link to the project manager (table resource.id)
manager_namecharacter varying(2048)Name of the project manager
statuscharacter varying(2048)Status of the project

resource_alloc_capa_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of a month
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours

resource_alloc_capa_obs_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of a month
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

resource_alloc_capa_obs_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of the week (Monday)
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

resource_alloc_capa_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of the week (Monday)
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours

resource_obs_levels

Column
Type
Description
typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
unit_idintegerLink to the obs unit (table obs.obsid)
resource_codecharacter varying(2048)Link to the resource (table resource.id)
level_1character varying(2048)The name of the unit on level 1
level_2character varying(2048)The name of the unit on level 2
...  
level_10character varying(2048)The name of the unit on level 10

resources

Column
Type
Description
codecharacter varying(2048)Link to the resource (table resource.id)
namecharacter varying(2048)The name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
costperhourdoubleThe cost per hour of the resource
costtypecharacter varyingCAPEX / OPEX
countrycharacter varying(255)The country assigned to the resource
citycharacter varying(255)The city assigned to the resource
postalcodecharacter varying(255)The postal code assigned to the resource

scenarioproject_totals

Column
Type
Description
idintegerLink to the scenarioproject (table scenarioproject.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
scenario_idintegerLink to the scenario (table scenario.id)
allocation_costdoubleCost per hour multiplied by the allocation in hours
allocation_hoursdoubleAllocation in hours
finance_costdoubleAllocation independent costs

scenarioprojects

Column
Type
Description
idintegerLink to the scenarioproject (table scenarioproject.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
scenario_idintegerLink to the scenario (table scenario.id)
startdatetimestamp without time zoneThe start date of the project
finishdatetimestamp without time zoneThe finish date of the project
abovemusthavebooleanTrue if project is above the must have line
belowcutoffbooleanTrue if project is below the cutoff line
prioritybigintThe priority of the project
programtitlecharacter varying(2048)The title of the program containing this project
programidintegerThe id of the program containing this project

scenarioprojects_noncutoff

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
idintegerLink to the scenarioproject (table scenarioproject.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)

scenarios

Column
Type
Description
idintegerLink to the scenario (table scenario.id)
nametextThe name of the scenario
Sv translation
languagede

Table of Contents

Tabellen

allocation_slices_monthly

Diese Tabelle enthält Informationen darüber, wie viele Stunden eine Ressource pro Monat auf ein Projekt allokiert ist.

Column
Type
Description
scenario_idintegerVerknüpfung zum Szenario (scenario.id).
project_codecharacter varying(2048)Link to Project (table generalproject.id / scenarioproject.projectid)
slice_datedateFirst day of a month the allocation occurs
resource_codecharacter varying(2048)Link to the resource (table resource.id)
project_rolecharacter varying(2048)Link to the role (table resource.id)
allocationdoubleAllocation in hours

allocation_slices_weekly

This table contains information about how many hours a resource is allocated on a project per week.

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id).
project_codecharacter varying(2048)Link to Project (table generalproject.id / scenarioproject.projectid)
slice_datedateFirst day of a week (Monday) the allocation occurs
resource_codecharacter varying(2048)Link to the resource (table resource.id)
project_rolecharacter varying(2048)Link to the role (table resource.id)
allocationdoubleAllocation in hours

capacity_slices_monthly

This table contains information about how many hours a resource is available per month.

Column
Type
Description
scenario_idintegerLink to the scenario (Table scenario.id).
slice_datedateFirst day of a month the capacity occurs
resource_codecharacter varying(2048)Link to the resource (Table resource.id)
capacitydoubleCapacity in hours

capacity_slices_weekly

This table contains information about how many hours a resource is available per week.

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id).
slice_datedateFirst day of a week the capacity occurs
resource_codecharacter varying(2048)Link to the resource (table resource.id)
capacitydoubleCapacity in hours

base_calendar_capacity_slices_monthly

This table gives information about work time of a full time resource in a specific month. It can be used to calculate the FTE.

Column
Type
Description
slice_datedateFirst day of a month the capacity occurs
capacitydoubleCapacity in hours

base_calendar_capacity_slices_weekly

This table gives information about the work time of a full time resource in a specific week. It can be used to calculate the FTE.

Column
Type
Description
slice_datedateFirst day of a month the capacity occurs
capacitydoubleCapacity in hours

obs

This table contains data of the flat representation of each organizational unit (level 1 to level10)

Column
Type
Description
fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
Level1character varying(2048)The name of the unit on level 1
Level2character varying(2048)The name of the unit on level 2
...  
Level10character varying(2048)The name of the unit on level 10
obsidintegerLink to the obs unit (table obsunit.internalid)

portfolio_project

This table contains the link between projects and portoflios to determine which portfolio contains which projects

Column
Type
Description
portfolio_idintegerLink to the portoflio (table portfolio.internalid)
project_idcharacter varying(4096)Link to the project (table generalproject.id)

portfolio_resource

This table contains the link between resources and portoflios to determine which portfolio contains which resources

Column
Type
Description
portfolio_idintegerLink to the portoflio (table portfolio.internalid)
resource_idcharacter varying(4096)Link to the resource (table resource.id)

Ansichten

businessgoal_overview

The view contains data about project, allocation, cost, benefit, etc. related to busioness goals per month.

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
businessgoalcharacter varying(2048)Name of the business goal
businessgoal_colorcharacter varying(2048)Color of the business goal
project_codecharacter varying(2048)Link to the project (table generalproject.id)
startdatedateProject start date
finishdatedateProject finish date
slice_datedateFirst day of a month
alllocationdoubleAllocation in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours
benefitdoubleExpected benefit in this month for this project
capexdoubleCAPEX in this month for this project
opexdoubleOPEX in this month for this project
prj_countintegerNumber of project for this business goals in this month
scenario_nametextName of the scenario

businessgoal_project

This view contains the link between projects and business goals. One project can only be linked to one business goal.

Column
Type
Description
businessgoal_codecharacter varying(2048)Link to the portoflio (table portfolio.internalid)
project_codecharacter varying(2048)Link to the project (table generalproject.id)
businessgaol_titlecharacter varying(2048)Name of the business goal
businessgoal_colorcharacter varying(2048)Color of the business goal

generalprojectcustomfields

This view contains the values of the custom fields of the projects. The view gets automatically extended with new custom fields as soon as they are created.

Column
Type
Description
projectidcharacter varying(2048)Link to the project (table generalproject.id)
cust_customfieldnamedata type of custom fieldValue of a custom field

lookup

This view contains the values of the custom fields of the projects. The view gets automatically extended with new custom fields as soon as they are created. The new columns will always be appended to the view.

Column
Type
Description
repository_idintegerLink to the repository (table repository.id)
cust_customfieldnamedata type of custom fieldValue of a custom field

milestones

This view contains the values of the custom fields of the projects. The view gets automatically extended with new custom fields as soon as they are created. The new columns will always be appended to the view.

Column
Type
Description
milestoneidcharacter varying(2048)Link to the task (table generaltask.id)
titlecharacter varying(2048)Title of the milestone
scenario_idintegerLink to the scenario (table scenario.id)
milestonetypecharacter varying(2048)Milestone type

obs_project

This view contains the link between obs unit and project.

Column
Type
Description
obs_fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
project_codecharacter varying(2048)Link to the project (table generalproject.id)

obs_resource

This view contains the link between obs unit and resource.

Column
Type
Description
obs_fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
resource_codecharacter varying(2048)Link to the resource (table resource.id)

portfolio_budget

Column
Type
Description
portfolio_idintegerLink to the portfolio (table portfolio.internalid)
slice_datedate

First day of a month

amount_keycharacter varying(255)Finance type (CAPEX, OPEX or BENEFIT)
amountdoubleThe respective amount regarding the finance type

project_obs_levels

Column
Type
Description
typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
fqncharacter varying(4096)

Unique code of the obsunit (full path of the codes concatinated by "/")

unit_idintegerLink to the obs unit (table obs.obsid)
project_codecharacter varying(2048)Link to the project (table generalproject.id)
level_1character varying(2048)The name of the unit on level 1
level_2character varying(2048)The name of the unit on level 2
...  
level_10character varying(2048)The name of the unit on level 10

project_resource_alloc_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of a month
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
project_namecharacter varying(2048)Name of the project

project_resource_alloc_obs_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
project_namecharacter varying(2048)Name of the project
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of a month
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

project_resource_alloc_obs_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
project_namecharacter varying(2048)Name of the project
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of the week (Monday)
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

project_resource_alloc_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametext

Name of the scenario

resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
project_codecharacter varying(2048)Link to the project (table generalproject.id)
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
primaryrole_namecharacter varying(2048)Name of the primary role
projectrolecharacter varying(2048)Link to the project role (table resource.id)
projectrole_namecharacter varying(2048)Name of the project role
slice_datedateFirst day of the week (Monday)
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
allocation_costdoubleCost per hour multiplied by the allocation in hours
project_namecharacter varying(2048)Name of the project

project_resource_slicedata_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
resource_codecharacter varyingLink to the resource (table resource.id)
project_codecharacter varyingLink to the project (table generalproject.id)
project_rolecharacter varyingLink to the role (table resource.id)
slice_datetimestamp without time zoneFirst day of a month
allocationhoursdoubleAllocation in hours
capacityhoursdoubleCapacity in hours
financetypecharacter varyingCAPEX, OPEX or BENEFIT
costdoubleThe respective amount regarding the finance type

project_resource_slicedata_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
resource_codecharacter varyingLink to the resource (table resource.id)
project_codecharacter varyingLink to the project (table generalproject.id)
project_rolecharacter varyingLink to the role (table resource.id)
slice_datetimestamp without time zoneFirst day of the week (Monday)
allocationhoursdoubleAllocation in hours
capacityhoursdoubleCapacity in hours
financetypecharacter varyingCAPEX, OPEX or BENEFIT
costdoubleThe respective amount regarding the finance type

projectfinance_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
finance_datetimestamp without time zoneThe point in time of the financial event
amountdoubleThe respective amount regarding the finance type
financetypecharacter varying(255)CAPEX, OPEX or BENEFIT

projectfinance_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
finance_datetimestamp without time zoneThe point in time of the financial event
amountdoubleThe respective amount regarding the finance type
financetypecharacter varying(255)CAPEX, OPEX or BENEFIT

projects

Column
Type
Description
codecharacter varying(2048)Link to the project (table generalproject.id)
namecharacter varying(2048)The name of the project
manager_codecharacter varying(2048)Link to the project manager (table resource.id)
manager_namecharacter varying(2048)Name of the project manager
statuscharacter varying(2048)Status of the project

resource_alloc_capa_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of a month
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours

resource_alloc_capa_obs_monthly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of a month
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

resource_alloc_capa_obs_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of the week (Monday)
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours
obs_typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
obs_level_1character varying(2048)The name of the unit on level 1
obs_level_2character varying(2048)The name of the unit on level 2
...  
obs_level_10character varying(2048)The name of the unit on level 10

resource_alloc_capa_weekly

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
scenario_nametextName of the scenario
resource_codecharacter varying(2048)Link to the resource (table resource.id)
resource_namecharacter varying(2048)Name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
slice_datedateFirst day of the week (Monday)
capacitydoubleCapacity in hours
allocationdoubleAllocation in hours
costtypecharacter varyingCAPEX / OPEX
capacity_costdoubleCost per hour multiplied by the capacity in hours
allocation_costdoubleCost per hour multiplied by the allocation in hours

resource_obs_levels

Column
Type
Description
typecharacter varying(2048)The name of the Organizational Breakdown Structure (OBS)
fqncharacter varying(4096)Unique code of the obsunit (full path of the codes concatinated by "/")
unit_idintegerLink to the obs unit (table obs.obsid)
resource_codecharacter varying(2048)Link to the resource (table resource.id)
level_1character varying(2048)The name of the unit on level 1
level_2character varying(2048)The name of the unit on level 2
...  
level_10character varying(2048)The name of the unit on level 10

resources

Column
Type
Description
codecharacter varying(2048)Link to the resource (table resource.id)
namecharacter varying(2048)The name of the resource
primaryrolecharacter varying(2048)Link to the primary role (table resource.id)
rolebooleanTrue if the given entity is a role (False if resource)
costperhourdoubleThe cost per hour of the resource
costtypecharacter varyingCAPEX / OPEX
countrycharacter varying(255)The country assigned to the resource
citycharacter varying(255)The city assigned to the resource
postalcodecharacter varying(255)The postal code assigned to the resource

scenarioproject_totals

Column
Type
Description
idintegerLink to the scenarioproject (table scenarioproject.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
scenario_idintegerLink to the scenario (table scenario.id)
allocation_costdoubleCost per hour multiplied by the allocation in hours
allocation_hoursdoubleAllocation in hours
finance_costdoubleAllocation independent costs

scenarioprojects

Column
Type
Description
idintegerLink to the scenarioproject (table scenarioproject.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)
scenario_idintegerLink to the scenario (table scenario.id)
startdatetimestamp without time zoneThe start date of the project
finishdatetimestamp without time zoneThe finish date of the project
abovemusthavebooleanTrue if project is above the must have line
belowcutoffbooleanTrue if project is below the cutoff line
prioritybigintThe priority of the project
programtitlecharacter varying(2048)The title of the program containing this project
programidintegerThe id of the program containing this project

scenarioprojects_noncutoff

Column
Type
Description
scenario_idintegerLink to the scenario (table scenario.id)
idintegerLink to the scenarioproject (table scenarioproject.id)
projectidcharacter varying(2048)Link to the project (table generalproject.id)

scenarios

Column
Type
Description
idintegerLink to the scenario (table scenario.id)
nametextThe name of the scenario