A Sample Mapping for ECE Cartridge Pack
This appendix contains the sample mapping for the Oracle Communications Offline Mediation Controller Elastic Charging Engine (ECE) Distribution Cartridge (DC).
Topics in this document:
About the Sample Mapping
The sample mapping includes:
-
The input attribute-value pairs (AVPs) in the call detail records (CDRs)
-
The values in the ECE payload specification files
-
The ECE usage requests and payload parameters Offline Mediation Controller uses to build the usage request to send to ECE
Supported Usage Types
The ECE DC supports the following usage types for offline usage requests:
-
Terminate
-
Update
-
Refund_Unit
-
Refund_Amount
-
Cancel
-
Debit_unit
-
Debit_amount
Note:
For refund usage types, the input CDR must contain the correlation_identifier value of the original debit request.
Mapping for ASCII
By default, the ECE DC supports the following ASCII product types:
-
Voice
-
Data
-
SMS
Voice
Product Type = VOICE
Event Type = USAGE
Usage Type = Terminate
Table A-1 shows the sample ASCII voice mappings for the Terminate usage type.
Table A-1 Sample ASCII Voice Mapping for the Terminate Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
duration |
USED_UNITS[0].DURATION |
N/A |
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
Product Type = VOICE
Event Type = USAGE
Usage Type = Update
Table A-2 shows the sample ASCII voice mappings for the Update usage type.
Table A-2 Sample ASCII Voice Mapping for the Update Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
Req_Duration |
REQUESTED_UNITS[0].DURATION |
N/A |
|
Used_Duration |
USED_UNITS[0].DURATION |
N/A |
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
Product Type = VOICE
Event Type = USAGE
Usage Type = Refund_Unit
Table A-3 shows the sample ASCII voice mappings for the Refund_Unit usage type.
Table A-3 Sample ASCII Voice Mapping for Refund_Unit Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
Used_duration |
USED_UNITS[0].DURATION |
N/A |
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
|
correlation_identifier |
CORRELATION_IDENTIFIER |
N/A |
Product Type = VOICE
Event Type = USAGE
Usage Type = Refund_Amount
Table A-4 shows the sample ASCII voice mappings for the Refund_Amount usage type.
Table A-4 Sample ASCII Voice Mapping for the Refund_Amount Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
|
balance_element_id |
IMPACT_AMOUNT[0].BALANCE_ELEMENT_ID |
N/A |
|
amount |
IMPACT_AMOUNT[0].AMOUNT |
N/A |
|
correlation_identifier |
CORRELATION_IDENTIFIER |
N/A |
Data
Product Type = DATA
Event Type = USAGE
Usage Type = Terminate
Table A-5 shows the sample ASCII data mappings for the Terminate usage type.
Table A-5 Sample ASCII Data Mapping for the Terminate Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
cell_id |
CELL_ID |
N/A |
|
usedUnitsInputVolume |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
usedUnitsOutputVolume |
USED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
usedUnitsTotalVolume |
USED_UNITS[0].TOTAL_VOLUME |
N/A |
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
Product Type = DATA
Event Type = USAGE
Usage Type = Update
Table A-6 shows the sample ASCII data mappings for the Update usage type.
Table A-6 Sample ASCII Data Mapping for the Update Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
cell_id |
CELL_ID |
N/A |
|
requestedInputVolume |
REQUESTED_UNITS[0].INPUT_VOLUME |
N/A |
|
requestedOutputVolume |
REQUESTED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
requestedTotalVolume |
REQUESTED_UNITS[0].TOTAL_VOLUME |
N/A |
|
usedUnitsInputVolume |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
usedUnitsOutputVolume |
USED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
usedUnitsTotalVolume |
USED_UNITS[0].TOTAL_VOLUME |
N/A |
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
Product Type = DATA
Event Type = USAGE
Usage Type = Refund_Unit
Table A-7 shows the sample ASCII data mappings for the Refund_Unit usage type.
Table A-7 Sample ASCII Data Mapping for the Refund_Unit Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
cell_id |
CELL_ID |
N/A |
|
usedUnitsInputVolume |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
usedUnitsOutputVolume |
USED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
usedUnitsTotalVolume |
USED_UNITS[0].TOTAL_VOLUME |
N/A |
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
|
correlation_identifier |
CORRELATION_IDENTIFIER |
N/A |
Product Type = DATA
Event Type = USAGE
Usage Type = Refund_Amount
Table A-8 shows the sample ASCII data mappings for the Refund_Amount usage type.
Table A-8 Sample ASCII Data Mapping for the Refund_Amount Usage Type
| ASCII NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
cell_id |
CELL_ID |
N/A |
|
CalledId |
N/A |
CALLED_ID |
|
calling_number |
N/A |
UserIdentity |
|
session_id |
N/A |
Session Id |
|
start_time |
N/A |
Start time |
|
end_time |
N/A |
End time |
|
seq_no |
N/A |
Seq number |
|
balance_element_id |
IMPACT_AMOUNT[0].BALANCE_ELEMENT_ID |
N/A |
|
amount |
IMPACT_AMOUNT[0].AMOUNT |
N/A |
|
correlation_identifier |
CORRELATION_IDENTIFIER |
N/A |
Mapping for SGSN
The ECE DC supports the following SGSN product types:
-
Data
-
SMS
Data
SGSN PDP Record
Table A-9 shows the sample SGSN data mapping for the PDP record.
Table A-9 Sample SGSN Data Mapping for the SGSN PDP Record
| ASN 1 Fields | SGSN Cartridge NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|---|
|
listOfTrafficVolumes.dataVolumeGPRSUplink |
part of 20209 |
USED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
listOfTrafficVolumes.dataVolumeGPRSDownlink |
part of 20209 |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
cellIdentifier |
20223(CellIdentifier) |
CELL_ID |
N/A |
|
servedIMSI |
20234 (ServedIMSI) |
N/A |
UserIdentity |
|
chargingID |
20001(ChargingID) |
N/A |
Session id |
|
recordOpeningTime |
N/A |
N/A |
start time |
|
duration |
duration |
N/A |
end_time(calculated from the duration) |
|
recordSequenceNumber |
20005 (record sequence number) |
N/A |
sequence number |
S-GW Record
Table A-10 shows the sample SGSN data mapping for the S-GW record.
Table A-10 Sample SGSN Data Mapping for the S-GW Record
| ASN1 Fields | SGSN | USED_UNITS[0].OUTPUT_VOLUME | Usage Object Parameter |
|---|---|---|---|
|
listOfTrafficVolumes.dataVolumeGPRSUplink |
part of 20209 |
USED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
listOfTrafficVolumes.dataVolumeGPRSDownlink |
part of 20209 |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
servedIMSI |
20234 (ServedIMSI ) |
N/A |
UserIdentity |
|
chargingID |
20001(ChargingID) |
N/A |
Session id |
|
startTime |
20274(StartTime ) |
N/A |
Start time |
|
stopTime |
20275(StopTime ) if it exists, otherwise derived from duration(20004) |
N/A |
End time |
|
recordSequenceNumber |
20005 (record sequence number) |
N/A |
sequence number |
P-GW Record
Table A-11 shows the sample SGSN data mapping for the P-GW record.
Table A-11 Sample SGSN Data Mapping for P-GW Record
| ASN1 Fields | SGSN cartridge NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|---|
|
listOfServiceData.datavolumeFBCUplink |
part of 20267 |
USED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
listOfService.datavolumeFBCDownlink |
part of 20267 |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
servedIMSI |
20234 (ServedIMSI) |
N/A |
UserIdentity |
|
chargingID |
20001(ChargingID) |
N/A |
Session id |
|
startTime |
20274 |
N/A |
Start time |
|
stopTime |
20275(StopTime ) if it exists, otherwise derived from duration(20004) |
N/A |
End time |
|
recordSequenceNumber |
20005 (record sequence number) |
N/A |
sequence number |
SMS
The SGSNMMRecord (mobility management), SGSNMORecord (Mobile originated) and SGSNMTRecord (Mobile Terminated) record types are supported for Mobility management and SMS services.
20234 (ServedIMSI)
20219
Product Type = SMS
Event Type = USAGE
Usage Type = Terminate
Table A-12 shows the sample SGSN SMS mapping for the Terminate usage type.
Table A-12 Sample SGSN SMS Mapping for the Terminate Usage Type
| ASN1 Fields | SGSN cartridge NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|---|
|
cellIdentifier |
20223(CellIdentifier) |
CELL_ID |
N/A |
|
destinationNumber |
if SGSNMORecord 20303(DestinationNumber), if SGSNMTRecord same as 20234(servedIMSI) |
CALLED_ID |
N/A |
|
N/A |
N/A |
USED_UNITS[0].SPECIFIC_UNIT |
N/A |
|
servedMSISDN or servedIMSI |
N/A |
N/A |
UserIdentity |
|
chargingID |
20001(ChargingID) |
N/A |
Session id |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
Start time |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
end time |
|
localSequenceNumber |
N/A |
N/A |
seq number |
Product Type = SMS
Event Type = USAGE
Usage Type = Update
Table A-13 shows the sample SGSN SMS mapping for the Update usage type.
Table A-13 Sample SGSN SMS Mapping for the Update Usage Type
| ASN1 Fields | SGSN cartridge NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|---|
|
cellIdentifier |
20223(CellIdentifier) |
CELL_ID |
N/A |
|
destinationNumber |
if SGSNMORecord 20303(DestinationNumber), if SGSNMTRecord same as 20234(servedIMSI) |
CALLED_ID |
N/A |
|
N/A |
N/A |
USED_UNITS[0].SPECIFIC_UNIT |
N/A |
|
servedMSISDN or servedIMSI |
N/A |
N/A |
UserIdentity |
|
chargingID |
20001(ChargingID) |
N/A |
Session id |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
Start time |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
end time |
|
localSequenceNumber |
N/A |
N/A |
seq number |
Product Type = SMS
Event Type = USAGE
Usage Type = Refund_Unit
Table A-14 shows the sample SGSN SMS mapping for the Refund_Unit usage type.
Table A-14 Sample SGSN SMS Mapping for the Refund_Unit Usage Type
| ASN1 Fields | SGSN cartridge NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|---|
|
cellIdentifier |
20223(CellIdentifier) |
CELL_ID |
N/A |
|
destinationNumber |
if SGSNMORecord 20303(DestinationNumber), if SGSNMTRecord same as 20234(servedIMSI) |
CALLED_ID |
N/A |
|
N/A |
N/A |
USED_UNITS[0].SPECIFIC_UNIT |
N/A |
|
servedMSISDN or servedIMSI |
N/A |
N/A |
UserIdentity |
|
chargingID |
20001(ChargingID) |
N/A |
Session id |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
Start time |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
end time |
|
localSequenceNumber |
N/A |
N/A |
seq number |
|
correlation_identifier |
N/A |
CORRELATION_IDENTIFIER |
N/A |
Product Type = SMS
Event Type= USAGE
Usage Type = Refund_Amount
Table A-15 shows the sample SGSN SMS mapping for the Refund_Amount usage type.
Table A-15 Sample SGSN SMS Mapping for the Refund_Amount Usage Type
| ASN1 Fields | SGSN cartridge NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|---|
|
cellIdentifier |
20223(CellIdentifier) |
CELL_ID |
N/A |
|
destinationNumber |
if SGSNMORecord 20303(DestinationNumber), if SGSNMTRecord same as 20234(servedIMSI) |
CALLED_ID |
N/A |
|
N/A |
N/A |
USED_UNITS[0].SPECIFIC_UNIT |
N/A |
|
servedMSISDN or servedIMSI |
N/A |
N/A |
UserIdentity |
|
chargingID |
20001(ChargingID) |
N/A |
Session id |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
Start time |
|
eventTimeStamp |
20240(EventTimeStamp) |
N/A |
end time |
|
localSequenceNumber |
N/A |
N/A |
seq number |
|
balance_element_id |
N/A |
IMPACT_AMOUNT[0].BALANCE_ELEMENT_ID |
N/A |
|
amount |
N/A |
IMPACT_AMOUNT[0].AMOUNT |
N/A |
|
correlation_identifier |
N/A |
CORRELATION_IDENTIFIER |
N/A |
Mapping for IMS
The ECE DC supports the following IMS product types:
-
Voice
In case of IMS cartridge pack, the input is a Diameter ACR request, which the cartridge pack node chains convert into the 3GPP ASN1 format. The converted ASN1 format is the input to the ECE DC.
Voice
Table A-16 shows the sample IMS voice mapping.
Table A-16 Sample IMS Voice Mapping
| ASN1 Fields | IMS cartridge NPL Fields | ECE Payload Fields |
|---|---|---|
|
Called_Party_Address |
Called_Party_Address |
CALLED_ID |
|
derived using service delivery start time stamp and end time stamp |
Duration |
REQUESTED_UNITS[0].DURATION |
|
PrivateUserID |
PrivateUserID |
UserIdentity |
|
ServiceDeliveryStartTimeStamp |
ServiceDeliveryStartTimeStamp |
start time |
|
ServiceDeliveryEndTimeStamp |
ServiceDeliveryEndTimeStamp |
end time |
|
Session_Id |
Session_Id |
session id |
|
N/A |
seqNo |
seq number |
Mapping for Oracle CDR Format
The ECE DC supports the following Oracle CDR format product types:
-
Voice
-
Data
-
SMS
-
TelcoGsmTelephony
-
TelcoGprs
Voice
Product Type = VOICE
Event Type = USAGE
Usage Type = Terminate
Table A-17 shows the sample Oracle CDR format voice mappings for the Terminate usage type.
Table A-17 Sample Oracle CDR Format Voice Mapping for the Terminate Usage Type
| Oracle CDR Format NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
A_NUMBER |
N/A |
UserIdentity |
|
N/A |
N/A |
Seq number |
|
N/A |
N/A |
Session Id |
|
CHARGING_START_TIMESTAMP |
N/A |
Start time |
|
CHARGING_END_TIMESTAMP |
N/A |
End time |
|
BASIC_SERVICE |
N/A |
cdr_service |
|
DURATION |
USED_UNITS[0].DURATION |
N/A |
|
B_NUMBER |
CALLED_ID |
N/A |
|
CELL_ID |
CELL_ID |
N/A |
|
USAGE_DIRECTION |
USAGE_DIRECTION |
N/A |
|
CALL_COMPLETION_INDICATOR |
TERMINATION_CAUSE |
N/A |
|
QOS_USED |
QUALITY_OF_SERVICE |
N/A |
Data
Product Type = DATA
Event Type = DATA_USAGE
Usage Type = Terminate
Table A-18 shows the sample Oracle CDR format data mappings for the Terminate usage type.
Table A-18 Sample Oracle CDR Format Data Mapping for the Terminate Usage Type
| Oracle CDR Format NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
A_NUMBER |
N/A |
UserIdentity |
|
N/A |
N/A |
Seq number |
|
N/A |
N/A |
Session Id |
|
CHARGING_START_TIMESTAMP |
N/A |
Start time |
|
CHARGING_END_TIMESTAMP |
N/A |
End time |
|
BASIC_SERVICE |
N/A |
cdr_service |
|
VOLUME_SENT |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
VOLUME_SENT + VOLUME_RECEIVED |
USED_UNITS[0].TOTAL_VOLUME |
N/A |
|
N/A |
USED_UNITS[0].CC_TIME |
N/A |
|
CHARGING_START_TIMESTAMP |
USED_UNITS[0].VALIDITY_START |
N/A |
|
CHARGING_END_TIMESTAMP |
USED_UNITS[0].VALIDITY_END |
N/A |
|
B_NUMBER |
CALLED_ID |
N/A |
|
CELL_ID |
CELL_ID |
N/A |
|
CALL_COMPLETION_INDICATOR |
TERMINATION_CAUSE |
N/A |
SMS
Product Type = SMS
Event Type = SMS_USAGE
Usage Type = Terminate
Table A-19 shows the sample Oracle CDR format SMS mapping for the Terminate usage type.
Table A-19 Sample Oracle CDR Format SMS Mapping for the Terminate Usage Type
| Oracle CDR Format NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
A_NUMBER |
N/A |
UserIdentity |
|
N/A |
N/A |
Seq number |
|
N/A |
N/A |
Session Id |
|
CHARGING_START_TIMESTAMP |
N/A |
Start time |
|
CHARGING_END_TIMESTAMP |
N/A |
End time |
|
BASIC_SERVICE |
N/A |
cdr_service |
|
DURATION |
USED_UNITS[0].SPECIFIC_UNIT |
N/A |
|
CALL_COMPLETION_INDICATOR |
TERMINATION_CAUSE |
N/A |
|
B_NUMBER |
CALLED_ID |
N/A |
|
CELL_ID |
CELL_ID |
N/A |
TelcoGsmTelephony
Product Type = TelcoGsmTelephony
Event Type = ConvergentVoice
Usage Type = Terminate
Table A-20 shows the sample Oracle CDR format TelcoGsmTelephony mapping for the Terminate usage type.
Table A-20 Sample Oracle CDR Format TelcoGsmTelephony Mapping for the Terminate Usage Type
| Oracle CDR Format NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
A_NUMBER |
N/A |
UserIdentity |
|
N/A |
N/A |
Seq number |
|
N/A |
N/A |
Session Id |
|
CHARGING_START_TIMESTAMP |
N/A |
Start time |
|
CHARGING_END_TIMESTAMP |
N/A |
End time |
|
BASIC_SERVICE |
N/A |
cdr_service |
|
CALL_COMPLETION_INDICATOR |
TERMINATION_CAUSE |
N/A |
|
N/A |
ZONE_ORIGIN |
N/A |
|
N/A |
ZONE_DEST |
N/A |
|
USAGE_TYPE |
USAGE_TYPE |
N/A |
|
B_NUMBER |
CALLED_ID |
N/A |
|
N/A |
TELCO_INFO[0].NETWORK_SESSION_ID |
N/A |
|
N/A |
TELCO_INFO[0].NETWORK_SESSION_CORRELATION_ID |
N/A |
|
DESTINATION_NETWORK |
TELCO_INFO[0].DESTINATION_NETWORK |
N/A |
|
MSID |
TELCO_INFO[0].PRIMARY_MSID |
N/A |
|
N/A |
TELCO_INFO[0].SECONDARY_MSID |
N/A |
|
A_NUMBER |
TELCO_INFO[0].CALLING_FROM |
N/A |
|
B_NUMBER |
TELCO_INFO[0].CALLED_TO |
N/A |
|
N/A |
TELCO_INFO[0].SVC_TYPE |
N/A |
|
N/A |
TELCO_INFO[0].SVC_CODE |
N/A |
|
USAGE_CLASS |
TELCO_INFO[0].USAGE_CLASS |
N/A |
|
VOLUME_RECEIVED |
TELCO_INFO[0].BYTES_DOWNLINK |
N/A |
|
VOLUME_SENT |
TELCO_INFO[0].BYTES_UPLINK |
N/A |
|
ACTION_CODE |
SERVICE_CODES[0].SS_ACTION_CODE |
N/A |
|
SS_CODE |
SERVICE_CODES[0].SS_CODE |
N/A |
|
ESN_IMEI |
GSM_INFO[0].IMEI |
N/A |
|
B_MODIFICATION_INDICATOR |
GSM_INFO[0].CALLED_NUM_MODIF_MARK |
N/A |
|
USAGE_DIRECTION or CALL_DIRECTION |
GSM_INFO[0].DIRECTION |
N/A |
|
B_NUMBER |
GSM_INFO[0].DIALED_NUMBER |
N/A |
|
QOS_REQUESTED |
GSM_INFO[0].QOS_REQUESTED |
N/A |
|
QOS_USED |
GSM_INFO[0].QOS_NEGOTIATED |
N/A |
|
LONG_DURATION_INDICATOR |
GSM_INFO[0].SUB_TRANS_ID |
N/A |
|
HOME_CARRIER_SID |
GSM_INFO[0].ORIGIN_SID |
N/A |
|
HOME_CARRIER_SID |
GSM_INFO[0].DESTINATION_SID |
N/A |
|
LOCATION_AREA_INDICATOR |
GSM_INFO[0].LOC_AREA_CODE |
N/A |
|
CELL_ID |
GSM_INFO[0].CELL_ID |
N/A |
|
VOLUME_RECEIVED |
GSM_INFO[0].BYTES_IN |
N/A |
|
VOLUME_SENT |
GSM_INFO[0].BYTES_OUT |
N/A |
|
USAGE_CLASS |
GSM_INFO[0].USAGE_CLASS |
N/A |
|
NUMBER_OF_UNITS |
GSM_INFO[0].NUMBER_OF_UNIT |
N/A |
|
DURATION |
USED_UNITS[0].DURATION |
N/A |
|
N/A |
USED_UNITS[0].SPECIFIC_UNIT |
N/A |
TelcoGprs
Product Type = TelcoGprs
Event Type = ConvergentData
Usage Type = Terminate
Table A-21 shows the sample Oracle CDR format TelcoGprs mapping for the Terminate usage type.
Table A-21 Sample Oracle CDR Format TelcoGprs Mapping for the Terminate Usage Type
| Oracle CDR Format NPL Fields | ECE Payload Fields | ECE Usage Object Builder Parameter |
|---|---|---|
|
A_NUMBER |
N/A |
UserIdentity |
|
N/A |
N/A |
Seq number |
|
N/A |
N/A |
Session Id |
|
CHARGING_START_TIMESTAMP |
N/A |
Start time |
|
CHARGING_END_TIMESTAMP |
N/A |
End time |
|
BASIC_SERVICE |
N/A |
cdr_service |
|
CALL_COMPLETION_INDICATOR |
TERMINATION_CAUSE |
N/A |
|
USAGE_TYPE |
USAGE_TYPE |
N/A |
|
B_NUMBER |
CALLED_ID |
N/A |
|
N/A |
TELCO_INFO[0].NETWORK_SESSION_ID |
N/A |
|
N/A |
TELCO_INFO[0].NETWORK_SESSION_CORRELATION_ID |
N/A |
|
DESTINATION_NETWORK |
TELCO_INFO[0].DESTINATION_NETWORK |
N/A |
|
MSID |
TELCO_INFO[0].PRIMARY_MSID |
N/A |
|
PORT_NUMBER |
TELCO_INFO[0].SECONDARY_MSID |
N/A |
|
A_NUMBER |
TELCO_INFO[0].CALLING_FROM |
N/A |
|
B_NUMBER |
TELCO_INFO[0].CALLED_TO |
N/A |
|
N/A |
TELCO_INFO[0].SVC_TYPE |
N/A |
|
N/A |
TELCO_INFO[0].SVC_CODE |
N/A |
|
USAGE_CLASS |
TELCO_INFO[0].USAGE_CLASS |
N/A |
|
VOLUME_RECEIVED |
TELCO_INFO[0].BYTES_DOWNLINK |
N/A |
|
VOLUME_SENT |
TELCO_INFO[0].BYTES_UPLINK |
N/A |
|
ROUTING_AREA |
GPRS_INFO[0].ROUTING_AREA |
N/A |
|
LOCATION_AREA_INDICATOR |
GPRS_INFO[0].LOC_AREA_CODE |
N/A |
|
CELL_ID |
GPRS_INFO[0].CELL_ID |
N/A |
|
SESSION_ID |
GPRS_INFO[0].SESSION_ID |
N/A |
|
SGSN_ADDRESS |
GPRS_INFO[0].SGSN_ADDRESS |
N/A |
|
NODE_ID |
GPRS_INFO[0].NODE_ID |
N/A |
|
TRANS_ID |
GPRS_INFO[0].TRANS_ID |
N/A |
|
N/A |
GPRS_INFO[0].EXTENSIONS |
N/A |
|
N/A |
GPRS_INFO[0].STATUS |
N/A |
|
NETWORK_INITIATED_PDP |
GPRS_INFO[0].NI_PDP |
N/A |
|
CONNECT_TYPE |
GPRS_INFO[0].ANONYMOUS_LOGIN |
N/A |
|
PDP_TYPE |
GPRS_INFO[0].PDP_TYPE |
N/A |
|
PDP_ADDRESS |
GPRS_INFO[0].PDP_ADDRESS |
N/A |
|
PDP_REMOTE_ADDRESS |
GPRS_INFO[0].PDP_RADDRESS |
N/A |
|
PDP_DYNAMIC_ADDRESS |
GPRS_INFO[0].PDP_DYNADDR |
N/A |
|
DIAGNOSTICS |
GPRS_INFO[0].DIAGNOSTICS |
N/A |
|
APN_ADDRESS |
GPRS_INFO[0].APN |
N/A |
|
NUMBER_OF_UNITS |
GPRS_INFO[0].NUMBER_OF_UNITS |
N/A |
|
NETWORK_CAPABILITY |
GPRS_INFO[0].NETWORK_CAPABILITY |
N/A |
|
SGSN_CHANGE |
GPRS_INFO[0].SGSN_CHANGE |
N/A |
|
CHANGE_CONDITION |
GPRS_INFO[0].CHANGE_CONDITION |
N/A |
|
QOS_REQUESTED_PRECEDENCE |
GPRS_INFO[0].QOS_REQ_PRECEDENCE |
N/A |
|
QOS_REQUESTED_DELAY |
GPRS_INFO[0].QOS_REQ_DELAY |
N/A |
|
QOS_REQUESTED_RELIABILITY |
GPRS_INFO[0].QOS_REQ_RELIABILITY |
N/A |
|
QOS_REQUESTED_PEAK_THROUGHPUT |
GPRS_INFO[0].QOS_REQ_PEAK_THROUGH |
N/A |
|
QOS_REQUESTED_MEAN_THROUGHPUT |
GPRS_INFO[0].QOS_REQ_MEAN_THROUGH |
N/A |
|
QOS_USED_PRECEDENCE |
GPRS_INFO[0].QOS_NEGO_PRECEDENCE |
N/A |
|
QOS_USED_DELAY |
GPRS_INFO[0].QOS_NEGO_DELAY |
N/A |
|
QOS_USED_RELIABILITY |
GPRS_INFO[0].QOS_NEGO_RELIABILITY |
N/A |
|
QOS_USED_PEAK_THROUGHPUT |
GPRS_INFO[0].QOS_NEGO_PEAK_THROUGH |
N/A |
|
QOS_USED_MEAN_THROUGHPUT |
GPRS_INFO[0].QOS_NEGO_MEAN_THROUGH |
N/A |
|
N/A |
GPRS_INFO[0].SGSN_PLMN_ID |
N/A |
|
N/A |
GPRS_INFO[0].MM_STATE |
N/A |
|
N/A |
GPRS_INFO[0].PTMSI |
N/A |
|
N/A |
GPRS_INFO[0].PTMSI_SIGNATURE |
N/A |
|
N/A |
GPRS_INFO[0].SERVICE_AREA_CODE |
N/A |
|
N/A |
GPRS_INFO[0].EXT_CHARGING_ID |
N/A |
|
N/A |
GPRS_INFO[0].PS_CHARGING_DESCR |
N/A |
|
VOLUME_SENT |
USED_UNITS[0].INPUT_VOLUME |
N/A |
|
VOLUME_RECEIVED |
USED_UNITS[0].OUTPUT_VOLUME |
N/A |
|
VOLUME_SENT + VOLUME_RECEIVED |
USED_UNITS[0].TOTAL_VOLUME |
N/A |