Table: dbo.Complete_Payroll_Output_Session
Complete Payroll Output sessions that are currently in progress.
Columns
NameTypeConstraintsDescription
complete_payroll_output_session_KEYint (4)NOT NULLThe primary key.
session_datedatetime (8, 3)NOT NULLDate and time the session was started.
staff_KEYint (4)NOT NULLStaff key associated with the staff running the complete payroll output session.
number_of_clientsint (4)NOT NULLNumber of clietns being processed with this complete payroll output session.
complete_payroll_output_session_status_KEYint (4)NOT NULL
finish_datedatetime (8, 3)Date and time the complete payroll output session completed or failed. If this date is null, then the session is still in progress.
user_session_guiduniqueidentifier (16)NOT NULLThe user session for the person running the complete payroll output session. ["BR"] This will be used to determine if clean up of aborted sessions is needed in this table. Clean up ["BR"] means changing a status to failure for an aborted session.
complete_payroll_output_session_guiduniqueidentifier (16)NOT NULLUnique identifier for this table that will assist with backup and restore efforts.
Primary key
NameColumnsDescription
PK_Complete_Payroll_Output_Sessioncomplete_payroll_output_session_KEY
Unique constraints
NameColumnsDescription
UK_Complete_Payroll_Output_Session$complete_payroll_output_session_guidcomplete_payroll_output_session_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Complete_Payroll_Output_Session__Complete_Payroll_Output_Session_Status__complete_payroll_output_session_status_KEYcomplete_payroll_output_session_status_KEYComplete_Payroll_Output_Session_Status (complete_payroll_output_session_status_KEY)
FK_Complete_Payroll_Output_Session__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Complete_Payroll_Output_Session_Client_Detail__Complete_Payroll_Output_Session__complete_payroll_output_session_KEYcomplete_payroll_output_session_KEYComplete_Payroll_Output_Session_Client_Detail

Schema diagram