Stores the government-specified and user-specified Standard Reinsurance Agreement (SRA) group numbers associated with each U.S. (United States) state.
Touchstone Re uses the group assignments to apply SRA sharing ratios 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 | 204 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | USMPCIGroupAssignmentsSID | Unique system-generated sequential identifier for the group assignment record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the group assignment record. | int | 4 | ||||
| USMPCITypeCode | Code that indicates whether the SRA group number represents the default (government-assigned) group number or a user-specified group number. For a complete list of codes, see tUSMPCIType Table. | tinyint | 1 | ||||
| ModelCode | Code that represents the AIR model associated with the group assignment. | int | 4 | ||||
| GeographySID | Unique system-generated sequential identifier for the U.S. state associated with the group assignment. For a complete list of codes, see tGeography Table. | int | 4 | ||||
| GroupAssignment | Number of the SRA state group that the state is associated with. | int | 4 |