Share this page
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.
