Stores the AIR-default and user-specified Standard Reinsurance Agreement (SRA) loss sharing percentages for policies in the assigned risk fund and the SRA-state-group-specific commercial funds.
Touchstone Re uses the loss sharing percentages during loss analyses that include the Multiple Peril Crop Insurance (MPCI) Model for the United States.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 42 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | USMPCISRAInsurerSID | Unique system-generated sequential identifier for the loss sharing percentages record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the loss sharing percentages record. | int | 4 | ||||
| USMPCITypeCode | Code that indicates whether the loss sharing percentages record represents the AIR default loss sharing percentages or user-specified loss sharing percentages. For a complete list of codes, see tUSMPCIType Table. | tinyint | 1 | ||||
| ModelCode | Code that represents the AIR model associated with the loss sharing percentages. | int | 4 | ||||
| ModelVersion | Version of the AIR model. | varchar | 10 | ||||
| PreSRARatio | Range of pre-SRA loss ratios (loss ratios prior to the application associated with the PreSRARatio | int | 4 | ||||
| AssignedRisk | Default or user-specified loss sharing percentage associated with the PreSRARatio for the assigned risk fund. | float | 9 | ||||
| ComGroup1 | Default or user-specified loss sharing percentage associated with the PreSRARatio for SRA state group 1 in the commercial fund. | float | 9 | ||||
| ComGroup2 | Default or user-specified loss sharing percentage associated with the PreSRARatio for SRA state group 2 in the commercial fund. | float | 9 | ||||
| ComGroup3 | Default or user-specified loss sharing percentage associated with the PreSRARatio for SRA state group 3 in the commercial fund. | float | 9 |