Meta Schema

Column

Details

Description

DateTime

datetime, not null

This is the data and time that the record was added to the Meta table.

Campaign

varchar (255), not null

The name of the Campaign.

Phone

varchar (50), not null

The phone number.

ResultCode

varchar (1), not null

A single character code that is used to determine whether or not to block the phone number. (See the Result Codes topic.)

DateField

varchar (30), null

The date that the EBR expires.

Reason

varchar (255), null

The reason the call was blocked

RecionAbbrev

varchar (2), null

The 2-letter postal abbreviation of the US state or territory or Canadian province corresponding to the phone number.

Country

varchar (2), null

The 2-letter ISO 3166-1 code for the country corresponding to the phone number's area code.

Locale

varchar (80), null

The geographic region (usually the city) served by the rate center associated with the area code and prefix of the phone number.

CarrierInfo

varchar (255), null

This field is actually comprised of three sub-fields (separated by semicolons) describing the carrier responsible for the area code and prefix of the phone number.

NewAreaCode

int (3), null

If the area code of the phone number has been reassigned in the process of an area code split, this field lists the new 3-digit area code that should be used in place of the old one. If this field is blank, there is no change to the area code.

tzCode

int (3), null

This field will contain a 1 to 3-digit numeric code referencing a lookup table of Time Zone UTC (GMT)Offset and Daylight Savings Times (DST) observance. Dialer will use this code to determine the contact's local time.

CallingWindow

varchar (50), null

This field is actually comprised of three sub-fields (separated by semicolons) and indicates the time during which the phone number is available for telemarketing calls based on federal and state laws. The time is always in the time zone of this phone number.

Each field is in the format H:MM-H:MM where H is the 1 or 2 digit hour in 24-hour format. In the case where telemarketing is prohibited on a particular day of the week (Sunday for example) the calling window will be designated with zeros (0:00-0:00).

The first sub-field shows the calling window on weekdays (M-F)

The second sub-field shows the calling window on Saturdays

The third sub-field shows the calling window on Sundays

UTCOffset

int (5), null

This field contains a signed integer of the number of minutes to add to current UTC (GMT) time to obtain the current time at the phone number’s location.

DoNotCallToday

int (1), null

This field will contain a 1 on the days where the state in which the phone number resides has a holiday or a state of emergency declaration.

Calling TimeRestrictions

int (1), null

This field will contain code that Indicates if there are any calling time restrictions for the phone number at the time of the scrub. (See the Calling Time Restrictions Codes topic.)

EBRType

varchar (1), null

Indicates whether there is an Existing Business Relationship Permission. (See the EBR Types topic).

isWireless

int (1), null

Indicates whether the phone number is a wireless number or a VoIP (1) or not (0).