Complete Payroll Output sessions that are currently in progress. |
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. |