Skip to main content
Skip table of contents

S_ID_USR_StaffAssignments_C (ver 17.8.0)

This table is a child table of USERS.

Column Name

Version

Data Type

Description

unique_id

17.8.0

Number(11,0)

Record ID Migrated from [ID_StaffAssignments.unique_ID].

schoolID

17.8.0

Number(11,0)

School ID Migrated from [ID_StaffAssignments.schoolID].

foreignKey

17.8.0

Number(11,0)

Reserved for future use. Migrated from [ID_StaffAssignments.foreignKey].

foreignKey_alpha

17.8.0

Varchar2(31)

Reserved for future use. Migrated from [ID_StaffAssignments.foreignKey_alpha].

AssignmentCode

17.8.0

Varchar2(6)

Assignment Code Migrated from [ID_StaffAssignments.user_defined_text].

PeriodNumber 

17.8.0

Number(11,0)

Period Number Migrated from [ID_StaffAssignments.user_defined_integer].

EffectiveDate

17.8.0

Date

Effective Date Migrated from [ID_StaffAssignments.user_defined_date].

EndDate

17.8.0

Date

End Date Migrated from [ID_StaffAssignments.user_defined_date2].

FTE

17.8.0

Number(25,10)

Full Time Equivalency Migrated from [ID_StaffAssignments.FTE].

ClassLevel

17.8.0

Varchar2(3)

Class Level Migrated from [ID_StaffAssignments.ID_ClassLevel].

ContractNo

17.8.0

Number(11,0)

Contract Number Migrated from [ID_StaffAssignments.ID_ContractNo].

CourseStandards

17.8.0

Varchar2(3)

Course Standards Migrated from [ID_StaffAssignments.ID_CourseStandards].

CRDCFteFactor

17.8.0

Number(1,0)

CRDC FTE Factor Migrated from [ID_StaffAssignments.ID_CRDCFteFactor].

GradeLevel

17.8.0

Varchar2(2)

Grade Level Migrated from [ID_StaffAssignments.ID_GradeLevel].

HQDate

17.8.0

Date

HQ Date Migrated from [ID_StaffAssignments.ID_HQDate].

HQT

17.8.0

Varchar2(3)

HQT Migrated from [ID_StaffAssignments.ID_HQT].

InstructionalSetting

17.8.0

Varchar2(2)

Instructional Setting Migrated from [ID_StaffAssignments.ID_InstructionalSetting].

NoncertRate

17.8.0

Number(25,10)

Non-Cert Rate Migrated from [ID_StaffAssignments.ID_NoncertRate].

NoncertHours

17.8.0

Number(25,10)

Non-Cert Hours Migrated from [ID_StaffAssignments.ID_NoncertHours].

NoncertWeeks

17.8.0

Number(25,10)

Non-Cert Weeks Migrated from [ID_StaffAssignments.ID_NoncertWeeks].

QualOverride

17.8.0

Varchar2(2)

Qual Override Migrated from [ID_StaffAssignments.ID_QualOverride].

TeachingRole

17.8.0

Varchar2(3)

Teaching Role Migrated from [ID_StaffAssignments.ID_TeachingRole].

TeacherID

17.8.0

Number(11,0)

Teacher Id Migrated from [ID_StaffAssignments.teacherId].

JavaScript errors detected

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

If this problem persists, please contact our support.