Site Product Risk Summary
Internal Table Name: OptimizationOutputProductRiskSummary
This output table provides risk scores at the risk profile-site-product level. In addition to the scores defined in the Risk Profile table, the Risk Summary includes a Composite Risk Score that takes into account the weights applied to each of the individual risk scores.
Scenario
Table: OptimizationOutputProductRiskSummary
Internal Name: Not Applicable (Scenario column not in table)
The scenario for which the summary data was generated.
Risk Profile
Table: OptimizationOutputProductRiskSummary
Internal Name: RiskProfileName
The name of the risk profile.
Site
Table: OptimizationOutputProductRiskSummary
Internal Name: SiteName
The name of the site that uses the risk profile.
Product
Table: OptimizationOutputProductRiskSummary
Internal Name: ProductName
The name of the product that uses the risk profile at the site.
Flow Quantity
Table: OptimizationOutputProductRiskSummary
Internal Name: FlowQuantity
The amount of flow that is covered by the Risk Profile for the Site-Product combination. This is the total outbound Product quantity from the Site with this Risk Profile.
% Total Flow
Table: OptimizationOutputProductRiskSummary
Internal Name: FlowPercent
The percentage of the total network flow that the Flow Quantity represents. This is the:
total outbound quantity of this Site-Product combination / total outbound quantity for all Site-Product combinations
Financial Score
Table: OptimizationOutputProductRiskSummary
Internal Name: FinancialScore
The financial score defined for the Risk Profile.
Judicial Score
Table: OptimizationOutputProductRiskSummary
Internal Name: JucicialScore
The judicial score defined for the Risk Profile.
News Sentiment Score
Table: OptimizationOutputProductRiskSummary
Internal Name: NewsSentimentScore
The news sentiment score defined for the Risk Profile.
Screening List
Table: OptimizationOutputProductRiskSummary
Internal Name: ScreeningList
The screening list score defined for the Risk Profile.
Residual Score
Table: OptimizationOutputProductRiskSummary
Internal Name: ResidualScore
The residual score defined for the Risk Profile.
Inherent Score
Table: OptimizationOutputProductRiskSummary
Internal Name: InherentScore
The inherent score defined for the Risk Profile.
Business Continuity Score
Table: OptimizationOutputProductRiskSummary
Internal Name: BusinessContinuityScore
The business continuity score defined for the Risk Profile.
Performance Score
Table: OptimizationOutputProductRiskSummary
Internal Name: PerformanceScore
The performance score defined for the Risk Profile.
Labor Score
Table: OptimizationOutputProductRiskSummary
Internal Name: LaborScore
The labor score defined for the Risk Profile.
Geography Score
Table: OptimizationOutputProductRiskSummary
Internal Name: GeographyScore
The geography score defined for the Risk Profile.
Custom Score 1
Table: OptimizationOutputProductRiskSummary
Internal Name: CustomScore1
The Custom Score 1 value defined for the Risk Profile.
Custom Score 2
Table: OptimizationOutputProductRiskSummary
Internal Name: CustomScore2
The Custom Score 2 value defined for the Risk Profile.
Custom Score 3
Table: OptimizationOutputProductRiskSummary
Internal Name: CustomScore3
The Custom Score 3 value defined for the Risk Profile.
Custom Score 4
Table: OptimizationOutputProductRiskSummary
Internal Name: CustomScore4
The Custom Score 4 value defined for the Risk Profile.
Composite Risk Score
Table: OptimizationOutputProductRiskSummary
Internal Name: CompositeRiskScore
The weighted average of all risk scores for this Risk Profile-Site-Productcombination. Higher Composite Risk Score values indicate a high risk. This score is calculated as:
((100 - Financial Score)* Financial Weight + (100 - Judicial Score) * Judicial Weight + (100 - rescaled News Sentiment Score) * News Sentiment Weight + rescaled Screening List * Screening List Weight + Residual Score * Residual Weight + Inherent Score * Inherent Weight + (100 - Business Continuity Score) * Business Continuity Weight + (100 - Performance Score) * Performance Weight + (100 - Labor Score) * Labor Weight + (100 - Geography Score) * Geography Weight + Custom Score 1 * Custom Weight 1 + Custom Score 2 * Custom Weight 2 + Custom Score 3 * Custom Weight 3 + Custom Score 4 * Custom Weight 4 + % Total Flow * Node Criticality Weight) / (Financial Weight + Judicial Weight + News Sentiment Weight + Screening List Weight + Residual Weight + Inherent Weight + Business Continuity Weight + Performance Weight + Labor Weight + Geography Weight + Custom Weight 1 + Custom Weight 2 + Custom Weight 3 + Custom Weight 4 + Node Criticality Weight)
Keep in mind that both the News Sentiment Score and Screening List input values are rescaled in the calculation to align with the 0 to 100 range for the other scores.
Aggregated Risk Score
Table: OptimizationOutputProductRiskSummary
Internal Name: AggregatedRiskScore
The weighted average of all risk scores (excluding node criticality) for this Risk Profile. Higher Composite Risk Score values indicate a high risk. This score is calculated as:
((100 - Financial Score)* Financial Weight + (100 - Judicial Score) * Judicial Weight + (100 - rescaled News Sentiment Score) * News Sentiment Weight + rescaled Screening List * Screening List Weight + Residual Score * Residual Weight + Inherent Score * Inherent Weight + (100 - Business Continuity Score) * Business Continuity Weight + (100 - Performance Score) * Performance Weight + (100 - Labor Score) * Labor Weight + (100 - Geography Score) * Geography Weight + Custom Score 1 * Custom Weight 1 + Custom Score 2 * Custom Weight 2 + Custom Score 3 * Custom Weight 3 + Custom Score 4 * Custom Weight 4) / (Financial Weight + Judicial Weight + News Sentiment Weight + Screening List Weight + Residual Weight + Inherent Weight + Business Continuity Weight + Performance Weight + Labor Weight + Geography Weight + Custom Weight 1 + Custom Weight 2 + Custom Weight 3 + Custom Weight 4)
Keep in mind that both the News Sentiment Score and Screening List input values are rescaled in the calculation to align with the 0 to 100 range for the other scores.
Scenario ID
Table: OptimizationOutputProductRiskSummary
Internal Name: ScenarioID
The identifier of the scenario for which the summary data was generated.
Sub-Scenario ID
Table: OptimizationOutputProductRiskSummary
Internal Name: StepNumber
The identifier of the sub-scenario, if applicable, for which the summary data was generated.
Last modified: Wednesday May 15, 2024