Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 10 Queue Participation and Redirection : part_defn

part_defn
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.)
Structure
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)
Days of the week that users can participate in the specified queue_name. For example, -TWT-SS indicates every day except Monday or Friday.
Primary Key
The following primary key is defined for this table.
Foreign Keys
None.
Indexes
None.
Storage
The following STORAGE values are defined for this table.
Table Activity
The part_defn table contains one row for each participation record defined on the system.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.