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 |