PSM_Section (ver1.0)
This table contains occurrences of courses in a period and other related information, such as teacher and grade level. Data duplicated here from the originating SIS.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Description | 1.0 | Varchar2(4000) | The description of the section. |
GradebookType | 2.8 | Number(10,0) | Indicates which grade book this section is located. Valid values: Null, 1, 2. Null=Legacy, 1=This section is used by PTG, 2=This section is used by PowerTeacher Pro. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. Indexed. |
IsEarnedVarCreditAllowed | 2.1 | Number(3,0) | Number(3) 1 indicates a variable credit value, also known as awarded credit, which may be submitted by the teacher. Allows teacher access to update. Required. |
IsPotentialVarCreditAllowed | 2.1 | Number(3,0) | Number(3) 1 indicates a potential credit value, also known as attempted credit, which may be submitted by the teacher. Allows teacher access to update. Required. |
Meeting | 1.5 | Varchar2(256) | Currently not used. |
RoomName | 1.5 | Varchar2(10) | Name of room used for the section. |
SchoolCourseID | 1.0 | Number(19,0) | Internal ID of the PSM_SchoolCourse record to which the record is associated. Indexed. |
SchoolID | 1.0 | Number(19,0) | Internal ID of the PSM_School record to which the record is associated. Required. Indexed. |
SectionIdentifier | 1.0 | Varchar2(30) | Section Number entered by administrator. Indexed. |
TermID | 1.0 | Number(19,0) | Internal ID of the PSM_Term record to which the record is associated. Required. Indexed. |