Share this page
KWFL_RESOLVED_SEC_TOKENS
This table stores values of resolved security tokens (defined in Workflow Step Security) from Requests and Packages. Resolved security tokens can be either a User ID or a Security Group ID only.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_ENTITIES_NLS |
ENTITY_ID |
ENTITY_ID |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KNTA_SECURITY_GROUPS_NLS |
SECURITY_GROUP_ID |
SECURITY_GROUP_ID |
|
KCRT_REQUESTS |
REQUEST_ID |
SOURCE_ID |
|
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
SOURCE_ID |
|
KDLV_PACKAGES |
PACKAGE_ID |
SOURCE_SET_ID |
|
KCRT_REQUESTS |
REQUEST_ID |
SOURCE_SET_ID |
|
KNTA_USERS |
USER_ID |
USER_ID |
|
KWFL_WORKFLOW_STEP_SECURITY |
WORKFLOW_STEP_SECURITY_ID |
WORKFLOW_STEP_SECURITY_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
RESOLVED_SEC_TOKEN_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
|
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
SOURCE_SET_ID |
NOT NULL |
NUMBER |
Package ID or Request ID which uses this resolved token |
|
SOURCE_ID |
NULLABLE |
NUMBER |
Package Line ID or Request ID which uses this resolved token (value of -1 signify Package without Package Line) |
|
ENTITY_ID |
NOT NULL |
NUMBER |
Either Request Entity or Package Line Entity |
|
WORKFLOW_STEP_SECURITY_ID |
NOT NULL |
NUMBER |
Step Security which resolved value is stored here |
|
SECURITY_TYPE_CODE |
NOT NULL |
VARCHAR2(80) |
Type of Step Security |
|
USER_ID |
NULLABLE |
NUMBER |
Contains User ID if the token resolved to a User ID |
|
SECURITY_GROUP_ID |
NULLABLE |
NUMBER |
Contains Security Group ID if the token resolved to a Security Group ID |
|
OBSOLETE_FLAG |
NULLABLE |
VARCHAR2(3) |
Temporary flag used internal (should be set to N) |
|
TOKEN |
NULLABLE |
VARCHAR2(80) |
Token which resolved value is stored here |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KWFL_RESOLVED_SEC_TOKENS_N2 |
NONUNIQUE |
1 |
USER_ID |
|
KWFL_RESOLVED_SEC_TOKENS_N3 |
NONUNIQUE |
1 |
SECURITY_GROUP_ID |
|
KWFL_RESOLVED_SEC_TOKENS_N4 |
NONUNIQUE |
1 |
WORKFLOW_STEP_SECURITY_ID |
|
KWFL_RESOLVED_SEC_TOKENS_N5 |
NONUNIQUE |
1 |
TOKEN |
|
KWFL_RESOLVED_SEC_TOKENS_N6 |
NONUNIQUE |
1 |
SOURCE_SET_ID |
|
KWFL_RESOLVED_SEC_TOKENS_N6 |
NONUNIQUE |
2 |
ENTITY_ID |
|
KWFL_RESOLVED_SEC_TOKENS_N6 |
NONUNIQUE |
3 |
USER_ID |
|
KWFL_RESOLVED_SEC_TOKENS_U1 |
UNIQUE |
1 |
RESOLVED_SEC_TOKEN_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KWFL_RESOLVED_SEC_TOKENS_S |
RESOLVED_SEC_TOKEN_ID |
