Table: dbo.User_Session
Columns
NameTypeConstraintsDescription
user_session_guiduniqueidentifier (16)NOT NULLA database generated unique key for this table.
staff_KEYint (4)NOT NULLKey to the Staff that this session is for.
login_datedatetime (8, 3)NOT NULLThe date and time the session was opened.
logout_datedatetime (8, 3)NOT NULLThe date and time that the user logged out, or that the session was deemed expired or killed.
user_session_pattern_guiduniqueidentifier (16)NOT NULLKey to the User_Session_Pattern table.
expiration_datedatetime (8, 3)NOT NULLThe date and time that this session will expire.
last_access_datedatetime (8, 3)NOT NULLDate and time this session was last active.
user_session_status_KEYint (4)NOT NULLThe status of this session (1=Open, 2=Closed, 3=Expired, 4=Killed)
Primary key
NameColumnsDescription
PK_User_Session$user_session_guiduser_session_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Session__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
FK_User_Session__User_Session_Pattern__user_session_pattern_guiduser_session_pattern_guidUser_Session_Pattern (user_session_pattern_guid)
FK_User_Session__User_Session_Status__user_session_status_KEYuser_session_status_KEYUser_Session_Status (user_session_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Onvio_Client_List__User_Session__user_session_guiduser_session_guidOnvio_Client_List
FK_Print_1099__User_Session__user_session_guiduser_session_guidPrint_1099
FK_W2_Rendering_Client_Lock__User_Session__user_session_guiduser_session_guidW2_Rendering_Client_Lock
FK_Print_W2__User_Session__user_session_guiduser_session_guidPrint_W2
FK_Notification_Queue_Record_Lock__User_Session__user_session_guiduser_session_guidNotification_Queue_Record_Lock
FK_Direct_Deposit_Fundable_Transaction__User_Session__user_session_guiduser_session_guidDirect_Deposit_Fundable_Transaction
FK_Direct_Deposit_Processable_Transaction__User_Session__user_session_guiduser_session_guidDirect_Deposit_Processable_Transaction
FK_Undo_Manager_Entry__User_Session__user_session_guiduser_session_guidUndo_Manager_EntryForeign key for the user session guid.
FK_Print_1095__User_Session__user_session_guiduser_session_guidPrint_1095
FK_User_Session_Override__User_Session__user_session_guiduser_session_guidUser_Session_Override
FK_Onvio_Payroll_Integration_Queue__User_Session__user_session_guiduser_session_guidOnvio_Payroll_Integration_Queue
FK_Tax_Form_Liability_Processing_Lock__User_Session__user_session_guiduser_session_guidTax_Form_Liability_Processing_Lock
FK_Print_Receivable_Transaction_Detail_Selection__User_Session__user_session_guiduser_session_guidPrint_Receivable_Transaction_Detail_Selection
FK_Client_Pay_Schedule_Batch_Session__User_Session__user_session_guiduser_session_guidClient_Pay_Schedule_Batch_Session
FK_Print_Customer_Statement_Selection__User_Session__user_session_guiduser_session_guidPrint_Customer_Statement_Selection
FK_Manage_AP_Payment_Processable_Transaction__User_Session__user_session_guiduser_session_guidManage_AP_Payment_Processable_Transaction
FK_Manage_Customer_Payment__User_Session__user_session_guiduser_session_guidManage_Customer_Payment
FK_Print_AR_Transaction_Selection__User_Session__user_session_guiduser_session_guidPrint_AR_Transaction_Selection
FK_Print_Payable_Transaction_Selection__User_Session__user_session_guiduser_session_guidPrint_Payable_Transaction_Selection
FK_Transmit_Online_Bill_Pay_Selection__User_Session__user_session_guiduser_session_guidTransmit_Online_Bill_Pay_Selection
FK_Print_Check_Selection__User_Session__user_session_guiduser_session_guidPrint_Check_Selection

Schema diagram