| Table Name: | scrqstn_rspns |
| Table Number: | 5155 |
| Group: | Script Mgr |
| Description: | Predefined responses or possible choices for script prompts (questions) |
| 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 | Search (2) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| editable_ind | LONG | tinyint | 0 | DIRECT | Actual response may be modified when used: 0=no, 1=yes | |||
| is_default | LONG | tinyint | 0 | DIRECT | Is the default response. For multi-select prompts, there may be more than one default response | Search (1) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| parm | CHAR | varchar | 255 | Parameter set for the action | ||||
| response | CHAR | varchar | 255 | Text of the response | Search (3) | |||
| score | LONG | int | DIRECT | Numeric score of the response | Search (2) | |||
| seq_num | LONG | smallint | DIRECT | Sequence number of the response | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| r_next_s2call_script | MTO | call_script | r_next_s2scqstn_rspns | Script branched to from the response | Search (1) | ||
| r_play_s2call_script | MTO | call_script | r_play_s2scqstn_rspns | Script played from the current response | Search (1) | ||
| response2opp_response | OTM | opp_response | answer2scrqstn_rspns | Opportunity related answers to the response. Reserved; obsolete | |||
| answer2scr_response | OTM | scr_response | answ2scrqstn_rspns | Actual answers to the response | |||
| current2script_qstn | MTO | script_qstn | qstn2scqstn_rspns | Current call script question | Search (2) | ||
| next2script_qstn | MTO | script_qstn | next2scqstn_rspns | Next call script question. The response traggers a jump to an out-of-sequence script question | Search (2) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_action | action | nonclustered located on PRIMARY |
| ind_current2script_qstn | current2script_qstn | nonclustered located on PRIMARY |
| ind_parm | parm | nonclustered located on PRIMARY |
| ns2q5155 | next2script_qstn | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| rn2cs5155 | r_next_s2call_script | nonclustered located on PRIMARY |
| rp2cs5155 | r_play_s2call_script | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5171 | scrqstnrsq_v | script_qstn, scrqstn_rspns |
| 5215 | ccc_rsp_v | call_script, script_qstn, scrqstn_rspns |
| 5216 | ccc_srun_v | scr_response, scr_run, scrqstn_rspns |
| scrqstn_rspns | |||