Results Schema

The entities in the results schema store the results from running analyses. See Table 1 for their descriptions. For the full specification of fields, data types, and values, see the Results & Settings Schema tab of the RDOS schema specification RDOS_Schema.xlsx.

Table 1: RDOS Result Entities
Table	Description
Analysis	Stores the analysis Id, settings Id, and structure Id of every analysis, and indicates whether the analysis was run using a model profile or a risk analysis profile
AnalysisHierarchy	Indicates the model profiles that are included in the risk analysis profile for every analysis that is run using a risk analysis profile
AnalysisMap	Maps analysis Id to results Id
Result_ELT	Stores the event loss table per result Id
Result_EP	Stores the EP results per result Id, return period, and facet, including AEP, OEP, TCE-AEP, TCE-OEP, and EEF
Result_PLT	Stores the period loss table per result Id
Result_Stats	Stores the statistical results per result Id and facet, including AAL, StdDev, and CV
ResultFacetValues	Defines the granularity that applies to each facet Id, including granularities like admin1Code, admin2Code, countryCode, lineOfBusinessCode, cedantCode, and postalCodeGeoId
ResultMetadata	Indicates the structure and position analyzed for every result Id. It also indicates the type of results that are available (EP, stats, ELT, PLT) and the granularity of the analysis (AdminLOB, CedantLOB).