Sections, 3 (ver3.6.1)
Section maintains occurrences of courses in a period and other related information such as Teacher and Grade level.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Attendance | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. Keeps a record of the days a teacher has taken attendance. The data stored is a space or a + so it is not easily understood from looking at it. The first space is the first day of the course and each place there after is a day. A blank means no attendance taken. In version 4.0 started using Attendance_Taken table instead. |
Attendance_Type_Code | 3.6.1 | Number(10,0) | Meeting attendance recording mode.
|
Bitmap | 3.6.1 | BLOB | A binary string holding the actual schedule for the class. Some can understand this string, but the schedule expression is the text representation of this. |
Blockperiods_Obsolete | 3.6.1 | Varchar2(20) | Used for backward compatibility. These indicate the block of periods this section spans. Changed to Expressions. |
BuildID | 3.6.1 | Number(10,0) | The internal number for the build associated with this section. |
CCRNArray | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. Maintains an array of internal record numbers for each Current Class (CC) enrollment record. |
CampusID | 3.6.1 | Number(10,0) | No longer used by the application, but still used for copying purposes. |
Comment_Value | 3.6.1 | CLOB | Any comments entered in the scheduling area for this section. Copied from ScheduleSection table. Note: The column name was renamed from Comment to Comment_Value in ver5.2.0. |
Course_Number | 3.6.1 | Varchar2(20) | The course number associated with this section. Indexed. |
Custom | 3.6.1 | CLOB | Stores Section related custom fields and their data. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Primary Key. Required. Indexed. |
Days_Obsolete | 3.6.1 | Varchar2(7) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Dependent_Secs | 3.6.1 | CLOB | Text string holding the course numbers of dependent sections. |
DistUniqueID | 3.6.1 | Number(10,0) | The unique number for this section district-wide. Used for delta download. |
ExcludeFromClass Rank | 3.6.1 | Number(10,0) | Indicates whether this section should be excluded during class ranking. Valid values:
|
ExcludeFromGPA | 3.6.1 | Number(10,0) | Indicates whether this section should be excluded during GPA calculations. Valid values:
|
ExcludeFromHon orRoll | 3.6.1 | Number(10,0) | Indicates whether this section should be excluded during Honor Roll calculations. Valid values:
|
ExcludeFromStoredGrades | 5.0.0 | Number(10,0) | Indicates whether this section should be excluded during the Permanently Store Grades function. Valid values: 0, 1, 2.
Defaults to 0. |
Exclude_ ADA | 4.0.0 | Number(10,0) | Changed name from NoAttendance to better reflect this column in 4.0. Flag indicating if this section is used in the ADA/ADM calculation or not. Valid values:
|
Exclude_State_Rpt_YN | 4.0.0 | Number(10,0) | Indicates whether or not to include this section record in a state report - migrated from custom fields. |
Expression | 3.6.1 | Varchar2(80) | The internal schedule expression for the section, which is a representation of the day and period it is offered. May contain multiple if offered over several days, such as 2(A) would be read as 2nd period A days. |
External_Expression | 11.0.0 | Varchar2(200) | The external schedule expression for the section is similar to the expression (internal) however the external expression is represented using the school/year period and day abbreviations. Populated for Sections.TermID >= 2500. |
FastPerList | 3.6.1 | Varchar2(11) | Stored string representation of term ID + Period for the section for query purposes. Indexed. |
GradeProfile | 3.6.1 | Varchar2(11) | Used for Delta communication. |
GradeScaleID | 3.6.1 | Number(10,0) | The grade scale associated with the section; could be the same as the one for the course. |
Grade_Level | 3.6.1 | Number(10,0) | Maintains the grade level for the section. |
GradebookType | 9.0.0 | Number(10,0) | Indicates which gradebook is associated to this section. Valid values: Null, 1, 2. Null=Legacy, 1=This section is used by PTG, 2=This section is used by PowerTeacher Pro. |
House | 4.0.0 | Varchar2(10) | This field identifies the house to which the section is assigned, if any, and is necessary to continue support of scheduling students by house in Automated Walk-In scheduling. This field will be captured during the PowerScheduler commit process from ScheduleSections:House. There is no current effort identified to expose this field for editing or viewing in PowerAdmin. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Instruction_Lang | 4.0.0 | Varchar2(40) | Currently only used by State Reporting. Maintains the language of instruction for this section. |
LastAttUpdate | 3.6.1 | Date | The date a teacher last took attendance in this class using either PowerTeacher or PowerGrade. Indexed. |
Log | 3.6.1 | CLOB | Used with AutoComm for determining which duplicate section to use or not. |
MaxCut | 4.0.0 | Number(10,0) | This field identifies whether or not enrollment of new students should be allowed after the max enrollment Sections:MaxEnrollment has been reached. This is necessary to support max enrollment in Automated Walk-In scheduling. This field will be captured during the PowerScheduler commit process from ScheduleSections:MaxCut. |
MaxEnrollment | 3.6.1 | Number(10,0) | The maximum number of students for this particular section. |
Max_Load_Status | 5.0.1 2 | Varchar2(24) | Used to identify those teachers who are scheduled to teach more students in a day than is allowed by their contract. |
NoOfTerms | 3.6.1 | Number(10,0) | The number of terms this particular section spans. |
No_of_Students | 3.6.1 | Number(10,0) | The number of students currently enrolled in this section. |
Original_Expression | 3.6.1 | Varchar2(80) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PGFlags | 3.6.1 | CLOB | This field holds all the PowerGrade flags for this particular section. |
PGVersion | 4.0.0 | Number(10,0) | Changed datatype from Integer to Integer in 4.0. The version of PowerGrade the teacher is using. |
PSGUID | 7.8.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. Indexed. |
Parent_S ection_ID | 3.6.1 | Number(10,0) | If sections are separated for attendance purposes, this holds the parent section ID that contains the full Expression in Original Expression column. This the main row used for grading and other calculations. For parent row this is 0. Indexed. |
Period_Obsolete | 3.6.1 | Varchar2(7) | Used for backward compatibility. These indicate the period for this section. Changed to Expressions. Indexed. |
ProgramID | 4.0.0 | Number(10,0) | Foreign key to the Programs table. Indexed. |
Room | 3.6.1 | Varchar2(10) | The room number the section is in. This is not presently tied to PowerScheduler, so it will need to be imported or entered manually. Indexed. |
RosterModSer | 3.6.1 | Number(10,0) | Roster-modified serial number. This number is incremented by one each time a sections roster is changed. PowerGrade checks to see if the numbers match. If not, the roster and serial number are synchronized. |
ScheduleSectionID | 3.6.1 | Number(10,0) | Internal number of the schedule section associated with this section. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. Indexed. |
SectionInfo_guid | 4.0.0 | Varchar2(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
Section_ Number | 3.6.1 | Varchar2(10) | The number for this section. While it is an alpha field, it is strongly recommended that numbers are used for this field. Indexed. |
Section_ Type | 4.0.0 | Varchar2(2) | This field identifies the section type for a section as assigned during the build process in PowerScheduler. Capturing it in PowerAdmin as part of the commit process for PowerScheduler is necessary to maintain scheduling by section types in Automated Walk-In scheduling. This field is populated by the ScheduleSections SectionType column. |
SortOrder | 4.0.0 | Number(10,0) | Attendance sort order. Indexed. |
Teacher | 3.6.1 | Number(10,0) | The internal ID of the associated primary section teacher record for this particular section. Indexed. |
TeacherDescr | 3.6.1 | CLOB | The teachers' description for the class entered in PowerGrade that appears in PowerSchool Parent. |
Team | 4.0.0 | Varchar2(10) | This field identifies the team to which the section is assigned, if any, and is necessary to continue support of scheduling students by team in Automated Walk-In scheduling. This will be captured during the PowerScheduler commit process from ScheduleSections:Team. |
TermID | 3.6.1 | Number(10,0) | The internal number for the term for this section. Indexed. |
TrackTeacherAtt | 3.6.1 | Number(10,0) | Designates if this section should be included when referencing the teacher table report. |
WhereTaught | 3.6.1 | Number(10,0) | A field for the USOE report. School ID of where this section is being taught if other than current school. 0=Current School. |
WhereTaughtDistrict | 3.6.1 | Number(10,0) | District ID of where this section is being taught if other than current district. 0=CurrentDistrict. |