Table: dbo.Complete_Payroll_Output_Session_Client_Detail
This table stores the client detail associated with a complete payroll output session.
Columns
Name | Type | Constraints | Description
complete_payroll_output_session_client_detail_KEY | int (4) | NOT NULL | Primary key for this table.
complete_payroll_output_session_KEY | int (4) | NOT NULL | Foreign key to the parent table Complete_Payroll_Output_Session.
client_KEY | int (4) | NOT NULL | A client we are processing inside this complete payroll output session.
pay_date | smalldatetime (4) | NOT NULL | Pay date of the check being processed for the client inside this complete payroll output session.

Primary key
Name | Columns | Description
PK_Complete_Payroll_Output_Session_Client_Detail | complete_payroll_output_session_client_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Complete_Payroll_Output_Session_Client_Detail$complete_payroll_output_session_KEY$client_KEY$pay_date | complete_payroll_output_session_KEY, client_KEY, pay_date |

Foreign keys
Name | Columns | Referenced table | Description
FK_Complete_Payroll_Output_Session_Client_Detail__Client__client_KEY | client_KEY | Client (client_KEY) |
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 (complete_payroll_output_session_KEY) |