School_Course_Sched_Parm, 154 (ver4.0.0)
Specific scheduling parameters as related to school course. This is used mostly by Auto Walk-in scheduling and is a one to one relationship to School_Course table.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Allow_Std_Rpt_Diff_Term | 4.0.0 | Number(10,0) | Populated from ScheduleCourseCatalogs:Sched_RepeatsAllowed. Indicates whether or not repeating this course is allowed in a different term - True/ False/Blank. |
Allow_Std_Rpt_Same_Term | 4.0.0 | Number(10,0) | Populated from ScheduleCourseCatalogs:Sched_OverlapAllowed. Indicates whether or not overlapping in the same term is allowed - True/False/Blank. |
Balance_Priority | 4.0.0 | Varchar(10) | Populated from ScheduleCourseCatalogs:Sched_BalancePriority. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Global_Substitution1 | 4.0.0 | Varchar(10) | Populated from ScheduleCourseCatalogs:Sched_GlobalSubstitution1 and must be a valid course number in [Courses] that is associated to the current school. Indexed. |
Global_Substitution2 | 4.0.0 | Varchar(10) | Populated from ScheduleCourseCatalogs:Sched_GlobalSubstitution2 and must be a valid course number in [Courses] that is associated to the current school. Indexed. |
Global_Substitution3 | 4.0.0 | Varchar(10) | Populated from ScheduleCourseCatalogs:Sched_GlobalSubstitution3 and must be a valid course number in [Courses] that is associated to the current school. Indexed. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Load_Priority | 4.0.0 | Number(10,0) | Populated from ScheduleCourseCatalogs:Sched_LoadPriority. 0 - 99. |
Load_Type | 4.0.0 | Varchar(15) | Populated from ScheduleCourseCatalogs:Sched_LoadType - Required. Valid values: Academic - Elective - Alt1 - Alt2 - Alt3 - Alt4 - Alt5. |
Lunch_Course | 4.0.0 | Number(10,0) | Populated from ScheduleCourseCatalogs:Sched_LunchCourse. |
School_Course_ID | 4.0.0 | Number(10,0) | The internal number for the School Course with which this record is associated. Indexed. |
Substitution_Allowed | 4.0.0 | Number(10,0) | Populated from ScheduleCourseCatalogs:Sched_SubstitutionAllowed - True/ False/Blank. |
Use_Section_Types | 4.0.0 | Number(10,0) | Populated from ScheduleCourseCatalogs:Sched_UseSectionTypes - True/ False/Blank. |
Use_Team | 4.0.0 | Number(10,0) | Populated from ScheduleCourseCatalogs:Sched_UsePreestablishedTeams - True/False/Blank. |