Share this page

# KVER_REVISIONS

This table stores all of the revision information that happens with Version Control.

## Foreign Keys

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

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
REVISION_ID | NOT NULL | NUMBER | Unique ID for each revision
FILE_ID | NOT NULL | NUMBER | Unique ID for each file
LAST_UPDATED_BY | NOT NULL | VARCHAR2(30) | The last person to perform a check in
LAST_UPDATE_DATE | NOT NULL | DATE | Date of last check in
CREATED_BY | NOT NULL | VARCHAR2(30) | Person who created the file
CREATION_DATE | NOT NULL | DATE | Date the file was created
LOCKED_FLAG | NOT NULL | VARCHAR2(1) | Lock status of the file (Y/N)
REVISION_NUMBER | NOT NULL | VARCHAR2(30) | Revision number for the version of the file
LOG_MSG | NULLABLE | VARCHAR2(200) | Log message for each revision checked into the Version Control
DESCRIPTION | NULLABLE | VARCHAR2(200) | Description associated with the file
REFERENCE_ID | NULLABLE | VARCHAR2(30) | Reference number associated with each file (generally the Change Request number)
REFERENCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | Entity code associated with the reference type (generally a "1" for a package)

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KVER_REVISIONS_N1 | NONUNIQUE | 1 | FILE_ID
KVER_REVISIONS_N2 | NONUNIQUE | 1 | REVISION_NUMBER
KVER_REVISIONS_N3 | NONUNIQUE | 1 | LOCKED_FLAG
KVER_REVISIONS_U1 | UNIQUE | 1 | REVISION_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KVER_REVISIONS_S | REVISION_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: