Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ColumnTypeReferencesComments
idInteger Primary key
codeString A unique project code
vdb_idInteger  
guidString  
createdDate Date this project was created
project_categorytype_idIntegerdb_project_category.idID of its project category
workspace_idIntegerdb_group.idID of the group this project belongs to
working_calendar_idInteger  
client_idIntegerdb_person.idClient ID
manager_idIntegerdb_person.idPrimary Project Manager ID
priorityInteger Priority. 1 is for highest and 5 for lowest.
summarynameString Short name of this project
detaildescriptionString Detail
markdown_detailString Detail
chargingbilling_modeltypeInteger  
fixed_priceFloat  
budgetFloat Budget
folder_idIntegerdb_folder.idID of its document folder
archivedDate Date when the project is in an 'end' phase
archived_by_idInteger ID of the user who archived this project
state_idIntegerdb_project_state.id 
projected_hoursFloat Projected cost
projected_costFloat Projected cost
projected_finishDate Projected finish date
planplanned_startDate Planned start date of this project
planplanned_finishDate Planned finish date of this project. This will be the max of plan_finish of its tasks.
actual_finishDate The time when all tasks report 100%
deadlineDate The deadline of this project
duration_hoursFloat Duration of the project in hours
actual_percent_completeInteger % complete
actual_fixed_costFloat Accumulated fixed cost for this project
useractual_labor_costFloat Accumulated user cost for this project
actual_costFloat Total accumulated cost
cactual_costable_expenseFloat Total costable expense
ncactual_non_costable_expenseFloat Total non-costable expense
bactual_billable_expenseFloat Total billable expense
nbactual_non_billable_expenseFloat Total non-billable expense
estplanned_workeffortFloat Total estimated work in minutes
estplanned_labourlabor_billingrevenueFloat Estimated labour billing
estplanned_labourlabor_costFloat Total estimated labour cost
estplanned_non_labourlabor_costFloat Total estimated non-labour cost
estplanned_fixed_costFloat Total estimated fixed cost
bactual_billable_timelabor_moneyamountFloat Total billable time sheet billing
nb_time_moneyactual_non_billable_labor_amountFloat Total non-billable time sheet billing
bactual_billable_timelabor_hoursFloat Billable time sheet hoursnb
_timeactual_non_billable_labor_hoursFloat Non-billable time sheet hoursc
actual_costable_timelabor_hourshourFloat Costable time sheet hours
iinvoiced_expenseFloat Total invoiced expense
iinvoiced_timelabor_moneyamountFloat Total invoiced time
iinvoiced_timelabor_hoursFloat Total invoiced hours
percent_complete_methodInteger Default % complete method for tasks
default_schedule_typeInteger Default schedule type for tasks
note_countInteger Total number of notes associated with its tasks
message_countInteger Total number of email messages associated with its tasks
status_update_countInteger Total number of task status updates associated with its tasks
expense_countInteger Total number of expenses associated with its tasks
time_entry_countInteger Total number of time entries associated with its tasks
riskInteger PPM risk. 1 is for Very Low and 5 for Very High. The potential negative impact that may arise from this project.
benefitInteger Number between 0 to 100. The potential for financial or operational gain upon successful completion.
alignmentInteger Number between 0 to 100. The measure of how closely this project's requirements fit within the organizations business model, goals, skill sets, and resources.
default_baselineInteger The default baseline to use in baseline comparisons
Computed Columns:
spiFloat The schedule performance index using earned value method
cpiFloat The cost performance index using earned value method
bcwsFloat The budgeted cost of work scheduled using earned value method
bcwpFloat The budgeted cost of work performed using earned value method
acwpFloat The actual cost of work performed using earned value method
schedule_statusString The schedule status. Will be one of: ON_TIME, AT_RISK, OVERDUE, BLOCKED, FUTURE and COMPLETED
budget_statusString The budget status. Will be one of: ON_BUDGET, AT_RISK, OVER_BUDGET
client_root_nameString The name of the client root in this project's client hierarchy
client_nameString The name of this project's client
manager_nameString The name of this project's manager

...