db_task

Describes a task

Column	Type	References	Comments
id	Integer		Primary key
guid	String
vdb_id	Integer
project_id	Integer	db_project.id	ID this task's project
parent_id	Integer	db_task.id	Parent ID
folder_id	Integer	db_folder.id	Document folder ID
priority	Integer		Priority. 1 for highest 5 for lowest
name	String		Short name
description	String		Detailed description
flags	Integer		Bit string of flags
duration_value	Float		Duration value (e.g. if duration is 2.5days this field will be 2.5)
actual_start	Date		Actual start
schedule_type	Integer
planned_start	Date		Planned start
planned_finish	Date		Planned finish
is_critical	Boolean (t or f)		True if task is on critical path
is_milestone	Boolean (t or f)		True if milestone
is_manually_scheduled	Boolean (t or f)		True if manually scheduled
is_hold	Boolean (t or f)		True if on hold
early_start	Date		Early start
early_finish	Date		Early finish
late_start	Date		Late start
late_finish	Date		Late finish
actual_finish	Date		Actual finish
actual_percent_complete	Integer		% complete
percent_complete_method	Integer		% complete method
budget	Float		Budget
planned_fixed_cost	Float		Fixed cost
planned_non_labor_cost	Float		Estimated non labour cost
planned_effort	Float		Effort in minutes
my_actual_billable_labor_amount	Float		Total billable time entries billing
ru_actual_billable_labor_amount	Float		Total rolled-up billable time entries billing
my_nb_time_money	Float		Total non-billable time entries billing
my_actual_non_billable_labor_amount	Float		Total rolled-up non-billable time entries billing
my_actual_non_billable_labor_hours	Float		Total non-billable time (hours)
ru_actual_billable_labor_hours	Float		Total rolled-up non-billable time (hours)
my_actual_billable_labor_hours	Float		Total billable time (hours)
ru_actual_non_billable_labor_amount	Float
ru_b_time_hours	Float		Total rolled-up billable time (hours)
my_actual_costable_labor_hours	Float		Total costable time (hours)
ru_actual_costable_labor_hours	Float		Total rolled-up costable time (hours)
my_actual_billable_expense	Float		Total billable expense
ru_actual_billable_expense	Float		Total rolled-up billable expense
my_actual_non_billable_expense	Float		Total non billable expense
ru_actual_non_billable_expense	Float		Total rolled-up non billable expense
my_actual_costable_expense	Float		Total costable expense
ru_actual_costable_expense	Float		Total rolled-up costable expense
my_actual_non_costable_expense	Float		Total non costable expense
ru_actual_non_costable_expense	Float		Total rolled-up non costable expense
my_invoiced_expense	Float		Total invoiced expense
ru_invoiced_expense	Float		Total rolled-up invoiced expense
my_invoiced_labor_amount	Float		Total invoiced time
ru_invoiced_labor_amount	Float		Total rolled-up invoiced time
ru_actual_non_billable_labor_hours	Float
my_invoiced_labor_hours	Float		Total invoiced hours
ru_invoiced_labor_hours	Float		Total rolled-up invoiced hours
my_planned_cost	Float		Estimated cost to complete this task
ru_planned_cost	Float		Rolled-up estimated cost to complete this task and its descendants
my_planned_labor_cost	Float		Estimated labour cost
ru_planned_labor_cost	Float		Rolled-up estimated labour cost
my_actual_labor_cost	Float		Actual labour cost till now
ru_actual_labor_cost	Float		Rolled-up actual labour cost till now
my_actual_cost	Float		Actual cost for this task
ru_actual_cost	Float		Actual cost for this task's descendants
my_planned_labor_revenue	Float		Estimated labour billing for this task
ru_planned_labor_revenue	Float		Estimated labour billing for this task's descendants
billing_amount	Float
is_time_allowed	Boolean (t or f)		Can fill time on this task?
are_predecessor_constraints_satisfied	Boolean (t or f)		Have all predecessors finished?
last_status_updated	Date		Date of the last status update
is_assigned	Boolean (t or f)		Is this task assigned to anyone
constraint_date	Date		Constraint date
constraint_type	Integer		Constraint type: 1 = ASAP, 2 = ALAP, 3 = MSO, 4 = MFO, 5 = SNET, 6 = SNLT, 7 = FNET, 8 = FNLT.
duration_unit	Integer		Duration units: 1 = Day, 2 = Hour, 3 = Week, 4 = Month, 5 = Year, 6 = Minute
is_summary	Boolean (t or f)		Is this a summary task i.e. does this task have any sub tasks
is_duration_estimated	Boolean (t or f)		Is the duration an approximation
is_duration_elapsed	Boolean (t or f)		Is the duration calendar elapsed time
projected_start_date	Date		Projected start date
projected_deadline	Date		Projected deadline
project_state_id	Integer		State of this task's project
archived	Date		Date when project was archived
tree_index	Integer		Number in siblings
sn	Integer
tree_level	Integer
note_count	Integer		Total number of notes associated with this task
message_count	Integer		Total number of email messages associated with this task
status_update_count	Integer		Total number of task status updates associated with this task
expense_count	Integer		Total number of expenses associated with this task
time_entry_count	Integer		Total number of time entries associated with this task
document_count	Integer		Total number of documents associated with this task
projected_start	Date		Projected start date
projected_finish	Date		Projected finish date
followers_csv	String		Person ID CSV (-1 means project team), (-2 means PM)
Computed Columns:
spi	Float		The schedule performance index using earned value method
cpi	Float		The cost performance index using earned value method
bcws	Float		The budgeted cost of work scheduled using earned value method
bcwp	Float		The budgeted cost of work performed using earned value method
acwp	Float		The actual cost of work performed using earned value method
schedule_status	String		The schedule status. Will be one of: ON_TIME, AT_RISK, OVERDUE, BLOCKED, FUTURE and COMPLETED
budget_status	String		The budget status. Will be one of: ON_BUDGET, AT_RISK, OVER_BUDGET
project_summary	String		The name of the project