Report Designer CDR Field Definitions

Field

Description

Detail

Org Summary

Summary

Header

<Spacer>

Used to create extra spaces between columns.

X

X

X

Abandoned

Indicates if an inbound or internal call was abandoned, that is the caller hung up before the call was answered. It will put Y or N in the column as appropriate.

X

X

Abandoned Call Count

Number of abandoned calls.

X

X

Account Code

The account code used on the call. An account code assigns a call to a specific account or client. The field name may be different if it was changed in System Setup, e.g. Client Code.

X

X

X

Account Description

Description of the account code.

X

X

X

Alternate

One of 10 informational fields included in Directory that may be used to further define characteristics associated to each person e.g. Building, Room, etc. The Alternate field name may be modified in the Configure Directory application.

X

X

X

X

Area Code

3-digit number that identifies each telephone service area for countries that use the North American Numbering Plan (NANP) to place phone calls including the USA (and its territories), Canada and the Caribbean. - Available on NANP calls only.

X

X

X

Area Code Exchange

Area code identifies the service area and the exchange identifies the local exchange or city. Available for NANP calls only.

X

X

X

Auth Code

Telephone systems may be configured to require a person to enter an authorization code in order to be able to place a phone call. Authorization codes are commonly used in environments where people need to place phone calls from multiple locations within the company or enterprise. Calls placed with an authorization code are associated with the person who owns the auth code and not the person that owns the extension that the call was placed from.

X

X

X

Auth Code Call

Indicates if an authorization code was used on the call.

X

X

X

Base Cost

Base cost of the call, usually the cost from the rate table. Can be displayed in common currency or, if more than one currency is in use, local currency.

X

Billable Fee

Cost of the person's time for the call. Available only with Enhanced PSP.

X

X

X

Billable Time

Time that is billable to a customer. Available only with Enhanced PSP.

X

X

Billed Cost

Billed cost of the call, adjusted cost of the call. Can be displayed in common currency or, if more than one currency is in use, local currency.

X

Billing Class

Billing class used to determine the call cost.

X

X

X

Billing Pool

Field to track Calls based on specific billing pools.

X

X

X

X

Billing Pool Reason

Field to track whether or not a call is part of a pool. .

X

X

X

Building

The place where the person is located.

X

X

X

X

Calculated Cost

Allows user to choose which costs will be added together in the report to create a sub-total column.

X

X

Call Cost - Billable

The cost of calls that are billable to a customer. Cost can be displayed as base cost, billed cost and if more than one currency is in use, base cost in the local currency or billed cost in the local currency. Only available with Enhanced PSP.

X

X

Call Cost - Non-Billable

The cost of calls that are business related that are not billable to a customer. Cost can be displayed as base cost, billed cost and if more than one currency is in use, base cost in the local currency or billed cost in the local currency. Only available with Enhanced PSP.

X

X

Call Cost - Non-Business

The cost of calls that are not business related. Cost can be displayed as base cost, billed cost and if more than one currency is in use, base cost in the local currency or billed cost in the local currency. Only available with Enhanced PSP.

X

X

Call Cost - Unassigned

The cost of calls that have not been assigned an account code. Cost can be displayed as base cost, billed cost and if more than one currency is in use, base cost in the local currency or billed cost in the local currency. Only available with Enhanced PSP.

X

X

Call Count - Billable

The count of calls that are billable to a customer. Only available with Enhanced PSP.

X

X

Call Count - Non-Billable

The count of calls that are business related that are not billable to a customer. Only available with Enhanced PSP.

X

X

Call Count - Non-Business

The count of calls that are . Only available with Enhanced PSP.

X

X

Call Count - Unassigned

The count of calls that have not been assigned an account code. Only available with Enhanced PSP.

X

X

Call Duration - Billable

The duration of calls that are billable to a customer. Only available with Enhanced PSP.

X

X

Call Duration - Non-Billable

The duration of calls that are business related that are not billable to a customer. Only available with Enhanced PSP.

X

X

Call Duration - Non-Business

The duration of calls that are. Only available with Enhanced PSP.

X

X

Call Duration - Unassigned

The duration of calls that have not been assigned an account code. Only available with Enhanced PSP.

X

X

Call Hour

Displays the hour of the day in which the call occurred, e.g. 9 AM shows as 09, 1 PM shows as 13.

X

X

X

Call Month

Displays the month in which the call occurred. Export designs display month as a number, e.g. 02 for February. Report designs display month as a the first three letters of the month e.g. Apr for April.

X

X

X

X

Call Type

Type of call, e.g. Local, Long Distance, International, info/assist, inbound, etc.

X

X

X

Call Week

Displays the date of the first day of the week in which the call occurred.

X

X

X

X

Call Year

Displays the year in which the call occurred in the format of YYYY, e.g. 2011.

X

X

X

Caller ID

Phone number of the person making the call

X

X

X

Calling Party Number

Number Available with Cisco data only. Gives the phone number making the call.

X

X

X

City

City based on the digits dialed or ANI. If ANI is not provided by the phone system, "INBOUND"  will display.

X

X

X

Company

Highest organizational level. The name may be different if it was changed in System Configuration Options. Can be displayed as Name, Code, Name (Code), or Code - Name. If the system is configured to use less than four organizational levels, this level will not display.

X

X

X

X

ConfID

A Conference ID is assoicated with each conference call and is used to group all of the call legs together for reporting purposes.

X

X

Cost

Cost of the call - only shows if the system is set up so that the base and billed costs are the same. Otherwise, Base Cost and Billed Cost are available.

X

Cost Center

Third highest organizational level. The name may be different if it was changed in System Configuration Options. Can be displayed as Name, Code, Name (Code), or Code - Name. If you only use one organizational level, it will not appear.

X

X

X

X

Cost per Minute

Per minute cost of the calls = cost divided by duration. Cost can be displayed as base cost, billed cost and if more than one currency is in use, base cost in the local currency or billed cost in the local currency.

X

X

Count

Number of calls based on call type

X

X

Country Code Dest

Country code for the call’s destination, e.g., 44.

X

X

X

Country Code Origin

Country code for the call’s origination, e.g., 1.

X

X

X

Country Name Dest

Country name for the call’s destination, e.g., United Kingdom.

X

X

X

Country Name Origin

Country name for the call’s origination, e.g., United States.

X

X

X

Data

Person's data number from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

Data Source Group Name

Available only when Networked PBX is ON. This is the name of the group to which the data source belongs.

X

X

X

Data Source Name

Each source of data, e.g. PBX, data feed, etc. has a name.

X

X

X

Date

Date on which the call(s) occurred. See the Formatting Tab  topic for supported formats.

X

X

X

X

Department

Lowest organizational level. The name may be different if it was changed in System Configuration Options. Can be displayed as Name, Code, Name (Code), or Code - Name. If always appears.

X

X

X

X

Device Name

This field is used to include the name of a device in a report.

X

X

X

Device Type

This field is used to include the type of device in a report.

X

X

X

DID

Person's DID number from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

Disconnect Initiator

Party that disconnected a call for Cisco Call Manager systems.

X

X

X

X

Division

Second highest organizational level. The name may be different if it was changed in System Configuration Options. Can be displayed as Name, Code, Name (Code), or Code - Name. If you only use two organizational levels, it will not appear.

X

X

X

X

DNIS

Used to identify which Dialed Number Identification Service was used. This is a feature of inbound 800 and 900 lines.

X

X

X

Duration

Duration of the call(s). See the Formatting Tab  topic for supported formats.

X

E164PhoneNumber

This is a  phone number that has a maximum of fifteen digits and comprises of the country code and the national phone number.

X

X

Equal Access

This field only appears if Equal Access digits are defined in the system. Allows the display of the Equal Access digits if any were used.

X

X

X

Extension

Extension number of the phone the made or received the call(s).

X

X

X

Extension Location

Extension locations group extensions into physical locations. Only available if Extension Locations is ON. This is the extension location to which the extension on an outbound, inbound, or the originator of an internal call belongs.

X

X

X

X

Extension Location Destination

Extension locations group extensions into physical locations. Only available if Extension Locations is ON. This is the extension location to which the receiving extension on an internal call belongs.

X

X

X

X

External Code

This code is used to link to an external system such as a General Ledger.

X

X

X

X

Facility Name

Trunks and Gateways are grouped into Facilities for pricing purposes. A group of trunks or gateways that are priced the same make up a facility.

X

X

X

Fax

Person's fax number from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

Final Called Party Number

Available with Cisco data only. Gives the final destination of a call.

X

X

X

First Name

First Name of the owner of the call.

X

X

X

X

Fixed Charges

Fixed Charges are equipment or features (such as phone devices and voice mail). While adding or editing a person in the Directory database, you can add to their record the monthly, weekly, or daily charge for the use of the special equipment or features.

X

Group Count

Used in conjunction with the “Include Subtotals” Header attribute to include an average based on the number of items in the group for the summed cost, duration or count columns.

X

X

Home

Person's home phone number from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

Home Site

A Home Site is a physical location where a person is located.

X

X

X

X

Hunt Group (Name and Number)

This field is used to display either the Number (default) or  Name in a report.

X

X

X

Inbound Costs

Cost for Inbound calls. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

Inbound Count

Count of Inbound calls.

X

X

Inbound Duration

Duration of Inbound calls. Can be displayed as a total or an average.

X

X

Info/Assist Costs

Cost for Info/Assist calls. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

Info/Assist

Count of Info/Assist calls.

X

X

Info/Assist Duration

Duration of Info/Assist calls. Can be displayed as a total or an average.

X

X

Internal Costs

Cost for Internal calls. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

Internal Count

Count of Internal calls.

X

X

Internal Duration

Duration of Internal calls. Can be displayed as a total or an average.

X

X

International Costs

Cost for International calls. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

International Count

Count of International calls.

X

X

International Durations

Duration of International calls. Can be displayed as a total or an average.

X

X

Is Conf

Indicates if the call is part of a conference call.

X

X

X

Jitter

This field describes the variations in latency of a VoIP transmission.

X

X

X

Jurisdiction

The lowest classification of a call. E.g. Interstate/InterLATA.

X

X

X

Last Name

Last name of the owner of the call.

X

X

X

X

Latency

This is a measure of the time it takes for a packet of data to travel from its source to destination. A high amount of latency will lead to poor voice quality.

X

X

X

Line Type

Type of extension, e.g. Station, wireless, attendant.

X

X

X

Local Costs

Cost for Local calls. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

Local Count

Count of Local calls.

X

X

Local Duration

Duration of Local calls. Can be displayed as a total or an average.

X

X

Local Currency Code

Code of the local as opposed to common currency. Only shows if more than one currency is in use.

X

X

Location

Combines City and State into one field in the format City, State.  For outbound calls this is the destination city.  For inbound calls it is the origination city if ANI is available for the call.

X

X

Local Profit

Profit made on local calls

X

Long Distance Costs

Cost for Long Distance calls. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

Long Distance Count

Count of Long Distance calls.

X

X

Long Distance Duration

Duration of Long Distance calls. Can be displayed as a total or an average.

X

X

Matter Code

The matter code used on the call. A matter code is used with account codes to further classify the purpose of the call, e.g. a specific project or case. The name may be different if it was changed in System Setup, e.g. Project Code.

X

X

X

Matter Description

The name (description) of the matter code.

X

X

X

Maximum MOS

This field indicates the highest quality measured during the call.  The range is 1 (poor) to 5 (excellent).

X

X

X

Media Type

The media type field is used for tracking transactions that are not voice calls because other media are billed differently than voice calls and have different reporting needs. Other media include video, IM, SMS, and file transfers.

Media types supported by Microsoft Lync/OCS are voice, video, IM, and file transfers.

Media types supported by Cisco are voice and video.

Media types supported by Wireless Now are voice and SMS.

X

X

X

Minimum MOS

This field indicates the lowest quality measured during the call.  The range is 1 (poor) to 5(excellent).

X

X

X

Mobile

Person's mobile phone number from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

Mobile Termination

Indicates if a call terminated on a mobile phone. This can be determined for non-US calls, it cannot be determined for US calls.

X

X

X

Mobility Call

Used with Cisco data. Indicates that the call was redirected to a different number.

X

X

X

Networked Call

When using networked PBXs, indicates that the call traversed the network. Only available when Networked PBX is ON.

X

X

X

Networked Call Count

Count of the calls that traversed the networked. Only available when Networked PBX is ON.

X

X

Non-Billable Time

A call with a valid Account/Matter code where the account or matter codes are marked as non-billable and the group they belong to is a “Business” type group as defined in the Account Code database. Available only with Enhanced PSP.

X

X

Non-Business Time

A call with a valid Account/Matter code where the group the account code belongs to is a “Non-business” type group as defined in the Account Code database. Available only with Enhanced PSP.

X

X

One Time Charges

One time charges are common non-recurring events (such as moving a phone). While adding or editing a person in the Directory database, you can add a one-time charge.

X

Operator Assisted

Indicates if a call was made using the operator.

X

X

X

Operator Assisted Call Count

Count of the calls that were made with the operator's assistance.

X

X

Original Called Party

Number Available with Cisco data only. Gives the original destination of a call, which may be different than its final destination.

X

X

X

Originating Data Source

Name When using networked PBXs, this is the data source where the call started. Only available when Networked PBX is ON.

X

X

X

Other Charges

Other Charges is the sum of fixed, one-time and overhead charges associated to a person or organization.

X

Other Costs

Combines the cost of all of the call types not specifically chosen on the report. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

Other Count

Combines the count of all of the call types not specifically chosen on the report.

X

X

Other Duration

Combines the duration of all of the call types not specifically chosen on the report.

X

X

Overhead Charges

Overhead Charges are charges that allocate the cost of shared resources across all people in a selected Home Site, all Home Sites, or spread the overhead charge based on usage (including call cost, call duration, or call count). Overhead Charges are defined in the Pricing application.

X

Owner Name

Full name of the owner of the call in the format Lastname, Firstname.

X

X

X

X

Pager

Person's page number from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

Phone Name

The phone number database allows you to group phone numbers together and give them names, e.g. ABC Corporation. This displays that name, if it exists.

X

X

X

X

Phone Number

Phone number for the call. For an outbound or internal call, this is the digits dialed. For an inbound call it is the ANI if it is available.

X

X

X

Phone Number Group

The phone number database allows you to group phone numbers together and give the groups names, e.g. Customers. This displays the group name, if it exists.

X

X

X

X

Profit

Billed Cost - Base Cost. Can be displayed in common currency or if more than one currency is in use, local currency.

X

X

X

Queue Time

Total wait time for calls in a queue.

X

X

X

Queued Call

A call  waiting to be routed and then answered (calls in queue).

X

X

Queued Call Count

Amount of calls that were in a queue for a given duration.

X

Raw Extension

The raw extension is the actual extension in the raw data. Sometimes the decision is made to show only part of the extension (reporting extension) to disguise it.

X

X

X

Receiver Name

This field is used to include the name of the people that received a transferred file in a report

X

X

X

Recording Type

When a call recording application is integrated with this call reporting system, this field is used to display if a voice, video,or no recording exists for a call.

X

X

X

Ring Time

Amount of time the phone rang before the call was answered. Available only with phone systems that report ring time.

X

X

X

Second Extension

Second extension number to where the call was transferred.

X

X

X

Source Facility Name

For trunk-to-trunk calls this is the facility the call came in on.

X

X

X

Source Trunk Group

For trunk-to-trunk calls this is the Trunk Group the call came in on.

X

X

X

Source Trunk Member

For trunk-to-trunk calls this is the Trunk Member the call came in on.

X

X

X

State Name

Name of the state based on the phone number.

X

X

X

Time

Time the call started.

X

X

Title

Person's title from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

Total Charges

Combined total of all fixed charges, one-time charges, and overhead charges.

X

Total Costs

Total of all of the call costs on the report.

X

X

Total Count

Total count of all of the calls on the report.

X

X

Total Duration

Total duration of all of the calls on the report.

X

X

Trunk Group

Trunk group used by the call.

X

X

X

Trunk Member

Trunk member used by the call.

X

X

X

Trunk to Trunk

Indicates that a call was trunk-to-trunk.

X

X

X

Unassigned Time

A person's time that has not been assigned to a person. Available only if Enhanced PSP is ON.

X

X

UserDef1

Person's User Defined 1 field from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

UserDef2

Person's User Defined 2 from the Directory. The name could be different if it was changed in Configure Directory.

X

X

X

X

User Defined 1 Costs

Cost for User Defined 1 calls. The name may be different if it was changed in System Configuration Options. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

User Defined 1 Count

Count of User Defined 1 calls. The name may be different if it was changed in System Configuration Options.

X

X

User Defined 1 Duration

Duration of User Defined 1 calls. Can be displayed as a total or an average. The name may be different if it was changed in System Configuration Options.

X

X

User Defined 2 Costs

Cost for User Defined 2 calls. The name may be different if it was changed in System Configuration Options. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

User Defined 2 Count

Count of User Defined 2 calls. The name may be different if it was changed in System Configuration Options.

X

X

User Defined 2 Duration

Duration of User Defined 2 calls. Can be displayed as a total or an average. The name may be different if it was changed in System Configuration Options.

X

X

User Defined 3 Costs

Cost for User Defined 3 calls. The name may be different if it was changed in System Configuration Options. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

User Defined 3 Count

Count of User Defined 3 calls. The name may be different if it was changed in System Configuration Options.

X

X

User Defined 3 Duration

Duration of User Defined 3 calls. Can be displayed as a total or an average. The name may be different if it was changed in System Configuration Options.

X

X

User Defined 4 Costs

Cost for User Defined 4 calls. The name may be different if it was changed in System Configuration Options. Can be displayed as a total or an average. Can display base cost or billed cost and if more than one currency is in use, can display local base or local billed cost.

X

X

User Defined 4 Count

Count of User Defined 4 calls. The name may be different if it was changed in System Configuration Options.

X

X

User Defined 4 Duration

Duration of User Defined 4 calls. Can be displayed as a total or an average. The name may be different if it was changed in System Configuration Options.

X

X