View: dbo.User_Session_View | |||
View definition | |||
create view dbo.User_Session_View as select US.user_session_guid , US.staff_KEY , USP.user_name , USP.host_name , USP.privilege_data , USP.client_application_name , USP.server_application_name , US.login_date , coalesce(USO.logout_date, US.logout_date) as logout_date , US.expiration_date , coalesce(USO.last_access_date, US.last_access_date) as last_access_date , coalesce(USO.user_session_status_KEY, US.user_session_status_KEY) as user_session_status_KEY , US.user_session_pattern_guid , PU.must_change_password , USP.windows_user_name from dbo.User_Session as US with (nolock) left outer join ( select USO.user_session_guid , max(USO.last_access_date) as last_access_date , max(USO.logout_date) as logout_date , max(USO.user_session_status_KEY) as user_session_status_KEY from dbo.User_Session_Override as USO with (nolock) group by USO.user_session_guid ) as USO on US.user_session_guid = USO.user_session_guid left outer join dbo.Practice_User as PU with (nolock) on PU.staff_KEY = US.staff_KEY left outer join dbo.User_Session_Pattern as USP with (nolock) on USP.user_session_pattern_guid = US.user_session_pattern_guid | |||