KNTA_REPORT_SUBMISSIONS

This table stores the information about the report that a user submits for execution. A report submissions includes the report you are running along with any parameters for the report and scheduling information.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KNTA_REPORT_TYPES_NLS

REPORT_TYPE_ID

REPORT_TYPE_ID

KWFL_WORKFLOWS_NLS

WORKFLOW_ID

WORKFLOW_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REPORT_SUBMISSION_ID

NOT NULL

NUMBER

System-generated identifier

REPORT_TYPE_ID

NOT NULL

NUMBER

Report type identifier for this report submission

REPEAT_FLAG

NOT NULL

VARCHAR2(1)

Whether the report is scheduled for periodic executions

SCHEDULED_TIME

NULLABLE

DATE

Date/time when the report should run

REPEAT_UNTIL_DATE

NULLABLE

DATE

Date/time when the recurrence ends

RECURRENCE_PATTERN_CODE

NULLABLE

VARCHAR2(30)

Hours, days, weeks, and so on. A knta_lookup type

REPEAT_FREQUENCY

NULLABLE

NUMBER

How often the report needs to run repeatedly

STATUS_CODE

NOT NULL

VARCHAR2(30)

Status of the report (running, failed, completed, scheduled)

WORKFLOW_ID

NOT NULL

NUMBER

Workflow identifier for the report submission. This ha the same value for all reports

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Foreign key to table knta_parameter_set_contexts

PARAMETER1-45

NULLABLE

VARCHAR2(200)

Report submission parameter for internal use

VISIBLE_PARAMETER1-45

NULLABLE

VARCHAR2(200)

Report submission parameter for display purpose

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

REPORT_NAME

NULLABLE

VARCHAR2(100)

Filename of the HTML report

RELEASE_DATE

NULLABLE

DATE

Date when report is release to run; required by workflow engine

PARAMETER46-50

NULLABLE

VARCHAR2(4000)

Report submission parameter for internal use

VISIBLE_PARAMETER46-50

NULLABLE

VARCHAR2(4000)

Report submission parameter for display purpose

SIMPLE_NOTIFICATION_ID

NULLABLE

NUMBER

A reference to the system controlled notification if the user has enabled it on a report

SUBMISSION_LANGUAGE

NULLABLE

VARCHAR2(40)

 

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_REPORT_SUBMISSIONS_N1

NONUNIQUE

1

REPORT_TYPE_ID,

KNTA_REPORT_SUBMISSIONS_N1 NONUNIQUE 2 CREATED_BY

KNTA_REPORT_SUBMISSIONS_U1

UNIQUE

1

REPORT_SUBMISSION_ID

Sequences

Sequence Name

Sequence Type

KNTA_REPORT_SUBMISSIONS_S

REPORT_SUBMISSION_ID