Versions Compared

Key

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

Describes Updates on a process typeincludes assignee changes, comments or state transitions

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
nameguidString Name 
descriptioncreatedStringDate Description
requestor_reqdBoolean (t or f) Whether requestor makes sense for this process type
initial_Date of update
process_idIntegerdb_process.idProcess ID
commentsString Comments
creator_idIntegerdb_person.idCreator ID
assignee_idInteger  initial_assignee_typedb_person.idAssignee ID
state_idInteger 1 = None , 2 = Specific user, 3 = State manager
allow_timeBoolean (t or f)  
allow_clientBoolean (t or f)  
activeBoolean (t or f)  
followers_csvString Person ID CSV (-1 means project team), (-2 means PM)db_state.idFrom state ID
transition_idIntegerdb_state_transition.idState Transition ID, if none then empty
next_state_idIntegerdb_state.idTo state ID
nameString Name of the person doing the transition if not a Celoxis user
emailString Email of the person doint the transition if not a Celoxis user