Source file: modules/RiskTemplates/DFMEATemplate/attachments/risksheet.json
Hierarchy Structure
The DFMEA risksheet organizes failure modes into a three-level tree:
| Level | Name | Control Column | Work Item Link |
|---|
| L1 | Item/Function | item | function via assesses link role |
| L2 | Failure Mode | failureMode | Free-text field |
| L3 | Cause | causes | Free-text field (causeOfFailure) |
Column Reference
Identification Columns
| Column ID | Type | Binding / Link | Level | Description |
|---|
item | itemLink | assesses -> function | 1 | Links to Function work items (filtered by queryFactory) |
failureMode | text | failureMode field | 2 | Free-text failure mode description |
| (effect) | text | effectOfFailure field | 2 | Downstream effects of the failure |
riskRecord | multiItemLink | analyzedIn <- riskRecord (backLink) | — | HARA cross-reference to risk records |
causes | text | causeOfFailure field | 3 | Root cause description |
Pre-Mitigation RPN Columns
| Column ID | Type | Binding | Level | Description |
|---|
sev | enum | fmSeverity (failureModeSeverity) | 2 | Severity rating (shared pre/post) |
occ | enum | premitigationFMOccurrence (fmOccurrence) | 3 | Pre-mitigation occurrence rating |
det | enum | premitigationDetection (detection) | 3 | Pre-mitigation detection rating |
| (RPN) | formula | commonRpn = S x O x D | — | Pre-mitigation Risk Priority Number |
Mitigation Task Columns
| Column ID | Type | Binding | Description |
|---|
task | taskLink | mitigates -> task | Links to mitigation action work items |
taskTitle | text | task.title | Mitigation action name |
taskStatus | enum | task.status | Action item status |
requirements | serverRender | Velocity | Linked sys_req/des_req via task back-links |
verification | serverRender | Velocity | Two-hop: task -> requirements -> verif_test_case |
Post-Mitigation RPN Columns (Final Ranking)
| Column ID | Type | Binding | Description |
|---|
occNew | enum | postmitigationFMOccurrence | Post-mitigation occurrence |
detNew | enum | postmitigationDetection | Post-mitigation detection |
rpnNew | formula | commonRpnNew = S x Onew x Dnew | Post-mitigation RPN |
Additional Columns
| Column ID | Type | Description |
|---|
component | serverRender | Resolves parent systemElement of the linked function |
description | formula | Auto-generated: function + failure mode + cause |
commonRpn formula: info.item['occ'] * info.item['det'] * info.item['sev']
Returns null if any factor is missing, preventing partial RPN calculations.
Severity (sev) is constant between pre and post-mitigation RPN. Only Occurrence and Detection change after mitigation actions are applied.
RPN Color Coding
| CSS Class | RPN Range | Color | Meaning |
|---|
rpn1 | 1 — 10 | Green | Low risk |
rpn2 | 11 — 30 | Amber | Medium risk |
rpn3 | > 30 | Red | High risk |
RPN thresholds are embedded in the cellDecorator JavaScript and are not configurable without modifying the risksheet JSON.
Component-Scoped Function Query
The functionQuery queryFactory dynamically filters available functions by the current component/subsystem:
function(info) { return 'linkedWorkItems:' + component }
component variable is set by the top panel Velocity template (risksheetTopPanel.vm) from the document’s subsystem custom field. This enables subsystem-scoped analysis where each DFMEA document only shows functions relevant to its assigned component.
HARA Cross-Reference
The riskRecord column uses multiItemLink with backLink: true to display HARA risk records that reference the failure mode via the analyzedIn link role. This creates bidirectional traceability between DFMEA and HARA:
- DFMEA
failureMode -> analyzedIn -> HARA riskRecord
- HARA
riskRecord -> cause column shows back-linked failure modes
Data Types and Views
| Data Type | Work Item Type | Link Role |
|---|
risk | failureMode | — |
task | task | mitigates |
rowHeaderRpnNew renderer color-codes each row header based on the post-mitigation RPN value, providing at-a-glance mitigation effectiveness.
