sp053_drus
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table provides a list of organisational units comprising one or more final responsibility units. These may be further grouped within a 'BRU' which is the top-most available organisational unit that can be defined.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| dru_no | number (4) | Â |  |
| dru_id | varchar2(8) | Â | |
| name | varchar2(40) | Â | |
| bru_no | number (4) | Â |  |
Keys
primary key (dru_no)
unique (dru_id)Â
unique (name)Â
foreign key (bru_no) references sp051_brus (bru_no)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| dru_no  | Unique identifier |
| dru_id | End users' unique identifier |
| name | Descriptive name |
| bru_no | BRU identifier |
Â
Â