KENV_ENV_GROUPS
The main table is for the environment groups. It stores information regarding the name of the environment group, description, the enabled status, and whether executions should be executed in parallel or serial.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
ENV_GROUP_ID |
NOT NULL |
NUMBER |
System-generated identifier |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
ENTITY_LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date a record in the entity was last updated |
ENV_GROUP_NAME |
NOT NULL |
VARCHAR2(100) |
Name of the environment group |
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Flag to determine whether the environment group is currently enabled |
PARALLEL_FLAG |
NOT NULL |
VARCHAR2(1) |
Flag to determine whether environment executions should take place in parallel or serially |
DESCRIPTION |
NULLABLE |
VARCHAR2(240) |
Description of the environment group |
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 |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KENV_ENV_GROUPS_U1 |
UNIQUE |
1 |
ENV_GROUP_ID |
KENV_ENV_GROUPS_U2 |
UNIQUE |
1 |
ENV_GROUP_NAME |
Sequences
Sequence Name |
Sequence Type |
---|---|
KENV_ENV_GROUPS_S |
ENV_GROUP_ID |