KACC_ACCELERATORS

This table stores a row for each installed Accelerator. Installed Accelerators have the enabled_flag set to 'Y'.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

ACCELERATOR_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

ACCELERATOR_NAME

NOT NULL

VARCHAR2(80)

Long name of the Accelerator. It can contain spaces.

SHORT_NAME

NULLABLE

VARCHAR2(80)

An abbreviation of the accelerator name with no spaces

DESCRIPTION

NULLABLE

VARCHAR2(240)

Description of the Accelerator

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

'Y' if the Accelerator is installed, no otherwise.

VERSION

NULLABLE

VARCHAR2(10)

Release number of the Accelerator: 3.0.1 or 3.0.1.a. The first three digits correspond with the PPM Center release.

ORIGINAL_ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Not used. All values are 'N'

TOKEN_NAME_PREFIX

NOT NULL

VARCHAR2(20)

Prefix used for tokens in the Accelerator-specific Environment and User panels.

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2(40)

Language in which this Accelerator was created.

REFERENCE_CODE

NOT NULL

VARCHAR2(200)

Reference code

Indexes

Index Name

Index Type

Sequence

Column Name

KACC_ACCELERATORS_U1

UNIQUE

1

ACCELERATOR_ID

KACC_ACCELERATORS_U2

UNIQUE

1

ACCELERATOR_NAME

KACC_ACCELERATORS_U3

UNIQUE

1

SHORT_NAME

KACC_ACCELERATORS_U4

UNIQUE

1

TOKEN_NAME_PREFIX

SYS_C005196855

UNIQUE

1

REFERENCE_CODE

Sequences

This table uses no sequences.