Enterprise AI Administration
Source-to-Target Mapping
Lineage from source systems to governed platform domains and fields.
Mappings by source system
Lineage into governed platform domains
Source-to-target mapping
| Source system | Source object / field | Transformation | Target domain | Target object / field | Grain | Refresh | Owner | |
|---|---|---|---|---|---|---|---|---|
| Billing | invoice_line.charge_amount | Exclude taxes and handset; allocate to revenue type | Revenue | service_revenue.service_revenue_zar | Account-month | Daily | Head of Billing Data | View details → |
| CRM | customer.segment | Map to governed segment codes | Customer | subscriber_dimension.segment_code | Subscriber-month | Daily | Customer Data Steward | View details → |
| CRM | subscription.status_change | Classify activations and disconnects | Customer | subscriber_movements.gross_adds / disconnects | Subscriber-day | Daily | Customer Data Steward | View details → |
| OSS / NOC | cell_counters.availability_minutes | Normalise counters to scheduled minutes | Network | network_performance.availability_pct | Site-hour | Hourly | Head of Network Data | View details → |
| Mediation / CDR | cdr.duration / volume | Rate, deduplicate, aggregate | Usage | subscriber_usage.usage_volume | Subscriber-day | Daily | Head of Data Engineering | View details → |
| Recharge | topup.amount | Aggregate per subscriber | Revenue | recharge_summary.recharge_amount | Subscriber-month | Daily | Revenue Data Steward | View details → |
| Trouble Ticketing | ticket.category | Map to complaint taxonomy | Customer Experience | complaints.complaint_category | Complaint-case | Daily | Head of CX Data | View details → |
| Contact Center | interaction.sentiment | Score sentiment −1 to +1 | Customer Experience | cx_interactions.sentiment_score | Subscriber-month | Daily | Head of CX Data | View details → |
| Digital App / Channels | app_event.event_type | Weight engagement events | Digital | digital_activity.digital_activity_score | Subscriber-month | Daily | Head of Digital Data | View details → |
| Finance ERP / GL | gl_entry.amount | Map GL accounts to opex/capex lines | Finance | financial_performance.opex / capex | Operator-month | Monthly | Finance Data Steward | View details → |
| Revenue Assurance | reconciliation.gap_amount | Estimate leakage by stream | Revenue Assurance | leakage.leakage_zar | Product-month | Daily | Head of RA Data | View details → |
| Fraud Monitoring | fraud_alert.loss_estimate | Confirm and classify fraud type | Revenue Assurance | fraud_cases.fraud_loss_zar | Fraud-case | Daily | Head of RA Data | View details → |
| Billing | roaming_tap.settlement_amount | Net partner settlement | Wholesale | roaming.roaming_margin | Partner-month | Monthly | Head of Wholesale Data | View details → |
| CRM | crm_subscribers.termination_date | Churn event when termination_date falls in period; voluntary/involuntary from reason code | Subscriber | subscriber_dimension.termination_date | Subscriber-month | Daily | Head of Customer Analytics | View details → |
| CRM | crm_subscribers.activation_date | Gross add when activation_date falls in period and first usage within 30 days | Subscriber | subscriber_dimension.activation_date | Subscriber-month | Daily | Head of Customer Analytics | View details → |
| Billing | billing_service_revenue.amount | Sum by revenue_type and billing_period; excludes equipment and VAT | Revenue | revenue_kpi_mart.service_revenue | Account-month | Daily | Head of Revenue Reporting | View details → |
| Billing | billing_subscriptions.plan_code | Map plan_code to governed tariff group | Subscriber | subscriber_monthly_features.plan_type | Subscriber-month | Daily | Head of Pricing & Revenue | View details → |
| Billing | billing_adjustments.adjustment_reason | Classify credits and write-offs; leakage-relevant reasons flagged | Revenue Assurance | revenue_kpi_mart.adjustment_amount | Account-month | Daily | Head of Revenue Assurance | View details → |
| Mediation / CDR | cdr_data_daily.data_mb | 30-day vs prior 30-day change per subscriber | Usage | subscriber_monthly_features.usage_decline_30d_pct | Subscriber-day | Daily | Head of Customer Analytics | View details → |
| Mediation / CDR | cdr_voice_daily.voice_minutes | 30-day vs prior 30-day change per subscriber | Usage | subscriber_monthly_features.voice_usage_change_30d_pct | Subscriber-day | Daily | Head of Customer Analytics | View details → |
| Recharge | recharge_transactions.recharge_date | Count of successful recharges per subscriber, last 30 days | Recharge | subscriber_monthly_features.recharge_frequency_30d | Subscriber-day | Daily | Head of Prepaid | View details → |
| OSS / NOC | oss_site_capacity.capacity_utilization_pct | Busy-hour maximum per site | Network | network_performance_mart.capacity_utilization_pct | Site-hour | Hourly | Head of Network Analytics | View details → |
| OSS / NOC | oss_alarm_events.severity | Count of CRITICAL alarms per site-day | Network | network_performance_mart.critical_alarm_count | Site-day | Hourly | Head of Network Operations | View details → |
| OSS / NOC | noc_incidents.outage_minutes | Sum of outage minutes per site-day; planned work excluded | Network | network_performance_mart.outage_minutes | Site-day | Hourly | Head of Network Operations | View details → |
| Contact Center | nps_responses.nps_score | Promoters (9–10) minus detractors (0–6), % of responses | Customer Experience | customer_experience_mart.nps_score | Region-day | Daily | Head of Customer Experience | View details → |
| Contact Center | customer_complaints.complaint_category | Count of complaints per subscriber, last 30 days | Customer Experience | customer_experience_mart.complaint_count_30d | Complaint-case | Daily | Head of Customer Experience | View details → |
| Revenue Assurance | ra_leakage_cases.estimated_amount | Sum of open and confirmed case amounts per period | Revenue Assurance | fraud_assurance_mart.leakage_amount | Fraud-case | Daily | Head of Revenue Assurance | View details → |
| Fraud Monitoring | fraud_cases.risk_score | Latest risk score per subscriber | Fraud | fraud_assurance_mart.fraud_anomaly_score | Fraud-case | Daily | Head of Fraud Management | View details → |
| Finance ERP / GL | gl_opex.amount | Filter energy cost centres; allocate to sites by consumption | Finance | revenue_kpi_mart.energy_opex | Site-day | Monthly | Head of Network Finance | View details → |
| Finance ERP / GL | budget_plan.budget_amount | Monthly phasing of approved budget by account | Finance | revenue_kpi_mart.budget_amount | Account-month | Monthly | Head of FP&A | View details → |