Environment > Env Tokens

The prefix for these tokens is ENV.

Table A-9. Environment > Env (ENV) tokens

Tokens

Description

CLIENT_BASE_PATH

Base (root) path of the client.

CLIENT_CON_PROTOCOL

Protocol used to connect to this client.

CLIENT_CON_PROTOCOL_MEANING

Visible value of the client connect protocol.

CLIENT_ENABLED_FLAG

Flag that indicates whether the client portion of the environment is enabled.

CLIENT_NAME

DNS name or IP address of the client computer.

CLIENT_NT_DOMAIN

Domain name for the client, if the client machine is running Windows.

CLIENT_PASSWORD

Password PPM uses to log on to or access the client. This value is encrypted.

CLIENT_SQL_COMMAND

Default command line SQL*Plus command name.

CLIENT_STREAM_ENCODING

Encoding used to send messages and commands to or decode messages from this client.

CLIENT_TYPE_CODE

Validation value code of the client machine type.

CLIENT_USERNAME

Username PPM uses to log on to or access the client.

CLIENT_TRANSFER_PROTOCOL

Protocol used to transfer files to or from this client.

CLIENT_TRANSFER_PROTOCOL_MEANING

Visible value of the client transfer protocol.

CREATED_BY

ID of the user who created the environment.

CREATION_DATE

Date the environment was created.

DATABASE_ENABLED_FLAG

Flag that indicates whether the database portion of the environment is enabled.

DATABASE_TYPE

Validation value code of the database type.

DB_CONNECT_STRING

For Oracle database type, the connect string used to access the database from the command line.

DB_JDBC_URL

JDBC URL used in Oracle 9i RAC configuration.

DB_LINK

For Oracle database type, the database link from the PPM schema to the environment's database schema.

DB_NAME

DNS name or IP address of the database server.

DB_ORACLE_SID

For Oracle database type, the SID of the database (often the same as the DB_CONNECT_STRING).

DB_PASSWORD

Encrypted password that PPM uses to log on to or access the database.

DB_PORT_NUMBER

For Oracle database type, the port number on which SQL*Net is listening for remote SQL connections on the database server.

DB_USERNAME

Username or schema name PPM uses to log on to or access the database.

DB_VERSION

Database version (such as 8.1.7).

DESCRIPTION

Environment description.

ENABLED_FLAG

Flag that Indicates whether the environment is enabled and available for use in workflows.

ENVIRONMENT_ID

ID of the environment in the table KENV_ENVIRONMENTS.

ENVIRONMENT_NAME

Environment name.

LAST_UPDATED_BY

ID of the user who last updated the environment.

LAST_UPDATE_DATE

Date the environment was last updated.

LOCATION

Environment location.

MSSQL_DB_NAME

For a Microsoft SQL Server database type, the database name used to access the database from the command line.

SERVER_BASE_PATH

Base (root) path of the server.

SERVER_CON_PROTOCOL

Protocol used to connect to this server.

SERVER_CON_PROTOCOL_MEANING

Visible value of the server connection protocol.

SERVER_ENABLED_FLAG

Flag that indicates whether the server portion of the environment is enabled.

SERVER_NAME

DNS name or IP address of the server computer.

SERVER_NT_DOMAIN

Domain name for the server, if the server machine type is Windows.

SERVER_PASSWORD

Encrypted password that PPM uses to log on to or access the server.

SERVER_SQL_COMMAND

Default command line SQL*Plus command name.

SERVER_STREAM_ENCODING

Encoding used to send messages and commands to or decode messages from this server.

SERVER_TRANSFER_PROTOCOL

Protocol used to transfer files to or from this server.

SERVER_TRANSFER_PROTOCOL_MEANING

Visible value of the server transfer protocol.

SERVER_TYPE_CODE

Validation value code of the server machine type.

SERVER_USERNAME

Username PPM uses to log on to or access the server.

WORKBENCH_ENVIRONMENT_URL

URL to access the Environment window for this environment in the PPM Workbench.