View Name:case2sub_cls
View Number:179
Group:Support
Description:Displays case T&E data. Used by form Case Close (340), 2 of 2 (405)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
cls_idclose_caseobjidClose case internal record number 3 (UNIQUE)
sub_idsubcaseobjidSubcase internal record number 
case_idcaseobjidCase internal record number 
id_numbersubcaseid_numberUnique ID number for the subcase; consists of case number-# 4
titlesubcasetitleSubcase title 2
behaviorsubcasebehaviorInternal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase 31
sub_typesubcasesub_typeSubcase type; general or administrative 32
close_dateclose_caseclose_dateCase close date and time 1
actl_phone_timeclose_caseactl_phone_timeActual time spent on the phone for the case or subcase; entered by user if different from captured phone time in seconds 
calc_phone_timeclose_casecalc_phone_timeTime spent on the phone for the case or subcase; calculated from phone logs 
actl_rsrch_timeclose_caseactl_rsrch_timeActual time spent doing research for the case or subcase; entered by user if different from captured research time in seconds 
calc_rsrch_timeclose_casecalc_rsrch_timeTime spent doing research for the case or subcase; calculated from research logs 
actl_bill_expclose_caseactl_bill_expActual billable expenses for the case; not displayed/used 
actl_nonbillclose_caseactl_nonbillActual non-billable expenses for the case; not displayed/used 
calc_bill_expclose_casecalc_bill_expCalculated billable expenses for the case; calculated from T&E logs 
calc_nonbillclose_casecalc_nonbillCalculated non-billable expenses for the case; calculated from T&E logs 
bill_timeclose_casebill_timeCalculated billable time for the case/subcase; calculated from T&E log time items in seconds 
nonbill_timeclose_casenonbill_timeCalculated non-billable time for the case/subcase; calculated from T&E log time items in seconds 
previous_closedclose_caseprevious_closedDate/time case/subcase was last closed; earlier than close date if the case has been closed before 

Joins:

Join FromJoin To
(subcase).subcase2case(case).case2subcase
(close_case).close_case2subcase(subcase).subcase2close_case
My Recent Objects
case2sub_cls