Creation Date | 4/4/2022 3:02 AM |
File Group | PRIMARY |
Text File Group | |
System Object | ![]() |
Published for Replication | ![]() |
Rows | 4 |
Data Space Used | 8.00 KB |
Index Space Used | 8.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
![]() | AnalysisSID | Unique system-generated sequential identifier for the analysis record. | int | 4 | |||
CompanySID | Unique system-generated sequential identifier for the company associated with the analysis. For a complete list of records, see tCompany Table. | int | 4 | ![]() | |||
ReinsuranceTypeCode | Code that represents the type of reinsurance treaty associated with the analysis. For a complete list of codes, see tReinsuranceType Table. | varchar | 10 | ![]() | |||
MultiYear | Reserved for future use. Indicates whether the analysis included a multi-year catalog. Iterations in multi-year catalogs span six years.
| bit | 1 | ![]() | ((0)) | ||
HistoricalIncluded | Indicates whether the analysis included historical events.
| bit | 1 | ![]() | ((0)) | ||
ExposureYear | Year in the exposure set used during the analysis. | int | 4 | ((0)) | |||
IsEventStartFromProgram | Indicates whether a user specified a start date as an event filter for the loss analysis.
| bit | 1 | ((0)) | |||
IsEventEndFromProgram | Indicates whether a user specified an end date as an event filter for the loss analysis.
| bit | 1 | ((0)) | |||
EventStartDate | User-specified start date to apply as an event filter. | date | 8 | ![]() | |||
EventEndDate | User-specified end date to apply as an event filter. | date | 8 | ![]() | |||
MultiYearStartDate | Start date in a multi-year catalog. | date | 8 | ![]() | |||
IsEventsFromProgramInceptionDate | Indicates whether events that do not meet the event filter criteria but are within the in-force window for the reinsurance program are included in the analysis.
| bit | 1 | ![]() | |||
ParentOptionSID | Unique system-generated sequential identifier for the parent loss analysis options. For a complete list of records, see tLossAnalysisOption Table. | int | 4 | ![]() | |||
CustomLOBOptionCode | Code that indicates whether the analysis included losses for custom lines of business. For a complete list of codes, tCustomLOBOption Table.
You must license Custom Models and LOBs to use the custom LOB feature.
| varchar | 10 | ![]() | ('PGM') | ||
GlobalAdjustmentFactor | Indicates whether the analysis included a global adjustment factor.
| bit | 1 | ![]() | ((0)) | ||
CalcIndLoss | Indicates whether industry losses were computed.
| bit | 1 | ![]() | ((0)) | ||
IgnoreHistoricalEventDate | Indicates whether the analysis included all historical events regardless of the event filters.
| bit | 1 | ![]() | ((0)) | ||
AdjustmentFactorAllComp | User-specified adjustment factor for all companies included in the analysis. | float | 9 | ((1)) | |||
EventSetName | Name of the event set included in the analysis. For a complete list of records, see tReinsuranceEventSet Table. | varchar | 255 | ![]() | |||
CatalogSize | Number of years in the catalog used during the analysis. | int | 4 | ![]() | |||
IsByProgram | Indicates whether the user selected the option to save the analysis results by reinsurance program.
| bit | 1 | ![]() | |||
IsUseLatestIED | Indicates whether the user selected the option to use the latest Industry Exposure Database (IED).
| bit | 1 | ![]() | |||
EPAdjustmentOptionCode | Code that indicates whether the analysis included user-specified EP adjustments to program losses. For a complete list of codes, see tAggregateAnalysisPLAFlag Table.
You must license program loss adjustments to use the program loss adjustments feature.
| varchar | 10 | ![]() | |||
EventBasedAdjFactorSetSID | Unique system-generated sequential identifier for the set of event-based adjustment factors included in the analysis. For a complete list of records, see tEventBasedAdjFactorSet Table.
You must license event-based adjustment factors to use the event-based adjustment factors feature.
| int | 4 | ![]() | |||
IsSeismic | Indicates whether the analysis included additional events in the event catalog to account for increased seismicity beyond the historical average.
Increased seismicity is supported only for New Zealand. | bit | 1 | ![]() | |||
IsUseSavedResults | Indicates whether the user selected the option to include previously saved treaty loss results. After you run a loss analysis, you can optionally upload the results of the analysis to the Analyze Re application, and then use the results to speed up future analyses. | tinyint | 1 | ![]() | ((0)) | ||
IsCustomLoss | Indicates whether the user selected the option to include custom LOBs, exclude custom LOBs, or include program-specific custom LOBs. | bit | 1 | ![]() | ((0)) | ||
ParentWithInvalidSourceProgramMap | varchar | 8000 | ![]() |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | tAggregateAnalysisTerrorismOption | Table | Stores information about the terrorism option specified for each loss analysis. | 1 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | tAnalysis | Table | Stores information about each analysis. | 1 |
![]() | tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 3 |