KNTA_USERS_INT

This table is the Open Interface Table for the import of Users into the database. Users can be populated from any external source that can populate this table. This table can also be populated from an LDAP source. The import is controlled by the User Interface Report.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KACC_ACCELERATORS_NLS

ACCELERATOR_ID

DEFAULT_ACCELERATOR_ID

KNTA_USERS

USER_ID

DEST_CREATED_BY

KNTA_USERS

USER_ID

DEST_LAST_UPDATED_BY

KNTA_USERS

USER_ID

DEST_USER_ID

KNTA_USER_PROFILES

USER_PROFILE_ID

DEST_USER_PROFILE_ID

KNTA_SCREENS_NLS

SCREEN_ID

SCREEN_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TRANSACTION_ID

NULLABLE

NUMBER

System-generated identifier

GROUP_ID

NULLABLE

NUMBER

A value from KNTA_INTERFACE_GROUPS_S. Is used to group together all records to be processed together.

EXISTS_FLAG

NULLABLE

VARCHAR2(1)

Used to indicate if the user already exists in the system

PROCESS_PHASE

NULLABLE

NUMBER

Indicates the current stage of the record as it is being processed

PROCESS_STATUS

NULLABLE

NUMBER

Indicates the current disposition of the record

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record. The value should initially be set to 1.

CREATED_BY_USERNAME

NULLABLE

VARCHAR2(200)

User that created the record in the source

CREATION_DATE

NULLABLE

DATE

Date record was created

DEST_CREATED_BY

NULLABLE

NUMBER

USER_ID from the KNTA_USERS table for Identifier for the user who is performing the transaction. If null, the column is derived from CREATED_BY_USERNAME or set to the user currently running the report

DEST_CREATION_DATE

NULLABLE

DATE

Date that the transaction is performed

DEST_LAST_UPDATED_BY

NULLABLE

NUMBER

Identifier for the user who last updated the record

DEST_LAST_UPDATE_DATE

NULLABLE

DATE

Date that the transaction is performed

DEST_ENTITY_UPD_DATE

NULLABLE

DATE

Date that the transaction is performed

USER_ID

NULLABLE

NUMBER

Unique identifier for the user

DEST_USER_ID

NULLABLE

NUMBER

Internal identifier for a user. This should normally be left blank and will be defaulted from KNTA_USERS_S. If a value is entered, it should be derived from KNTA_USERS_S sequence

USERNAME

NULLABLE

VARCHAR2(200)

Name of the user in the source

DEST_USERNAME

NULLABLE

VARCHAR2(200)

Username that will be used to Logon

PASSWORD

NULLABLE

VARCHAR2(200)

Password for the user (will be defaulted from the report)

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

NULLABLE

VARCHAR2(80)

User's first name

LAST_NAME

NULLABLE

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 ID of 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

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 of the user. If user being imported from LDAP server, then will be automatically set to LDAP otherwise will be set to KINTANA

SCREEN_ID

NULLABLE

NUMBER

Optional. Will be given a default value. Determines which screen is shown when the user logs on first

SHORTCUT_BAR_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether the shortcut bar is shown in the screen manager

SHORTCUT_BAR_LOC_CODE

NULLABLE

VARCHAR2(4)

Optional. Will be given a default value. Determines the position within the screen manager where the shortcut bar is displayed

SAVE_WINDOW_BOUNDS_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether the size and location of the screen manager window are saved each time the user logs off; if saved, the settings are the default when the user next logs on

WINDOW_HEIGHT

NULLABLE

NUMBER

Optional. Will be given a default value. Determines the default height of the screen manager window

WINDOW_WIDTH

NULLABLE

NUMBER

Optional. Will be given a default value. Determines the default width of the screen manager window

WINDOW_X_LOCATION

NULLABLE

NUMBER

Optional. Will be given a default value. Determines the horizontal position of the screen manager window

WINDOW_Y_LOCATION

NULLABLE

NUMBER

Optional. Will be given a default value. Determines the vertical position of the screen manager window

REUSE_INTERNAL_FRAME_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether multiple internal frames can be opened within each screen

SHOW_ALL_WORKFLOW_STEPS_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether all workflow steps are shown within workflow status panes

SHOW_TRAVERSED_STEPS_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether steps that have been traversed and are no longer active are shown within workflow status panes

NUM_BRANCH_STEPS_TO_SHOW

NULLABLE

NUMBER

Optional. Will be given a default value. Determines how many steps of each branch are shown within workflow status panes, if a currently active workflow step leads to several branches

NUM_KNOWN_REACH_STEPS_TO_SHOW

NULLABLE

NUMBER

Optional. Will be given a default value. Determines how many steps of a non-branching path are shown within workflow status panes

HIDE_IMMEDIATE_STEPS_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether workflow steps based upon immediate executions and conditions are shown within workflow status panes

SHOW_CHANGE_WARNINGS_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether warning messages are displayed when you update a business entity that is used by another entity (for example, when you update a workflow that is used by a change request line)

HIDE_CANCELLED_CRL_FLAG

NULLABLE

VARCHAR2(1)

Optional. Will be given a default value. Determines whether cancelled package lines are displayed in the Packages screen.

DEFAULT_BROWSER

NULLABLE

VARCHAR2(300)

Default browser associated with the user

DEST_USER_PROFILE_ID

NULLABLE

NUMBER

Should be left blank. Will be derived from KNTA_USER_PROFILES_S

COMPANY

NULLABLE

VARCHAR2(40 CHAR)

This is used to associate a user with a company

LOGON_IDENTIFIER

NULLABLE

VARCHAR2(200)

Logon ID of the user. Used when the server 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)

Contact number for the User.

COST_RATE

NULLABLE

NUMBER

Dollar amount that this User costs the company per hour.

WORKLOAD_CAPACITY

NULLABLE

NUMBER

% of the workday the Resource can be scheduled for work within the system.

MAX_ROWS_PORTLETS

NULLABLE

NUMBER

Default number or rows that this user should see in a Portlet

DEPARTMENT_CODE

NULLABLE

VARCHAR2(40 CHAR)

Lookup code for 'DEPT'

DEPARTMENT_MEANING

NULLABLE

VARCHAR2(80)

Lookup meaning for 'DEPT'

LOCATION_CODE

NULLABLE

VARCHAR2(40 CHAR)

Lookup code for 'RSC - Location'

LOCATION_MEANING

NULLABLE

VARCHAR2(80)

Lookup meaning for 'RSC - Location'

MANAGER_USER_ID

NULLABLE

NUMBER

ID of user who manages this User

MANAGER_USERNAME

NULLABLE

VARCHAR2(200)

Username corresponding to the manager.

MANAGER_LOGON_IDENTIFIER

NULLABLE

VARCHAR2(200)

Logon Identifier (as defined in the KNTA_USERS table) corresponding to the manager.

RESOURCE_CATEGORY_CODE

NULLABLE

VARCHAR2(40 CHAR)

Lookup code for 'RSC - Resource Category'

RESOURCE_CATEGORY_MEANING

NULLABLE

VARCHAR2(80)

Lookup meaning for 'RSC - Resource Category'

RESOURCE_TITLE_CODE

NULLABLE

VARCHAR2(40 CHAR)

Lookup code for 'RSC - Resource Title'

RESOURCE_TITLE_MEANING

NULLABLE

VARCHAR2(80)

Lookup code for 'RSC - Resource Category'

PRODUCT_ID_LIST

NULLABLE

VARCHAR2(200)

List of products (licenses) to associate this user with.

LABOR_CATEGORY_CODE

NULLABLE

VARCHAR2(120)

LABOR_CATEGORY_MEANING

NULLABLE

VARCHAR2(320)

DATA_LANG

NULLABLE

VARCHAR2(40)

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_USERS_INT_N1

NONUNIQUE

1

USERNAME

KNTA_USERS_INT_N1

NONUNIQUE

2

GROUP_ID

KNTA_USERS_INT_N2

NONUNIQUE

1

LOGON_IDENTIFIER

KNTA_USERS_INT_N2

NONUNIQUE

2

GROUP_ID

KNTA_USERS_INT_N3

NONUNIQUE

1

DEST_USER_ID

KNTA_USERS_INT_N3

NONUNIQUE

2

GROUP_ID

KNTA_USERS_INT_N4

NONUNIQUE

1

DEST_USERNAME

KNTA_USERS_INT_N4

NONUNIQUE

2

GROUP_ID

KNTA_USERS_INT_N5

NONUNIQUE

1

SYS_NC00111$

KNTA_USERS_INT_N6

NONUNIQUE

1

GROUP_ID
KNTA_USERS_INT_N7 NONUNIQUE 1 CREATION_DATE

KNTA_USERS_INT_U1

NONUNIQUE

1

TRANSACTION_ID

Sequences

This table uses no sequences.