CEDE 7.0 Database Reference
tPublicProtectionClass Table
| AIRReference Database : tPublicProtectionClass Table |
Stores Public Protection Classification (PPC) codes.
ISO analyzes community data (for example, fire department, water supply, or emergency communications system data) and assigns a Public Protection Classification (PPC). PPCs range from 1 to 10. Class 1 generally represents superior fire protection, and Class 10 indicates that the area's fire suppression program does not meet ISO's minimum criteria.
The codes are used in the tLocFeature Table.
| Creation Date | 11/26/2013 9:53 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 28 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | PPCCode | Code that represents the Public Protection Classification (PPC). Class 1 generally represents superior property fire protection, and Class 10 indicates that the area's fire-suppression program doesn't meet ISO’s minimum criteria. For additional information, see the ISO Public Protection Classification Program. | varchar | 10 | |||
| PPC | Name of the code. | varchar | 40 |  | |||
| Description | Description of the code. | varchar | 1024 | | |||
| PSOLDProtectionCode | Corresponding PSOLD protection code. | int | 4 | ((0)) |