S_USR_EDFI_SUBJECTS_C (ver 17.4.0)
This table defines one or more subject areas a staff member teaches at a school. 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. |
AcademicSubject | 17.4.0 | Varchar2(50) | Academic subject taught by staff member. |
MaxGradeLevel | 17.4.0 | Number(11,0) | Maximum grade level taught by staff member for this subject. |
MinGradeLevel | 17.4.0 | Number(11,0) | Minimum grade level taught by staff member for this subject. |
SchoolID | 17.4.0 | Number(11,0) | The internal number for the school where the staff teaches the academic subject. |