Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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		INTEGER		NOT NULL,
    	queue_name	VARCHAR(24)	NOT NULL,
    	days_mask	VARCHAR(7)	NOT NULL,
    	start_time	SMALLINT	NOT NULL,
    	end_time	SMALLINT	NOT NULL,
    	style		VARCHAR(24)	NULL,
    	start_date	INTEGER		NOT NULL,
    	end_date	INTEGER		NOT NULL)

Column | Description
`part_id` | Unique ID for this participation record.
`queue_name` | Name of the queue that this participation record allows users to participate in, as defined in the user_names table.
`days_mask` | Days of the week that users can participate in the specified `queue_name`. For example, `-TWT-SS` indicates every day except Monday or Friday.
`start_time` | Time of day when participation starts.
`end_time` | Time of day when participation ends.
`style` | Not used. Reserved for possible future use.
`start_date` | Date on which participation starts.
`end_date` | Date on which participation ends.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_part_defn` | `part_id`

## Triggers

The following `DELETE CASCADE` trigger is defined for this table.

Trigger Name | Triggered by | Affects Table(s)
`tr_part_defn` | `DELETE` | part_list

## Indexes

None.

## 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.

A row is... | When...
added | a new participation record is added.
updated | an existing participation record is updated.
deleted | an existing participation record is deleted.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine