KENV_ENV_APPS

This table stores all of the data for the applications associated with each environment. The APP_CODE field is used by developers when adding lines to a change request. This defines the username, password, and path that PPM Center will use in its process of moving a file. It also stores database schema and db_link information which is used for execution of SQL scripts or any other custom-defined, database-level objects.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KENV_ENVIRONMENTS

ENVIRONMENT_ID

ENVIRONMENT_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

USER_DATA_SET_CONTEXT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

ENV_APP_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

APP_CODE

NOT NULL

VARCHAR2(30)

ode for the application

APP_NAME

NOT NULL

VARCHAR2(80)

Full name of the application

ENVIRONMENT_ID

NOT NULL

NUMBER

System-generated identifier

SERVER_BASE_PATH

NULLABLE

VARCHAR2(80)

Initial path for this environment; the server will change to this directory after successfully connecting

SERVER_USERNAME

NULLABLE

VARCHAR2(30)

Default username used when connecting via FTP or Telnet to the machine

SERVER_PASSWORD

NULLABLE

VARCHAR2(200)

(ENCRYPTED) Password used when connecting to the machine

CLIENT_USERNAME

NULLABLE

VARCHAR2(30)

Default username used when connecting via FTP or Telnet to the machine

CLIENT_PASSWORD

NULLABLE

VARCHAR2(200)

(ENCRYPTED) Password used when connecting to the machine

CLIENT_BASE_PATH

NULLABLE

VARCHAR2(80)

Initial path for this environment; the client will change to this directory after successfully connecting

DB_USERNAME

NULLABLE

VARCHAR2(30)

Default username for connecting to or executing scripts against the database

DB_PASSWORD

NULLABLE

VARCHAR2(200)

(ENCRYPTED) Password used when connecting to or executing scripts against the database

DB_LINK

NULLABLE

VARCHAR2(130)

Database link from the schema to the "apps" user on this database

DB_NAME

NULLABLE

VARCHAR2(30)

Database name used for SQL Server only

DESCRIPTION

NULLABLE

VARCHAR2(240)

Description of the environment

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Determines whether this environment can serve as a source or destination database for a workflow

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

KENV_ENV_APPS_N1

NONUNIQUE

1

APP_CODE

KENV_ENV_APPS_U1

UNIQUE

1

ENV_APP_ID

KENV_ENV_APPS_U2

UNIQUE

1

ENVIRONMENT_ID

KENV_ENV_APPS_U2

UNIQUE

2

APP_CODE

Sequences

Sequence Name

Sequence Type

KENV_ENV_APPS_S

ENV_APP_ID