14.1 sp620_special_periods
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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) | |
Keys
primary key (period_id)
foreign key (employee_no) references 14.1 sp210_employees (employee_no)
foreign key (fru_no) references /wiki/spaces/SCH141/pages/27099986 (resp_unit_no)
Column Descriptions
| 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. |