Stores industry-default and user-specified per-life premium rates for the pandemic peril.
Touchstone Re 2022 Database Reference
tReinsuranceIndustryRate Table
| Creation Date | 12/3/2018 5:21 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 512520 |
| Data Space Used | 24,424.00 KB |
| Index Space Used | 120.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceIndustryRateSID | Unique system-generated sequential identifier for the rates. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit. | int | 4 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils associated with the rates. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| YearID | Exposure year associated with the rates. | smallint | 2 | ||||
| GeographySID | Unique system-generated sequential identifier for the geographic record associated with the rates. For a complete list of records, see tGeography Table. | int | 4 | ||||
| LOBCode | Numeric code for the line of business associated with the rates. For a complete list of codes, see tReinsuranceLOB Table. | int | 4 | ||||
| Rate | Industry per-life premium rate. | float | 9 | ||||
| UserDefinedRate | User-defined per-life premium rate. | float | 9 |  |