| Table Name: | life_cycle |
| Table Number: | 5012 |
| Group: | Task Mgr |
| Description: | Specifies a life cycle or a process |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | tinyint | DIRECT | Indicates whether the life cycle definition/process is active; i.e., 0=inactive, 1=active | ||||
| appl_id | CHAR | varchar | 20 | Clarify application identifier of the application which owns the life cycle | ||||
| description | CHAR | varchar | 255 | Description of the life cycle | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| id_number | CHAR | varchar | 4 | 80 | Unique process number assigned within application ID. Reserved; not used | |||
| is_default | LONG | int | 0 | DIRECT | Indicates whether the object is the default life_cycle; i.e., 0=no, 1=yes. Used for auto-generated opportunities, which must be related to a life_cycle | |||
| name | CHAR | varchar | 2 | 50 | Name of the life cycle | Search (4) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) | ||
| text | CHAR | text | ALLOW_NULL | Full description of the life cycle or process |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| cycle2case | OTM | case | case2life_cycle | Cases tracking the life cycle. Reserved | |||
| player2cyc_cyc_role | OTM | cyc_cyc_role | player2life_cycle | Roles played for other processes | |||
| role_for2cyc_cyc_role | OTM | cyc_cyc_role | role_for2life_cycle | Roles received from other processes | |||
| cycle2job | OTM | job | job2life_cycle | Jobs tracking the life cycle | |||
| cycle2opportunity | OTM | opportunity | opp2life_cycle | Opportunities using the life cycle | |||
| cycle2stage_assign | OTM | stage_assign | assign2life_cycle | Life cycle stage assignment | |||
| cycle2task_set | MTM | task_set | task_set2life_cycle | Task sets assigned directly to the business process | mtm_life_cycle6_ task_set2 |
| Index Name | Fields | Flags |
|---|---|---|
| life_cycle_ind | name:appl_id | UNIQUE |
| id_number_ind | id_number:appl_id | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| id_number_ind | id_number, appl_id | nonclustered, unique located on PRIMARY |
| life_cycle_ind | name, appl_id | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5105 | stgassign_v | cycle_stage, life_cycle, stage_assign |
| 5355 | sfa_stage_v | cycle_stage, gbst_elm, gbst_lst, life_cycle, stage_assign |
| 5357 | sfa_opp_mto_v | currency, cycle_stage, lead_source, life_cycle, opportunity, territory |
| 5742 | opp_summary_v | currency, cycle_stage, lead_source, life_cycle, opportunity, territory |
| life_cycle | |||