Share this page

# KRML_VIEWS

This table stores a record for each view that exists in the Reporting Meta Layer database schema. This table is for internal use only.

## Foreign Keys

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

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
VIEW_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 who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
VIEW_NAME | NOT NULL | VARCHAR2(30) | Name of this RML view to be updated, if applicable
EXISTING_VIEW_NAME | NULLABLE | VARCHAR2(100) | Name of this RML view as it currently exists
VIEW_DEF_TEMPLATE_ID | NOT NULL | NUMBER | ID of the template this view is based on.
DDL_ACTION | NOT NULL | VARCHAR2(50) | Action {CREATE, REPLACE, DROP} that will be taken on this view during synchronization of the Reporting Meta Layer
REASON_OF_DDL_ACTION | NULLABLE | VARCHAR2(200) | Brief reason for the DDL action, to be displayed in the synchronization report
STATUS | NOT NULL | VARCHAR2(20) | Status of the DDL action {PENDING, SUCCEED, FAILED, ERROR}
ERROR | NULLABLE | VARCHAR2(400) | Visible error message, if applicable
ORACLE_ERROR | NULLABLE | VARCHAR2(2000) | Oracle error associated with the error message, if applicable
LAST_SUCCESSFUL_SYNC_DATE | NULLABLE | DATE | Date this view was last successfully synchronized
BATCH_NUMBER | NULLABLE | NUMBER | Identifier for a batch of views that are being assessed or synchronized in a single synchronization report
UPDATE_DOC_FLAG | NULLABLE | VARCHAR2(1) | (Future use only) Indicator for whether this view's documentation needs to be updated
VIEW_COMMENTS | NULLABLE | VARCHAR2(2000) | Comments
DDL_STATEMENT | NULLABLE | CLOB | DDL statement used to take action on this RML view; displayed in synchronization report in case of error

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KRML_VIEWS_U1 | UNIQUE | 1 | VIEW_ID
KRML_VIEWS_U2 | UNIQUE | 1 | VIEW_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KRML_BATCH_NUMBER_S | BATCH_NUMBER
KRML_VIEWS_S | VIEW_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: