| View Name: | case2rsrch |
| View Number: | 119 |
| Group: | Support |
| Description: | View used to access case research log times to calculate total research time for close case entry |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| case_id | case | objid | Case object ID number | |
| creation_time | resrch_log | creation_time | Date and time the research log was created | 1 |
| elapsed_time | resrch_log | elapsed_time | Elapsed time spent on research log item in seconds | 6 |
| objid | act_entry | objid | Act_entry internal record number | 3 (UNIQUE) |
| resrch_objid | resrch_log | objid | Resrch_log internal record number |
| Join From | Join To |
|---|---|
| (act_entry).act_entry2case | (case).case_act2act_entry |
| (act_entry).act_entry2resrch_log | (resrch_log).resrch_log2act_entry |
| case2rsrch | |||