| View Name: | cls_sub_view |
| View Number: | 166 |
| Group: | Support |
| Description: | Reserved; not used |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| subcase_id | subcase | objid | Subcase internal record number | 3 (UNIQUE) |
| empl_id | employee | objid | Employee internal record number | |
| user_id | sub_user(user) | objid | User internal record number | |
| wip_id | sub_wip(wipbin) | objid | WIPbin internal record number | 18 |
| id_number | subcase | id_number | Unique ID number for the subcase; consists of case number-# | 4 |
| closer_name | sub_user(user) | login_name | User login name | 12 |
| site_name | site | name | Site name | |
| contact_f_name | contact | first_name | Contact first name | 15 |
| contact_l_name | contact | last_name | Contact last name | 14 |
| condition | condition | title | Title of condition | 7 |
| case_wip_id | case_wip(wipbin) | objid | WIPbin internal record number | |
| case_owner_id | case_user(user) | objid | User internal record number |
| Join From | Join To |
|---|---|
| (case).case_wip2wipbin | case_wip(wipbin).wipbin2case |
| (case).case_owner2user | case_user(user).curr_owner2case |
| (case).case_reporter2site | (site).cust_loc2case |
| (case).case_reporter2contact | (contact).caller2case |
| (subcase).subc_wip2wipbin | sub_wip(wipbin).wipbin2subcase |
| (subcase).subcase2case | (case).case2subcase |
| (subcase).subc_owner2user | sub_user(user).curr_owner2subcase |
| (subcase).subc_state2condition | (condition).subc_conditn2subcase |
| (employee).employee2user | sub_user(user).user2employee |
| cls_sub_view | |||