db_process

Describes a process

ColumnTypeReferencesComments
idInteger Primary key
guidString  
vdb_idInteger  
createdDate Date created
summaryString Short summary
detailString Detailed description
due_dateDate Due date
is_delayedBoolean (t or f) Is this process delayed?
priorityInteger Priority : 1 = highest, 5 = lowest
type_idIntegerdb_process_type.idProcess type ID
workspace_idIntegerdb_group.idWorkspace ID
project_idIntegerdb_project.idProject ID
last_state_changedDate Last state change on
last_updatedDate Last process update on
requestor_idIntegerdb_person.idRequestor ID
requestor_nameString Requestor name (in case requestor is not a user of the system)
requestor_emailString Requestor email (in case requestor is not a user of the system)
creator_idIntegerdb_person.idCreator ID
assigned_to_idIntegerdb_person.idCurrent owner
state_idIntegerdb_state.idState this process is in
completedDate Completed on
followers_csvString Person ID CSV (-1 means project team), (-2 means PM)
is_requestor_visibleBoolean (t or f) Is visible to requestor?
my_b_time_moneyFloat Total billable time entries billing
my_b_time_hoursFloat Total billable time (hours)
my_nb_time_moneyFloat Total non-billable time entries billing
my_nb_time_hoursFloat Total non-billable time (hours)
my_c_time_hoursFloat Total costable time (hours)
my_i_time_moneyFloat Total invoiced time
my_i_time_hoursFloat Total invoiced hours
my_labour_costFloat Actual labour cost for this process
my_costFloat Actual cost for this process
time_entry_countInteger Total number of time entries associated with this process