Aarvian / Telecom Operator
›Data Sources
All agentsOnline
Data Sources · Sanitised Telecom Operator slice (demo)
The data lineage from CDR to strategy
7 source systems ingested daily across the 4 data layers (Customer · Network · S&D · Market). PII fields are hashed at ingest. This view mirrors the schema expected when integrated with Telecom Operator's real production pipeline.
Source systems
7
Aggregate rows
2,099,339,103
Data layers
4
Ingestion health
100%
Customer / Base Management
Service Delivery Platform — Monthly Aggregate
Source system
Huawei SDP
Refresh
Daily 02:00 GST
Owner
Customer Value Mgmt
Rows (est)
3,312,072
Source ID
sdp_dump_ma
Schema
| Field | Type | Description |
|---|---|---|
| msisdnPII | VARCHAR(15) | Hashed subscriber MSISDN |
| circle_id | VARCHAR(20) | Zone code (NCSI) |
| segment | ENUM | High / Mid / Low value |
| arpu_3m_avg | DECIMAL(8,2) | Trailing 3-month ARPU in OMR |
| data_mb_3m | BIGINT | Trailing 3-month data consumption |
| voice_min_3m | BIGINT | Trailing 3-month voice minutes |
| last_rge_date | DATE | Last recharge date — churn anchor |
| handset_tier | ENUM | Premium / Mid / Entry / Feature |
Feeds KPIs
total_subsarpuhigh_subs_pctdata_users_pctchurn_risk_pct
Real schema, sanitised values
Lineage
All 4 data layers (Customer / Network / S&D / Market) flow into the Strategy Grid via the Customer Intelligence and Sales & Distribution Agents, then surface into the Strategy Orchestrator. PII fields (MSISDN) are hashed at ingestion.