Stores information about the sourcing and inuring relationships between reinsurance programs.
Touchstone Re 2022 Database Reference
tReinsuranceProgramSourceInure Table
Stores information about the sourcing and inuring relationships between reinsurance programs.
| 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceProgramSubjectSID | Unique system-generated sequential identifier for a reinsurance program that has a relationship to another reinsurance program. For a complete list of records, see tReinsuranceProgram Table. | int | 4 | |||
| | ReinsuranceProgramSourceInureSID | Unique system-generated sequential identifier for a source or inuring reinsurance program. For a complete list of records, see tReinsuranceProgram Table. | int | 4 | |||
| FinancialPerspectiveCode | Code that represents the financial perspective of the losses from the source program. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | ||||
| ParticipationAmount | User-specified participation amount. | float | 9 |  | |||
| IsSource | Indicates whether the reinsurance program identified in the ReinsuranceProgramSourceInureSID column is the source program.
| bit | 1 | ||||
| IsInuringNextProgramFlow | Indicates whether the reinsurance program has a subsequent program to inure.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCompany | Table | Stores information about companies. | 3 |
| tReinsuranceProgram | Table | Stores information about reinsurance programs. | 2 |