14.1 sp621_special_periods_history
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table contains a list of changes made to sp620.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| period_id | number(9) |  | |
| timestamp | date | | |
| employee_no | number(9) | | |
| start_date | date | | |
| end_date | date |  | |
| colour | varchar2(30) | |
Keys
None.
Column Descriptions
| Field | Description |
|---|---|
| period_id | Period identifier. |
| timestamp | Date/time of the change (Uses the time zone of the DBMS server machine). |
| action | The type of change made – one of (C,U,D). |
| 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 | Colour the period is to be dispayed in. |