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

Is this useful?