Skip to main content
Skip table of contents

S_ID_USR_X (ver 15.7.3)

This is an extension of the Users table.

Column Name

Version

Data Type

Description

usersdcid

15.7.3

Number(10,0)

Foreign key to the users table

AddlCredits15.11.0Number(25,10)Migrated from [SchoolStaff.ID_addlCredits].
Addldegree115.11.0Varchar2(5)Migrated from [SchoolStaff.ID_addldegree1].
Addldegree215.11.0Varchar2(5)Migrated from [SchoolStaff.ID_addldegree2].
Addldegree315.11.0Varchar2(5)Migrated from [SchoolStaff.ID_addldegree3].
Addldegree415.11.0Varchar2(5)Migrated from [SchoolStaff.ID_addldegree4].
BaseSalary115.11.0Number(10,0)Migrated from [SchoolStaff.ID_BaseSalary1].
BaseSalary215.11.0Number(10,0)Migrated from [SchoolStaff.ID_BaseSalary2].
BaseSalary315.11.0Number(10,0)Migrated from [SchoolStaff.ID_BaseSalary3].
CertificationState15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_CertificationState].
CertificationYear15.11.0Number(10,0)Migrated from [SchoolStaff.ID_CertificationYear].
Citizen15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Citizen].
ClaimDegreeInst15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ClaimDegreeInst].
ClaimDegreeState15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ClaimDegreeState].
ClaimedMajor15.11.0Varchar2(15)Migrated from [SchoolStaff.ID_ClaimedMajor].
CompetencyDate15.11.0DateMigrated from [SchoolStaff.ID_CompetencyDate].
ContractDays115.11.0Number(10,0)Migrated from [SchoolStaff.ID_ContractDays1].
ContractDays215.11.0Number(10,0)Migrated from [SchoolStaff.ID_ContractDays2].
ContractDays315.11.0Number(10,0)Migrated from [SchoolStaff.ID_ContractDays3].
ContractFTE115.11.0Number(25,10)Migrated from [SchoolStaff.ID_ContractFTE1].
ContractFTE215.11.0Number(25,10)Migrated from [SchoolStaff.ID_ContractFTE2].
ContractFTE315.11.0Number(25,10)Migrated from [SchoolStaff.ID_ContractFTE3].
ContractHours115.11.0Number(10,0)Migrated from [SchoolStaff.ID_ContractHours1].
ContractHours215.11.0Number(10,0)Migrated from [SchoolStaff.ID_ContractHours2].
ContractHours315.11.0Number(10,0)Migrated from [SchoolStaff.ID_ContractHours3].
ContractType115.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ContractType1].
ContractType215.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ContractType2].
ContractType315.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ContractType3].
Degree1Institution15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree1Institution].
Degree1major15.11.0Varchar2(15)Migrated from [SchoolStaff.ID_Degree1major].
Degree1State15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree1State].
Degree1Year15.11.0Number(10,0)Migrated from [SchoolStaff.ID_Degree1Year].
Degree2Institution15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree2Institution].
Degree2major15.11.0Varchar2(15)Migrated from [SchoolStaff.ID_Degree2major].
Degree2State15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree2State].
Degree2Year15.11.0Number(10,0)Migrated from [SchoolStaff.ID_Degree2Year].
Degree3Institution15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree3Institution].
Degree3major15.11.0Varchar2(15)Migrated from [SchoolStaff.ID_Degree3major].
Degree3State15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree3State].
Degree3Year15.11.0Number(10,0)Migrated from [SchoolStaff.ID_Degree3Year].
Degree4Institution15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree4Institution].
Degree4major15.11.0Varchar2(15)Migrated from [SchoolStaff.ID_Degree4major].
Degree4State15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_Degree4State].
Degree4Year15.11.0Number(10,0)Migrated from [SchoolStaff.ID_Degree4Year].
DegreeYear15.11.0Number(10,0)Migrated from [SchoolStaff.ID_DegreeYear].
EmploymentStatus15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_EmploymentStatus].
EvalDate15.11.0DateMigrated from [SchoolStaff.ID_EvalDate].
EvalResults15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_EvalResults].
ExtraPay115.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ExtraPay1].
ExtraPay215.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ExtraPay2].
ExtraPay315.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ExtraPay3].
ExtraPay415.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ExtraPay4].
ExtraPayAmount115.11.0Number(10,0)Migrated from [SchoolStaff.ID_ExtraPayAmount1].
ExtraPayAmount215.11.0Number(10,0)Migrated from [SchoolStaff.ID_ExtraPayAmount2].
ExtraPayAmount315.11.0Number(10,0)Migrated from [SchoolStaff.ID_ExtraPayAmount3].
ExtraPayAmount415.11.0Number(10,0)Migrated from [SchoolStaff.ID_ExtraPayAmount4].
FormerNames15.11.0Varchar2(100)Migrated from [SchoolStaff.ID_FormerNames].
FundedFTE115.11.0Number(25,10)Migrated from [SchoolStaff.ID_FundedFTE1].
FundedFTE215.11.0Number(25,10)Migrated from [SchoolStaff.ID_FundedFTE2].
FundedFTE315.11.0Number(25,10)Migrated from [SchoolStaff.ID_FundedFTE3].
FundedFTE415.11.0Number(25,10)Migrated from [SchoolStaff.ID_FundedFTE4].
FundSource115.11.0Varchar2(5)Migrated from [SchoolStaff.ID_FundSource1].
FundSource215.11.0Varchar2(5)Migrated from [SchoolStaff.ID_FundSource2].
FundSource315.11.0Varchar2(5)Migrated from [SchoolStaff.ID_FundSource3].
FundSource415.11.0Varchar2(5)Migrated from [SchoolStaff.ID_FundSource4].
HEExperience15.11.0Number(25,10)Migrated from [SchoolStaff.ID_HEExperience].
HighestDegree15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_HighestDegree].
HireDate15.11.0DateMigrated from [SchoolStaff.ID_HireDate].
IdahoHEExperience15.11.0Number(25,10)Migrated from [SchoolStaff.ID_IdahoHEExperience].
IdahoK12Experience15.11.0Number(25,10)Migrated from [SchoolStaff.ID_IdahoK12Experience].
IdahoStaffID15.11.0Varchar2(20)Migrated from [SchoolStaff.ID_IdahoStaffID].
IncStuPerf15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_IncStuPerf].
IsCertified15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_IsCertified].
IsParapro15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_IsParapro].
IsTitleParaPro15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_IsTitleParaPro].
K12PrivateExperience15.11.0Number(25,10)Migrated from [SchoolStaff.ID_K12PrivateExperience].
K12PublicExperience15.11.0Number(25,10)Migrated from [SchoolStaff.ID_K12PublicExperience].
LegalFirstName15.11.0Varchar2(70)Migrated from [SchoolStaff.ID_LegalFirstName].
LegalLastName15.11.0Varchar2(70)Migrated from [SchoolStaff.ID_LegalLastName].
LegalMiddleName15.11.0Varchar2(60)Migrated from [SchoolStaff.ID_LegalMiddleName].
MinCreditsDate15.11.0DateMigrated from [SchoolStaff.ID_MinCreditsDate].
MinCreditsIHE15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_MinCreditsIHE].
MinCreditsIHEState15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_MinCreditsIHEState].
ncFundSource115.7.3Varchar2(10)Non-certified fund source 1.
ncFundSource215.7.3Varchar2(10)Non-certified fund source 2.
ncFundSource315.7.3Varchar2(10)Non-certified fund source 3.
ncFundSource415.7.3Varchar2(10)Non-certified fund source 4.
ncPercentSource115.7.3Number(25,10)The percentage of funding from source 1.
ncPercentSource215.7.3Number(25,10)The percentage of funding from source 2.
ncPercentSource315.7.3Number(25,10)The percentage of funding from source 3.
ncPercentSource415.7.3Number(25,10)The percentage of funding from source 4.
ParaExamdate15.11.0DateMigrated from [SchoolStaff.ID_ParaExamdate].
ParaExamOS15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ParaExamOS].
ParaExamScore15.11.0Number(10,0)Migrated from [SchoolStaff.ID_ParaExamScore].
ParaHSDiplomaType15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ParaHSDiplomaType].
ParaPraxis15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_ParaPraxis].
PreviousTeacherID15.11.0Varchar2(20)Migrated from [SchoolStaff.ID_PreviousTeacherID].
profEndorseDate16.8.0DateProfessional Endorsement Date
profPerfCriteriaMet16.8.0Varchar2(3)Professional (Compensation Rung) Performance Criteria Met
ProfPractRating15.7.3Varchar2(5)The professional practice level of performance from the evaluation.
ScheduleColumn15.11.0Number(10,0)Migrated from [SchoolStaff.ID_ScheduleColumn].
ScheduleIndex15.11.0Number(25,10)Migrated from [SchoolStaff.ID_ScheduleIndex].
ScheduleRow15.11.0Number(10,0)Migrated from [SchoolStaff.ID_ScheduleRow].
Staffprefix15.11.0Varchar2(16)Migrated from [SchoolStaff.ID_Staffprefix].
StuAchieveRating15.7.3Varchar2(5)The student achievement level of performance from the evaluation.
TerminationDate15.11.0DateMigrated from [SchoolStaff.ID_TerminationDate].
TerminationReason15.11.0Varchar2(5)Migrated from [SchoolStaff.ID_TerminationReason].
TranscriptYear15.11.0Number(10,0)Migrated from [SchoolStaff.ID_TranscriptYear].
YearsInDistrict15.11.0Number(10,0)Migrated from [SchoolStaff.ID_YearsInDistrict].
ContractEmployee19.2.0Boolean(1)Indicates whether the employee is a contract employee.
JavaScript errors detected

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

If this problem persists, please contact our support.