| case_id | case | objid | Case internal record number | 3 (UNIQUE) |
| id_number | case | id_number | Response priority of case; from a Clarify-defined pop up list | 4 |
| title | case | title | Case or service call title; summary of case details | 2 |
| 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 in seconds; entered by user if different from captured phone time | |
| 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 | |
| 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 in seconds; calculated from T&E log time items | |
| nonbill_time | close_case | nonbill_time | Calculated non-billable time for the case/subcase in seconds; calculated from T&E log time items | |
| previous_closed | close_case | previous_closed | Date/time case/subcase was last closed; earlier than close date if the case has been closed before | |