Stores the company loss file (CLF) set or CLF set and exposure set combination specified as the target of each reinsurance program.
Touchstone Re 2022 Database Reference
tReinsuranceProgramTargetXRef Table
| 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 | |
|---|---|---|---|---|---|---|---|
 | ReinsuranceProgramSID | Unique system-generated sequential identifier for the reinsurance program. For a complete list of records, see tReinsuranceProgram Table. | int | 4 | |||
| | TargetID | Identifier for the preferred exposure target. An exposure target is a company loss file (CLF) set or a CLF set and exposure set combination. | int | 4 | |||
| ExposureSetSID | Unique system-generated sequential identifier for the exposure set. For a complete list of records, see tExposureSet Table. | int | 4 |  | |||
| CompanyLossAssociationSID | Unique system-generated sequential identifier for the CLF set. For a complete list of records, see tCompanyLossAssociation Table. | int | 4 | | |||
| TargetName | Name of the preferred exposure target. An exposure target is a company loss file (CLF) set, or a CLF set and exposure set combination. | varchar | 255 | | |||
| YearSID | Unique system-generated sequential identifier for the year in the exposure set. | int | 4 | | |||
| ExposureTypeCode | Code that represents the exposure type. For a complete list of codes, see tAggregateExposureType Table. | varchar | 10 | | |||
| IsRollup | Reserved for future use. | bit | 1 | ((0)) | |||
| IsUseLatest | Indicates whether to use the most recent year in the exposure set.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCompany | Table | Stores information about companies. | 3 |
| tCompanyLossAssociation | Table | Stores relationships between company loss file (CLF) sets and companies. You can associate a CLF set with a company in two ways:
| 1 |
| tReinsuranceProgram | Table | Stores information about reinsurance programs. | 2 |