Share this page

# KREL_DISTRIBUTIONS

Table containing Distributions created from the Release Screen.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KREL_RELEASES | RELEASE_ID | RELEASE_ID
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_ID
KWFL_WORKFLOWS_NLS | WORKFLOW_ID | WORKFLOW_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
DISTRIBUTION_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
RELEASE_ID | NOT NULL | NUMBER | Release ID. Refers to KREL_RELEASES.
DISTRIBUTION_NAME | NOT NULL | VARCHAR2(80) | Unique name within a Release.
STATUS_CODE | NOT NULL | VARCHAR2(30) | Status within Distribution's workflow. LOOKUP_TYPE = 'WF_PARENT_STATUS'
WORKFLOW_ID | NULLABLE | NUMBER | Workflow ID. Refers to KWFL_WORKFLOWS.
FEEDBACK_FLAG | NOT NULL | VARCHAR2(1) | Whether FEEDBACK_CODE was fed back to original package lines.
FEEDBACK_CODE | NULLABLE | VARCHAR2(30) | Value to feed back to original Package Lines. LOOKUP_TYPE = 'RM - Ready for Release'
DESCRIPTION | NULLABLE | VARCHAR2(240) | Free-form description of the distribution.
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
--- | --- | --- | ---
KREL_DISTRIBUTIONS_N1 | NONUNIQUE | 1 | RELEASE_ID
KREL_DISTRIBUTIONS_U1 | UNIQUE | 1 | DISTRIBUTION_ID
KREL_DISTRIBUTIONS_U2 | UNIQUE | 1 | DISTRIBUTION_NAME
KREL_DISTRIBUTIONS_U2 | UNIQUE | 2 | RELEASE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KREL_DISTRIBUTIONS_S | DISTRIBUTION_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: