S_USR_ASSIGNMENTS_C (ver 19.11.1.0)
This table is a child of the [Users] table and defines one or more staff assignments per Users record. This information is used in conjunction with Ed-Fi related functionality. The table is available for all states and provinces and may or may not be utilized for your state or province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 19.11.1.0 | Number(11,0) | Primary Key |
UsersDCID | 19.11.1.0 | Number(11,0) | The unique DCID in the Users table. |
BeginDate | 19.11.1.0 | Date | The first day of the assignment. |
EndDate | 19.11.1.0 | Date | The last day of the assignment. |
PositionTitle | 19.11.1.0 | Varchar2(100) | The descriptive name of an individual's position. |
SchoolId | 19.11.1.0 | Number(11,0) | The internal number for the school where the staff is assigned, or 0 if this is a district office assignment. |
StaffClassification | 19.11.1.0 | Varchar2(50) | The titles of employment, official status, or rank of education staff; Ed-Fi descriptor. |