KDEM_DEMAND_SET_REQ_TYPES

This table is the link between the various demand entities like request types (and task category, and so on in future) and demand set.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KDEM_DEMAND_SETS

DEMAND_SET_ID

DEMAND_SET_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

DEMAND_SET_REQ_TYPE_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

DEMAND_SET_ID

NOT NULL

NUMBER

Identifier that identifies which demand set is associated with the demand set request type

REQUEST_TYPE_ID

NOT NULL

NUMBER

Identifier that identifies what type of request is associated with the demand set

Indexes

Index Name

Index Type

Sequence

Column Name

KDEM_DEMAND_SET_REQ_TYPES_U1

UNIQUE

1

DEMAND_SET_REQ_TYPE_ID

KDEM_DEMAND_SET_REQ_TYPES_U2

UNIQUE

1

DEMAND_SET_ID

KDEM_DEMAND_SET_REQ_TYPES_U2

UNIQUE

2

REQUEST_TYPE_ID

Sequences

Sequence Name

Sequence Type

KDEM_DEMAND_SET_REQ_TYPES_S

DEMAND_SET_REQ_TYPE_ID