Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
date_created | TIMESTAMP | ||||||
date_last_modified | TIMESTAMP | ||||||
date_period_end | TIMESTAMP | ||||||
date_period_start | TIMESTAMP | ||||||
date_valid_until | TIMESTAMP | ||||||
employee_id | NUMBER | 39 | 0 |
employee_id |
Employees |
||
is_inactive | VARCHAR2 | 3 | |||||
last_modified_by_id | NUMBER | 39 | 0 |
employee_id |
Employees |
||
unlocked_time_period_extid | VARCHAR2 | 255 | |||||
unlocked_time_period_id | NUMBER | 39 | 0 |
PK Column Name |
---|
unlocked_time_period_id |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
unlocked_time_periods_employees_fk | employee_id | Employees | employee_id | 1 |
unlocked_time_periods_employees_fk_2 | last_modified_by_id | Employees | employee_id | 1 |