This is a comprehensive list of all pre-defined columns. In addition to the listed IDs all user defined attributes can be used as column IDs.

The number of sub-tasks (including the current task) that are active in the reported time period. Active means that they are ongoing at the current time or now date.

The number of annual leave units within the reported time period. The unit can be adjusted with loadunit.

The balance of the annual leave at the end of the reporting interval. The unit can be adjusted with loadunit.

A list with all annual leave intervals. The list can be customized with the listtype attribute.

The alert level of the property that was reported with the date closest to the end date of the report. Container properties that don't have their own alert level reported with a date equal or newer than the alert levels of all their sub properties will get the highest alert level of their direct sub properties.

Deprecated. Please use journal instead

Deprecated. Please use journal instead

Shows how the alert level at the end of the report period compares to the alert level at the beginning of the report period. Possible values are Up, Down or Flat.

The account balance at the beginning of the reported period. This is the balance before any transactions of the reported period have been credited.

The hierarchical or work breakdown structure index (i. e. 1.2.3)

A Gantt chart. This column type requires all lines to have the same fixed height. This does not work well with rich text columns in some browsers. Some show a scrollbar for the compressed table cells, others don't. It is recommended, that you don't use rich text columns in conjuction with the chart column.

A list of all direct sub elements.

The list can be customized by the listitem and listtype attributes.

The number of sub-tasks (including the current task) that have been closed during the reported time period. Closed means that they have an end date before the current time or now date.

The number of tasks that have successfully competed for the same resources and have potentially delayed the completion of this task.

A list of tasks that have successfully competed for the same resources and have potentially delayed the completion of this task.

The completion degree of a task. Unless a completion degree is manually provided, this is a computed value relative to the now date of the project. A task that has ended before the now date is always 100% complete. A task that starts at or after the now date is always 0%. For effort based tasks the computation degree is the percentage of done effort of the overall effort. For other leaf tasks, the completion degree is the percentage of the already passed duration of the overall task duration. For container tasks, it's always the average of the direct sub tasks. If the sub tasks consist of a mixture of effort and non-effort tasks, the completion value is only of limited value.

Deprecated alias for complete

A measure for how much effort the resource is allocated for, or how strained the allocated resources of a task are.

The cost of the task or resource. The use of this column requires that a cost account has been set for the report using the balance attribute.

A group of columns with one column for each day

The resources that have this resource assigned as manager.

The list can be customized by the listitem and listtype attribute.

The duration of a task

List of tasks that the resource is allocated to

The list can be customized by the listitem and listtype attribute.

Measure for how efficient a resource can perform tasks

The allocated effort during the reporting period

The already completed effort as of now

The remaining allocated effort as of now

The email address of a resource

The end date of a task

List of attached flags

A list of tasks that depend on the current task. The list contains the names, the IDs, the date and the type of dependency. For the type the following symbols are used for <dep>:

• ]->[: End-to-Start dependency
• [->[: Start-to-Start dependency
• ]->]: End-to-End dependency
• [->]: Start-to-End dependency

The list can be customized by the listitem and listtype.column attributes. The dependency symbol can be generated via the dependency attribute in the query, the target date via the date attribute.

The amount of unallocated work time of a resource during the reporting period.

The amount of unallocated work capacity of a resource during the reporting period. This is the product of unallocated work time times the efficiency of the resource.

The Full-Time-Equivalent of a resource or group. This is the ratio of the resource working time and the global working time. Working time is defined by working hours and leaves. The FTE value can vary over time and is calculated for the report interval or the user specified interval.

When complete values have been provided to capture the actual progress on tasks, the gauge column will list whether the task is ahead of, behind or on schedule.

For resources this is the headcount number of the resource or resource group. For a single resource this is the efficiency rounded to the next integer. Resources that are marked as unemployed at the report start time are not counted. For a group it is the sum of the sub resources headcount.

For tasks it's the number of different resources allocated to the task during the report interval. Resources are weighted with their rounded efficiencies.

Deprecated alias for bsi

A group of columns with one column for each hour

The id of the item

The index of the item based on the nesting hierachy

A list of milestones that are a prerequiste for the current task. For container tasks it will also include the inputs of the child tasks. Inputs may not have any predecessors.

The list can be customized by the listitem and listtype attribute.

The journal entries for the task or resource for the reported interval. The generated text can be customized with journalmode, journalattributes, hidejournalentry and sortjournalentries. If used in queries without a property context, the journal for the complete project is generated.

Deprecated. Please use journal instead

Deprecated. Please use journal instead

Deprecated. Please use journal instead

The line number in the report

A list of managers that the resource reports to.

The list can be customized by the listitem and listtype attributes.

The latest allowed end of a task

The lastest allowed start of a task

The earliest allowed end of a task

The earliest allowed start of a task

A group of columns with one column for each month

The object line number in the report (Cannot be used for sorting!)

The name or description of the item

The note attached to a task

The number of sub-tasks (including the current task) that have not yet been closed during the reported time period. Closed means that they have an end date before the current time or now date.

The criticalness of the task with respect to all the paths that it is a part of.

A list of tasks the current task depends on. The list contains the names, the IDs, the date and the type of dependency. For the type the following symbols are used

• ]->[: End-to-Start dependency
• [->[: Start-to-Start dependency
• ]->]: End-to-End dependency
• [->]: Start-to-End dependency

The list can be customized by the listitem and listtype attributes. The dependency symbol can be generated via the dependency attribute in the query, the target date via the date attribute.

The priority of a task

A group of columns with one column for each quarter

The daily cost of a resource.

All resources that have this resource assigned as a direct or indirect manager.

The list can be customized by the listitem and listtype attributes.

A list of resources that are assigned to the task in the report time frame.

The list can be customized by the listitem and listtype attributes.

The responsible people for this task.

The list can be customized by the listitem and listtype attributes.

The revenue of the task or resource. The use of this column requires that a revenue account has been set for the report using the balance attribute.

The name of the scenario

The scheduling mode of the leaf tasks. ASAP tasks are scheduled start to end while ALAP tasks are scheduled end to start.

The index of the item based on the declaration order

The number of sick leave units within the reported time period. The unit can be adjusted with loadunit.

The number of special leave units within the reported time period. The unit can be adjusted with loadunit.

The start date of the task

The status of a task. It is determined based on the current date or the date specified by now.

A list of milestones that depend on the current task. For container tasks it will also include the targets of the child tasks. Targets may not have any follower tasks.

The list can be customized by the listitem and listtype attributes.

The financial turnover of an account during the reporting interval.

Deprecated alias for bsi.

The number of unpaid leave units within the reported time period. The unit can be adjusted with loadunit.

A group of columns with one column for each week

A group of columns with one column for each year