Page 26 - Methodology for inter-operator and cross-border P2P money transfers

Table 3 Structure and content example of a Device Assignment List (DAL)

Column name Example Type Function Hints/Further remarks
CheckStatus Ok Text Can be used for valida- Free text, can be empty
tion vs. log files
OwnerTeam MTN Ghana Text Name of the team By default, same as con-
figuration name (An Excel
DAL can use a formula
here)
Country Ghana Text Country
Operator MTN Text Operator (DFS/mobile
network)
ConfigName MTN Ghana Text Logical configuration An Excel DAL can use a
name (default: Opera- formula here
tor<blank>Country)
Start_Allocation 30.04.2020 00:00 Date/Time Date (time is optional) see remarks
End_Allocation 19.06.2020 00:00 Date/Time Date/time (see remarks). see remarks
Can be left empty
Config1_DFS_IMEI 354481115999999 Text IMEI of the device in the Although an IMEI only con-
primary DFS role tains numeric characters,
respective fields should
be treated as text to avoid
artefacts by conversion.
May also use "text-dec-
orated" variants to ease
import to databases
Config1_Obstool_IMEI 354481115888888 Text IMEI of the device in the
primary "observer" role
Config1_FIMSW_ID c07eead8-62e8- Text MSW ID of the device
41dc-b3fb-d5c- in the primary Observer
1b3a7cde6 role
Config2_DFS_IMEI 354481115888888 Text IMEI of the device in the An Excel DAL can use a
secondary DFS role formula here to get con-
Config2_Obstool_IMEI 354481115999999 Text IMEI of the device in the tent from "opposite" fields
secondary "observer"
role
Config2_FIMSW_ID d12c73fe-8961-450a- Text MSW ID of the device in
8b9f-bc431e394c3e the secondary Observer
role
Remarks Text Free text
Remarks: er time-windowing only considering actual test-
ing-campaign times.
• The DAL structure shown here has the functionally • If device allocations do not change over time,
required minimum number of elements. Addition- both the Start_Allocation and End_Allocation
al elements may be useful, such as e.g., the phone fields could be left empty. In that case, data base
number associated to a device. procedures must make sure proper treatment of
• Typically, the Start_Allocation and End_Allocation content e.g., by setting default dates/times.
fields are including pre- and after-campaign rang- • If device allocation changes during the campaign,
es, and actual time windowing for KPI reporting Start_Allocation and End_Allocation must be
is made in respective processing steps. In a typi- used to properly describe these allocations. In
cal data base based post processing, JOIN oper- respective JOIN operations, SQL BETWEEN state-
ations also using these time ranges are applied. ments will be used; if only a date is given w/o time
These fields can however also be used for a tight- information, 00:00 is assumed. Make sure to that
respective time regions are complete (i.e., include

24 Methodology for inter-operator and cross-border P2P money transfers