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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: