Pre-call Scripts
    • Dark
      Light

    Pre-call Scripts

    • Dark
      Light

    Article summary

    Pre-scall Script

    Data Type

    Description

    CampaignID

    nvarchar(64

    Name of the Campaign.

    ContactID

    Int

    Unique ID for a Campaign.

    ListID

    Int

    List ID is Unique ID for a Campaign.

    MODEID

    Int

    Internal ID of Mode Name, refer as OBD_Modes table.

    CampaignKey

    Int

    Internal ID for a Campaign, refer Obd_Campaign Table.

    CampaignKey

    Int

    Attempts made for the contact so far.

    ModeRetries

    Int

    The number of tries in the same mode. This is reset when dialing switches to the different mode.

    MaxRetries

    Int

    The number of tries made for a contact till this moment. It is equivalent to contact retries.

    CValue

    nvarchar(12)

    Phone number to which the call will be dialed (or) Email ID to which the email will be sent.

    TimeZoneID

    Int

    Internal ID of Time Zone Name, refer as OBD_TimeZone table.

    TenantID

    Int

    This is applicable only for Tenant module, this is unique ID for a Tenant.

    UserID

    Int

    For PCB contacts, the Agent ID from which the callback is registered. For Regular Callback this field holds the value as LCM. For AEM Contacts, the contact is tagged to this Agent.

    CallType

    Int

    Identifies the call mode (0 - Regular call, 1 - Callback, 2 - AEM).

    ConditionID

    Int

    Internal ID of CSS Condition (refer OBD_CustomFilters).

    CISCOALTERNATEVDN

    nvarchar(12)

    No longer used.

    PhoneNumber

    nvarchar(12)

    Phone number to which the call will be dialed (or) Email ID to which the email will be sent.

    BUSSFLD1 to BU0SSFLD20

    nvarchar(128)

    Value of Business field1 to Value of Business field20.

    BUSSFLD21 to BU06SSFLD26

    nvarchar(Max)

    Value of Business field21 to Value of Business field26.

    CONTACTDETAIL

    nvarchar(Max)

    Optional Business field value. This field holds the value in XML type.

    MailSubject

    nvarchar(1024)

    Email subject.

    MailMessage

    nvarchar(Max)

    Email body.

    MailAttach

    nvarchar(1024)

    Email attachment. This must absolute path to the location where the attachment is saved.

    SMSText

    nvarchar(4000)

    SMS message.

    ZONENAME

    nvarchar(128)

    Zone Name of the Mode. The current mode which the contact has picked.

    ZipCode

    nvarchar(32)

    Zip code of the contact.

    AreaCode

    nvarchar(50)

    Area Code of the Mode. The current mode which the contact has picked.

    StateName

    nvarchar(64)

    State Name of the contact.

    RescheduleExpiredTime

    DateTime

    Call end time — For Reschedule contacts, the call end time is considered. For Callback contacts, the callback end time is considered.

    ListEndTime

    DateTime

    End Time of the List.

    CallbackTime

    DateTime

    CallBack Start Time.

    PRIORITY

    int

    Priority of the Contact.

    LastAccessed

    DateTime

    The date and time when contact information is updated on the Contact table.

    ListTimeToLive

    int

    Time to live for a List.

    DailyRetries

    int

    Retries made for the current day.

    CycleRetries

    int

    Number of cycle Retries has made so far.

    LastOutCome

    int

    The last outcome received from the dialer for this contact.

    GID

    int

    Global List ID.

    IsWireless

    Bool

    Flag to determine whether the current mode is wired or wireless.

    MAILCC

    nvarchar(Max)

    The recipients that need to be mapped in the CC field while sending an email.

    MAILBCC

    nvarchar(Max)

    The recipients that need to be mapped in the BCC field while sending an email.

    EmailRetries

    int

    Number of Emails sent so far.

    SMSRetries

    int

    Number of SMS sent so far.

    ListProcessingDate

    DateTime

    List start date time.

    LeadScore

    int

    Lead Score. This can be part of Upload List to rank the Contact.

    Weightage

    int

    Weightage of the Mode. The current mode which the contact has picked.

    ChannelType

    int

    Channel type of the Mode. The current mode which the contact has picked.

    EmailSMSTemplateName

    nvarchar(64)

    Name of the template that is executed. This is the template selected based on the conditions defined.

    AccountNumber

    nvarchar(30)

    It is a unique ID to identify a call attempt for a contact.

    DeliverType

    nvarchar

    This defines whether the contact is delivered to a dialer or an agent such as Manual dialing (Deliver - PEWC, Deliver - Regular).

    RetValue

    bool

    This flag must be set to True when the script is executed and the contact must be dialed out. This flag must set to False when this contact are prevents from being dialed out at this moment.

    IsListExpired

    bool

    A flag which denotes the expiry of this contact under a List based on the Time Zone.

    BusinessOutcome

    nvarchar

    This is related to the RetValue field. While RetValue is set to false, it is mandatory to set the Business/Telephony outcome when there is a need to prevent the contact from dialing.

    Module

    nvarchar

    Expiry Module (Campaign, Time Zone, Mode, Contact, List). This is applicable for manual dialling (non-PEWC).

    ExpiryTime

    DateTime

    Expiry time of the contact. This is derived based on the end time of the listed module (Campaign, Time Zone, Mode, Contact, List).

    ResetContactLeadScore

    bool

    A flag to reset the lead score value (this is internal flag).

    TemplateName

    nvarchar

    Name of the template that is executed; this is the template selected, based on the conditions defined.

    CallID

    nvarchar(64)

    This is a unique ID for a call.

    DeliverdTimeZone

    nvarchar(128)

    The contact time zone is held in this field.

    TimezoneExpiryTime

    nvarchar(32)

    The expiry time for contact is calculated based on the time zone and filled in this field.

    CiscoTimezonebias

    nvarchar(128)

    This is the time zone bias for API contacts.

    CiscodstObsereved

    Boolean

    Flag to determine if the contact time zone is under Daylight Saving Time (DST). True if under DST False if not under DST.

    CampaignCategoryName

    nvarchar(64)

    The campaign category name associated to this campaign.

    CampaignCategoryID

    int

    The mapped campaign category ID.

    AuthScheduleRetry

    int

    The number of tries allowed for Identity Authentication.

    DeviceID

    nvarchar(255)

    The device ID used for Identity Authentication.

    CallerID

    nvarchar(64)

    The caller ID was identified by ANI.

    DialerAgentCallback

    bit

    This determines if a callback request was set by a clicker agent or an external agent.

    OverridePEWCValidation

    bit

    It is used to determine if customer has permitted autodialing. This enables immediate delivery of contact without validating for PEWC.

    DialerID

    int

    This is the dialer ID assigned by the application when a dialer is created.

    PaceID

    int

    This is the ID assigned to the pacing mode (Preview, Progressive, Predictive, etc.) when creating a campaign.

    CampaignGroup

    nvarchar(64)

    This is the Campaign Group name as created by the user or synchronized from the dialer.

    FilterConditionID

    int

    This is the auto-generated ID when a user creates filter conditions for the application to override the Group settings at the campaign level. This is applicable only for overriding CLI, Answering Machine Treatment, and Abandoned Call Treatment.

    DialerAttributes

    nvarchar

    This column contains all the pacing mode properties configured for a Campaign Group in a JSON string format.

    The default value is CampaignGroup.

    DialerAttributesModifiedBy

    nvarchar

    This is the entity name that overrides the group settings at the campaign level. For example, if the group settings are overridden by a pre-call script, this contains PreCallScript as the entry.

    The default value is CampaignGroup.

    Amazon Connect

    PacingMode

    varchar

    Pacing Mode of the Campaign.

    IsRequiredDisposition

    varchar

    Flag to indicate if the agent disposition is mandatory. True if mandatory.

    LCMKey

    varchar

    It is a unique ID to identify a call attempt for a contact.

    QueueName

    varchar

    The campaign group (Queue) name.

    QueueARN

    varchar

    The Amazon Resource Name (ARN) for this queue.

    isCPA

    varchar

    Flag to indicate if CPA detection is necessary. True if necessary.

    CPAResult

    varchar

    This contains the string of CPA detected.

    isWhisper

    varchar

     This propriety is not used in the contact flow.

    ContactNature

    varchar

    Type of the contact such as Fresh contact, Regular Callback contact, or a Personal Callback contact.

    CampaignID

    varchar

    The campaign name.

    CallType

    varchar

    This is the call type for the contact. Possible values are Agent call or agent-less IVR call.

    IsCallAnswered

    varchar

      This propriety is not used in the contact flow.

    AgentName

    varchar

    The name of the agent handling the Preview or Personal Callback call.

    AgentRoutableState

    varchar

    The state of the Agent Routable State.

    CallBackURL

    varchar

     This propriety is not used in the contact flow.

    AMDTreatment

    varchar

    The Answering Machine Treatment configured for this campaign. Sample values are Transfer to IVR or Play Message and Disconnect.

    AMDContactFlowId

    varchar

    If Answering Machine Treatment is Transfer to IVR, the name of Custom Contact Flow ID used by the application.

    AMDAudioPromptType

    varchar

    If Answering Machine Treatment is Play and Disconnect, the Prompt Type used by the application.

    AMDAudioPromptName

    varchar

    If Answering Machine Treatment is Play and Disconnect, the Audio Prompt file name used by the application

    AMDAudioTTSMessage

    varchar

    If Answering Machine Treatment is Play and Disconnect, the TTS Message configured in the application.

    AMDAudioTTSLanguage

    varchar

    If Answering Machine Treatment is Play and Disconnect , the language in which the TTS Message is played.

    AMDAudioTTSVoiceTalent

    varchar

    If Answering Machine Treatment is Play and Disconnect, the TTS Voice Talent configured in the application.

    ABDTreatment

    varchar

    The Abandon Treatment configured for this campaign. Possible values are Transfer to IVR or Play Message and Disconnect.

    ABDWaitTime

    varchar

    If Abandon Treatment is configured, the Wait Time configured in the application.

    ABDContactFlowId

    varchar

    If Abandon Treatment is Transfer to IVR, the name of Custom Contact Flow ID used by the application.

    ABDInitialAudioPromptType

    varchar

    Flag to indicate if Abandon Treatment is Initial Play and Disconnect Prompt Type.

    ABDInitialAudioPromptName

    varchar

    If Abandon Treatment is Initial Play and Disconnect, the Audio Prompt file name to play.

    ABDInitialAudioTTSMessage

    varchar

    If Abandon Treatment is Initial Play and Disconnect, the TTS Message configured in the application.

    ABDInitialAudioTTSLanguage

    varchar

    If Abandon Treatment is Initial Play and Disconnect, the TTS Language configured in the application.

    ABDInitialAudioTTSVoiceTalent

    varchar

    If Abandon Treatment is Initial Play and Disconnect, the TTS Voice Talent configured in the application.

    ABDFollowupAudioPromptType

    varchar

    Flag to indicate if Abandon Treatment is Follow-up Play and Disconnect Prompt Type.

    ABDFollowupAudioPromptName

    varchar

    If Abandon Treatment is Follow-up Play and Disconnect, the Audio Prompt file name to play.

    ABDFollowupAudioTTSMessage

    varchar

    If Abandon Treatment is Follow-up Play and Disconnect, the TTS Message configured in the application.

    ABDFollowupAudioTTSLanguage

    varchar

    If Abandon Treatment is Follow-up Play and Disconnect, the TTS Language configured in the application.

    ABDFollowupAudioTTSVoiceTalent

    varchar

    If Abandon Treatment is Follow-up Play and Disconnect, the TTS Voice Talent configured in the application.

    ABDTimeOutAudioPromptType

    varchar

    If Abandon Treatment is on account of Time Out, the Prompt Type configured.

    ABDTimeOutAudioPromptName

    varchar

    If Abandon Treatment is on account of Time Out, Audio Prompt file name.

    ABDTimeOutAudioTTSMessage

    varchar

    If Abandon Treatment is on account of Time Out, the TTS Message configured in the application.

    ABDTimeOutAudioTTSLanguage

    varchar

    If Abandon Treatment is on account of Time Out, the TTS Language configured in the application.

    ABDTimeOutAudioTTSVoiceTalent

    varchar

    If Abandon Treatment is on account of Time Out, the TTS Voice Talent configured in the application.

    IVRContactFlowId

    varchar

    The Custom Contact Flow ID configured for the Progressive IVR campaign.

    Business Fields (Agent View Enabled)

    varchar

    The business fields that are enabled for Agent View.

    ContactCreatedTime

    Datetime

    This indicates the date and time of a contact created in the system.


    Was this article helpful?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.
    ESC

    Eddy AI, facilitating knowledge discovery through conversational intelligence