Stores information about companies.
Touchstone Re 2022 Database Reference
tCompany 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 | |
|---|---|---|---|---|---|---|---|
 | CompanySID | Unique system-generated sequential identifier for the company record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the company. | int | 4 | ||||
| CompanyTypeCode | Reserved for future use. | varchar | 10 |  | |||
| CompanyID | Identifier for the company. | varchar | 20 | | |||
| CompanyName | Name of the company. | varchar | 765 | ||||
| Description | User-specified description of the company. | varchar | 4000 | | |||
| UnderwriterJudgementFactor | Underwriter judgment factor associated with the company. | float | 9 | | |||
| StatusCode | Code that represents the system-provided status for the company. For a complete list of codes, see tStatus Table. | varchar | 10 | ||||
| EnteredDate | Date and time the company was created. | datetime | 4 | (getdate()) | |||
| EditedDate | Date and time the company was last edited. | datetime | 4 | (getdate()) | |||
| AuthorEntered | User that created the company. | varchar | 1000 | | |||
| AuthorEdited | User that last edited the company. | varchar | 1000 | | |||
| DefaultExposureSetSID | Unique-system generated sequential identifier for the default exposure set associated with the company. For a complete list of records, see tExposureSet Table. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAggregateExposure | Table | Stores aggregated exposure data. For example, one row in the table may specify the total insured value for a given subarea and line of business included in an exposure set. | 2 |
| tAppliesToEventFilter | Table | Stores information about event filters. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 1 |
| tAppliesToEventFilterGeoXRef | Table | Stores information about event filters that include geographic areas. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tAppliesToEventFilterLatLong | Table | Stores information about event filters that include latitude and longitude pairs. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tAppliesToEventFilterRule | Table | Stores information about event filters that include event parameters, such as earthquake depth or hurricane central pressure. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tCatBondAttributeValue | Table | Stores information about catastrophe bond reinsurance programs, for example, the sponsor and covered perils. | 1 |
| tCLFCatalog | Table | Stores metadata about company loss files (CLF). The metadata includes information about the event catalogs associated with each CLF. | 1 |
| 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 |
| tCompanyLossMarketShare | Table | Stores loss market share information for company loss file (CLF) sets exported from Touchstone to Touchstone Re. A loss market share represents a given company’s share of industry-wide losses. | 1 |
| tCompanyUDCClassification_Xref | Table | Stores relationships between user-defined categories (UDCs) and companies. | 1 |
| tReinsuranceProgram | Table | Stores information about reinsurance programs. | 2 |
| tReinsuranceProgramSourceInure | Table | Stores information about the sourcing and inuring relationships between reinsurance programs. | 1 |
| tReinsuranceProgramTargetXRef | Table | Stores the company loss file (CLF) set or CLF set and exposure set combination specified as the target of each reinsurance program. | 1 |
| tReinsuranceTreaty | Table | Stores information about reinsurance treaties included in reinsurance programs. | 1 |
| tReinsuranceTreatyReinstatement | Table | Stores information about reinstatement treaties included in reinsurance programs. | 1 |
| tReinsuranceTreatyTerrorismOption | Table | Stores information about the terrorism coverage for each reinsurance treaty. | 1 |
| tReinsuranceTreatyUDCClassification_Xref | Table | Stores relationships between user-defined categories (UDCs) and reinsurance treaties. | 1 |