| Table Name: | fld_def |
| Table Number: | 9766 |
| Group: | Process Manager |
| Description: | Defines parameters used by services. Each field is unique by the combination of its name and class |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| attrib_type | CHAR | varchar | 20 | For Tuxedo fields: the attribute type, either string or number | Search (2) | |||
| description | CHAR | varchar | 255 | Brief description of what the field is for | Search (2) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| fld_class | CHAR | varchar | 128 | ALLOW_NULL | The fully qualified Java class name of the parameter | Search (2) | ||
| fld_name | CHAR | varchar | 128 | The parameter field name | Search (2) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| fld_def2rqst_fld_role | OTM | rqst_fld_role | rqst_fld_role2fld_def | Where this field is used by service requests | |||
| fld_def2svc_fld | OTM | svc_fld | svc_fld2fld_def | Service fields using this definition | |||
| fld_def2tbl_def | MTO | tbl_def | tbl_def2fld_def | The tbl file that defines this field | Search (1) |
| Index Name | Fields | Flags |
|---|---|---|
| I9766 | fld_name:fld_class | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| fd2td9766 | fld_def2tbl_def | nonclustered located on PRIMARY |
| I9766 | fld_name, fld_class | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 9878 | fld_def_view | fld_def, rqst_def, rqst_fld_role |
| 9879 | fld_tbl_view | fld_def, tbl_def |
| fld_def | |||