Share this page

# KENV_ENVIRONMENTS

This table stores all of the base information defined for each environment.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KACC_ACCELERATORS_NLS | ACCELERATOR_ID | DEFAULT_ACCELERATOR_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
--- | --- | --- | ---
ENVIRONMENT_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
ENVIRONMENT_NAME | NOT NULL | VARCHAR2(80) | Name of the environment
DESCRIPTION | NULLABLE | VARCHAR2(240) | Description of the environment
LOCATION | NULLABLE | VARCHAR2(240) | Physical location of the machine (used for reporting only)
SERVER_NAME | NULLABLE | VARCHAR2(100) | DNS name or IP Address of the server.
SERVER_TYPE_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'SERVER_TYPE_CODE'; defines the operating system of the server
SERVER_USERNAME | NULLABLE | VARCHAR2(30) | Default username used when connecting via FTP, SCP, Telnet, or SSH to the machine
SERVER_PASSWORD | NULLABLE | VARCHAR2(200) | (ENCRYPTED) Password used when connecting to the machine
SERVER_NT_DOMAIN | NULLABLE | VARCHAR2(80) | Domain of the Windows NT server
SERVER_BASE_PATH | NULLABLE | VARCHAR2(80) | Initial path for this environment; the server will change to this directory after successfully connecting
SERVER_CON_PROTOCOL | NULLABLE | VARCHAR2(30) | Lookup code for 'CONNECTION_PROTOCOL'; defines the protocol for interaction connections to this server
SERVER_TRANSFER_PROTOCOL | NULLABLE | VARCHAR2(30) | Lookup code for 'TRANSFER_PROTOCOL'; defines the protocol for file transfers to and from this server
CLIENT_NAME | NULLABLE | VARCHAR2(100) | DNS name or IP address of the client
CLIENT_TYPE_CODE | NULLABLE | VARCHAR2(30) | Lookup code for 'SERVER_TYPE_CODE' ; defines the operating system of the client.
CLIENT_USERNAME | NULLABLE | VARCHAR2(30) | Default username used when connecting via FTP, SCP, Telnet, or SSH to the machine
CLIENT_PASSWORD | NULLABLE | VARCHAR2(200) | (ENCRYPTED) Password used when connecting to the machine
CLIENT_NT_DOMAIN | NULLABLE | VARCHAR2(80) | NT Domain of the client machine
CLIENT_BASE_PATH | NULLABLE | VARCHAR2(80) | Initial path for this environment; the client will change to this directory after successfully connecting
CLIENT_CON_PROTOCOL | NULLABLE | VARCHAR2(30) | Lookup code for 'CONNECTION_PROTOCOL'; defines the protocol for interaction connections to this client
CLIENT_TRANSFER_PROTOCOL | NULLABLE | VARCHAR2(30) | Lookup code for 'TRANSFER_PROTOCOL'; defines the protocol for file transfers to and from this client
DB_NAME | NULLABLE | VARCHAR2(100) | Database name for this environment's associated database
DB_ORACLE_SID | NULLABLE | VARCHAR2(30) | $ORACLE_SID for the database
DB_CONNECTION_STRING | NULLABLE | VARCHAR2(30) | Connection string (from tnsnames.ora) for the database
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_VERSION | NULLABLE | VARCHAR2(40) | Database version for the database (used for reporting only)
DB_LINK | NULLABLE | VARCHAR2(130) | Database link
DB_PORT_NUMBER | NULLABLE | NUMBER | Port number -- used mainly in environment comparison
DATABASE_TYPE | NOT NULL | VARCHAR2(40) | Type of database. Current valid values include Oracle, SQL Server
MSSQL_DB_NAME | NULLABLE | VARCHAR2(30) | Name of database (for SQL Server)
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Determines whether this environment can serve as a source or destination database for a workflow
SERVER_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Whether or not to enable server for this environment
CLIENT_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Whether or not to enable client for this environment
DATABASE_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Whether or not to enable database for this environment
DEFAULT_ACCELERATOR_ID | NULLABLE | NUMBER | Default accelerator associated with the environment
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
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
DB_JDBC_URL | NULLABLE | VARCHAR2(2000) | the database jdbc URL
SERVER_STREAM_ENCODING | NULLABLE | VARCHAR2(40) |
CLIENT_STREAM_ENCODING | NULLABLE | VARCHAR2(40) |

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KENV_ENVIRONMENTS_U1 | UNIQUE | 1 | ENVIRONMENT_ID
KENV_ENVIRONMENTS_U2 | UNIQUE | 1 | ENVIRONMENT_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KENV_ENVIRONMENTS_S | ENVIRONMENT_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: