KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

DEST_CREATED_BY

KNTA_USERS

USER_ID

DEST_LAST_UPDATED_BY

KNTA_USERS

USER_ID

DEST_USER_ID

KNTA_USER_SECURITY

USER_SECURITY_ID

DEST_USER_SECURITY_ID

KNTA_USERS_INT

TRANSACTION_ID

PARENT_TRANSACTION_ID

KNTA_SECURITY_GROUPS_NLS

SECURITY_GROUP_ID

SECURITY_GROUP_ID

KNTA_USERS

USER_ID

USER_ID

KNTA_USER_SECURITY

USER_SECURITY_ID

USER_SECURITY_ID

TRANSACTION_ID

NULLABLE

NUMBER

System-generated identifier

PARENT_TRANSACTION_ID

NULLABLE

NUMBER

Transaction ID of the parent table being imported

PARENT_TABLE_NAME

NULLABLE

VARCHAR2(30)

Indicates which table this entity was imported from

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 security group exists for the user

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. The value should initially be set to 1

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record in the source

CREATED_BY_USERNAME

NULLABLE

VARCHAR2(200)

USERNAME from the KNTA_USERS table for Identifier for the user who is performing the transaction. This will be used only if the CREATED_BY is null.

CREATION_DATE

NULLABLE

DATE

Date record was created

DEST_CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record in the destination

DEST_CREATION_DATE

NULLABLE

DATE

Date the record is created in the destination

DEST_LAST_UPDATED_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 LAST_UPDATED_USERNAME.

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_SECURITY_ID

NULLABLE

NUMBER

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

DEST_USER_SECURITY_ID

NULLABLE

NUMBER

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

USER_ID

NULLABLE

NUMBER

This is used to tie a record to a parent record in KNTA_USERS_INT. For existing users, this should refer to the USER_ID column in KNTA_USERS

DEST_USER_ID

NULLABLE

NUMBER

This is used to tie a record to a parent record in KNTA_USERS_INT. For existing users, this should refer to the USER_ID column in KNTA_USERS

SECURITY_GROUP_ID

NULLABLE

NUMBER

Identifier of the security group the user is linked to

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.

LOGON_IDENTIFIER

NULLABLE

VARCHAR2(200)

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

USERNAME

NULLABLE

VARCHAR2(200)

Username of the user. LOGON_IDENTIFIER and USERNAME can have either one or both are filled. In the case of both these columns are filled, LOGON_IDENTIFIER is used as identifier while USERNAME will be an attribute.

SECURITY_GROUP_NAME

NULLABLE

VARCHAR2(200)

Security Group Name that the user is going to associate with. The security group is allowed to not exist in the system yet.

USER_SECURITY_ACTION

NULLABLE

VARCHAR2(30)

Import Action for a user security. The values can be 'ADD', 'DROP', 'ADD/DROP', and 'OVERWRITE'.

DATA_LANG

NULLABLE

VARCHAR2(40)

KNTA_USER_SECURITY_INT_N1

NONUNIQUE

1

USERNAME

KNTA_USER_SECURITY_INT_N1

NONUNIQUE

2

GROUP_ID

KNTA_USER_SECURITY_INT_N2

NONUNIQUE

1

LOGON_IDENTIFIER

KNTA_USER_SECURITY_INT_N2

NONUNIQUE

2

GROUP_ID

KNTA_USER_SECURITY_INT_N3

NONUNIQUE

1

DEST_USER_ID

KNTA_USER_SECURITY_INT_N3

NONUNIQUE

2

GROUP_ID

KNTA_USER_SECURITY_INT_N4

NONUNIQUE

1

GROUP_ID

KNTA_USER_SECURITY_INT_U1

NONUNIQUE

1

TRANSACTION_ID