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