The following tables implement the storage of Gantt schedules, including details on timesheet (gantt) tasks and their dependency. They also capture the hours logged on timesheet tasks and vacations.
Table |
Cols |
Rows |
Description |
---|---|---|---|
[im_hours] |
12 |
750 |
Stores logged timesheet hours per user, day and project. |
[im_materials] |
8 |
26 |
Materials represent a type of service. They form a link between timesheet tasks and the price list per customer. Example: "Senior Consultant Hour". |
[im_timesheet_conf_objects] |
7 |
0 |
Timesheet confirmation objects represent a group of logged im_hour hours, to be submitted for approval. Usually, all hours of one work week are grouped into a single conf object. |
[im_timesheet_invoices] |
3 |
98 |
Sub-type if financial document. Deleting a timesheet invoice will take care of removing the dependencies of im_hour entries related to the timesheet invoice. |
[im_timesheet_prices] |
9 |
13 |
Timesheet prices define the price per material and company. |
[im_timesheet_task_dependencies] |
5 |
333 |
Dependencies of timesheet tasks for Gantt scheduling. |
[im_timesheet_tasks] |
11 |
172 |
Timesheet tasks are a sub-type of projects. They define a material per task, a unit of measure and estimations for the time necessary to complete the task. |
[im_user_absences] |
12 |
72 |
User absences represent vacations and other absences. |
[timesheet_approval_workf_cases] |
1 |
0 |
Cases for the default timesheet approval workflow |
[vacation_approval_wf_cases] |
1 |
20 |
Cases for the default vacation approval workflow |
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com