Stores the options used during a Geospatial analysis.
Touchstone 2022 Database Reference
tExposureConcentrationAnalysisOption Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 2 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| AccumulatorTypeCode | Code that represents the accumulator type for the analysis. For a complete list of codes, see tAccumulatorType Table. | varchar | 10 | ||||
| ProgramSID | Unique system-generated sequential identifier for the reinsurance program record. For a complete list of records, see tProgram Table. | int | 4 |  | |||
| FacultativeOptionCode | Code that represents how the facultative option is applied. For a complete list of codes, see tFacultativeOption Table. | varchar | 10 | | |||
| CATFinancialPerspectiveCode | Code that represents the financial perspectives. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | | |||
| ApplyDisaggregation | Indicates whether aggregate locations are disaggregated.
| bit | 1 | ((0)) | |||
| ApplyDeductibleBeforeLimit | Indicates whether the location terms are applied in residential contracts.
| bit | 1 | ((0)) | |||
| SaveReplacementValue | Indicates whether the replacement values are saved.
| bit | 1 | ((1)) | |||
| SavePremium | Indicates whether the premium is saved.
| bit | 1 | ((0)) | |||
| SaveRiskCount | Indicates whether the risk count is saved.
| bit | 1 | ((1)) | |||
| SaveLocationCount | Indicates whether the location count is saved.
| bit | 1 | ((0)) | |||
| SavePrimaryCharacteristics | Indicates whether the primary characteristics are saved.
| bit | 1 | ((1)) | |||
| SaveSecondaryCharacteristics | Indicates whether the secondary characteristics are saved.
| bit | 1 | ((0)) | |||
| SaveLocationTerm | Indicates whether the location terms are saved.
| bit | 1 | ((0)) | |||
| SaveContractPrimaryAttributes | Indicates whether the contract's primary attributes are saved.
| bit | 1 | ((0)) | |||
| SaveLayerTerm | Indicates whether the layer terms are saved.
| bit | 1 | ((0)) | |||
| SaveGroundUp | Indicates whether the Ground-Up results loss are saved.
| bit | 1 | ((0)) | |||
| SaveGross | Indicates whether the Gross loss results are saved.
| bit | 1 | ((0)) | |||
| SaveNetOfPreCAT | Indicates whether the Net-of-Pre loss results are saved.
| bit | 1 | ((0)) | |||
| SavePostCATNet | Indicates whether the Net-of-Post loss results are saved.
| bit | 1 | ((0)) | |||
| SaveCoverage | Indicates whether coverage data for a given financial perspective is saved. For example, when Ground-Up is selected and coverage option is chosen, the resultant table would include Ground-Up loss for Coverage A, Coverage B , Coverage C, and Coverage D.
| bit | 1 | ((0)) | |||
| SaveEmployeeCount | Indicates whether the employee count is saved.
| bit | 1 | ((0)) | |||
| SaveTotalAnnualPayroll | Indicates whether the total annual payroll is saved.
| bit | 1 | ((0)) | |||
| SaveCostOfLives | Indicates whether the cost of lives amount is saved.
| bit | 1 | ((0)) | |||
| SaveLossCost | Indicates whether the loss costs are saved.
| bit | 1 | ((0)) | |||
| SaveByContract | Indicates whether the loss is saved at a contract level.
| bit | 1 | ((1)) | |||
| SaveByLocation | Indicates whether the loss is saved at a location level.
| bit | 1 | ((1)) | |||
| SaveByLayer | Indicates whether the loss is saved at a layer level.
| bit | 1 | ((1)) | |||
| EnableDynamicResultBrowsing | Indicates whether the ability to browse results is enabled.
| bit | 1 | ((1)) | |||
| IsWorkersCompSelected | Indicates whether the worker's compensation option was selected.
| bit | 1 | ((0)) | |||
| IsPropertySelected | Indicates whether the property option was selected.
| bit | 1 | ((0)) | |||
| SaveInjuryType | Code that represents the type of injury. For complete list of injury types, see tInjury table. | tinyint | 1 | | |||
| SaveTimeOfShift | Code that represents the working hours of employees. For complete list of shift details, see tTimeOfShift table. | tinyint | 1 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tECAAreaZoneOption | Table | Stores the zone set identifiers used during a Geospatial analysis. | 1 |
| tECACustomSaveOption | Table | Stores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use. | 1 |
| tECARingDefinition | Table | Stores information regarded the rings used during a Geospatial analysis. | 2 |
| tECARingGeoMatchLevelOption | Table | Stores information about the geocode match level achieved during the Geospatial \analysis. | 2 |
| tECARingLandmarkOption | Table | Stores information about the landmarks used during a Geospatial analysis. | 2 |
| tECARingLocationList | Table | Stores information about the locations included in the Geospatial analysis. | 2 |
| tECARingOption | Table | Stores information about the ring options selected for the Geospatial analysis. | 1 |
| tECASpatialDataSetBucketDefinition | Table | Stores information that defines the buckets used in a Geospatial analysis. A bucket is a range of attribute values that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour. | 2 |
| tECASpatialDataSetBucketDetail | Table | Stores information regarding the data set bucket used during the Geospatial analysis. A bucket is a range that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour. | 3 |
| tECASpatialDataSetOption | Table | Stores information regarding the spatial data set options used during the Geospatial analysis. | 1 |
| tECASpatialEventOption | Table | Stores information regarding the events for each model to include during the Geospatial analysis. | 1 |
| tECASpatialLossOption | Table | Stores information regarding the loss analysis options used during the Geospatial analysis. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysis | Table | Stores information about each analysis. | 1 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 3 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 2 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 3 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 2 |