db_time_entry
- Former user (Deleted)
- Rashmi Likhite
Owned by Former user (Deleted)
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 | 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 |
| 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 |