| Table Name: | fld_inst |
| Table Number: | 9759 |
| Group: | Process Manager |
| Description: | Contains one instance for each field for an executed function |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| fld_name | CHAR | varchar | 128 | Field name, from svc_fld | Search (3) | |||
| flex_owner_objid | LONG | int | DIRECT | Objid of owning object of an N_AttributeValue (for dependent and activation fields) | Search (2) | |||
| is_pending | LONG | int | DIRECT | 0 = value holds the field's value, 1 = activation/dependent field value is pending | Search (3) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) | ||
| type | LONG | int | DIRECT | Type of field - copied from svc_fld.type | Search (2) | |||
| value | CHAR | varchar | 255 | Value of the field | Search (4) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| f2ri9759 | fld2rqst_inst | nonclustered located on PRIMARY |
| f2sf9759 | fld2svc_fld | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 9862 | fld_status_view | fld_inst, rqst_inst, svc_fld |
| 9874 | process_fld_inst_view | fld_inst, rqst_inst, svc_fld, svc_rqst |
| 9898 | procinst_param_view | fld_inst, function, group_inst, proc_inst, rqst_inst, svc_fld |
| 9904 | fld_inst_view | fld_inst, rqst_inst, svc_fld |
| fld_inst | |||