Unlocked_time_periods
This table includes data related to the Unlocked Time Periods record, representing time periods locked by the Accounting Preference Lock Timesheet Period. During the locked period, users are not allowed to submit their timesheet or time entry.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
date_created |
TIMESTAMP |
|
|
|
|
|
Original date of the record creation |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date of the last record modification |
date_period_end |
TIMESTAMP |
|
|
|
|
|
End date of the period |
date_period_start |
TIMESTAMP |
|
|
|
|
|
Start date of the period |
date_valid_until |
TIMESTAMP |
|
|
|
|
|
States the date until unlocking of a period is valid |
employee_id |
NUMBER |
|
39 |
0 |
employee_id
|
Employees
|
Employee ID for which the locked periods apply |
is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Whether the unlocked period is inactive |
last_modified_by_id |
NUMBER |
|
39 |
0 |
employee_id
|
Employees
|
The ID of the user who last modified the record |
unlocked_time_period_extid |
VARCHAR2 |
255 |
|
|
|
|
Unlocked Time Period external ID |
unlocked_time_period_id |
NUMBER |
|
39 |
0 |
|
|
Unlocked Time Period ID |
Primary key
PK Column Name |
unlocked_time_period_id |
Foreign keys in this table
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 |