| Table Name: | status_chg |
| Table Number: | 120 |
| Group: | Workflow Mgr |
| Description: | Records a status change of a queueable object (see related objects) |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| creation_time | CLK_TIME | datetime | 1 | Date and time of the status change | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| notes | CHAR | text | 23 | ALLOW_NULL | Status change text | |||
| objid | LONG | int | 3 | DIRECT | Internal record number |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| status_chg2act_entry | OTOP | act_entry | act_entry2status_chg | Activity log entry for the status change | |||
| status_chg2bug | MTO | bug | bg_statchg2status_chg | Related change request | |||
| case_status_chg2case | MTO | case | case2status_chg | Related case | |||
| contr_status_chg2contract | MTO | contract | contract2status_chg | Related contract | |||
| status_chg2demand_dtl | MTO | demand_dtl | demand_dtl2status_chg | Related part request | |||
| status_chg2dialogue | MTO | dialogue | dialogue2status_chg | Related dialogue | |||
| c_status_chg2gbst_elm | MTO | gbst_elm | curr_stat2status_chg | Current <new> status in change status activity | |||
| p_status_chg2gbst_elm | MTO | gbst_elm | prev_stat2status_chg | Previous <old> status in change status activity | |||
| job_status_chg2job | MTO | job | job2status_chg | Related job | |||
| status_chg2opportunity | MTO | opportunity | opp2status_chg | Related opportunity | |||
| status_chg2probdesc | MTO | probdesc | probdesc2status_chg | Related solution | |||
| subc_stat_chg2subcase | MTO | subcase | subcase2status_chg | Related subcase | |||
| status_chg2task | MTO | task | task2status_chg | Related task | |||
| status_chger2user | MTO | user | originator2status_chg | Reserved; obsolete. Use relation from corresponding act_entry to user instead |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_c_status_chg2gbst_elm | c_status_chg2gbst_elm | nonclustered located on PRIMARY |
| ind_case_status_chg2case | case_status_chg2case | nonclustered located on PRIMARY |
| ind_contr_status_chg2contract | contr_status_chg2contract | nonclustered located on PRIMARY |
| ind_creation_time | creation_time | nonclustered located on PRIMARY |
| ind_p_status_chg2gbst_elm | p_status_chg2gbst_elm | nonclustered located on PRIMARY |
| ind_status_chg2act_entry | status_chg2act_entry | nonclustered located on PRIMARY |
| ind_status_chg2bug | status_chg2bug | nonclustered located on PRIMARY |
| ind_status_chg2demand_dtl | status_chg2demand_dtl | nonclustered located on PRIMARY |
| ind_status_chg2opportunity | status_chg2opportunity | nonclustered located on PRIMARY |
| ind_status_chg2task | status_chg2task | nonclustered located on PRIMARY |
| ind_status_chger2user | status_chger2user | nonclustered located on PRIMARY |
| ind_subc_stat_chg2subcase | subc_stat_chg2subcase | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| status_chg2dialogue | status_chg2dialogue | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|
| status_chg | |||