| View Name: | case_cmit2 |
| View Number: | 5987 |
| Group: | Support |
| Description: | Used in form My Commitment (498) to show user's case commitments |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| elm_objid | commit_log | objid | Commit log internal record number | 3 (UNIQUE) |
| user_objid | origin(user) | objid | Originator internal record number | |
| id_number | case | id_number | Unique ID number for the case | 4 |
| due_date | commit_log | sched_cmpltime | Date and time the task must be completed | 43 |
| first_name | contact | first_name | Contact first name | 15 |
| last_name | contact | last_name | Contact last name | 14 |
| description | commit_log | title | Commitment title | 2 |
| condition | commit_log | condition | Commitment condition | 8 |
| owner_objid | owner(user) | objid | Owner internal record number | 42 |
| parent_objid | case | objid | Case internal record number |
| Join From | Join To |
|---|---|
| (commit_log).case_commit2case | (case).case_cmit2commit_log |
| (commit_log).commit_cust2contact | (contact).caller2commit_log |
| (commit_log).commit_owner2user | origin(user).originator2commit_log |
| (case).case_owner2user | owner(user).curr_owner2case |
| case_cmit2 | |||