Stores information for A.M. Best reports, such as the TIV percent, value, and count data of known attributes by personal property, commercial property, and worker's compensation.
For the A.M. Best reports of "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation, see tDQ_AMB_25K Table.
| Creation Date | 4/11/2022 5:46 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. | 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 | |