KNTA_SECURITY_GROUPS

This table stores the definitions for each of the security groups defined in PPM Center.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KRSC_ORG_UNITS_NLS

ORG_UNIT_ID

ORG_UNIT_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SECURITY_GROUP_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

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

SECURITY_GROUP_NAME

NULLABLE

VARCHAR2(200)

 

DESCRIPTION

NULLABLE

VARCHAR2(240)

 

RESTRICT_WF_FLAG

NULLABLE

VARCHAR2(1)

 

RESTRICT_APPCODE_FLAG

NULLABLE

VARCHAR2(1)

 

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

 

USED_BY_PACKAGES_FLAG

NULLABLE

VARCHAR2(1)

 

USED_BY_PROJECTS_FLAG

NULLABLE

VARCHAR2(1)

 

USED_BY_REQUESTS_FLAG

NULLABLE

VARCHAR2(1)

 

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

 

SOURCE

NULLABLE

VARCHAR2(100)

 

USER_DATA_SET_CONTEXT_ID

NULLABLE

NUMBER

Parameter set context identifier for the user data fields

USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

ORG_UNIT_ID

NULLABLE

NUMBER

 

CASCADING_FLAG

NOT NULL

VARCHAR2(1)

 

USED_BY_TIME_SHEETS_FLAG

NULLABLE

VARCHAR2(1)

 

RESTRICT_CHARGE_CODES_FLAG

NOT NULL

VARCHAR2(1)

 

DEFINITION_LANGUAGE

NOT NULL

VARCHAR2(40)

 

REFERENCE_CODE

NOT NULL

VARCHAR2(200)

 

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_SECURITY_GROUPS_N1

NONUNIQUE

1

ORG_UNIT_ID

KNTA_SECURITY_GROUPS_U1

UNIQUE

1

SECURITY_GROUP_ID

KNTA_SECURITY_GROUPS_U2

UNIQUE

1

SECURITY_GROUP_NAME

SYS_C00109353089

UNIQUE

1

REFERENCE_CODE

KNTA_SECURITY_GROUPS_NLS_IDX_1 NONUNIQUE 1 ENABLED_FLAG

Sequences

This table uses no sequences.