TeacherPreference (ver10.0.0)
This table contains preference settings for teachers which typically override a school preference setting.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AssignmentSortOption | 10.0.0 | Varchar2(30) | The sort order to display assignments. Valid values: Latest, Oldest, CategoryLatest, CategoryOldest. Defaults to Latest. Required. |
| CalcDirectionInitState | 24.5.0 | Varchar2(30) | Determines whether auto-calculate assignment standard scores for new assignments starts out checked or unchecked. Valid values: Set=Checked. UnSet=unchecked. Defaults to null (i.e. unchecked). |
| IsCalcHelpFullClassShown | 24.5.0 | Number(1,0) | Determines whether to show the Professional Judgement Indicator help information on the Standards Final Grades pages. 1=Yes, 0=No. Defaults to 1. Required. |
| IsCalcHelpStudentShown | 24.5.0 | Number(1,0) | Determines whether to show the Professional Judgement Indicator help information on the Student Standards Progress page. 1=Yes, 0=No. Defaults to 1. Required. |
IsLetterGradeDisplayed | 10.0.0 | Number(1,0) | Indicates if the traditional letter or numeric grade is displayed. Valid values: 1=Yes, 0=No. Defaults to 1. Required. |
IsNewStudAddedToBottom | 10.0.0 | Number(1,0) | Indicates if new students are sorted to the bottom. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
IsPercentDisplayed | 10.0.0 | Number(1,0) | Indicates if the traditional grade percent is displayed. Valid values: 1=Yes, 0=No. Defaults to 1. Required. |
IsPointsEarnedDisplayed | 10.0.0 | Number(1,0) | Indicates if the traditional grade points earned and points possible is displayed. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
IsPreRegStudentHidden | 10.0.0 | Number(1,0) | Indicates if pre-registered students are hidden. Valid values: 1=Yes, 0=No. Defaults to 0. Required. |
| IsStandardsLimited | 22.5.0 | Number(1,0) | Indicates whether to Limit Assignment Standard Selection to Lowest Level. Valid values: 1=Yes, 0=No, NULL - not defined. Defaults to NULL. |
IsStandardsShown | 10.0.0 | Number(1,0) | Indicates if the standards pages appear in the gradebook. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsStandardsShownOnAsgmt | 10.0.0 | Number(1,0) | Indicates if teachers are able to associate standards to assignments. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
IsTraditionalGradeShown | 10.0.0 | Number(1,0) | Indicates if the traditional grades appear in the gradebook. Valid values: 1=Yes, 0=No, Null. Defaults to Null. |
OverlayMask | 10.0.0 | Number(16,0) | Bit mask where each bit controls whether an overlay is displayed on a PowerTeacher Pro page. Defaults to 0. Required. |
SectionNames | 10.0.0 | Varchar2(30) | Defines how sections are differentiated/displayed for teachers at a school. Valid values: PeriodAndDay, SectionNumber, Alphabetical, Custom, CustomPeriodDay. Defaults to Null. |
StandardTraditionalOrder | 10.0.0 | Varchar2(30) | When both traditional and standards grades are used, indicate which grade appears first in the gradebook. Valid values: TraditionalFirst=Order by Traditional then Standards, StandardsFirst=Order by Standards then Traditional, Null. Defaults to Null. |
| StartingPageKey | 21.11.0.0 | Varchar2(254) | The URL specified in StartingPageURL may contain one or more pages that can be displayed. This StartingPageKey uniquely identifies the page to display as the starting page. |
| StartingPageURL | 21.11.0.0 | Varchar2(1024) | The URL for the page that the teacher has selected as their starting page when they log in to the teacher portal. If not set, the teacher will start on the Assignment List page. |
StudentNameDisplayOption | 10.0.0 | Varchar2(30) | Indicates the student name display option. Valid values: Last_First, Last_First_Initial, Last_First_Middle, First_Last, First_Initial_Last, First_Middle_Last. Defaults to Last_First. Required. |
StudentSortOption | 10.0.0 | Varchar2(30) | The sort order to display students. Valid values: Last_Name, First_Name, GradeLevel_FirstName, GradeLevel_LastName, Teacher_Defined_Order. Defaults to Last_Name. Required. |
TeacherPreferenceID | 10.0.0 | Number(16,0) | Primary key. Unique sequential number generated by PowerSchool. Required. Indexed. |
UsersDCID | 10.0.0 | Number(10,0) | Foreign key. Internal number for the associated users DCID record. Required. Indexed. |
WhenCreated | 10.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 10.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 10.0.0 | Varchar2(100) | The user login that created the record. Defaults to the database user. Required. |
WhoModified | 10.0.0 | Varchar2(100) | The user login that modified the record. Defaults to the database user. Required. |