cls_id | close_case | objid | Close case internal record number | 3 (UNIQUE) |
sub_id | subcase | objid | Subcase internal record number | |
case_id | case | objid | Case internal record number | |
id_number | subcase | id_number | Unique ID number for the subcase; consists of case number-# | 4 |
title | subcase | title | Subcase title | 2 |
behavior | subcase | behavior | Internal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase | 31 |
sub_type | subcase | sub_type | Subcase type; general or administrative | 32 |
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; entered by user if different from captured research time in seconds | |
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; 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 | |