Describes an individual time entry in the time sheet
Column | Type | References | Comments |
id | Integer | Primary key | |
vdb_id | Integer | ||
for_date | Date | Date for this time entry was filled | |
hours_worked | Float | Hours | |
creator_id | Integer | db_person.id | User that created this entry |
user_id | Integer | db_person.id | User for whom the entry is for |
task_id | Integer | db_task.id | Task ID |
process_id | Integer | db_process.id | Process/Issue ID |
process_state_id | Integer | State ID in which the process existed ad the time of this time entry | |
project_id | Integer | db_project.id | Project ID |
time_code_id | Integer | db_time_code.id | Time code ID |
user_comments | String | Comments | |
approver_comments | String | Approver comments | |
approved_on | Date | Approved on | |
approver_id | Integer | db_person.id | Approved by ID |
rejected_by_id | Integer | db_person.id | Rejected by ID |
rejected_on | Date | Rejected on | |
rejection_comments | String | Reason for rejection | |
invoiced_on | Date | Invoiced on | |
invoiced_by_id | Integer | Invoiced by ID | |
state | Integer | 0 - saved but not submitted for approval, 1 - sent for approval, 2 - rejected, 3 - approved, 6 - invoiced | |
is_billable | Boolean (t or f) | Is billable? | |
is_costable | Boolean (t or f) | Is costable? | |
cost_rate | Float | the cost rate for this time entry | |
bill_rate | Float | the bill rate for this time entry |