PSSIS_Student_Discip_Summary (ver5.0.0)
This view provides summarized Discipline information related to Students.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Name | 5.0.0 | String35 | [From Students] The Student Last Name, First Name. Indexed. |
Student_Number | 5.0.0 | Real | [From Students] The unique Student identifier. Indexed. |
Current_Grade_Level | 5.0.0 | Longint | [From Students] The Student's current grade level. Indexed. |
Current_School_Abbreviation | 5.0.0 | String20 | [From Schools] The Current School's abbreviation. |
Gender | 5.0.0 | String2 | [From Students] Gender indicator. Indexed. |
Ethnicity_Name | 5.0.0 | String50 | [From GEN] Ethnicity from the Gen table where category = 'Ethnicity'. |
Ethnicity_Code | 5.0.0 | String20 | [From Students custom field] The student's Primary Language as decoded in the CustomVarchars table. |
Special_Ed_Student | 5.0.0 | String3 | [From Students custom field] The student's Secondary Language as decoded in the CustomVarchars table. |
Log_Type | 5.0.0 | String50 | [From Gen] Log type indicator. |
Incident_Sub_Type | 5.0.0 | String20 | [From Log] not yet populated. |
Incident_Date | 5.0.0 | Date | [From Log] not yet populated. |
Incident_Type | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Type_Category | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Context | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Location | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Offender | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Reporter | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Victim_Type | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Felony | 5.0.0 | Longint | [From Log] not yet populated. |
Incident_Gang_Related | 5.0.0 | Longint | [From Log] not yet populated. |
Incident_Hate_Crime | 5.0.0 | Longint | [From Log] not yet populated. |
Incident_Alcohol | 5.0.0 | Longint | [From Log] not yet populated. |
Incident_Drug | 5.0.0 | Longint | [From Log] not yet populated. |
Incident_Weapon | 5.0.0 | Longint | [From Log] not yet populated. |
Incident_Weapon_Type | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Action_Taken | 5.0.0 | String79 | [From Log] not yet populated. |
Incident_Money_Loss | 5.0.0 | Real | [From Log] not yet populated. |