| View Name: | subc_cmitl |
| View Number: | 81 |
| Group: | Support |
| Description: | Selects subcase commitment log information |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | commit_log | objid | Commitment object ID number | 3 (UNIQUE) |
| title | commit_log | title | Commitment title | |
| creation_time | commit_log | creation_time | Commitment creation time and date | |
| sched_cmpltime | commit_log | sched_cmpltime | Scheduled completion time | |
| act_cmpltime | commit_log | act_cmpltime | Actual completion time | |
| cmit_txt | commit_log | cmit_history | Commitment details | |
| made_to | commit_log | made_to | Whom the commitment was made to | |
| condition | commit_log | condition | Commitment condition | |
| originator | user | login_name | Commitment originator | |
| priority | gbst_elm | title | Commitment priority | |
| parent_objid | subcase | objid | Parent subcase |
| Join From | Join To |
|---|---|
| (commit_log).subc_commit2subcase | (subcase).subc_cmit2commit_log |
| (commit_log).commit_owner2user | (user).originator2commit_log |
| (commit_log).cmit_prirty2gbst_elm | (gbst_elm).priority2commit_log |
| subc_cmitl | |||