| Creation Date | 4/11/2022 6:17 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 | |
|---|---|---|---|---|---|---|---|
 | AggregateExposureSID | Unique system-generated sequential identifier for the aggregated exposure data record. | int | 4 | |||
| ExposureSetSID | Unique system-generated sequential identifier for the exposure set associated with the aggregated exposure data. For a complete list of records, see tExposureSet Table. | int | 4 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils associated with the aggregated exposure data. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| YearID | Year associated with the aggregated exposure data. | smallint | 2 | ||||
| IntAreaScheme | Numeric code that represents the area scheme associated with the aggregated exposure data. For a complete list of codes, see TblAreaScheme Table. | smallint | 2 | ||||
| GeographySID | Unique system-generated sequential identifier for the geographic record associated with the aggregated exposure data. For a complete list of records, see tGeography Table. | int | 4 |  | |||
| CountryCode | ISO 2-character code for the country associated with the aggregated exposure data. For a complete list of codes, see tCountry Table.. | varchar | 15 | | |||
| CountryName | Name of the country associated with the aggregated exposure data. | varchar | 255 | | |||
| CRESTACode | CRESTA code associated with the aggregated exposure data, if applicable. | varchar | 15 | | |||
| CRESTAName | Name of the CRESTA. | varchar | 255 | | |||
| AreaCode | Area code associated with the aggregated exposure data. | varchar | 15 | | |||
| AreaName | Name of the area. | varchar | 255 | | |||
| SubareaCode | Subarea code associated with the aggregated exposure data. | varchar | 15 | | |||
| SubareaName | Name of the subarea. | varchar | 255 | | |||
| CurrencyCode | ISO 3-character code for the currency associated with the aggregated exposure data. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| LOBCode | Numeric code for the line of business associated with the aggregated exposure data. For a complete list of codes, see tReinsuranceLOB Table. | int | 4 | | |||
| TotalInsuredValue | (TIV) Monetary value of (all) coverage paid out as a result of a catastrophe. | float | 9 | | |||
| RiskCount | Number of risks. | float | 9 | | |||
| Premium | Premium amount. | float | 9 | | |||
| Payroll | Total annual payroll for covered employees. | float | 9 | | |||
| Rates | Reserved for future use. | float | 9 | | |||
| UserSpecifiedMarketShare | User-specified market share. | float | 9 | | |||
| IsLossMarketShare | Indicates whether the market share value is generated using losses from a Company Loss File (CLF).
| bit | 1 | | |||
| GeoLevelCode | Code that represents the highest resolution to which the locations are validated. For a complete list of codes, see tGeoLevel Table. | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCompany | Table | Stores information about companies. | 3 |