KNTA_USER_SECURITY_INT

Open Interface Table for import of user security groups into the system tables.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
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

Column Descriptions

Column Name	Null?	Data Type	Description
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)

Indexes

Index Name	Index Type	Sequence	Column Name
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

Sequences

This table uses no sequences.