CallRecordMaster_HELD

It is in this table that unratable calls will be dumped. You can re-attempt rating by moving these records back into the [CallRecordMaster_TBR] table or clicking the 'Move Calls to Rating Queue' button in the 'Rating Errors' page of the PHP Admin Portal.

This page describes the columns in this table.

Column | Data type | Nulls | Description

CallID | varchar(100) | No Nulls | This should contain the same unique CallID your CDR source uses so you can reference the original record if you ever need to. This value must be unique amongst all your CDR.

CustomerID | varchar(15) | Nulls Allowed | This field is the customer that owns the call.

CallType | smallint| Nulls Allowed | Please see [Call Types] for more information.

CallDateTime | timestamp| No Nulls | This is the date/time the call was connected.

Duration | integer | No Nulls | This is the raw duration, in seconds, of the call. We will convert it to 'Billed Duration' during rating.

Direction | char(1) | Nulls Allowed | This field is optional but if you do know the value, send it. If you are populating this field, use "I" for incoming calls and "O" for outgoing calls.

SourceIP | vachar(15) | Nulls Allowed | This field is optional at the moment. We may use this field to determine the owner of the call if the CustomerID field is blank/null.

OriginatingNumber | varchar(50) | No Nulls | This field is required. It should be in E.164 format. If it cannot be supplied in E.164 then scripting in the rating engine may attempt to convert it to E.164. More information on E.164 http://en.wikipedia.org/wiki/E.164

DestinationNumber | varchar(50) | No Nulls | This field is required. It should be in E.164 format. If it cannot be supplied in E.164 then scripting in the rating engine may attempt to convert it to E.164. More information on E.164 http://en.wikipedia.org/wiki/E.164

LRN | varchar(50) | Nulls Allowed | If the LRN is supplied, we will bill termination using LRN instead of DestinationNumber/DialedNumber.

CNAMDipped | boolean | Nulls Allowed | Per-call surcharges can be added if the call was dipped for CNAM. This is customer-level setting.

RateCenter | varchar(50) | Nulls Allowed | Required for [Tiered Origination] CDR.

CarrierID | varchar(100) | Nulls Allowed | Optional. Used primarily for reporting.

WholesaleRate | numeric(19, 7) | No Nulls | This is the per-minute rate applied to the call by your carrier. This value might be supplied in the CDR your carrier sends you. This information can be used to calculate margins or profitability to certain destinations.

WholesalePrice | numeric(19, 7) | No Nulls | This is the price you carrier charged you for this call. This value might be supplied in the CDR your carrier sends you. This information can be used for profit analysis reporting.

RoutingPrefix | varchar(10) | Nulls Allowed | Optional. You can supply it or we can parse it from DestinationNumber using '#' as a separator. We use routing prefix for rating and [Carrier Reconciliation].

RowID | integer | Auto-increment | This is an internal field used primarily for adhoc queries. Do not supply a value for this field. Do not remove this field.

If you have any questions, please contact [Support].

-The OpenCDRRate team.

Follow us on twitter to receive new feature notifications: http://www.twitter.com/opencdrrate/

Join our LinkedIn group to open discussions on features you would like to see in the system. http://www.linkedin.com/groups/OpenCDRRate-4381972