Share this page
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 |
