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