S_NY_SCH_VADIR_X (ver 16.1.0)
This table is an extension of the [Schools] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 16.1.0 | Number(10,0) | Primary key that relates the extended table back to the [Schools] table. |
| PersistentlyDangerousBeginDate | 16.1.0 | Date | The date the school was first designated as persistently dangerous. Migrates from [Schools]NY_VADIR_Begin_DOD. |
| PersistentlyDangerousEndDate | 16.1.0 | Date | The date the school was no longer designated as persistently dangerous. Migrates from [Schools]NY_VADIR_End_DOD. |
| OfficerPresent | 16.1.0 | Number(1,0) | Indicates if an officer is present on campus. Migrates from [Schools]NY_VADIR_Officer_Present. |
| OfficerInput | 16.1.0 | Number(1,0) | Indicates if an officer provides VADIR input. Migrates from [Schools]NY_VADIR_Officer_Provide. |
| PersistentlyDangerous | 16.1.0 | Number(1,0) | Indicates if the school is designated as persistently dangerous. Migrates from [Schools]NY_VADIR_Pers_Dangerous. |