Skip to main content
Skip table of contents

TeacherPreference (ver10.0.0)

This table contains preference settings for teachers which typically override a school preference setting.

Column NameInitial VersionData TypeDescription

AssignmentSortOption

10.0.0

Varchar2(30)

The sort order to display assignments. Valid values: Latest, Oldest, CategoryLatest, CategoryOldest. Defaults to Latest. 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.

IsStandardsLimited22.5.0Number(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.

SectionsDCID

10.0.0

Number(10,0)

Foreign key. Internal number for the associated sections DCID record. Indexed.

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.

StartingPageKey21.11.0.0Varchar2(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.
StartingPageURL21.11.0.0Varchar2(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.





JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.