ScheduledEvents Table

Applies to QAComplete 12.90 SaaS & On-Premises, last modified on September 09, 2021

Description

For any item that has scheduled events, the ScheduledEvents table contains a cross reference between a task (appointment, agile task, or to do list item) and a specific item, such as defect or requirement.

An item can have several scheduled events.

Columns

The table contains the following columns:

ScheduledEventId  :  int, primary key, allows null: no, default: auto-generated

The identifier of the scheduled event.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time when the item was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no, default: Current date and time

The date and time when the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

EntityCode  :  varchar (max 100 chars), allows null: no

The module where the scheduled item is located.

You can find correspondences between entity code values and related modules in Table of Entity Code Values.

FKId  :  int, allows null: no

The unique identifier of the associated item, such as BugId, FunctionalSpecId, and so on.

TaskId  :  int, allows null: no

The identifier of the associated task.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

ScheduledEvents View
Tasks Table
Agile Tasks

Highlight search results