Table: dbo.Client_Pay_Schedule_Detail
Columns
Name | Type | Constraints | Description
client_pay_schedule_KEY | int (4) | NOT NULL | Key of parent client pay schedule
client_pay_schedule_detail_KEY | int (4) | NOT NULL | Primary key for this table.
check_date | smalldatetime (4) |  | Date check is to be created.
period_begin_date | smalldatetime (4) |  | Date pay period begins
period_end_date | smalldatetime (4) |  | Date pay period ends
time_in_date | smalldatetime (4) |  | Date time in for checks is due.
checks_out_date | smalldatetime (4) |  | Date checks are to be sent out by.
client_pay_schedule_status_KEY | int (4) | NOT NULL |
max_version_from_suspended_batch_payroll_session_recommend_update | binary (8) |  | The highest version of dependant rows that prompts for an update to a suspended pay schedule batch.
is_processed_as_prior | bit (1) | NOT NULL | bit to signify whether the pay schedule was ever processed in batch as a prior schedule. Defaults to false.

Primary key
Name | Columns | Description
PK_Client_Pay_Schedule_Detail | client_pay_schedule_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule (client_pay_schedule_KEY) |
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Status__client_pay_schedule_status_KEY | client_pay_schedule_status_KEY | Client_Pay_Schedule_Status (client_pay_schedule_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Preloaded_Payroll_Check_Entry_Batch |
FK_Autopay_Session__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Autopay_Session |
FK_Scheduled_Payroll_Tracking_Detail__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Scheduled_Payroll_Tracking_Detail |
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Payroll_Check_Payroll_Item_Import |
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail |
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Payroll_Check_Tax_Item_Import |
FK_Payroll_Check_Sales_Amount_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Payroll_Check_Sales_Amount_Import |