Share this page

# KVER_FILES

This table stores version control information of the files in the PPM system.

## Foreign Keys

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

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
FILE_ID | NOT NULL | NUMBER | System-generated identifier
LAST_UPDATED_BY | NOT NULL | VARCHAR2(30) | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
CREATED_BY | NOT NULL | VARCHAR2(30) | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
FILE_NAME | NOT NULL | VARCHAR2(66) | Name of the file
FILE_BASE | NOT NULL | VARCHAR2(50) | the base path of the file
FILE_EXT | NULLABLE | VARCHAR2(15) | the file extension
SUB_PATH | NOT NULL | VARCHAR2(50) | sub path of the file
APPLICATION | NOT NULL | VARCHAR2(50) | which application the file is associated with
LOCKED_FLAG | NOT NULL | VARCHAR2(1) | is the file locked
LOCKED_BY | NULLABLE | VARCHAR2(30) | who is it locked by
CURR_REVISION | NOT NULL | VARCHAR2(30) | the current revision of the file
DESCRIPTION | NULLABLE | VARCHAR2(200) | description of the file

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KVER_FILES_N1 | NONUNIQUE | 1 | FILE_NAME
KVER_FILES_N2 | NONUNIQUE | 1 | SUB_PATH
KVER_FILES_N3 | NONUNIQUE | 1 | APPLICATION
KVER_FILES_N4 | NONUNIQUE | 1 | CURR_REVISION
KVER_FILES_U1 | UNIQUE | 1 | FILE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KVER_FILES_S | FILE_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: