S_PA_USR_X (ver 15.2.0)
This table is an extension of the [Users] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
UsersDCID | 15.2.0 | Number(10,0) | Primary Key |
Employment_Status_Code | 15.2.0 | Varchar2(2) | Employment Status Code (Used for EWS). |
Exclude_from_EWS | 15.6.2 | Number(1,0) | Exclude Teacher from EWS reports. |
Job_Description | 17.4.0 | Varchar2(3) | Migrated from [Teachers]PA_Job_Description. |
State_Staff_ID | 17.4.0 | Varchar2(7) | Migrated from [Teachers]PA_PPID. |
Staff_Type_Code | 17.4.0 | Varchar2(1) | Migrated from [Teachers]PA_Staff_Type. |
Termination_Code | 17.4.0 | Varchar2(2) | Migrated from [Teachers]PA_Termination_Cd. |
Years_Experience | 17.4.0 | Number(11,0) | Migrated from [Teachers]PA_Yrs_Exper. |
Years_Experience_In_District | 17.4.0 | Number(11,0) | Migrated from [Teachers]PA_Yrs_Exper_District. |
Active_Status_Code | 17.4.0 | Varchar2(1) | Migrated from [Teachers]PA_Active_Ind. |
Job_Class_Long_Code | 17.4.0 | Varchar2(3) | Migrated from [Teachers]PA_Job_Class_Cd. |
Annual_Salary | 17.4.0 | Number(11,0) | Migrated from [Teachers]PA_Ann_Salary. |
Local_Contract_TF | 17.4.0 | Number(1,0) | Migrated from [Teachers]PA_Loc_Contract. |
First_Name_Long | 17.4.0 | Varchar2(60) | Migrated from [Teachers]PA_First_Name_Long. |
Last_Name_Long | 17.4.0 | Varchar2(60) | Migrated from [Teachers]PA_Last_Name_Long. |
Middle_Name_Long | 17.4.0 | Varchar2(60) | Migrated from [Teachers]PA_Middle_Name_Long. |
Name_Suffix | 17.4.0 | Varchar2(10) | Migrated from [Teachers]PA_Name_Suffix. |
Highest_Deg_Institution_Code | 17.4.0 | Varchar2(4) | Migrated from [Teachers]PA_High_Degree_Inst_Cd. |
Employ_Eligibility_Verif_Code | 17.4.0 | Varchar2(4) | Migrated from [Teachers]PA_Employ_Elig_Verif. |
Address_2 | 17.4.0 | Varchar2(40) | Migrated from [Teachers]PA_Address_2. |
Address_3 | 17.4.0 | Varchar2(40) | Migrated from [Teachers]PA_Address_3. |
Current_Service_Date | 17.4.0 | Date | Migrated from [Teachers]PA_Cur_Service_Dt. |
Exit_Date | 17.4.0 | Date | Migrated from [Teachers]PA_Exit_Dt. |