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 |