sp620_special_periods

This table contains a list of periods which are shown on the gantt in the colour specified.

Table Definition

Field	Type	Default	Nullable
period_id	number(9)
employee_no	number(9)
start_date	date
end_date	date
colour	varchar2(30)
fru_no	number(9)

primary key (period_id)
foreign key (employee_no) references sp210_employees (employee_no)
foreign key (fru_no) references sp058_responsibility_units (resp_unit_no)

Field	Description
period_id	Period identifier.
employee_no	The employee number.
start_date	The start date for the period. Uses FRU timezone.
end_date	The end date for the period. Uses FRU timezone.
colour	The colour the period is to be dispayed in.
fru_no	The number of the responsibility unit within which the employee is posted for the date of the Special Period.