| View Name: | subcase_view |
| View Number: | 160 |
| Group: | Support |
| Description: | Reserved; obsolete |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| usr_objid | user | objid | Reserved; obsolete | |
| elm_objid | subcase | objid | Reserved; obsolete | 3 (UNIQUE) |
| id_number | subcase | id_number | Reserved; obsolete | 4 |
| dspch_age | condition | dispatch_time | Reserved; obsolete | 6 |
| total_age | subcase | creation_time | Reserved; obsolete | 1 |
| condition | condition | title | Reserved; obsolete | 7 |
| response | gbst_elm | title | Reserved; obsolete | 8 |
| contact_lname | contact | last_name | Reserved; obsolete | 14 |
| contact_fname | contact | first_name | Reserved; obsolete | 15 |
| parent_objid | case | objid | Reserved; obsolete |
| Join From | Join To |
|---|---|
| (case).case_reporter2contact | (contact).caller2case |
| (subcase).subcase2case | (case).case2subcase |
| (subcase).subc_state2condition | (condition).subc_conditn2subcase |
| (subcase).subc_priorty2gbst_elm | (gbst_elm).priority2subcase |
| (monitor).monitor2user | (user).user_access2monitor |
| (monitor).monitor2subcase | (subcase).subc_view2monitor |
| subcase_view | |||