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