| Table Name: | resrch_log |
| Table Number: | 29 |
| Group: | Workflow Mgr |
| Description: | Object which contains the details of research done for a case or subcase |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| action_type | CHAR | varchar | 49 | 40 | Action type for the log: This is a user-defined pop up with default name Research Log Action Type Level 1 | |||
| commitment | CHAR | varchar | 42 | 80 | Title of commitment made during the activity. This is a user-defined popup with default name COMMITMENT | |||
| creation_time | CLK_TIME | datetime | 1 | Date and time the research log was created | Search (3) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| due_date | CLK_TIME | datetime | 43 | Date and time commitment made on the research log is due | ||||
| elapsed_time | LONG | int | 6 | DIRECT | Total elapsed time spent doing research in seconds | Search (3) | ||
| internal | CHAR | varchar | 33 | 255 | For-internal-use-only research notes text | |||
| notes | CHAR | text | 23 | ALLOW_NULL | Research notes text | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| resrch_log2act_entry | OTM | act_entry | act_entry2resrch_log | Activity log entries for the research log | |||
| case_resrch2case | MTO | case | case_rsrch2resrch_log | Case for the research log | |||
| old_resrch_stat2gbst_elm | MTO | gbst_elm | old_cas_stat2resrch_log | Case status prior to changes made for the activity | |||
| new_resrch_stat2gbst_elm | MTO | gbst_elm | new_cas_stat2resrch_log | New case status based on changes made in the activity | |||
| subc_resrch2subcase | MTO | subcase | subc_rsrch2resrch_log | Subcase for the research log | |||
| resrch_owner2user | MTO | user | originator2resrch_log | User that logged the research time |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_case_resrch2case | case_resrch2case, objid | nonclustered, unique located on PRIMARY |
| ind_subc_resrch2subcase | subc_resrch2subcase, objid | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 119 | case2rsrch | act_entry, case, resrch_log |
| 176 | subcase2rsrch | act_entry, resrch_log, subcase |
| 178 | dfe2rsrch | disptchfe, resrch_log |
| resrch_log | |||