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. |