Table: dbo.Complete_Payroll_Output_Session
Complete Payroll Output sessions that are currently in progress.
Columns
Name | Type | Constraints | Description
complete_payroll_output_session_KEY | int (4) | NOT NULL | The primary key.
session_date | datetime (8, 3) | NOT NULL | Date and time the session was started.
staff_KEY | int (4) | NOT NULL | Staff key associated with the staff running the complete payroll output session.
number_of_clients | int (4) | NOT NULL | Number of clietns being processed with this complete payroll output session.
complete_payroll_output_session_status_KEY | int (4) | NOT NULL |
finish_date | datetime (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_guid | uniqueidentifier (16) | NOT NULL | The 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_guid | uniqueidentifier (16) | NOT NULL | Unique identifier for this table that will assist with backup and restore efforts.

Primary key
Name | Columns | Description
PK_Complete_Payroll_Output_Session | complete_payroll_output_session_KEY |
Unique constraints
Name | Columns | Description
UK_Complete_Payroll_Output_Session$complete_payroll_output_session_guid | complete_payroll_output_session_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Complete_Payroll_Output_Session__Complete_Payroll_Output_Session_Status__complete_payroll_output_session_status_KEY | complete_payroll_output_session_status_KEY | Complete_Payroll_Output_Session_Status (complete_payroll_output_session_status_KEY) |
FK_Complete_Payroll_Output_Session__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Complete_Payroll_Output_Session_Client_Detail__Complete_Payroll_Output_Session__complete_payroll_output_session_KEY | complete_payroll_output_session_KEY | Complete_Payroll_Output_Session_Client_Detail |