| Table Name: | call_script |
| Table Number: | 5081 |
| Group: | Script Mgr |
| Description: | A set of prompts, possible responses, scores, branching and actions which guides an agent through the steps required to perform a service for a customer |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| action | CHAR | varchar | 255 | Action to take if the response is selected | ||||
| branch_ind | LONG | tinyint | 0 | DIRECT | Indicates whether branching is enabled on the script; i.e., 0=no, 1=yes, default=0. Indicator may be modified when used | |||
| create_date | CLK_TIME | datetime | The create date and time of the call_script object | |||||
| description | CHAR | varchar | 255 | Description of the call script | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| duration | LONG | int | 6 | DIRECT | Estimated length of the call script in seconds | |||
| embed_func | CHAR | varchar | 255 | Embeded function used for processing embeded text | ||||
| embed_parm | CHAR | varchar | 255 | Parameter set for the embed func | ||||
| name | CHAR | varchar | 2 | 80 | Script name | Search (4) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) | ||
| parm | CHAR | varchar | 255 | Parameter set for the action | ||||
| scr_type | CHAR | varchar | 40 | Script type. This is from a user-defined popup with default name Call Script Type | ||||
| status | CHAR | varchar | 40 | Script status. This is from a user-defined popup with default name Call Script Status |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| s_next_s2call_script | MTO | call_script | snexts2call_script | Default next script to be executed | Search (1) | ||
| snexts2call_script | OTM | call_script | s_next_s2call_script | Scripts executing the current script as their default next script | |||
| scr2campaign | MTM | campaign | campaign2call_script | Campaigns in which the call script is used | mtm_campaign4_ call_script0 | ||
| scr2key_word | MTM | key_word | key_word2call_script | Key words applied to the call script | mtm_call_script5_ key_word0 | ||
| scr2opp_scr_role | OTM | opp_scr_role | scr_role2call_script | Opportunity roles for the call script | |||
| scr2scr_run | OTM | scr_run | scr_run2call_script | Instances of the script being used | |||
| scr2script_qstn | OTM | script_qstn | question2call_script | Questions used in the call script | |||
| q_next_s2script_qstn | OTM | script_qstn | q_next_s2call_script | Script questions branching to the current script | |||
| q_play_s2script_qstn | OTM | script_qstn | q_play_s2call_script | Script question playing the current script | |||
| r_next_s2scqstn_rspns | OTM | scrqstn_rspns | r_next_s2call_script | Script responses branching to the current script | |||
| r_play_s2scqstn_rspns | OTM | scrqstn_rspns | r_play_s2call_script | Script responses playing to the current script | |||
| scr_originator2user | MTO | user | orig2call_script | User who originated the call script | Search (1) |
| Index Name | Fields | Flags |
|---|---|---|
| script_ind | name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| script_ind | name | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5167 | oppscr_v | call_script, opp_scr_role, opportunity |
| 5213 | ccc_scr_v | call_script, user |
| 5214 | ccc_qsn_v | call_script, script_qstn |
| 5215 | ccc_rsp_v | call_script, script_qstn, scrqstn_rspns |
| call_script | |||