KCRT_FG_PROG_REFERENCE

If the 'Program Reference field on Request' field group is linked to a request's request header type, a row will exist in this table for the request.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NOT NULL

NUMBER

Request identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type used by the request

REF_PROGRAM_ID

NULLABLE

NUMBER

ID of the referenced program. If a value is supplied, automatically creates a reference to the specified program. If supplied, REF_PROGRAM_NAME must also be supplied.

REF_PROGRAM_NAME

NULLABLE

VARCHAR2(255)

Name of the referenced program. If a value is supplied, automatically creates a reference to the specified program. If supplied, REF_PROGRAM_ID must also be supplied.

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_PROG_REFERENCE_U1

UNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.