S_USR_EDFI_ASSIGNMENTS_C (ver 17.4.0)
This table defines one or more staff assignments per Users record. This information is used in conjunction with Ed-Fi related functionality and is available for all states and provinces. It might or might not be utilized for your state or province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.4.0 | Number(10,0) | Primary Key |
UsersDCID | 17.4.0 | Number(10,0) | The unique DCID in the USERS table. |
BeginDate | 17.4.0 | Date | The first day of the assignment. |
EndDate | 17.4.0 | Date | The last day of the assignment. |
PositionTitle | 17.4.0 | Varchar2(100) | The descriptive name of an individual's position. |
SchoolID | 17.4.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 | 17.4.0 | Varchar2(50) | The titles of employment, official status, or rank of education staff. |