| Table Name: | commit_log |
| Table Number: | 30 |
| Group: | Workflow Mgr |
| Description: | Object which contains the details of a commitment made for a case, subcase, or job |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| act_cmpltime | CLK_TIME | datetime | Date and time of actual completion | Search (3) | ||||
| action_type | CHAR | varchar | 49 | 40 | Action type for the log; from user-defined pop up with default name Commitment Log Action Type | |||
| cmit_history | CHAR | text | ALLOW_NULL | Commitment history; text appended as activities occur | Search (4) | |||
| condition | LONG | int | 8 | DIRECT | Commitment condition; open or closed | Search (7) | ||
| creation_time | CLK_TIME | datetime | 1 | Date and time the commitment was created | Search (4) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| elapsed_time | LONG | int | 6 | DIRECT | Prior warning elapsed time in seconds | |||
| made_to | LONG | int | DIRECT | Whether the commitment was made to or made by the customer | Search (3) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (9) | ||
| sched_cmpltime | CLK_TIME | datetime | 43 | Date and time of scheduled completion; date/time completion is required/requested | Search (9) | |||
| site_time | CLK_TIME | datetime | Reserved; not used | |||||
| title | CHAR | varchar | 2 | 80 | Commitment log title | Search (9) | ||
| warning_time | CLK_TIME | datetime | Date and time of commitment warning | |||||
| x_focus_type | CHAR | varchar | 80 | USER_DEFINED | The type of the main object for this commitment. case, subcase, bug, etc. Useful for notifications. | |||
| x_notes | CHAR | text | USER_DEFINED | Notes used by Dovetail Agent regarding reasons commitment was made. |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| commit_log2act_entry | OTM | act_entry | act_entry2commit_log | Activity logged for commitment log activities; e.g., make, modify, etc | |||
| bug_commit2bug | MTO | bug | bug_cmit2commit_log | Reserved; not used | |||
| case_commit2case | MTO | case | case_cmit2commit_log | Related case | Search (3) | ||
| commit_cust2contact | MTO | contact | caller2commit_log | Contact the commitment was made to or who made commitment | Search (5) | ||
| cmit_solver2employee | MTO | employee | solver2commit_log | Employee who completed commitment | |||
| commit_empl2employee | MTO | employee | intcontact2commit_log | Reserved; not used | |||
| cmit_name2gbst_elm | MTO | gbst_elm | cond_name2commit_log | Condition of commitment; e.g., open, closed; uses Clarify-defined pop up list | Search (1) | ||
| cmit_prirty2gbst_elm | MTO | gbst_elm | priority2commit_log | Reserved; not used | Search (3) | ||
| job_commit2job | MTO | job | job_cmit2commit_log | Related job | |||
| opp_commit2opportunity | MTO | opportunity | opp_cmit2commit_log | Related opportunity; reserved future | |||
| subc_commit2subcase | MTO | subcase | subc_cmit2commit_log | Related subcase | Search (3) | ||
| commit_owner2user | MTO | user | originator2commit_log | User that entered the commitment | Search (8) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| cc2c0030 | commit_cust2contact | nonclustered located on PRIMARY |
| ind_case_commit2case | case_commit2case, objid | nonclustered, unique located on PRIMARY |
| ind_cmit_name2gbst_elm | cmit_name2gbst_elm, objid | nonclustered, unique located on PRIMARY |
| ind_commit_owner2user | commit_owner2user, objid | nonclustered, unique located on PRIMARY |
| ind_opp_commit2opportunity | opp_commit2opportunity, objid | nonclustered, unique located on PRIMARY |
| ind_subc_commit2subcase | subc_commit2subcase, objid | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 80 | cas_cmitl | case, commit_log, gbst_elm, user |
| 81 | subc_cmitl | commit_log, gbst_elm, subcase, user |
| 82 | dfe_cmitl | commit_log, disptchfe, gbst_elm, user |
| 235 | act_cmitl | commit_log, gbst_elm |
| 379 | case_cmit | case, commit_log, contact, user |
| 380 | subc_cmit | commit_log, contact, subcase, user |
| 5235 | cmit2oltsk | commit_log, contact, user |
| 5987 | case_cmit2 | case, commit_log, contact, user |
| 5988 | subc_cmit2 | commit_log, contact, subcase, user |
| commit_log | |||