| Field | Nullable | Data type | Constraint | Description |
|---|
ID | NOT NULL | NUMERIC | Primary Key | |
SCHEDULER_ID | NOT NULL | VARCHAR | | corresponds to SCHEDULER_ORDER_HISTORY.SCHEDULER_ID |
HISTORY_ID | NOT NULL | NUMERIC | | corresponds to SCHEDULER
SCHEDULER_ORDER_HISTORY.HISTORY_ID (triggers, executions) orSCHEDULER_HISTORY.ID (tasks)
|
REFERENCE_ID | NOT NULL | NUMERIC | Foreign Key | references REPORTING_TRIGGERS.ID or -
REPORTING_EXECUTIONS.ID or
REPORTIN |
REFERENCE_TYPE | NOT NULL | NUMERIC | | type of reference: 0: references REPORTING_TRIGGERS1: references REPORTING_EXECUTIONS2: references REPORTING_TASKS
|
START_DAY | NOT NULL | NUMERIC | | calendar day e.g. 1 |
START_WEEK | NOT NULL | NUMERIC | | calendar week e.g. 52 |
START_MONTH | NOT NULL | NUMERIC | | calendar month e.g. 12 |
START_QUARTER | NOT NULL | NUMERIC | | quarter e.g. 1 |
START_YEAR | NOT NULL | NUMERIC | | year e.g. 2015 |
END_DAY | NOT NULL | NUMERIC | | calendar day e.g. 1 |
END_WEEK | NOT NULL | NUMERIC | | calendar week e.g. 52 |
END_MONTH | NOT NULL | NUMERIC | | calendar month e.g. 12 |
END_QUARTER | NOT NULL | NUMERIC | | quarter e.g. 1 |
END_YEAR | NOT NULL | NUMERIC | | calendar year e.g. 2015 |
CREATED | NOT NULL | DATETIME | | UTC timestamp of record creation |
MODIFIED | NOT NULL | DATETIME | | UTC timestamp of record modification |