Stores administrator-specified per-life premium rates for the pandemic peril.
Touchstone Re 2022 Database Reference
tReinsuranceIndustryRate Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 512520 |
| Data Space Used | 29,528.00 KB |
| Index Space Used | 104.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 | |