equity_StudentDisciplineActionDim
Purpose
Used to look up discipline actions associated with each student.
SQL Object Name
analytics.equity_StudentDisciplineActionDim
Data Definition and Sources
| Column | Data Type | Source | Description |
|---|---|---|---|
| StudentDisciplineActionKey | nvarchar | DisciplineAction | The unique key that describes the Student Discipline Action relationship |
| StudentSchoolKey | nvarchar | DisciplineAction | The student school that the discipline action took place in |
| DisciplineDateKey | nvarchar | DisciplineAction | The date the discipline action occurred |
| StudentKey | nvarchar | DisciplineAction | The student key that the discipline action occurred with |
| SchoolKey | int | DisciplineAction | The school key that the discipline action occurred in |
| DisciplineActionDescription | nvarchar | DisciplineAction | The description of the discipline action |
| UserKey | nvarchar | DisciplineAction | The staff that was associated with the discipline action |
| LastModifiedDate | datetime | DisciplineAction | The last date the event was modified |