| case_id | case | objid | Case internal record number | |
| sub_id | disptchfe | objid | Disptchfe internal record number | 3 (UNIQUE) |
| id_number | disptchfe | work_order | Work order number entered by the user | |
| title | disptchfe | description | Task description | |
| close_date | close_case | close_date | Case close date and time | 1 |
| actl_phone_time | close_case | actl_phone_time | Actual time spent on the phone for the case or subcase; entered by user if different from captured phone time in seconds | |
| calc_phone_time | close_case | calc_phone_time | Time spent on the phone for the case or subcase; calculated from phone logs | |
| actl_rsrch_time | close_case | actl_rsrch_time | Actual time spent doing research for the case or subcase in seconds; entered by user if different from captured research time | |
| calc_rsrch_time | close_case | calc_rsrch_time | Time spent doing research for the case or subcase; calculated from research logs in seconds | |
| actl_bill_exp | close_case | actl_bill_exp | Actual billable expenses for the case; not displayed/used | |
| actl_nonbill | close_case | actl_nonbill | Actual non-billable expenses for the case; not displayed/used | |
| calc_bill_exp | close_case | calc_bill_exp | Calculated billable expenses for the case; calculated from T&E logs | |
| calc_nonbill | close_case | calc_nonbill | Calculated non-billable expenses for the case; calculated from T&E logs | |
| bill_time | close_case | bill_time | Calculated billable time for the case/subcase; calculated from T&E log time items in seconds | |
| nonbill_time | close_case | nonbill_time | Calculated non-billable time for the case/subcase; calculated from T&E log time items in seconds | |
| previous_closed | close_case | previous_closed | Date/time case/subcase was last closed; earlier than close date if the case has been closed before | |