Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# case_deadline_event

The `case_deadline_event` table stores information about case deadlines when the case is running.

## Structure

The `case_deadline_event` table has the following structure:

    TABLE case_deadline_event (
    	node_id		INTEGER		NOT NULL,
    	proc_id		INTEGER		NOT NULL,
    	casenum		NUMERIC(20)	NOT NULL,
    	dead_id		VARCHAR(32)	NOT NULL,
    	dead_name	VARCHAR(32)	NOT NULL,
    	event_name	VARCHAR(32)	NOT NULL,
    	dead_value	VARCHAR(512)	NOT NULL)

Column | Description
`node_id` | ID of the node that this procedure is defined on, as defined in the nodes table.
`proc_id` | Unique ID of this procedure, generated from the sequences table.
`casenum` | The number of the case that this case deadline belongs to, as defined in the case_information table.
`dead_id` | For internal use only. This column is referenced from the `stepname` column in the outstanding_addr table.
`dead_name` | The name of the case deadline.
`event_name` | The name of the event step.
`dead_value` | The value of the case deadline when the case is running. The value is specified in one of the following formats:
| • | If the case deadline is specified as a period, then the value is in the format:
`minutes``^``hours``^``days``^``weeks``^``months``^``years`
| • | If the case deadline is specified as an expression, then the value is in the format:
`date expression``^``time expression`

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
pk_case_dl_event | node_id proc_id casenum dead_id

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_case_dl_event` 1 This key enforces the DELETE CASCADE referential action. | `casenum proc_id node_id` | case_information

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
`idx_case_dl_fk` | `casenum proc_id node_id`

## Table Activity

The `case_deadline_event` table contains one or more rows for each instance of each procedure definition on the system. Rows are added, updated, and deleted in the following situations.

A row is... | When...
added | If one of the following conditions occurs:
| • | A case is starting and its deadline is defined in the procedure.
| • | The `CreateCaseDeadline` expression is called in the EAI step.
updated | The `UpdateCaseDeadline` expression is called in the EAI step.
deleted | If one of the following conditions occurs:
| • | The `DeleteCaseDeadline` expression is called in the EAI step.
| • | The case deadline expired and an event is triggered.
| • | The case is closed.

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