KNTA_REFRESH_GROUPS

This is a staging table used by the Environment Refresh process. It stores one record for each environment refresh run.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KENV_ENVIRONMENTS

ENVIRONMENT_ID

REFRESHED_ENV_ID

KNTA_USERS

USER_ID

CREATED_BY

KENV_ENVIRONMENTS

ENVIRONMENT_ID

FROM_ENV_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REFRESH_GROUP_ID

NULLABLE

NUMBER

System-generated identifier

REFRESH_GROUP_NAME

NULLABLE

VARCHAR2(80)

User given name for the refresh run

CREATION_DATE

NULLABLE

DATE

Date record was created

CREATED_BY

NULLABLE

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NULLABLE

DATE

Date record was last updated

LAST_UPDATED_BY

NULLABLE

NUMBER

Identifier for the user who last updated the record

ENTITY_LAST_UPDATE_DATE

NULLABLE

DATE

Date a record in the entity was last updated

REFRESHED_ENV_ID

NULLABLE

NUMBER

Identifier for the Environment which was refreshed

FROM_ENV_ID

NULLABLE

NUMBER

Identifier for the Environment from where the refresh was done

STATUS_CODE

NULLABLE

VARCHAR2(30)

Status of the refresh (OPEN/CLOSED)

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

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_REFRESH_GROUPS_N1

NONUNIQUE

1

REFRESHED_ENV_ID

KNTA_REFRESH_GROUPS_N1

NONUNIQUE

2

FROM_ENV_ID

KNTA_REFRESH_GROUPS_N2

NONUNIQUE

1

FROM_ENV_ID

KNTA_REFRESH_GROUPS_N2

NONUNIQUE

2

REFRESHED_ENV_ID

KNTA_REFRESH_GROUPS_U1

UNIQUE

1

REFRESH_GROUP_ID

Sequences

Sequence Name

Sequence Type

KNTA_REFRESH_GROUPS_S

REFRESH_GROUP_ID