sp621_special_periods_history
- Jason Andrew
Owned by Jason Andrew
Oct 02, 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. |