Table: dbo.User_Session
Columns
Name | Type | Constraints | Description
user_session_guid | uniqueidentifier (16) | NOT NULL | A database generated unique key for this table.
staff_KEY | int (4) | NOT NULL | Key to the Staff that this session is for.
login_date | datetime (8, 3) | NOT NULL | The date and time the session was opened.
logout_date | datetime (8, 3) | NOT NULL | The date and time that the user logged out, or that the session was deemed expired or killed.
user_session_pattern_guid | uniqueidentifier (16) | NOT NULL | Key to the User_Session_Pattern table.
expiration_date | datetime (8, 3) | NOT NULL | The date and time that this session will expire.
last_access_date | datetime (8, 3) | NOT NULL | Date and time this session was last active.
user_session_status_KEY | int (4) | NOT NULL | The status of this session (1=Open, 2=Closed, 3=Expired, 4=Killed)

Primary key
Name | Columns | Description
PK_User_Session$user_session_guid | user_session_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_User_Session__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |
FK_User_Session__User_Session_Pattern__user_session_pattern_guid | user_session_pattern_guid | User_Session_Pattern (user_session_pattern_guid) |
FK_User_Session__User_Session_Status__user_session_status_KEY | user_session_status_KEY | User_Session_Status (user_session_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Onvio_Client_List__User_Session__user_session_guid | user_session_guid | Onvio_Client_List |
FK_Print_1099__User_Session__user_session_guid | user_session_guid | Print_1099 |
FK_W2_Rendering_Client_Lock__User_Session__user_session_guid | user_session_guid | W2_Rendering_Client_Lock |
FK_Print_W2__User_Session__user_session_guid | user_session_guid | Print_W2 |
FK_Notification_Queue_Record_Lock__User_Session__user_session_guid | user_session_guid | Notification_Queue_Record_Lock |
FK_Direct_Deposit_Fundable_Transaction__User_Session__user_session_guid | user_session_guid | Direct_Deposit_Fundable_Transaction |
FK_Direct_Deposit_Processable_Transaction__User_Session__user_session_guid | user_session_guid | Direct_Deposit_Processable_Transaction |
FK_Undo_Manager_Entry__User_Session__user_session_guid | user_session_guid | Undo_Manager_Entry | Foreign key for the user session guid.
FK_Print_1095__User_Session__user_session_guid | user_session_guid | Print_1095 |
FK_User_Session_Override__User_Session__user_session_guid | user_session_guid | User_Session_Override |
FK_Onvio_Payroll_Integration_Queue__User_Session__user_session_guid | user_session_guid | Onvio_Payroll_Integration_Queue |
FK_Tax_Form_Liability_Processing_Lock__User_Session__user_session_guid | user_session_guid | Tax_Form_Liability_Processing_Lock |
FK_Print_Receivable_Transaction_Detail_Selection__User_Session__user_session_guid | user_session_guid | Print_Receivable_Transaction_Detail_Selection |
FK_Client_Pay_Schedule_Batch_Session__User_Session__user_session_guid | user_session_guid | Client_Pay_Schedule_Batch_Session |
FK_Print_Customer_Statement_Selection__User_Session__user_session_guid | user_session_guid | Print_Customer_Statement_Selection |
FK_Manage_AP_Payment_Processable_Transaction__User_Session__user_session_guid | user_session_guid | Manage_AP_Payment_Processable_Transaction |
FK_Manage_Customer_Payment__User_Session__user_session_guid | user_session_guid | Manage_Customer_Payment |
FK_Print_AR_Transaction_Selection__User_Session__user_session_guid | user_session_guid | Print_AR_Transaction_Selection |
FK_Print_Payable_Transaction_Selection__User_Session__user_session_guid | user_session_guid | Print_Payable_Transaction_Selection |
FK_Transmit_Online_Bill_Pay_Selection__User_Session__user_session_guid | user_session_guid | Transmit_Online_Bill_Pay_Selection |
FK_Print_Check_Selection__User_Session__user_session_guid | user_session_guid | Print_Check_Selection |