Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: