| Creation Date | 4/11/2022 6:15 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 | |
|---|---|---|---|---|---|---|---|
| ImpactAdminBoundaryPerilID | Identifier for the administrative boundary and peril combination associated with the results. For a complete list of combinations, see tImpactAdminBoundaryPerilSetXref Table. | smallint | 2 | |||
| OutputTypeCode | Numeric code for the single peril or set of perils which impact the region. For a complete list of codes, see tPerilSet Table. | varchar | 10 | |||
| FinancialPerspectiveCode | Code that represents the perspective used to display the losses. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | |||
| EPAnnualTypeCode | Code that indicates whether the corresponding losses are based on all events that occurred during a year (aggregate) or on the single largest loss caused by all events in a year (occurrence). For a complete list of codes, see tEPAnnualType Table. | varchar | 10 | |||
| EPCurveTypeCode | Code that indicates whether the corresponding losses are based on all events that occurred during a year (aggregate) or on the single largest loss caused by all events in a year (occurrence). For a complete list of codes, see tEPCurveType Table. | varchar | 10 | |||
| EPTypeCode | Code that represents the type of Exceedance Probability curve. For a complete list of codes, see tEPType Table. | varchar | 10 | |||
| EPTargetTypeCode | Code that represents type of data represented in the EP curve. For a complete list of codes, see tEPTargetType Table. | varchar | 10 | |||
| ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record in which the EPTargetSID can be found . For a complete list of records, see tDataSource Table. | int | 4 | |||
| EPTargetSID | Unique system-generated sequential identifier for the target record for which the losses were aggregated For example, f the EP target type is Contract, then this is the ContractSID. | int | 4 | |||
| ExpectedValue | Mean annual expected loss ("expected value"), which is determined by taking the sum of all expected losses for the simulation and dividing by the number of years of the simulation. | float | 9 | ||||
| StandardDeviation | Standard deviation from the mean annual expected loss (EV). | float | 9 | ||||
| EP1Loss | Loss for the first user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP2Loss | Loss for the second user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP3Loss | Loss for the third user-specified point on the exceedance probability curve.thier | float | 9 | ![]() | |||
| EP4Loss | Loss for the fourth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP5Loss | Loss for the fifth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP6Loss | Loss for the sixth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP7Loss | Loss for the seventh user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP8Loss | Loss for the eighth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP9Loss | Loss for the ninth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP10Loss | Loss for the tenth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP11Loss | Loss for the eleventh user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP12Loss | Loss for the twelfth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP13Loss | Loss for the thirteenth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP14Loss | Loss for the fourteenth user-specified point on the exceedance probability curve. | float | 9 | ![]() | |||
| EP15Loss | Loss for the fifteenth user-specified point on the exceedance probability curve. | float | 9 | ![]() |