S_VA_USR_X (ver 16.7.0)
This table is an extension of the [Users] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| UsersDCID | 16.7.0 | Number(10,0) | Foreign Key to [Users] table. |
| State_Assignment_Code | 16.7.0 | Varchar2(5) | Migrated from: [Teachers]VA_Assignment_Code. |
| FTE | 16.7.0 | Number(25,10) | Migrated from: [Teachers]VA_FTE. |
| MSC_Exclude_B_Records | 16.7.0 | Number(1,0) | Migrated from: [Teachers]VA_MSCBExclude. |
| Admin_Division_Experience | 16.7.0 | Number(25,10) | Migrated from: [Teachers]VA_ad_division_exp. |
| Admin_VA_Experience | 16.7.0 | Number(25,10) | Migrated from: [Teachers]VA_ad_exp. |
| Admin_Years_Experience | 16.7.0 | Number(25,10) | Migrated from: [Teachers]VA_ad_total_exp. |
| Admin_Role_Code | 16.7.0 | Number(11,0) | Migrated from: [Teachers]VA_admin_role_cd. |
| Division_Pupil_Exp_Comp | 20.8.2.0 | Number(11,0) | Total years in Division as of October 1 of the current year as pupil personnel in the current school division |
| Teacher_Division_Experience | 16.7.0 | Number(25,10) | Migrated from: [Teachers]VA_Division_exp. |
| Teacher_VA_Experience | 16.7.0 | Number(25,10) | Migrated from: [Teachers]VA_exp. |
| High_Quality_Professional_Dev | 16.7.0 | Varchar2(1) | Migrated from: [Teachers]VA_hq_prof_dev. |
| TitleI_Funded_Position | 16.7.0 | Number(1,0) | Migrated from: [Teachers]VA_title_i. |
| Teacher_Years_Experience | 16.7.0 | Number(25,10) | Migrated from: [Teachers]VA_total_exp. |
| Total_Pupil_Exp_Comp | 20.8.2.0 | Number(11,0) | Total years as of October 1 of the current year as pupil personnel in any public, private, or out of state school |
| First_Year_Teacher_Flag | 16.7.2 | Varchar2(1) | Used to indicate whether the current year is the teacher's first year taught in any capacity |
| First_Year_Admin_Flag | 16.9.4 | Varchar2(1) | Used to indicate whether this individual have less than one year full-time experience in this role in a public or an accredited non-public school |