Table: dbo.Complete_Payroll_Output_Session_Client_Detail
This table stores the client detail associated with a complete payroll output session.
Columns
NameTypeConstraintsDescription
complete_payroll_output_session_client_detail_KEYint (4)NOT NULLPrimary key for this table.
complete_payroll_output_session_KEYint (4)NOT NULLForeign key to the parent table Complete_Payroll_Output_Session.
client_KEYint (4)NOT NULLA client we are processing inside this complete payroll output session.
pay_datesmalldatetime (4)NOT NULLPay date of the check being processed for the client inside this complete payroll output session.
Primary key
NameColumnsDescription
PK_Complete_Payroll_Output_Session_Client_Detailcomplete_payroll_output_session_client_detail_KEY
Unique constraints
NameColumnsDescription
UK_Complete_Payroll_Output_Session_Client_Detail$complete_payroll_output_session_KEY$client_KEY$pay_datecomplete_payroll_output_session_KEY, client_KEY, pay_date
Foreign keys
NameColumnsReferenced tableDescription
FK_Complete_Payroll_Output_Session_Client_Detail__Client__client_KEYclient_KEYClient (client_KEY)
FK_Complete_Payroll_Output_Session_Client_Detail__Complete_Payroll_Output_Session__complete_payroll_output_session_KEYcomplete_payroll_output_session_KEYComplete_Payroll_Output_Session (complete_payroll_output_session_KEY)

Schema diagram