ITG_SETTINGS_ATTRIBUTES

This table stores the settings information of various entities such as Project Type and Programs.

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

SETTINGS_ATTRIBUTE_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

NAME

NOT NULL

VARCHAR2(255)

Defines name of the attribute

CLASSTYPE

NULLABLE

VARCHAR2(200)

Defines java type of the value

VALUE

NULLABLE

VARCHAR2(3999)

Defines value of the attribute

SOURCE

NULLABLE

VARCHAR2(255)

Defines source of the entity. Used by migrators

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(255)

Defines source type code of the entity. Used by migrators

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

Indexes

Index Name

Index Type

Sequence

Column Name

ITG_SETTINGS_ATTRIBUTES_N1

NONUNIQUE

1

NAME

SYS_C005201545

UNIQUE

1

SETTINGS_ATTRIBUTE_ID

Sequences

Sequence Name

Sequence Type

ITG_SETTINGS_ATTRIBUTES_S

SETTINGS_ATTRIBUTE_ID