...
| 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 |
| project_id | Integer | db_project.id | Project ID |
| time_code_id | Integer | db_time_code.id | Time code ID |
| rate_type_id | Integer | db_rate_type.id | Rate type ID, 1 = regular, 2 = overtime |
| 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 | |
| state | Integer | 0 - Saved, 1 - Sent for Approval, 2 - Rejected, 3 - Approved, 6-Invoice | |
| is_billable | Boolean (t or f) | Is billable? | |
| is_costable | Boolean (t or f) | Is costable? | |
| user_cost | Float | Labour cost corresponding to this time entry | |
| cached_billing_rate | Float | the billing rate to be used for this time entry; billing rate is calculated from the db_rate which keeps a historic date for rates |