| View Name: | queelm_subcase |
| View Number: | 60 |
| Group: | Support |
| Description: | View subcase information for form Queue (378) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| age | condition | queue_time | Age of subcase in seconds | 6 |
| clarify_state | condition | condition | Subcase condition | 8 |
| condition | condition | title | Condition of subcase | 7 |
| condition_code | condition | condition | Code number for subcase condition | |
| elm_objid | subcase | objid | Subcase object ID number | 3 (UNIQUE) |
| id_number | subcase | id_number | Subcase ID number | 4 |
| owner | user | objid | Subcase owner's internal record number | |
| priority | gse_priority(gbst_elm) | title | Priority of subcase | 35 |
| que_objid | queue | objid | Queue object ID number | 18 |
| severity | gse_severity(gbst_elm) | title | Severity of subcase | 36 |
| status | gse_status(gbst_elm) | title | Status of subcase | 17 |
| subtype | subcase | sub_type | Subcase type | 37 |
| title | subcase | title | Title of subcase | 2 |
| x_res1 | site | x_res1 | Data Restriction field | |
| x_res2 | site | x_res2 | Data Restriction field | |
| x_res3 | site | x_res3 | Data Restriction field | |
| x_res4 | site | x_res4 | Data Restriction field | |
| x_res5 | site | x_res5 | Data Restriction field |
Join From | Join To |
|---|---|
| (subcase).subc_currq2queue | (queue).currq2subcase |
| (subcase).subc_state2condition | (condition).subc_conditn2subcase |
| (subcase).subc_priorty2gbst_elm | gse_priority(gbst_elm).priority2subcase |
| (subcase).subc_svrity2gbst_elm | gse_severity(gbst_elm).severity2subcase |
| (subcase).subc_casests2gbst_elm | gse_status(gbst_elm).case_status2subcase |
| (subcase).subc_owner2user | (user).curr_owner2subcase |
| (case).case_reporter2site | (site).cust_loc2case |
| (subcase).subcase2case | (case).case2subcase |
| queelm_subcase | |||