Stores information for A.M. Best reports, specificallyTIV percent, value, and count data of known attributes by personal property, commercial property, and worker's compensation.
See tDQ_AMB_25K Table for the A.M. Best reports of "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation.
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| | OutputTypeCode | Unique system-generated sequential identifier for the category record. For a complete list of codes, see tOutputType Table. | varchar | 10 | |||
| | CategorySID | Unique system-generated sequential identifier for the category record. Unique system-generated sequential identifier for the category record. | int | 4 | |||
| | PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | |||
| PerilSet | Name corresponds to the PerilSetCode value. | varchar | 255 |  | |||
| CategoryGroup | Description of the Category value. | varchar | 255 | | |||
| Category | Type of category value:
| varchar | 50 | | |||
| PercentPersonal | Percent of total replacement value for residential policies. | float | 9 | | |||
| PercentCommercial | Percent of total replacement value for commercial policies. | float | 9 | | |||
| PercentWC | Percent of total replacement value for workers' compensation policies. | float | 9 | | |||
| RVPersonal | Total replacement value for residential policies. | float | 9 | | |||
| RVCommercial | Total replacement value for commercial policies. | float | 9 | | |||
| RVWC | Total replacement value for workers' compensation policies. | float | 9 | | |||
| LocCountPersonal | Location count for residential policies. | int | 4 | | |||
| LocCountCommercial | Location count for commercial policies. | int | 4 | | |||
| LocCountWC | Location count for workers' compensation policies. | int | 4 | |