| View Name: | fc_user_subcase_view |
| View Number: | 4651 |
| Group: | Dovetail |
| Description: | |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Custom |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| subcase_objid | subcase | objid | Subcase internal record number | |
| id_number | subcase | id_number | Subcase Id Number | |
| sub_type | subcase | sub_type | Type of subcase | |
| creation_time | subcase | creation_time | Subcase Creation Time | |
| modify_stmp | subcase | modify_stmp | Subcase Modify Time | |
| required_date | subcase | required_date | Subcase Required Date | |
| warning_time | subcase | warning_time | Subcase Warning Time | |
| title | subcase | title | Subcase title; summary of case details | |
| owner | user | login_name | User login name | |
| owner_employee_objid | ownerEmployee(employee) | objid | Owner Employee Database Identifier | |
| owner_first | ownerEmployee(employee) | first_name | Owner First name | |
| owner_last | ownerEmployee(employee) | last_name | Owner Last name | |
| owner_workgroup | ownerEmployee(employee) | work_group | Owner Workgroup | |
| condition | condition | title | Condition of the subcase | |
| condition_value | condition | condition | The subcase's numeric condition value | |
| condition_queue_time | condition | queue_time | The subcase's datetime in queue | |
| site_name | site | name | Site Name | |
| first_name | contact | first_name | Contact first name | |
| last_name | contact | last_name | Contact last name | |
| status | gse_status(gbst_elm) | title | Status of the subcase | |
| priority | gse_priority(gbst_elm) | title | Priority of the subcase | |
| severity | gse_severity(gbst_elm) | title | Severity of the subcase | |
| queue | queue | title | Queue Title | |
| case_id_number | case | id_number | Case Id Number | |
| contact_objid | contact | objid | Contact objid | |
| site_objid | site | objid | Site objid | |
| site_id | site | site_id | Site Id | |
| wipbin_objid | wipbin | objid | Wipbin Objid | |
| owner_user_objid | user | objid | Subcase owner user objid | |
| 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 | OUTER (queue).currq2subcase |
| (subcase).subc_state2condition | (condition).subc_conditn2subcase |
| (case).case_reporter2contact | (contact).caller2case |
| (subcase).subcase2case | (case).case2subcase |
| (subcase).subc_priorty2gbst_elm | gse_priority(gbst_elm).priority2subcase |
| (subcase).subc_owner2user | (user).curr_owner2subcase |
| (subcase).subc_casests2gbst_elm | gse_status(gbst_elm).case_status2subcase |
| (subcase).subc_svrity2gbst_elm | gse_severity(gbst_elm).severity2subcase |
| (case).case_reporter2site | (site).cust_loc2case |
| ownerEmployee(employee).employee2user | (user).user2employee |
| (subcase).subc_wip2wipbin | OUTER (wipbin).wipbin2subcase |
| fc_user_subcase_view | |||