Source Mapping
Metric-to-source registry aligned to Project Data Map, OPG templates and Data Map Tagup inputs.
Level 3 — Admin / Governance · Source Mapping — metric decisions & audit
Audience: PMO, Finance, IT. Not the PM daily default — use project routes for operational summary.
PPMP Operating Model
Capture once · Validate once · Use operationally · Export / integrate cleanly
Every capability: view · input · validate · audit · output
- No feature added only because data exists
- No simulated/demo values in production export
- Missing source = no export
- UAT seed must be marked and excluded from production export
- Every warning has one clear CTA
- PM routes default to Operational UX level
Capability Registry (24 capabilities)
Operational: 12Investigation: 6Governance: 6
| ID | Name | Level | PM | V·I·Va·A·O | Fusion | PBI | Outbound | Status |
|---|---|---|---|---|---|---|---|---|
| cost.health-summary | Cost Health | Operational | 5 | ✓·✓·✓ | Deferred | true | Needs transformation | Partial |
| cost.itd | ITD Cost | Operational | 5 | ✓✓✓✓✓ | true | true | Ready for Power BI | Partial |
| cost.etc | ETC Cost | Operational | 4 | ✓✓✓✓✓ | Manual only | true | Ready for Power BI | Partial |
| cost.eac | EAC Cost | Operational | 5 | ✓·✓·✓ | true | true | Needs transformation | Partial |
| cost.variance-baseline | Variance vs Baseline | Operational | 5 | ✓·✓·✓ | true | true | Ready for Power BI | Partial |
| cost.forecast-accuracy | Forecast Accuracy | Operational | 4 | ✓·✓·✓ | false | true | Ready for Power BI | Partial |
| cost.top-driver | Top Cost Driver | Operational | 4 | ✓·✓·✓ | false | true | Ready for Power BI | Partial |
| cost.exceptions-actions | Exceptions & Recommended Actions | Operational | 5 | ✓·✓·· | false | false | — | Ready |
| cost.monthly-monitoring | Monthly Monitoring | Investigation | 3 | ✓·✓·✓ | false | true | Ready for Power BI | Partial |
| cost.forecast-vs-actual | Forecast vs Actual | Investigation | 4 | ✓·✓·✓ | false | true | Ready for Power BI | Partial |
| cost.eac-view | EAC View | Investigation | 3 | ✓·✓·✓ | true | true | Needs transformation | Partial |
| cost.cbs-matrix | CBS Matrix | Investigation | 4 | ✓✓✓✓✓ | true | true | Ready for Power BI | Partial |
| cost.source-details | Source Details | Investigation | 3 | ✓···· | false | false | — | Ready |
| cost.controls-table | Cost Controls (12 metrics) | Investigation | 3 | ✓·✓·✓ | true | true | Ready for Power BI | Partial |
| cost.input-cbs-actual | Add CBS Actual | Operational | 5 | ✓✓✓✓✓ | true | true | Ready for Power BI | Ready |
| cost.import-actuals | Import Cost Actuals | Operational | 5 | ✓·✓✓✓ | true | true | Ready for Power BI | Ready |
| forecast.summary | Forecast Operational Summary | Operational | 5 | ✓✓✓✓✓ | Manual only | true | Ready for Power BI | Partial |
| forecast.import | Forecast Import | Operational | 4 | ✓·✓✓✓ | Manual only | true | Ready for Power BI | Partial |
| governance.source-mapping | Source Mapping | Governance | 1 | ✓✓·✓· | true | false | Ready for Fusion mapping | Ready |
| governance.fusion-readiness | Fusion Readiness | Governance | 1 | ✓✓·✓· | true | false | Ready for Fusion mapping | Ready |
| governance.powerbi-model | Power BI Data Model | Governance | 1 | ✓···· | false | true | Ready for Power BI | Partial |
| cost.field-readiness | Field Readiness | Governance | 1 | ✓···· | false | false | Not worth exporting | Ready |
| cost.audit-log | Cost Input Audit Log | Governance | 1 | ✓··✓✓ | false | false | Manual only | Partial |
| governance.data-quality | Data Quality | Governance | 2 | ✓·✓·· | false | true | Needs transformation | Partial |
Output entities & export gatekeeper
- Block UAT seed rows from production export (Notes/Justification markers)
- Missing source = no export row for that metric
- Graph connection failure = export job fails — no fallback data
- No simulated or demo values in export payloads
- Validation status Blocked prevents export commit
- Warning allows export with quality flags in metadata
- Needs owner / Needs mapping = human sign-off before production feed
| Entity | Grain | Fusion | PBI | Export gate | Readiness |
|---|---|---|---|---|---|
| CostActualCbs | ProjectKey + PeriodMonth + CBSCode | true | Yes | Warning | Ready for Power BI |
| FactFinancialActualsMonthly | ProjectKey + Month + Metric | true | Yes | Warning | Ready for Power BI |
| FactForecast | ProjectKey + PeriodMonth + ForecastLineId + MetricType | Manual only | Yes | Warning | Ready for Power BI |
| FactCostControls | ProjectKey + AsOfMonth + CostControlMetric | true | Yes | Needs mapping | Needs transformation |
| FactCommitments | ProjectKey + POId + AsOfDate | true | Yes | Needs owner | Ready for Fusion mapping |
| FactContingency | ProjectKey + ContingencyMetric + AsOfDate | Manual only | Yes | Needs owner | Manual only |
| FactCostVariance | ProjectKey + PeriodMonth + CBSCode (optional) | true | Yes | Warning | Ready for Power BI |
| RevenueDiscount | ProjectKey + PeriodMonth | Deferred | Yes | Blocked | Deferred |
| FxRates | CurrencyPair + EffectiveDate | false | Yes | Warning | Ready for Power BI |
| FactCashflowMonthly | ProjectKey + PeriodMonth + CashflowType + SourceRecordId | Manual only | Yes | Warning | Needs transformation |
| FactReceivablesTiming | ProjectKey + BillingRecordId + ExpectedCollectionMonth | Manual only | Yes | Warning | Needs transformation |
| FactCostOutflowTiming | ProjectKey + POId + ExpectedOutflowMonth | Manual only | Yes | Warning | Needs transformation |
| FactCashflowVariance | ProjectKey + PeriodMonth + Metric | false | Yes | Warning | Needs transformation |
| FactFinancialResultsVsAOPMonthly | ProjectKey + POId + PeriodMonth + Metric + Scenario + RevenueBasis | Manual only | Yes | Warning | Needs transformation |
Input → outbound mappings (6)
| Screen | Source list | Audit event | Export target | Outbound |
|---|---|---|---|---|
| Financial > Cost → Input → Add CBS Actual | PPMP_Contract_Monthly_Snapshots | FINANCIAL_COST_INPUT → PPMP_Audit_Log (CREATE/UPDATE) | FactFinancialActualsMonthly | Ready for Power BI |
| Financial > Cost → Input → Import Cost Actuals | PPMP_Contract_Monthly_Snapshots | FINANCIAL_COST_INPUT → PPMP_Audit_Log (IMPORT) | FactFinancialActualsMonthly | Ready for Power BI |
| Financial > Forecast → Import | PPMP_Forecast_Curves | FINANCIAL_FORECAST_INPUT → PPMP_Audit_Log (IMPORT) | FactForecast | Ready for Power BI |
| Financial > FX Rates → Import | PPMP_FX_Rates_Monthly | FINANCIAL_FX_INPUT → PPMP_Audit_Log (IMPORT) | DimFxRate | Ready for Power BI |
| Financial > Cashflow → Input wizard | PPMP_Billing_Register (payments) / manual timing | FINANCIAL_CASHFLOW_INPUT → PPMP_Audit_Log (CREATE/UPDATE) | FactCashflowMonthly | Needs transformation |
| Financial > Cashflow → Import | PPMP_Billing_Register / timing overlays | FINANCIAL_CASHFLOW_INPUT → PPMP_Audit_Log (IMPORT) | FactCashflowMonthly | Needs transformation |
Export / integration specs (11)
| Export | Source | Target table | Validation | Outbound |
|---|---|---|---|---|
| Cost Actuals (CBS) | PPMP_Contract_Monthly_Snapshots | FactFinancialActualsMonthly | Warning | Ready for Power BI |
| Forecast Curves | PPMP_Forecast_Curves | FactForecast | Warning | Ready for Power BI |
| Actuals Monitoring (JP) | PPMP_Contract_Monthly_Snapshots, PPMP_PO_Monthly_Consumption | FactFinancialActualsMonthly | Warning | Ready for Power BI |
| Cost Controls Snapshot | Computed FinancialCostControlsService | FactCostControls | Needs mapping | Needs transformation |
| PO Commitments | PPMP_PO_Master | FactCommitments | Needs owner | Ready for Fusion mapping |
| Contingency Metrics | PPMP_Contracts | FactContingency | Needs owner | Manual only |
| FX Rates | PPMP_FX_Rates | DimFxRate | Warning | Ready for Power BI |
| Revenue Discount | PPMP_Contracts / billing context | FactRevenueDiscount | Blocked | Deferred |
| Cashflow Monthly | PPMP_Billing_Register, PPMP_PO_Monthly_Consumption | FactCashflowMonthly | Warning | Needs transformation |
| Receivables Timing | PPMP_Billing_Register | FactReceivablesTiming | Warning | Needs transformation |
| Cashflow Forecast vs Actual | Derived (FinancialCashflowService) | FactCashflowVariance | Warning | Needs transformation |
No live Fusion connector — specs define feeder readiness only. API routes document read sources for export jobs.
Official Source Registry Validation
Official domain → list mapping
| Domain | Official env vars | Lists |
|---|---|---|
| Financials | SHAREPOINT_CONTRACTS_LIST_ID, SHAREPOINT_CONTRACT_MONTHLY_SNAPSHOTS_LIST_ID, SHAREPOINT_FORECAST_CURVES_LIST_ID, SHAREPOINT_PO_MASTER_LIST_ID, SHAREPOINT_PO_MONTHLY_CONSUMPTION_LIST_ID, SHAREPOINT_BILLING_REGISTER_LIST_ID | PPMP_Contracts, PPMP_Contract_Monthly_Snapshots, PPMP_Forecast_Curves, PPMP_PO_Master, PPMP_PO_Monthly_Consumption, PPMP_Billing_Register |
| Schedule | SHAREPOINT_PROJECT_SCHEDULE_WBS_LIST_ID, SHAREPOINT_PROJECT_MILESTONES_LIST_ID, SHAREPOINT_PROJECT_EXECUTION_TASKS_LIST_ID | PPMP_Project_Schedule_WBS, PPMP_Project_Milestones, PPMP_Project_Execution_Tasks |
| Risks | SHAREPOINT_RISK_REGISTER_LIST_ID, SHAREPOINT_RISKS_LIST_ID | PPMP_Risk_Register, PPMP_Risks (legacy secondary) |
| Clarifications | SHAREPOINT_CLARIFICATIONS_LOG_LIST_ID | PPMP_Clarifications_Log |
| Actions / Decisions / Follow-ups | SHAREPOINT_ACTIONS_LIST_ID | PPMP_Actions |
| Meetings | SHAREPOINT_MEETINGS_LIST_ID | PPMP_Meetings |
| MDR | SHAREPOINT_MDR_DOCUMENTS_LIST_ID | PPMP_MDR_Documents |
| Quality | SHAREPOINT_QUALITY_RECORDS_LIST_ID, SHAREPOINT_LESSONS_LEARNED_LIST_ID | PPMP_Quality_Records, PPMP_Lessons_Learned |
| HSSE | SHAREPOINT_HSSE_RECORDS_LIST_ID | PPMP_HSSE_Records |
| Billing / QtC | SHAREPOINT_BILLING_CYCLES_LIST_ID, SHAREPOINT_BILLING_REGISTER_LIST_ID, SHAREPOINT_PSR_RECORDS_LIST_ID | PPMP_Billing_Cycles, PPMP_Billing_Register, PPMP_PSR_Records |
| Variations | SHAREPOINT_VARIATIONS_LIST_ID, SHAREPOINT_CONTRACT_SCENARIOS_LIST_ID, SHAREPOINT_CONTRACT_ALERTS_LIST_ID | PPMP_Variations, PPMP_Contract_Scenarios, PPMP_Contract_Alerts |
| Audit | SHAREPOINT_AUDIT_LOG_LIST_ID | PPMP_Audit_Log |
| Project lookup (fallback order) | SHAREPOINT_PROJECT_REGISTER_LIST_ID, SHAREPOINT_PROJECTS_LIST_ID, SHAREPOINT_PROJECT_GATE_LOG_LIST_ID, SHAREPOINT_PROJECT_CONTRACT_REVIEW_LIST_ID, SHAREPOINT_JOB_CREATION_REQUEST_LIST_ID | PPMP_Project_Register, PPMP_Projects, PPMP_Project_Gate_Log, PPMP_Project_Contract_Review, PPMP_Job_Creation_Request |
Financial → Cost (Renata 12 controls)
| Metric | Renata / PPMP source | Future source | Automation decision | Owner | PM / Leadership value | Effort | Decision |
|---|---|---|---|---|---|---|---|
| As Bid Cost | Renata: PPSFT · PPMP: PPMP_Contracts (AsBidCost); fallback PPMP_Contract_Line_Items | Oracle Fusion Project Budget / PPSFT bid extract | Defer to Fusion | Finance | Estimated cost from bid activities. PM value 2/5 · Leadership 3/5. | High | Defer |
| Baseline Cost | Renata: PPSFT · PPMP: PPMP_Contracts (BaselineCost, BaselineVersion, BaselineApprovedBy) | Oracle Fusion Project Budget — Approved Baseline | Keep and automate | Finance | Approved baseline budget incl. approved VOs. PM value 3/5 · Leadership 5/5. | High | Automate Later |
| ITD Cost | Renata: PPSFT · PPMP: PPMP_Contract_Monthly_Snapshots (CBS ActualCost) | Oracle Fusion / PPSFT actual cost extract | Keep and automate | Finance | Inception-to-date materialized actual costs. PM value 4/5 · Leadership 5/5. | Medium | Automate Later |
| Commitments | Renata: PPSFT · PPMP: PPMP_PO_Master; PPMP_PO_Monthly_Consumption | Oracle Fusion Purchasing / PPSFT PO commitment | Keep and automate | SCM / Finance | Future cost obligations committed contractually. PM value 2/5 · Leadership 3/5. | Medium | Automate Later |
| ETC Cost | Renata: Manual · PPMP: PPMP_Forecast_Curves (ForecastCost) | Oracle Fusion forecast / PPMP_Forecast_Curves bridge | Keep manual for pilot | PM / Finance | Estimated projected cost to complete. PM value 3/5 · Leadership 4/5. | High | Keep |
| EAC / Actual Cost | Renata: WDA · PPMP: Derived: FinancialCostControlsService (ITD + ETC) | WDA / Oracle Fusion EAC | Keep and automate | Finance | Total projected or actual cost at completion. PM value 4/5 · Leadership 5/5. | Low | Automate Later |
| As Bid Contingency | Renata: Manual · PPMP: PPMP_Contracts (AsBidContingency) | Fusion contingency / manual Finance | Keep ad hoc only | Finance | Contingency in cost estimate. PM value 2/5 · Leadership 2/5. | High | Needs Data Source Confirmation |
| Allocated Contingency | Renata: Manual · PPMP: PPMP_Contracts; PPMP_Risk_Register fallback | Fusion + PPMP_Risk_Register bridge | Keep manual for pilot | Risk / Finance | Contingency allocated to risks. PM value 2/5 · Leadership 3/5. | High | Keep |
| Unallocated Contingency | Renata: Manual · PPMP: Derived: AsBid − Allocated | Derived from Fusion contingency fields | Keep and automate | Finance | Remaining contingency not allocated. PM value 3/5 · Leadership 3/5. | Low | Keep |
| Contingency Remaining | Renata: Manual · PPMP: PPMP_Contracts (ContingencyUsed); derived | Fusion contingency consumption | Keep manual for pilot | Finance | Contingency not yet spent. PM value 3/5 · Leadership 3/5. | Medium | Keep |
| Cost Variance Total + Per Activity | Renata: Manual · PPMP: Derived; PPMP_Contract_Line_Items + snapshots | Fusion EAC vs Baseline; CBS actuals | Keep and automate | Finance | EAC vs Baseline; CBS breakdown. PM value 3/5 · Leadership 5/5. | Low | Automate Later |
| Cost Over Time | Renata: Manual · PPMP: PPMP_Contract_Monthly_Snapshots; PPMP_Forecast_Curves | Fusion actual cost by period | Keep and automate | Finance / PM | Monthly spend actual + forecast monitoring. PM value 4/5 · Leadership 5/5. | Medium | Automate Later |
Domain: Financial / Cost · 12 controls mapped (no new SharePoint lists or fields).
Decision defaults reference (config baseline)
| Metric | Domain | Availability | Automation | Decision | New list? | Next action |
|---|---|---|---|---|---|---|
| Project health domain score | Governance | Partial | Partial | Keep | No | Populate missing list records for CLTST domains |
| EAC / revenue weighted portfolio score | Financial | Not Ready | Not Ready | Defer | No | Confirm contract snapshots for active projects |
| Risk register completeness | Risk | Ready | Partial | Keep | No | Resolve DQ findings (owner, response plan) |
| Portfolio rotation schedule | Meetings | Partial | Partial | Needs Data Source Confirmation | No | Lucas approve PPMP_Project_Register field extension |
| Meeting input persistence | Meetings | Partial | Ready | Automate Later | No | Complete Check-in UAT on CLTST |
| Health trend history | Governance | Not Ready | Not Ready | Defer | No | Decide snapshot vs audit-only approach |
List reuse strategy
| Proposed list | Status | Reuse | Rationale |
|---|---|---|---|
| PPMP_Meeting_Types | config | — | Meeting type definitions are stable reference data — versioned in meeting-cadences.ts. |
| PPMP_Meeting_Cycles | extend | PPMP_Meetings | Each meeting instance is a cycle occurrence — extend PPMP_Meetings with cadenceId and cycleStatus. |
| PPMP_Meeting_Inputs | extend | PPMP_Meetings | Preparation inputs map to agenda + structured narrative fields on meeting rows; generator drafts from live project data. |
| PPMP_Meeting_Actions | reuse | PPMP_Actions | Actions already have owner, due date, status — link via sourceReference to meetingId. |
| PPMP_Decision_Log | extend | PPMP_Meetings + PPMP_Actions | Decisions field on PPMP_Meetings for narrative; escalated decisions become PPMP_Actions with category Decision. |
| PPMP_Project_Health_Snapshots | proposed | — | Computed on read today via ProjectHealthService; snapshot list only needed when historical trending is required. |
| PPMP_Data_Source_Map | config | — | Source mapping registry in lib/pm-os/source-mapping-registry.ts — promote to SharePoint when governance workflow requires approval. |
| PPMP_KPI_Dictionary | config | — | KPI definitions align to metricsRegistry / source-mapping — shared with admin Source Mapping page. |
| PPMP_Project_Priorities | reuse | PPMP_Actions | Weekly priorities are high-priority open actions filtered by projectKey. |
| PPMP_Portfolio_Rotation | config | — | Monthly overview rotation schedule in MEETING_ROTATION_SCHEDULE — no separate list until multi-BU rotation is live. |
| PPMP_Quarterly_KPI_Actions | reuse | PPMP_Actions | Improvement actions from quarterly review map to PPMP_Actions with sourceType Quarterly KPI Review. |
Capability reuse assessment
| Capability | Domain | Current | PPMP list | Reuse | Gap | Action | New list? | Why required | Meetings | Dashboards | Effort | Automation | Decision |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Meeting inputs (draft narrative) | Meetings | Meeting input generator + PPMP_Meetings.agenda | PPMP_Meetings (SHAREPOINT_MEETINGS_LIST_ID) | Partial | EvidenceUrl, ReviewedBy/At lack dedicated columns — JSON in agenda/openQuestions only | Persist drafts via meeting cycle API; extend list only after approval | No | PM must prepare and submit meeting input each cycle | All four meeting workspaces | PM Daily Brief | Medium | Partial | Keep |
| Meeting cycles / lifecycle status | Meetings | PPMP_Meetings.status + meetingType | PPMP_Meetings | Yes | Statuses Draft/Submitted map to field_4; Prepared/Reviewed/Closed use same field | Use meeting cycle service — one row per projectKey + cadenceId + date | No | — | — | — | — | — | Keep |
| Meeting actions / follow-ups | Meetings | PPMP_Actions | PPMP_Actions | Yes | Duplicate prevention via ProjectKey + MeetingType + Title + DueDate | Create follow-up actions from meeting workspace | No | — | — | — | — | — | Keep |
| Decision log | Governance | PPMP_Actions (isDecisionLinked / sourceType / title prefix) | PPMP_Actions | Partial | No RelatedRisk/RelatedClarification structured links — use description/notes | Use decision log view; structured field extension optional | No | — | — | — | — | — | Keep |
| Project health (current) | Health | ProjectHealthService computed on read | Multiple PPMP lists (aggregate) | Yes | No historical snapshot list | Use /health/* and performance domain pages | No | — | — | — | — | — | Keep |
| Health history / trends | Health | Not persisted | None | No | Requires new list or gate log extrapolation — not sufficient today | Propose PPMP_Project_Health_Snapshots — do not auto-create | Yes | — | — | — | — | — | Defer |
| KPI dictionary | KPI | source-mapping-registry.ts + meeting cadences | Config (no list) | Partial | No PPMP_KPI_Dictionary list — KPIs derived from billing/contracts/health | Quarterly KPI uses generator + lessons/actions | No | — | — | — | — | — | Defer |
| Data source map | Admin | lib/pm-os/source-mapping-registry.ts | Config | Yes | In-app registry only | Admin Source Mapping page | No | — | — | — | — | — | Keep |
| Portfolio rotation | Portfolio | PPMP_Project_Register → PPMP_Projects → demo fallback | PPMP_Project_Register | Yes | Demo config used when no active projects | Populate project register with active projects | No | — | — | — | — | — | Keep |
| Quarterly improvement actions | KPI | PPMP_Actions + PPMP_Lessons_Learned recommendations | PPMP_Actions | Yes | No KPI-specific action category — use sourceType quarterly | Create actions from quarterly KPI workspace | No | — | — | — | — | — | Keep |
| Performance domain cards | Performance | Performance domain API aggregating list candidates | Per-domain PPMP lists | Partial | Some .env list IDs missing per domain | Grey health + missing data warnings on each domain page | No | — | — | — | — | — | Keep |
| Financial dashboards | Financials | Contracts, snapshots, forecast, billing register, PO | PPMP_Contracts + related | Partial | Requires contract list configured per project | Link to /performance/financials and /contract | No | — | — | — | — | — | Keep |
| Billing / QtC dashboard | Billing | PPMP_Billing_Cycles, PPMP_Billing_Register, PPMP_PSR_Records | PPMP_Billing_Cycles | Yes | None if lists configured | Use /performance/billing | No | — | — | — | — | — | Keep |
| MDR / documentation dashboard | Documentation | PPMP_MDR_Documents | PPMP_MDR_Documents | Yes | None if list configured | Use /performance/mdr | No | — | — | — | — | — | Keep |
| HSSE dashboard | HSSE | PPMP_HSSE_Records | PPMP_HSSE_Records | Yes | Records may be empty for new projects | Use /performance/hsse | No | — | — | — | — | — | Keep |
| Quality dashboard | Quality | PPMP_Quality_Records + PPMP_Lessons_Learned | PPMP_Quality_Records | Yes | None if list configured | Use /performance/quality | No | — | — | — | — | — | Keep |
| Risk / opportunity dashboard | Risk | PPMP_Risk_Register (+ legacy PPMP_Risks) | PPMP_Risk_Register | Yes | Legacy risks list optional | Gate 10 + /performance/risks | No | — | — | — | — | — | Keep |
| Schedule / progress dashboard | Schedule | PPMP_Project_Schedule_WBS, PPMP_Project_Milestones, PPMP_Project_Execution_Tasks | PPMP_Project_Milestones | Partial | WBS/execution tasks require list IDs in .env | Use /performance/schedule | No | — | — | — | — | — | Keep |
Proposed new lists (not auto-created)
| List | Reason | Minimum fields |
|---|---|---|
| PPMP_Meeting_Inputs | Only if PPMP_Meetings cannot store structured meeting input after schema review | ProjectKey, CadenceId, MeetingDate, Status, SubmittedInput, EvidenceUrl |
| PPMP_Project_Health_Snapshots | Health history / trends — current health is computed on read only | ProjectKey, SnapshotDate, DomainScores JSON, OverallRag |
| PPMP_Decision_Log | Only if PPMP_Actions decision fields prove insufficient after field extension review | DecisionTitle, Context, Owner, DueDate, Status, RelatedMeeting |
| PPMP_KPI_Dictionary | Structured KPI definitions if config file governance is insufficient | KpiId, Name, Formula, SourceList, Cadence |
Metrics source map
| Metric | Domain | Current | Future | Owner | Quality | Meetings | Dashboard | Decision |
|---|---|---|---|---|---|---|---|---|
| Baseline Cost | Cost Management | PCMS Excel | Oracle Fusion | Project Controls | Needs cleanup | Yes | Yes | Keep |
| ITD Cost / EAC | Cost Management | PeopleSoft + PCMS | Oracle Fusion | Finance | Ready | Yes | Yes | Keep |
| Revenue Earned | Revenue Management | PeopleSoft | Oracle Fusion | Finance | Ready | Yes | Yes | Keep |
| Hours by Activity Code | Labor / Hours | WDA / PPSFT | Oracle Fusion | Project Controls | Needs cleanup | Yes | No | Keep |
| Document OTD | Documentation / MDR | Excel MDR local | MDR corporativo | Document Control | Needs cleanup | Yes | Yes | Keep |
| COPQ | Quality | Quality BI | Quality BI | Quality Lead | Ready | Yes | Yes | Keep |
| TRIR / LSR Violations | HSSE | HSE BI | HSE BI | HSE Lead | Ready | Yes | Yes | Keep |
| Pending VO Aging | Variations | Project VO Register Excel | Fusion + VO Register | Commercial | Needs cleanup | Yes | Yes | Keep |
| VOC Score | Quality | Global VOC | Global VOC | Quality | Ready | Yes | Yes | Defer |
| Vessel Days (ad hoc) | Operations | Planilha local | To confirm | Operations Lead | To confirm | Yes | No | To Confirm |