| View Name: | que_element |
| View Number: | 382 |
| Group: | Support |
| Description: | Used to allocate data structures to like columns in multiple views named 'queelm_*' by mapping them to the same generic field ID. This view is never run against the DBMS,. Used by form Queue (376) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| que_objid | queue | objid | Queue internal record number | 18 |
| elm_objid | case | objid | Case internal record number | 3 (UNIQUE) |
| clarify_state | bug_cond(condition) | condition | Bug internal record number | 8 |
| id_number | case | id_number | Unique case number assigned based on auto-numbering definition | 4 |
| age | bug_cond(condition) | queue_time | Date and time the object was dispatched to queue | 6 |
| condition | bug_cond(condition) | title | Condition of the object in queue | 7 |
| status | gse_status(gbst_elm) | title | Status of the object in queue | 17 |
| title | case | title | Title of the case | 2 |
| priority | gse_priority(gbst_elm) | title | Priority of the object in queue | 35 |
| severity | gse_severity(gbst_elm) | title | Severity of the object in queue | 36 |
| type | gse_type(gbst_elm) | title | Type of the object in queue | 37 |
| part_number | part_num | part_number | Part number/name | 39 |
| mod_level | mod_level | mod_level | Revision level of the part number | 40 |
| quantity | demand_dtl | demand_qty | The order quantity of the part request item queue | 41 |
| Join From | Join To |
|---|---|
| (case).case_currq2queue | (queue).currq2case |
| (case).case_state2condition | bug_cond(condition).case_condition2case |
| (case).calltype2gbst_elm | gse_type(gbst_elm).call_type2case |
| (case).respprty2gbst_elm | gse_priority(gbst_elm).resp_priority2case |
| (case).respsvrty2gbst_elm | gse_severity(gbst_elm).resp_severity2case |
| (case).casests2gbst_elm | gse_status(gbst_elm).case_status2case |
| (probdesc).probdesc2condition | fnl_cond(condition).condition2probdesc |
| (subcase).subc_state2condition | sub_cond(condition).subc_conditn2subcase |
| (demand_dtl).demand_dtl2condition | dtl_cond(condition).condition2demand_dtl |
| (demand_dtl).demand_dtl2part_info | (mod_level).part_info2demand_dtl |
| (bug).bug_condit2condition | bug_cond(condition).bug_condition2bug |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| que_element | |||