View Name: | wipelm_subcase |
View Number: | 57 |
Group: | Support |
Description: | View subcase information for WIPbin form (375) |
Flags: | VIEW_OPTIMIZED |
Baseline/Custom: | Baseline |
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
---|---|---|---|---|
wip_objid | wipbin | objid | WIPbin internal record number | 18 |
elm_objid | subcase | objid | Subcase internal record number number | 3 (UNIQUE) |
clarify_state | condition | condition | Subcase state | 8 |
id_number | subcase | id_number | Unique ID number for the subcase; consists of case number-# | 4 |
age | condition | wipbin_time | Subcase age in seconds | 6 |
condition | condition | title | Subcase condition | 7 |
status | gse_status(gbst_elm) | title | Subcase status | 17 |
title | subcase | title | Subcase title | 2 |
priority | gse_priority(gbst_elm) | title | Subcase priority | 35 |
severity | gse_severity(gbst_elm) | title | Subcase severity | 36 |
owner | user | objid | Subcase owner's internal record number | |
condition_code | condition | condition | Code number for subcase condition | |
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_wip2wipbin | (wipbin).wipbin2subcase |
(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 |
(subcase).subcase2case | (case).case2subcase |
(case).case_reporter2site | (site).cust_loc2case |
wipelm_subcase | |||