...
| 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 | ||||
| projectprocess_id | Integer | db_projectprocess.id | Project ID | time_codeProcess/Issue ID | |||
| process_state_id | Integer | State ID in which the process existed ad the time of this time entry | |||||
| project_id | Integer | db_time_codeproject.id | Time code Project ID | ||||
| ratetime_typecode_id | Integer | db_ratetime_typecode.id | Rate type ID, 1 = regular, 2 = overtimeTime 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 - Savedsaved but not submitted for approval, 1 - Sent sent for Approvalapproval, 2 - Rejectedrejected, 3 - Approvedapproved, 6 - Invoiceinvoiced | |||||
| is_billable | Boolean (t or f) | Is billable? | |||||
| is_costable | Boolean (t or f) | Is costable? | |||||
| cost_ | costrate | Float | Labour | the cost | corresponding torate for this time entry | ||
| bill_ | billing_rate | Float | the | billingbill rate | to be usedfor this time entry | ; billing rate is calculated from the db_rate which keeps a historic date for rates