| Table Name: | rqst_def |
| Table Number: | 9762 |
| Group: | Process Manager |
| Description: | Defines the published service requests available for process definition |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| description | CHAR | varchar | 255 | Brief description of what the service request does | Search (2) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| duration | LONG | int | DIRECT | Maximum duration (number of seconds before timeout) | Search (1) | |||
| is_pm_only | LONG | tinyint | DIRECT, ALLOW_NULL | Controls if the service can only be used by Process Manager 0 = No, 1 = Yes | ||||
| is_simulateable | LONG | tinyint | 1 | DIRECT, ALLOW_NULL | Indicates if the service can be simulated. 0 means the service is always executed, 1 means simulate according to ClarifyEnv.xml | |||
| max_retries | LONG | int | DIRECT | Maximum retries | Search (2) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| qualifier | CHAR | varchar | 255 | ALLOW_NULL | The qualifier for the resource/command (defined by svc_type) | Search (2) | ||
| retry_interval | LONG | int | DIRECT | Retry Interval | Search (2) | |||
| svc_name | CHAR | varchar | 128 | The Tuxedo service name that this function will call | Search (3) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| rqst_def2privclass | MTM | privclass | privclass2rqst_def | Related privclass using this definition | mtm_privclass9_ rqst_def3 | Search (1) | |
| rqst_def2rqst_fld_role | OTM | rqst_fld_role | rqst_fld_role2rqst_def | The fields defined for the service request | |||
| rqst_def2svc_rqst | OTM | svc_rqst | svc_rqst2rqst_def | Service requests using this definition | |||
| rqst_def2svc_type | MTO | svc_type | svc_type2rqst_def | The type of service request | Search (2) |
| Index Name | Fields | Flags |
|---|---|---|
| I9762 | svc_name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I9762 | svc_name | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| rd2st9762 | rqst_def2svc_type | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5839 | svc_def | rqst_def, svc_type |
| 5840 | priv_svc_rqst | privclass, rqst_def, svc_type |
| 9878 | fld_def_view | fld_def, rqst_def, rqst_fld_role |
| rqst_def | |||