BillMax CDR Input Format

The BillMax CDR file input format is a Comma Separated Value (CSV) file. If there is no header line, the order documented below is assumed. Processing of original CDRs should result in this format. Fields are optional within reason, but use a header line if not specifying every field. Processing of the header line is case insensitive.

Field	Description
Source	The original source/inbound of the call.
Destination	The original destination/outbound of the call.
Source Channel	The source/inbound channel or path of the call.
Destination Channel	The destination/outbound channel or path of the call.
Call Start	The time stamp of the start of the call - UTC
Call End	The time stamp of the end of the call - UTC
Billable Seconds	must be non-zero.
Source Search Key 1	The first source/inbound value to try to match to the Package/Service d01 value.
Source Search Key 2	The second source/inbound value to try to match to the Package/Service d01 value.
Destination Search Key 1	The first destination/outbound value to try to match to the Package/Service d01 value.
Destination Search Key 2	The second destination/outbound value to try to match to the Package/Service d01 value.
Destination Rate Deck Key	The destination/outbound value to match to a value in a Rate Deck.
Flags	A bit mask denoting what type of call the CDR represents: 2 Operator assisted 4 International 8 N11 call 16 Toll Free 32 Local Call 1024 Premium Call
Unique ID	A unique id for the record. Combined with Start of Call in the BillMax database to create a unique key across sources.
Status	Status of call. 0 Call is in progress. 1 Call is complete.
Time Call Answered	The time stamp of when the call was answered - UTC
Record Number	Record number of CDR in current file/dataset.
Direction of Call	0 Not specified in CDR. BillMax will derive it. 1 Call is outbound from Customer. 2 Call is inbound to Customer.
The following may be used for pre-rated and pre-classified CDRs.
Rated Amount	Rated amount based on duration of call.
Call Type	0 Not specified in CDR. BillMax will derive it. Typically used for location less numbers such as Toll Free and Premium numbers. 1 Process as a Plan call. 2 Process as a Long Distance call. 5 A local call processed as an N11 call.
Connect Fee	Connect Fee to bill.
Billed Seconds	Billed Seconds for the supplied Rated Amount.
Source Description	Description of the Source of the call.
Destination Description	Description of the Destination of the call.
USF Region	The region/state to which the call/revenue/minutes should be attributed for Federal USF and State USF purposes.
USF Class	0 Not relevant for USF purposes. In general outbound toll free, premium numbers and non billed inbound calls should have this value. 1 Intrastate. 2 Interstate. 3 International.