sp051_brus

This table provides a list of 'top-level' organisational units. brus are purely organisational - they have no relevance to the scheduling process other than, possibly, as a guide as to which subset of FRUs may be considered.

Table Definition

Field	Type	Default	Nullable
bru_no	number (4)
bru_id	varchar2(8)
name	varchar2(40)

Keys

primary key (bru_no)

unique (bru_id)

unique (name)

Primary Key Referenced From

sp051_brus

Column Descriptions

Field	Description
bru_no	Unique identifier
bru_id	End users' unique identifier
name.	Descriptive name