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
summary	String		Short name
detail	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_value	Integer
plan_start	Date		Planned start
plan_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_manual	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
percent_complete	Integer		% complete
percent_complete_method	Integer		% complete method
budget	Float		Budget
fixed_cost	Float		Fixed cost
est_non_labour_cost	Float		Estimated non labour cost
work_time	Float		Effort in minutes
my_b_time_money	Float		Total billable time entries billing
ru_b_time_money	Float		Total rolled-up billable time entries billing
my_nb_time_money	Float		Total non-billable time entries billing
ru_nb_time_money	Float		Total rolled-up non-billable time entries billing
my_nb_time_hours	Float		Total non-billable time (hours)
ru_nb_time_hours	Float		Total rolled-up non-billable time (hours)
my_b_time_hours	Float		Total billable time (hours)
ru_b_time_hours	Float		Total rolled-up billable time (hours)
my_c_time_hours	Float		Total costable time (hours)
ru_c_time_hours	Float		Total rolled-up costable time (hours)
my_b_expense	Float		Total billable expense
ru_b_expense	Float		Total rolled-up billable expense
my_nb_expense	Float		Total non billable expense
ru_nb_expense	Float		Total rolled-up non billable expense
my_c_expense	Float		Total costable expense
ru_c_expense	Float		Total rolled-up costable expense
my_nc_expense	Float		Total non costable expense
ru_nc_expense	Float		Total rolled-up non costable expense
my_i_expense	Float		Total invoiced expense
ru_i_expense	Float		Total rolled-up invoiced expense
my_i_time_money	Float		Total invoiced time
ru_i_time_money	Float		Total rolled-up invoiced time
my_i_time_hours	Float		Total invoiced hours
ru_i_time_hours	Float		Total rolled-up invoiced hours
my_est_cost	Float		Estimated cost to complete this task
ru_est_cost	Float		Rolled-up estimated cost to complete this task and its descendants
my_est_labour_cost	Float		Estimated labour cost
ru_est_labour_cost	Float		Rolled-up estimated labour cost
my_labour_cost	Float		Actual labour cost till now
ru_labour_cost	Float		Rolled-up actual labour cost till now
my_cost	Float		Actual cost for this task
ru_cost	Float		Actual cost for this task's descendants
my_est_labour_billing	Float		Estimated labour billing for this task
ru_est_labour_billing	Float		Estimated labour billing for this task's descendants
billing_amount	Float
can_fill_time	Boolean (t or f)		Can fill time on this task?
is_dep_solved	Boolean (t or f)		Have all predecessors finished?
last_status_update	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_value	Integer		Constraint type: 1 = ASAP, 2 = ALAP, 3 = MSO, 4 = MFO, 5 = SNET, 6 = SNLT, 7 = FNET, 8 = FNLT.
duration_type	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
child_number	Integer		Number in siblings
local_key	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