View Name:subc_alst
View Number:5364
Group:Support
Description:Used internally for Subcase activity log display
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_subc_alst
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
entry_timeact_entryentry_timeDate and time of activity log entry 1
act_codeact_entryact_codeActivity code for the activity log entry; internally assigned with a unique code for each type of activity 10
add_infoact_entryaddnl_infoAdditional information such as notes 11
login_nameuserlogin_nameLogin name of the user that made the activity log entry 12
subcase_objidsubcaseobjidSubcase internal record number 13
case_objidcaseobjidCase internal record number 14
subcase_id_numbersubcaseid_numberUnique ID number for the subcase; consists of case number-# 15
objidact_entryobjidAct_entry internal record number 3 (UNIQUE)
act_namegbst_elmtitleActivity Name 2
gsl_namegbst_lsttitleName of the Clarify-defined pop up list on which act name is found 
gse_objidgbst_elmobjidGbst_elm internal record number 
user_objiduserobjidUser internal record number 
gsl_objidgbst_lstobjidGbst_lst internal record number 

Joins:

Join FromJoin To
(act_entry).act_entry2subcase(subcase).subcase2act_entry
(act_entry).act_entry2user(user).originator2act_entry
(act_entry).entry_name2gbst_elm(gbst_elm).act_name2act_entry
(gbst_elm).gbst_elm2gbst_lst(gbst_lst).gbst_lst2gbst_elm
(subcase).subcase2case(case).case2subcase
My Recent Objects
subc_alst      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user