ScheduleBldSessions, 114 (ver3.6.1)
After the Scheduler Build is complete the file sent back and its information get stored in this table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
BuildID | 3.6.1 | Number(10,0) | The internal number for the Schedule Build with which this record is associated. |
BuildType | 3.6.1 | Varchar(20) | Type of the build category such as Optimize. |
Callback_ID | 3.6.1 | Number(10,0) | Identifier for scheduling engine tied to this scenario. |
Comment_Value | 3.6.1 | CLOB | Stores user comments entered on the Build Master Schedule Queue and Load Student Schedules Queue pages. |
Completed | 3.6.1 | Varchar(20) | Indicates whether the scenario was received from the engine successfully. |
DBFPath | 3.6.1 | CLOB | File path to the zip file coming back from the engine. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Diags | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
EngineIP | 3.6.1 | Varchar(20) | IP address where the engine is located. |
EnginePings | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
EnginePort | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ErrorLog | 3.6.1 | CLOB | Text returned by the engine indicating any errors met. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Input | 5.0.0 | CLOB | Stores the Input.zip file. |
IsBuild | 3.6.1 | Number(10,0) | Indicates whether this is a Build or Load. 1=Build. |
Reschedule | 3.6.1 | Number(10,0) | Indicates whether this is a reschedule of the selection of students. 1=yes. |
RescheduleStudentSelection | 3.6.1 | BLOB | Array of student IDs being sent back for rescheduling. |
Results | 3.6.1 | BLOB | The actual zip file with the dbfs and the error files returned by the engine. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Started | 3.6.1 | Number(10,0) | Indicates whether this was send to the engine. 1=yes. |
Success | 3.6.1 | Number(10,0) | Indicates whether the file was successfully returned. |
UserID | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Validateonly | 3.7.0 | Number(10,0) | Identifies whether the build process for which the session was created was run for validation purposes only. |