Share this page

# KNTA_DOCUMENTS

This table stores data for documents such as file size, author, description, checked out user and date.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_PARAM_SET_FIELDS_NLS | PARAMETER_SET_FIELD_ID | DOCUMENT_HOLDER_ID
KNTA_PARAM_SET_FIELDS_NLS | PARAMETER_SET_FIELD_ID | DOCUMENT_TYPE_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_ENTITIES_NLS | ENTITY_ID | PARENT_ENTITY_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
DOCUMENT_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user that created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user that last updated the record
NAME | NOT NULL | VARCHAR2(200) | File name minus extension
EXTENSION | NULLABLE | VARCHAR2(50) | Extension
CHECKED_OUT_BY | NULLABLE | NUMBER | User id
CHECKED_OUT_DATE | NULLABLE | DATE | Date
CHECKED_IN_BY | NOT NULL | NUMBER | User id
CHECKED_IN_DATE | NOT NULL | DATE | Date
DESCRIPTION | NULLABLE | VARCHAR2(1800) | Description
AUTHOR | NULLABLE | VARCHAR2(200) | Author, free-form text
FILESIZE | NOT NULL | NUMBER | File size
VERSION_NUMBER | NOT NULL | NUMBER | Version number
KEYWORDS | NULLABLE | VARCHAR2(1800) | Key words
VERSION_COMMENT | NULLABLE | VARCHAR2(200) | Version comment
PARENT_ENTITY_ID | NULLABLE | NUMBER | For example, request
PARENT_PRIMARY_KEY | NULLABLE | NUMBER | For example, containing request ID
DOCUMENT_TYPE_ID | NULLABLE | VARCHAR2(30) | Reference or component
DOCUMENT_HOLDER_ID | NULLABLE | NUMBER | Component index (for example, Field ID of a request)
MIGRATION_STATUS | NOT NULL | NUMBER | This field is only used during DMS Migration: 0 = not migrated, 1 = in the queue for migration, 2 = migrated successfully, 3 = migration failed
LAST_FLAGGED_TIME | NOT NULL | DATE | This field is only used during DMS Migration. It contains the date at which the document was put in the documents migration queue, and is used to detect migration timeouts.
ENGINE_UUID | NULLABLE | VARCHAR2(128) | This field is only used during DMS Migration. It contains an ID uniquely identifying the PPM Node on which migration is running.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_DOCUMENTS_N1 | NONUNIQUE | 1 | PARENT_ENTITY_ID
KNTA_DOCUMENTS_N1 | NONUNIQUE | 2 | PARENT_PRIMARY_KEY
KNTA_DOCUMENTS_N2 | NONUNIQUE | 1 | DOCUMENT_TYPE_ID
KNTA_DOCUMENTS_N2 | NONUNIQUE | 2 | DOCUMENT_HOLDER_ID
KNTA_DOCUMENTS_U1 | UNIQUE | 1 | DOCUMENT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_DOCUMENTS_S | DOCUMENT_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: