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