Centre I :
- Colonnes obligatoires : REGION, TERRITORY, SA NAME, SA_INCHARGE, QUARTIER, TMA_ZONE, SECTOR, SITENAME, SITEID, POS_MSISDN, PROFILE, FULL_NAME, SEGMENT_GROUP, TYPE POS, STATUS POS
- Colonnes optionnelles : NON SERVI DATE, NON SERVI
- Note : Structure trimestrielle - mise à jour tous les 3 mois
Centre III :
- pos_msisdn, profile, fullname, account_status
- 1-Day Target, OOS FREQUENT
- parentmsisdn, zone, territory, quartier, tma_zone, sector, sitename, site_id
- dp_incharge, sa_incharge, is_mpic_active
- recency, recency_score, recency_rank, frequency, freq_score, freq_rank
- daily_amt, daily_amt_score, daily_amt_rank, daily_nb_trx, daily_soi
- score, score_rank, segment, segment_group, report_date, Q2
Littoral II :
- POS MSISDN, PROFILE, FULL NAME, ACCOUNT STATUS
- 1-Day Target, OOS FREQUENT
- PARENT MSISDN, ZONE, TARRITORY, QUATER, TMA ZONE, SECTOR, SITENAME, SITE ID
- DP_INCHARGE, SA_INCHARGE, is_mpic_active
- RECENCY, RECENCY_SCORE, RECENCY_RANK, FREQUENCY, FREQ_SCORE, FREQ_RANK
- DAILY AMT, DAILY AMT SCORE, DAILY AMT RANK, DAILY NB TRX, DAILY SOI
- SCORE, SCORE RANK, SEGMENT, SEGMENT GROUP, REPORT DATE, DATE KEY
Les colonnes sont automatiquement mappées même si les noms varient (majuscules/minuscules, espaces, virgules).