The part_defn table holds all the
participation records defined on the system. A participation record defines the dates and times that users are allowed to participate in a particular queue. (The
part_list table defines what users are allowed to use a particular participation record.)
The part_defn table has the following structure:
TABLE part_defn (
part_id number(5) NOT NULL,
queue_name varchar2(24) NOT NULL,
days_mask varchar2(7) NOT NULL,
start_time number(4) NOT NULL,
end_time number(4) NOT NULL,
style varchar2(24) NULL,
start_date number(7) NOT NULL,
end_date number(7) NOT NULL)
The part_defn table contains one row for each participation record defined on the system.