14.1 sp242_ru_ext_data_objects
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table defines the set of objects available to operatives within a given responsibility unit through the GUI update screens.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| resp_unit_no | number(4) |  | |
| object_no | number(2) | |
Keys
Primary key (resp_unit_no, object_no)
Foreign key (resp_unit_no) references sp-58_responsibility_units (resp_unit_no)
Foreign key (object_no) references sp234_ext_data_objects (object_no)
Column Descriptions
| Field | Description |
|---|---|
| resp_unit_no | Identifier for the responsibility unit. Should be either an FRU or the Root unit. If records are defined for both the Root unit and an FRU then for operatives in the FRU only the records for that FRU will be used i.e. they are not additive. |
| object_no | Identifier of the object mapped to the RU. |