db_time_entry

Describes an individual time entry in the time sheet

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
for_dateDate Date for this time entry was filled
hours_workedFloat Hours
creator_idIntegerdb_person.idUser that created this entry
user_idIntegerdb_person.idUser for whom the entry is for
task_idIntegerdb_task.idTask ID
process_idIntegerdb_process.idProcess/Issue ID
process_state_idInteger State ID in which the process existed ad the time of this time entry
project_idIntegerdb_project.idProject ID
time_code_idIntegerdb_time_code.idTime code ID
user_commentsString Comments
approver_commentsString Approver comments
approved_onDate Approved on
approver_idIntegerdb_person.idApproved by ID
rejected_by_idIntegerdb_person.idRejected by ID
rejected_onDate Rejected on
rejection_commentsString Reason for rejection
invoiced_onDate Invoiced on
invoiced_by_idInteger Invoiced by ID
stateInteger 0 - saved but not submitted for approval, 1 - sent for approval, 2 - rejected, 3 - approved, 6 - invoiced
is_billableBoolean (t or f) Is billable?
is_costableBoolean (t or f) Is costable?
cost_rateFloat the cost rate for this time entry
bill_rateFloat the bill rate for this time entry