db_process

Describes a process

Column	Type	References	Comments
id	Integer		Primary key
guid	String
vdb_id	Integer
created	Date		Date created
summary	String		Short summary
detail	String		Detailed description
due_date	Date		Due date
is_delayed	Boolean (t or f)		Is this process delayed?
priority	Integer		Priority : 1 = highest, 5 = lowest
type_id	Integer	db_process_type.id	Process type ID
workspace_id	Integer	db_group.id	Workspace ID
project_id	Integer	db_project.id	Project ID
last_state_changed	Date		Last state change on
last_updated	Date		Last process update on
requestor_id	Integer	db_person.id	Requestor ID
requestor_name	String		Requestor name (in case requestor is not a user of the system)
requestor_email	String		Requestor email (in case requestor is not a user of the system)
creator_id	Integer	db_person.id	Creator ID
assigned_to_id	Integer	db_person.id	Current owner
state_id	Integer	db_state.id	State this process is in
completed	Date		Completed on
followers_csv	String		Person ID CSV (-1 means project team), (-2 means PM)
is_requestor_visible	Boolean (t or f)		Is visible to requestor?
my_b_time_money	Float		Total billable time entries billing
my_b_time_hours	Float		Total billable time (hours)
my_nb_time_money	Float		Total non-billable time entries billing
my_nb_time_hours	Float		Total non-billable time (hours)
my_c_time_hours	Float		Total costable time (hours)
my_i_time_money	Float		Total invoiced time
my_i_time_hours	Float		Total invoiced hours
my_labour_cost	Float		Actual labour cost for this process
my_cost	Float		Actual cost for this process
time_entry_count	Integer		Total number of time entries associated with this process