The Timesheet Confirmation Object is an auxillary object used in the Timesheet Workflow package when requesting an approval for a number of hours logged on a project.
We had to introduce this auxillary object because workflows in ]po[ require a specific object to which they can attach. Using the ]po[ workflow for approval of hours forced us to introduce this "container" object.
create table im_timesheet_conf_objects ( conf_id integer constraint im_timesheet_conf_id_pk primary key constraint im_timesheet_conf_id_fk references acs_objects, conf_project_id integer constraint im_timesheet_conf_project_nn not null constraint im_timesheet_conf_project_fk references im_projects, conf_user_id integer constraint im_timesheet_conf_user_nn not null constraint im_timesheet_conf_user_fk references users, start_date date constraint im_timesheet_conf_start_date_nn not null, end_date date constraint im_timesheet_conf_end_date_nn not null, conf_status_id integer constraint im_timesheet_conf_status_nn not null constraint im_timesheet_conf_status_fk references im_categories, conf_type_id integer constraint im_timesheet_conf_type_nn not null constraint im_timesheet_conf_type_fk references im_categories );
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