KNTA_USERS

This table stores the definition for each of the users who have access to PPM.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KDRV_CALENDARS

CALENDAR_ID

CALENDAR_ID

KNTA_USERS

USER_ID

CREATED_BY

KACC_ACCELERATORS_NLS

ACCELERATOR_ID

DEFAULT_ACCELERATOR_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_REGIONS_NLS

REGION_ID

REGION_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

USER_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

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

USERNAME

NOT NULL

VARCHAR2(200)

Username that will be used to log on

PASSWORD

NULLABLE

VARCHAR2(200)

(ENCRYPTED) The password for the user

PASSWORD_EXPIRATION_DAYS

NULLABLE

NUMBER

Number of days in which current password expires

PASSWORD_EXPIRATION_DATE

NULLABLE

DATE

Effective date when the password for user ID will expire

EMAIL_ADDRESS

NULLABLE

VARCHAR2(80)

E-Mail address of the user

FIRST_NAME

NOT NULL

VARCHAR2(80)

User's first name

LAST_NAME

NOT NULL

VARCHAR2(80)

User's last name

START_DATE

NULLABLE

DATE

Start date for the user

END_DATE

NULLABLE

DATE

End date for the user

DEFAULT_ACCELERATOR_ID

NULLABLE

NUMBER

Default accelerator associated with the user

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

AUTHENTICATION_MODE

NULLABLE

VARCHAR2(30)

Authentication mode (ITG or LDAP) for the user

SOURCE_TYPE_CODE

NULLABLE

VARCHAR2(30)

For records that have been updated by an interface or migrator, indicates the type of external update (specific interface or migrator name, and so on)

SOURCE

NULLABLE

VARCHAR2(100)

For records that have been updated by an interface or migrator, provides additional information about the source of the external update

COMPANY

NULLABLE

VARCHAR2(40 CHAR)

This is used to associate a user with a company

LOGON_IDENTIFIER

NOT NULL

VARCHAR2(200)

Logon ID of the user. Used when the system is started in LOGON_ID mode.

DOMAIN

NULLABLE

VARCHAR2(80)

WINDOWS domain to use when logging in. Used for NTLM Authentication Mode.

PHONE_NUMBER

NULLABLE

VARCHAR2(30)

This is used to associate a user with a phone number

DEPARTMENT_CODE

NULLABLE

VARCHAR2(40 CHAR)

This is used to associate a user with a department by means of a unique department identifier

LOCATION_CODE

NULLABLE

VARCHAR2(40 CHAR)

This is used to associate a user with a location by means of a unique location identifier

MANAGER_USER_ID

NULLABLE

NUMBER

This is used to associate a user with a manager by means of a unique manager identifier

RESOURCE_CATEGORY_CODE

NULLABLE

VARCHAR2(40 CHAR)

This is used to associate a user with a resource category by means of a unique resource category identifier

RESOURCE_TITLE_CODE

NULLABLE

VARCHAR2(40 CHAR)

This is used to associate a user with a department by means of a unique department identifier

FULL_NAME

NULLABLE

VARCHAR2(200)

Full name of the user

CALENDAR_ID

NOT NULL

NUMBER

Identifier of the Calendar in KDRV_CALENDARS that belongs to this user

REGION_ID

NOT NULL

NUMBER

Identifier of the Region in KNTA_REGIONS that this user uses

REGION_OVERRIDE_FLAG

NOT NULL

VARCHAR2(1)

This is Y if the user has a specific region directly set to override inheritance

RESOURCE_FLAG

NOT NULL

VARCHAR2(1)

This is Y if the user is also a resource.

LABOR_CATEGORY

NULLABLE

VARCHAR2(255)

Labor category

LANGUAGE NULLABLE VARCHAR2(255) The session language the user selects to use when working with PPM in SSO.

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_USERS_FI1

NONUNIQUE

1

SYS_NC00077$

KNTA_USERS_FI2

NONUNIQUE

1

SYS_NC00078$

KNTA_USERS_FI3

NONUNIQUE

1

SYS_NC00076$

KNTA_USERS_FI4

NONUNIQUE

1

SYS_NC00079$

KNTA_USERS_N1

NONUNIQUE

1

FIRST_NAME

KNTA_USERS_N2

NONUNIQUE

1

LAST_NAME

KNTA_USERS_N3

NONUNIQUE

1

MANAGER_USER_ID

KNTA_USERS_N5

NONUNIQUE

1

FULL_NAME

KNTA_USERS_N6

NONUNIQUE

1

DEPARTMENT_CODE

KNTA_USERS_N7

NONUNIQUE

1

CALENDAR_ID

KNTA_USERS_N9

NONUNIQUE

1

REGION_ID

KNTA_USERS_U1

UNIQUE

1

USER_ID

KNTA_USERS_U2

UNIQUE

1

USERNAME

KNTA_USERS_U3

UNIQUE

1

LOGON_IDENTIFIER

KNTA_USERS_U4 NONUNIQUE 1 (DECODE(SIGN(USER_ID - 9999), -1,USER_ID+100000000, USER_ID), USERNAME)

Sequences

Sequence Name

Sequence Type

KNTA_USERS_S

USER_ID