KCRT_DEFAULTS_MATRIX

This table stores all the issue type defaults. This is the initial data that goes into the issue form as soon as the user selects an issue type.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

ASSIGNED_TO_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KNTA_SECURITY_GROUPS_NLS

SECURITY_GROUP_ID

ASSIGNED_TO_GROUP_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

Column Descriptions

Column Name

Null?

Data Type

Description

MATRIX_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

SEQ_NUM

NOT NULL

NUMBER

Indicates the sequence number of the record.

REQUEST_TYPE_ID

NOT NULL

NUMBER

Identifier for the issue type this is default is associated to

DEPARTMENT_CODE

NULLABLE

VARCHAR2(30)

Lookup Code for 'DEPT'

APPLICATION

NULLABLE

VARCHAR2(30)

Lookup code for 'APPLICATION'

ASSIGNED_TO_ID

NULLABLE

NUMBER

Identifier for the default assigned user for this record

ASSIGNED_TO_GROUP_ID

NULLABLE

NUMBER

Identifier for the default assigned group for this record

WORKFLOW_ID

NOT NULL

NUMBER

Identifier for the default link workflow for this record

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Indicates whether this default is available for use

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_DEFAULTS_MATRIX_N1

NONUNIQUE

1

REQUEST_TYPE_ID

KCRT_DEFAULTS_MATRIX_U1

UNIQUE

1

MATRIX_ID

Sequences

Sequence Name

Sequence Type

KCRT_DEFAULTS_MATRIX_S

MATRIX_ID