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 |
_workedprojectprojectProject ID | time_code| 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_ |
time_codeTime code ratetyperatetypeuser_Rate type ID, 1 = regular, 2 = overtime | | 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| saved but not submitted for approval, 1 - |
Sent Approval Rejected ApprovedInvoice| invoiced |
| is_billable | Boolean (t or f) | | Is billable? |
| is_costable | Boolean (t or f) | | Is costable? |
usercostLabour corresponding to cachedbilling_ billing to be used ; billing rate is calculated from the db_rate which keeps a historic date for rates