Stores information for A.M. Best reports, such as the "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation.
For the A.M. Best reports of TIV percent, value, and count data of known attributes by personal property, commercial property, and worker's compensation, see tDQ_AMB_25I 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 |  | |||
| Category | Type of category value:
| varchar | 50 | | |||
| MFOVPersonal | Description of the specified Occupancy or Construction for residential policies. | varchar | 50 | | |||
| MFOVCommercial | Description of the specified Occupancy or Construction for commercial policies. | varchar | 50 | | |||
| MFOVWC | Description of the specified Occupancy or Construction for workers' compensation policies. | varchar | 50 | | |||
| PercentMFOVPersonal | Percent of the replacement value in regards to specified Occupancy or Construction for personal policies. | float | 9 | | |||
| PercentMFOVCommercial | Percent of the replacement value in regards to specified Occupancy or Construction for commercial policies. | float | 9 | | |||
| PercentMFOVWC | Percent of the replacement value in regards to specified Occupancy or Construction for worker’s compensation policies. | float | 9 | | |||
| RVMFOVPersonal | Total replacement value in regards to specified Occupancy or Construction for worker’s compensation policies. | float | 9 | | |||
| RVMFOVCommercial | Total replacement value in regards to specified Occupancy or Construction for commercial policies. | float | 9 | | |||
| RVMFOVWC | Total replacement value in regards to specified Occupancy or Construction for worker’s compensation policies. | float | 9 | | |||
| LocationCountMFOVPersonal | Location count in regards to specified Occupancy or Construction for personal policies. | int | 4 | | |||
| LocationCountMFOVCommercial | Location count in regards to specified Occupancy or Construction for commercial policies. | int | 4 | | |||
| LocationCountMFOVWC | Location count in regards to specified Occupancy or Construction for worker’s compensation policies. | int | 4 | | |||
| Attribute_183 | Reserved for future use. | char | 10 | |