Share this page

# KDLV_RESPONSES

This table stores the prompts and responses used by the special command 'ksc_respond'. Currently, this table is seeded to only work with Patch*Applicator (adpatch and adadmin). The 'ksc_respond' can support responses to generic programs requiring interactivity, but no seeded data is supplied.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KDLV_RESPONSES | RESPONSE_ID | PARENT_RESPONSE_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
RESPONSE_ID | NOT NULL | NUMBER | System-generated identifier
PARENT_RESPONSE_ID | NULLABLE | NUMBER | Used to link multi-line prompts, including menu prompts
MODULE | NOT NULL | VARCHAR2(40) | Currently, this field is either 'ADPATCH' or 'ADADMIN_<function>'. With the VERSION value, this column identifies a unique set of responses to use during processing. In order to use Patch*Applicator, the value must begin with 'ADADMIN' or 'ADPATCH'.
VERSION | NOT NULL | VARCHAR2(40) | System-generated version for the entity. This column must not be updated manually
PROMPT_TYPE | NOT NULL | VARCHAR2(240) | Identifies the prompt type. (A command parameter, multi-line prompt, sql response, token response, value, menu item)
PROMPT | NOT NULL | VARCHAR2(240) | Prompt to search for
RESPONSE | NULLABLE | VARCHAR2(500) | Response that will be issued if the prompt is found
ENCRYPT_FLAG | NOT NULL | VARCHAR2(1) | Signifies the response should be encrypted (for example, a password)
EXIT_FLAG | NOT NULL | VARCHAR2(1) | Exit after processing this prompt
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NULLABLE | NUMBER | Identifier for the user who last updated the record
NEXT_MODULE | NULLABLE | VARCHAR2(40) | Next module to respond to (used when interacting with menus)
NEXT_VERSION | NULLABLE | VARCHAR2(40) | Next version to respond to (used when interacting with menus)
BUFFER_LINES | NULLABLE | NUMBER | Number of buffered lines to search for a menu item
EXECUTION_FLAG | NULLABLE | VARCHAR2(1) | Whether or not this is an execution (used when interacting with menus). If this value is Y, the next menu found will cause ksc_respond to load a new set of responses per the NEXT_MODULE and NEXT_VERSION values
ACTION | NULLABLE | VARCHAR2(200) | Show the action taken in conjunction with this response. Action is in addition to the normal response processing.
DEFAULT_PROMPT_TYPE | NULLABLE | VARCHAR2(240) | What form does the default prompt take

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KDLV_RESPONSES_U1 | UNIQUE | 1 | RESPONSE_ID

## Sequences

This table uses no sequences.

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: