| Table Name: | script_qstn |
| Table Number: | 5082 |
| Group: | Script Mgr |
| Description: | Prompts (questions) for call scripts |
| 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 | ||||
| answer | CHAR | varchar | 255 | Text of the answer to the question | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| embed_func | CHAR | varchar | 255 | Embeded function used for processing embeded text | ||||
| embed_parm | CHAR | varchar | 255 | Parameter set for the embed func | ||||
| long_question | CHAR | text | ALLOW_NULL | Text of the question if longer than 255 characters | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| parm | CHAR | varchar | 255 | Parameter set for the action | ||||
| question | CHAR | varchar | 255 | Text of the question if length is within 255 characters | Search (3) | |||
| seq_num | LONG | smallint | DIRECT | Sequence number of the question | Search (3) | |||
| status | CHAR | varchar | 30 | Question status. This is from a user-defined popup |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| question2call_script | MTO | call_script | scr2script_qstn | The call script which owns the question | Search (1) | ||
| q_next_s2call_script | MTO | call_script | q_next_s2script_qstn | Next script to be branched to | Search (1) | ||
| q_play_s2call_script | MTO | call_script | q_play_s2script_qstn | Next script to be played | Search (1) | ||
| resp_type2gbst_elm | MTO | gbst_elm | resp_type2script_qstn | Type of response expected: e.g., multi-select, single select, etc | |||
| q_next_q2script_qstn | MTO | script_qstn | qnextq2script_qstn | Next question to be branched to | Search (1) | ||
| qnextq2script_qstn | OTM | script_qstn | q_next_q2script_qstn | Script questions branching to the current question | |||
| qstn2scqstn_rspns | OTM | scrqstn_rspns | current2script_qstn | Possible responses for the question | |||
| next2scqstn_rspns | OTM | scrqstn_rspns | next2script_qstn | Responses that lead to the question |
| Index Name | Fields | Flags |
|---|---|---|
| scr_qstn_ind | question2call_script:seq_num | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_action | action | nonclustered located on PRIMARY |
| ind_parm | parm | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| qn2cs5082 | q_next_s2call_script | nonclustered located on PRIMARY |
| qn2sc5082 | q_next_q2script_qstn | nonclustered located on PRIMARY |
| qp2cs5082 | q_play_s2call_script | nonclustered located on PRIMARY |
| scr_qstn_ind | question2call_script, seq_num | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5171 | scrqstnrsq_v | script_qstn, scrqstn_rspns |
| 5214 | ccc_qsn_v | call_script, script_qstn |
| 5215 | ccc_rsp_v | call_script, script_qstn, scrqstn_rspns |
| script_qstn | |||