Table Name:session
Table Number:5832
Group:CIM
Description:Records the reason for interactions
Flags:CACHEOBJIDS 
Baseline/Custom:Baseline
select * from table_session
Keyboard shortcuts available
Fields:

(double-click a column header to select column text)

Field Name
Common Type
Database Type
Generic Field ID
Array Size
Default
Flags
Comment
Field Used in Views
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
disconnect_timeCLK_TIMEdatetime    The time when the User got-off the media (phone/email/chat) during an interaction. This will be the start time for the wrap-up  
end_timeCLK_TIMEdatetime    The User end-time for the interaction, i.e when the user completed updating the notes, creation of a WF object, etc  
objidLONGint3  DIRECT Internal record number  
start_timeCLK_TIMEdatetime    Date and time the interaction was created.The User start-time for an interaction  
Relations:
Relation
Type
Target Object
Inverse Relation
Comment
Flags
MTM Table
Used in Views
session2intrxnMTOintrxnintrxn2sessionInteraction related to a session   Search (1)
session2userMTOuseruser2sessionUser of the session   Search (1)
Indexes: (Defined in Clarify Schema)
Index Name
Fields
Flags
Indexes (Defined in Database):
Index Name
Fields
Additional Information
objindexobjidclustered, unique located on PRIMARY
s2i5832session2intrxnnonclustered located on PRIMARY
s2u5832session2usernonclustered located on PRIMARY
Referenced in Views:
View ID
View Name
Tables
5860agent_list employee, intrxn, session, user
My Recent Objects
session      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user