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 |
AddlCredits | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_addlCredits]. |
Addldegree1 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_addldegree1]. |
Addldegree2 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_addldegree2]. |
Addldegree3 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_addldegree3]. |
Addldegree4 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_addldegree4]. |
BaseSalary1 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_BaseSalary1]. |
BaseSalary2 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_BaseSalary2]. |
BaseSalary3 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_BaseSalary3]. |
CertificationState | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_CertificationState]. |
CertificationYear | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_CertificationYear]. |
Citizen | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Citizen]. |
ClaimDegreeInst | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ClaimDegreeInst]. |
ClaimDegreeState | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ClaimDegreeState]. |
ClaimedMajor | 15.11.0 | Varchar2(15) | Migrated from [SchoolStaff.ID_ClaimedMajor]. |
CompetencyDate | 15.11.0 | Date | Migrated from [SchoolStaff.ID_CompetencyDate]. |
ContractDays1 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ContractDays1]. |
ContractDays2 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ContractDays2]. |
ContractDays3 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ContractDays3]. |
ContractFTE1 | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_ContractFTE1]. |
ContractFTE2 | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_ContractFTE2]. |
ContractFTE3 | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_ContractFTE3]. |
ContractHours1 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ContractHours1]. |
ContractHours2 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ContractHours2]. |
ContractHours3 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ContractHours3]. |
ContractType1 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ContractType1]. |
ContractType2 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ContractType2]. |
ContractType3 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ContractType3]. |
Degree1Institution | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree1Institution]. |
Degree1major | 15.11.0 | Varchar2(15) | Migrated from [SchoolStaff.ID_Degree1major]. |
Degree1State | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree1State]. |
Degree1Year | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_Degree1Year]. |
Degree2Institution | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree2Institution]. |
Degree2major | 15.11.0 | Varchar2(15) | Migrated from [SchoolStaff.ID_Degree2major]. |
Degree2State | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree2State]. |
Degree2Year | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_Degree2Year]. |
Degree3Institution | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree3Institution]. |
Degree3major | 15.11.0 | Varchar2(15) | Migrated from [SchoolStaff.ID_Degree3major]. |
Degree3State | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree3State]. |
Degree3Year | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_Degree3Year]. |
Degree4Institution | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree4Institution]. |
Degree4major | 15.11.0 | Varchar2(15) | Migrated from [SchoolStaff.ID_Degree4major]. |
Degree4State | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_Degree4State]. |
Degree4Year | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_Degree4Year]. |
DegreeYear | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_DegreeYear]. |
EmploymentStatus | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_EmploymentStatus]. |
EvalDate | 15.11.0 | Date | Migrated from [SchoolStaff.ID_EvalDate]. |
EvalResults | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_EvalResults]. |
ExtraPay1 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ExtraPay1]. |
ExtraPay2 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ExtraPay2]. |
ExtraPay3 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ExtraPay3]. |
ExtraPay4 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ExtraPay4]. |
ExtraPayAmount1 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ExtraPayAmount1]. |
ExtraPayAmount2 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ExtraPayAmount2]. |
ExtraPayAmount3 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ExtraPayAmount3]. |
ExtraPayAmount4 | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ExtraPayAmount4]. |
FormerNames | 15.11.0 | Varchar2(100) | Migrated from [SchoolStaff.ID_FormerNames]. |
FundedFTE1 | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_FundedFTE1]. |
FundedFTE2 | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_FundedFTE2]. |
FundedFTE3 | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_FundedFTE3]. |
FundedFTE4 | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_FundedFTE4]. |
FundSource1 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_FundSource1]. |
FundSource2 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_FundSource2]. |
FundSource3 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_FundSource3]. |
FundSource4 | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_FundSource4]. |
HEExperience | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_HEExperience]. |
HighestDegree | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_HighestDegree]. |
HireDate | 15.11.0 | Date | Migrated from [SchoolStaff.ID_HireDate]. |
IdahoHEExperience | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_IdahoHEExperience]. |
IdahoK12Experience | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_IdahoK12Experience]. |
IdahoStaffID | 15.11.0 | Varchar2(20) | Migrated from [SchoolStaff.ID_IdahoStaffID]. |
IncStuPerf | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_IncStuPerf]. |
IsCertified | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_IsCertified]. |
IsParapro | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_IsParapro]. |
IsTitleParaPro | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_IsTitleParaPro]. |
K12PrivateExperience | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_K12PrivateExperience]. |
K12PublicExperience | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_K12PublicExperience]. |
LegalFirstName | 15.11.0 | Varchar2(70) | Migrated from [SchoolStaff.ID_LegalFirstName]. |
LegalLastName | 15.11.0 | Varchar2(70) | Migrated from [SchoolStaff.ID_LegalLastName]. |
LegalMiddleName | 15.11.0 | Varchar2(60) | Migrated from [SchoolStaff.ID_LegalMiddleName]. |
MinCreditsDate | 15.11.0 | Date | Migrated from [SchoolStaff.ID_MinCreditsDate]. |
MinCreditsIHE | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_MinCreditsIHE]. |
MinCreditsIHEState | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_MinCreditsIHEState]. |
ncFundSource1 | 15.7.3 | Varchar2(10) | Non-certified fund source 1. |
ncFundSource2 | 15.7.3 | Varchar2(10) | Non-certified fund source 2. |
ncFundSource3 | 15.7.3 | Varchar2(10) | Non-certified fund source 3. |
ncFundSource4 | 15.7.3 | Varchar2(10) | Non-certified fund source 4. |
ncPercentSource1 | 15.7.3 | Number(25,10) | The percentage of funding from source 1. |
ncPercentSource2 | 15.7.3 | Number(25,10) | The percentage of funding from source 2. |
ncPercentSource3 | 15.7.3 | Number(25,10) | The percentage of funding from source 3. |
ncPercentSource4 | 15.7.3 | Number(25,10) | The percentage of funding from source 4. |
ParaExamdate | 15.11.0 | Date | Migrated from [SchoolStaff.ID_ParaExamdate]. |
ParaExamOS | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ParaExamOS]. |
ParaExamScore | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ParaExamScore]. |
ParaHSDiplomaType | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ParaHSDiplomaType]. |
ParaPraxis | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_ParaPraxis]. |
PreviousTeacherID | 15.11.0 | Varchar2(20) | Migrated from [SchoolStaff.ID_PreviousTeacherID]. |
profEndorseDate | 16.8.0 | Date | Professional Endorsement Date |
profPerfCriteriaMet | 16.8.0 | Varchar2(3) | Professional (Compensation Rung) Performance Criteria Met |
ProfPractRating | 15.7.3 | Varchar2(5) | The professional practice level of performance from the evaluation. |
ScheduleColumn | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ScheduleColumn]. |
ScheduleIndex | 15.11.0 | Number(25,10) | Migrated from [SchoolStaff.ID_ScheduleIndex]. |
ScheduleRow | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_ScheduleRow]. |
Staffprefix | 15.11.0 | Varchar2(16) | Migrated from [SchoolStaff.ID_Staffprefix]. |
StuAchieveRating | 15.7.3 | Varchar2(5) | The student achievement level of performance from the evaluation. |
TerminationDate | 15.11.0 | Date | Migrated from [SchoolStaff.ID_TerminationDate]. |
TerminationReason | 15.11.0 | Varchar2(5) | Migrated from [SchoolStaff.ID_TerminationReason]. |
TranscriptYear | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_TranscriptYear]. |
YearsInDistrict | 15.11.0 | Number(10,0) | Migrated from [SchoolStaff.ID_YearsInDistrict]. |
ContractEmployee | 19.2.0 | Boolean(1) | Indicates whether the employee is a contract employee. |