DataImportTemplateSchedule (ver24.5.1.0)
The table stores the import template schedules associated with a template. One template can be associated with only one template schedule. Data gets entered into this table on scheduling an import template.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DATAIMPORTTEMPLATEID | 24.5.1.0 | NUMBER(19,0) | Foreign key. Associated to DATAIMPORTTEMPLATE table |
DATAIMPORTTEMPLATESCHEDULEID | 24.5.1.0 | NUMBER(19,0) | Primary Key of table. |
ISACTIVE | 24.5.1.0 | NUMBER(1,0) | Stores 1 if schedule is active, 0 instead. |
ISDISTRICT | 24.5.1.0 | NUMBER(1,0) | Stores 1 if at district level, 0 instead. |
PLUGINURLENDPOINTID | 24.5.1.0 | NUMBER(19,0) | Foreign key. Associated to PLUGINURLENDPOINT table |
SCHEDULEDAYSOFWEEK | 24.5.1.0 | VARCHAR2(100 CHAR) | Stores the days on which the template is scheduled. 1 represent template is scheduled on that day, 0 represents template id not scheduled on that day. the length is 7, each char represents a day. |
SCHEDULEEMAIL | 24.5.1.0 | VARCHAR2(4000 CHAR) | Stores email address. Schedule import report is send to this email. |
SCHEDULELASTRUNTIME | 24.5.1.0 | TIMESTAMP(6) | Timestamp at which the schedule was run last. |
SCHEDULEINPUT | 24.5.1.0 | VARCHAR2(500 CHAR) | Input source. |
SCHEDULEINPUTPATH | 24.5.1.0 | VARCHAR2(500 CHAR) | Path of file for import. |
SCHEDULEINPUTFILENAME | 24.5.1.0 | VARCHAR2(2000 CHAR) | Filename of the file which is being imported |
SCHEDULESTATUS | 24.5.1.0 | VARCHAR2(100 CHAR) | Status of scheduled import |
SCHEDULETIME | 24.5.1.0 | TIMESTAMP(6) | The time at which the template is scheduled. |
SCHOOL_NUMBER | 24.5.1.0 | NUMBER(10,0) | Stores the school number from which the schedule template was created. |
WHENCREATED | 24.5.1.0 | TIMESTAMP(6) | Date and time the record was created. Defaults to system date. Required. |
WHENMODIFIED | 24.5.1.0 | TIMESTAMP(6) | Date and time the record was modified. Defaults to system date. Required. |
WHOCREATED | 24.5.1.0 | VARCHAR2(305 CHAR) | The user login that created the record. Defaults to database user. Required. |
WHOMODIFIED | 24.5.1.0 | VARCHAR2(305 CHAR) | The user login that created the record. Defaults to database user. Required. |