| View Name: | subcase2rsrch |
| View Number: | 176 |
| Group: | Support |
| Description: | Information on research logs for a subcase. Used to calculate research time on the close subcase form |
| 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) |
| creation_time | resrch_log | creation_time | Date and time the research log was created | 1 |
| elapsed_time | resrch_log | elapsed_time | Total elapsed time spent doing research in seconds | 6 |
| Join From | Join To |
|---|---|
| (act_entry).act_entry2subcase | (subcase).subcase2act_entry |
| (act_entry).act_entry2resrch_log | (resrch_log).resrch_log2act_entry |
| subcase2rsrch | |||