ALM Project Database Reference
td.TRAN_RULES Table
Description
Permitted status changes per group.
Remarks
This table defines permitted changes from one status to another by group. For example, TR_TABLE_NAME is BUG, TR_FIELD_NAME is BG_STATUS, TR_GROUP_ID is 1, and TR_RULES is Open,FixedReopen,FixedOpen,RejectedReopen,Rejected. This means that members of group 1 can change a defect status from Open to Fixed, from Reopen to Fixed, from Open to Rejected, and from Reopen to Rejected. All other status changes are denied.
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key TR_TABLE_NAMEThe table containing the field to which the rule applies.varchar40   
Primary Key TR_FIELD_NAMEThe field to which the rule applies.varchar40   
Primary Key TR_GROUP_IDThe GROUPS.GR_GROUP_ID of the group to which the rule applies.int4   
 TR_RULESOne or more allowed transitions. The initial value (or $ANY) is separated by a comma from the permitted target value. There is no separation between a target value and the initial value of the next permitted transition.varchar16  
Indexes
IndexDescriptionPrimaryUnique
TR_PRIMARYKEY 
See Also