Employee_time

The Transaction Column Fields custom field is available for the Employee Time table.

Columns

Name Type Length Precision Scale References In Description
approved VARCHAR2 3 Approved
billable VARCHAR2 3 Billable
billed VARCHAR2 3 Billed
billing_class_id NUMBER 39 0 billing_class_id
Billing_classes
Billing class ID
billing_subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Billing subsidiary ID
break_duration NUMBER 12 5 Break duration
charge_billing_run_id NUMBER 39 0 Charge billing run ID
class_id NUMBER 39 0 class_id
Classes
Class ID
closed TIMESTAMP Closed
comments VARCHAR2 4000 Comments
customer_id NUMBER 39 0 customer_id
Customers
Customer ID
date_last_modified TIMESTAMP Date last modified
day_0 TIMESTAMP Day
department_id NUMBER 39 0 department_id
Departments
Department ID
duration NUMBER 12 5 Duration
employee_id NUMBER 39 0 employee_id
Employees
Employee
employee_time_id NUMBER 39 0 Employee time ID
ending TIMESTAMP Ending
event_id NUMBER 39 0 Event ID
is_outside_project_plan VARCHAR2 3 Is outside of the project plan
is_posted VARCHAR2 3 Whether the time is posted
is_productive VARCHAR2 1 Productive
is_utilized VARCHAR2 1 Utilized
item_id NUMBER 39 0 item_id
Service_items
Item ID
location_id NUMBER 39 0 location_id
Locations
Location ID
next_approver_id NUMBER 39 0 Next approver ID
payroll_item_id NUMBER 39 0 payroll_item_id
Payroll_items
Payroll item ID
payroll_workplace_id NUMBER 39 0 Payroll workplace ID
price_type_id NUMBER 39 0 price_type_id
Price_types
Price type ID
rejection_note VARCHAR2 4000 Rejection note
remaining_time_to_charge NUMBER 39 0 Remaining time to charge
resource_allocation_id NUMBER 39 0 Resource allocation ID
starting TIMESTAMP Starting
status_code VARCHAR2 200 Status code
subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Subsidiary ID
time_type VARCHAR2 9 Type of time (Actual, Allocated, Planned)
timesheet_id NUMBER 39 0 Timesheet ID
transaction_id NUMBER 39 0 transaction_id
transaction_id
Transaction_lines
Transactions
Transaction ID
transaction_line_id NUMBER 39 0 transaction_line_id
Transaction_lines
Transaction Line ID
unit_cost NUMBER 20 2 Unit cost
unit_price NUMBER 30 15 Unit price

Primary key

PK Column Name
employee_time_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
employee_time_billing_classes_fk billing_class_id Billing_classes billing_class_id 1
employee_time_classes_fk class_id Classes class_id 1
employee_time_customers_fk customer_id Customers customer_id 1
employee_time_departments_fk department_id Departments department_id 1
employee_time_employees_fk employee_id Employees employee_id 1
employee_time_locations_fk location_id Locations location_id 1
employee_time_payroll_items_fk payroll_item_id Payroll_items payroll_item_id 1
employee_time_price_types_fk price_type_id Price_types price_type_id 1
employee_time_service_items_fk item_id Service_items item_id 1
employee_time_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1
employee_time_subsidiaries_fk_2 billing_subsidiary_id Subsidiaries subsidiary_id 1
employee_time_transaction_lines_fk transaction_id Transaction_lines transaction_id 1
employee_time_transaction_lines_fk transaction_line_id Transaction_lines transaction_line_id 2
employee_time_transactions_fk transaction_id Transactions transaction_id 1