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 |