KINS_PATCHES

This table stores information about deployment of patches on the PPM Server (hotfixes), including the full list of files deployed as part of the hotfixes. It is populated when hotfixes are deployed using the kDeploy script.

Foreign Keys

This table does not have any Foreign Keys.

Column Descriptions

Column Name

Null?

Data Type

Description

DEPLOYMENT_ID

NULLABLE

VARCHAR2(100)

Hotfix name.

PATCH_DESC

NULLABLE

VARCHAR2(200)

Short description of the hotfix

INCIDENT_NUMBER

NULLABLE

VARCHAR2(20)

Incident number of the hotfix, if any

DEFECT_NUMBER

NULLABLE

VARCHAR2(40)

Defect number of the hotfix, if any

FILE_PATH

NULLABLE

VARCHAR2(200)

Path of the file deployed in the bundle

FILE_FROM

NULLABLE

VARCHAR2(20)

Indicates whether the file path is from FILESYSTEM or from deployed HOTFIX

DEPLOY_DATE

NULLABLE

DATE

Date the hotfix was deployed

MACHINE_NAME

NULLABLE

VARCHAR2(100)

HostName and path of PPM_HOME concatenated using '|'

PPM_VERSION

NULLABLE

VARCHAR2(10)

Version of PPM Center where the hotfix was deployed

FILE_SIZE

NULLABLE

NUMBER

Size of the file

Indexes

This table does not use any Indexes.

Sequences

This table does not use any Sequences.