Stores information for A.M. Best reports, specifically the "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation.
See tDQ_AMB_25I Table 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.
| 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 |  | |||
| 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 | |