Share this page

# KRML_VIEW_DEF_TEMPLATES

This table contains information about existing RML View Definition Templates. The Reporting Meta Layer uses this table to store information about existing View Templates, and to keep track of changes made since the last RML synchronization.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KRML_PARAMETER_SET_FLDS_COPY | PARAMETER_SET_ID | DRIVING_PARAMETER_SET
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
VIEW_DEF_TEMPLATE_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
TEMPLATE_FILE_NAME | NOT NULL | VARCHAR2(200) | Name of the text file that stores this template
VIEW_CATEGORY_ID | NULLABLE | NUMBER | (Future Use Only) Category this template belongs to
VIEW_NAME_PREFIX | NULLABLE | VARCHAR2(10) | Prefix for all RML views generated by this template, if this template represents a driving context
STATIC_VIEW_NAME | NULLABLE | VARCHAR2(30) | Full name of the RML view if this template does not represent a driving context
SOURCE | NOT NULL | VARCHAR2(30) | Source of this template
DRIVING_PARAMETER_SET | NULLABLE | NUMBER | PARAMETER_SET_ID that drives the creation of multiple RML views, if this template represents a driving context

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KRML_VIEW_DEF_TEMPLATES_PK | UNIQUE | 1 | VIEW_DEF_TEMPLATE_ID
KRML_VIEW_DEF_TEMPLATES_U1 | UNIQUE | 1 | TEMPLATE_FILE_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
KRML_VIEW_DEF_TEMPLATES_S | VIEW_DEF_TEMPLATE_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: