Dataset: Telephone Calls and SMS

Dataset name: ds_utility_tel_calls

Description

Telephone calls

Fields in this dataset

Name Field Name Description Field Type Field Example
Telephone Calls ID id The primary identifier for this record. number 5
Telephone Calls Instance instance The instance this transaction relates to. number 8
Telephone Calls Source source The source of the data - user or connection. text
Telecoms Transactions Charge Type utility_tel_call_charge_type The charge type text Included
Telecoms Transactions Cost utility_tel_call_cost The cost of the transaction/ call currency 122.22
Currency Code utility_tel_call_currency_code Currency code for the transaction text GBP
Telecoms Transactions Date utility_tel_call_date The date of the transaction date 29222
Telecoms Transactions Duration utility_tel_call_duration The duration of the call time 0.050138888888889
Incoming/Outgoing utility_tel_call_incoming_outgoing Is this record an incoming or outgoing call/sms. varchar
Telecoms Transactions Number Called utility_tel_call_number_called The telephone number called in the transaction text (44) 01234 123456
Telecoms Transactions Transaction Type utility_tel_call_type The type of transaction text Call or SMS