| View Name: | qry_subcase_view |
| View Number: | 248 |
| Group: | Support |
| Description: | Used by form Subcases from Query (811) |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| elm_objid | subcase | objid | Subcase internal record number | 3 (UNIQUE) |
| id_number | subcase | id_number | Unique ID number for the subcase; consists of case number-# | 4 |
| owner | owner(user) | login_name | Subcase owner user login name | 12 |
| condition | condition | title | Condition of the subcase | 7 |
| status | gse_status(gbst_elm) | title | Status of the subcase | 8 |
| title | subcase | title | Subcase title | 2 |
| site_name | site | name | Name of the reporting site | |
| first_name | contact | first_name | Contact first name | |
| last_name | contact | last_name | Contact last name | |
| sub_type | subcase | sub_type | Subcase type; general or administrative | 32 |
| behavior | subcase | behavior | Internal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase | 31 |
| priority | gse_priority(gbst_elm) | title | Priority of the subcase | 35 |
| severity | gse_severity(gbst_elm) | title | Serverity of the subcase | 36 |
| required_date | subcase | required_date | Date and time task must be completed | 38 |
| creation_time | subcase | creation_time | ||
| 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 |
|---|---|
| (case).case_reporter2site | (site).cust_loc2case |
| (subcase).subcase2case | (case).case2subcase |
| (subcase).subc_svrity2gbst_elm | gse_severity(gbst_elm).severity2subcase |
| (case).case_reporter2contact | (contact).caller2case |
| (subcase).subc_casests2gbst_elm | gse_status(gbst_elm).case_status2subcase |
| (subcase).subc_state2condition | (condition).subc_conditn2subcase |
| (subcase).subc_owner2user | owner(user).curr_owner2subcase |
| (subcase).subc_priorty2gbst_elm | gse_priority(gbst_elm).priority2subcase |
| qry_subcase_view | |||