Share this page

# KDLV_OBJECT_TYPES

This table stores the base information for all of the objects defined in Deliver. This includes Migration Objects, AOL objects, Report Objects, and Custom objects.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KACC_ACCELERATORS_NLS | ACCELERATOR_ID | ACCELERATOR_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
OBJECT_TYPE_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
OBJECT_TYPE_NAME | NOT NULL | VARCHAR2(150) | Name of the object type
ACCELERATOR_ID | NULLABLE | NUMBER | Accelerator associated with the object type
OBJECT_CATEGORY | NOT NULL | VARCHAR2(30) | Lookup code for 'OBJECT_CATEGORY' can be 'REP', 'MIG', or 'AOL'
OBJECT_NAME_COLUMN | NULLABLE | VARCHAR2(30) | Parameter column name that stores the defined object name
OBJECT_REVISION_COLUMN | NULLABLE | VARCHAR2(30) | Parameter column name that stores the defined object revision
DESCRIPTION | NULLABLE | VARCHAR2(240) | Free form text describing the object type.
OM_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Used to sequence the migration of AOL objects
OM_SEQ_NUM | NULLABLE | NUMBER | Used to sequence the migration of AOL objects.
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Determines whether this object may be used on a change request
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
MDL_VIEW_NAME_ROOT | NULLABLE | VARCHAR2(20) | Defines the root part of an MDL view name for this object type. The term root is borrowed from linguist terms such that a word can have prefix, root and suffix. The system will try to default to the object type name if possible.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KDLV_OBJECT_TYPES_U1 | UNIQUE | 1 | OBJECT_TYPE_ID
KDLV_OBJECT_TYPES_U2 | UNIQUE | 1 | OBJECT_TYPE_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KDLV_OBJECT_TYPES_S | OBJECT_TYPE_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: