Table: dbo.Client_Pay_Schedule_Detail
Columns
NameTypeConstraintsDescription
client_pay_schedule_KEYint (4)NOT NULLKey of parent client pay schedule
client_pay_schedule_detail_KEYint (4)NOT NULLPrimary key for this table.
check_datesmalldatetime (4)Date check is to be created.
period_begin_datesmalldatetime (4)Date pay period begins
period_end_datesmalldatetime (4)Date pay period ends
time_in_datesmalldatetime (4)Date time in for checks is due.
checks_out_datesmalldatetime (4)Date checks are to be sent out by.
client_pay_schedule_status_KEYint (4)NOT NULL
max_version_from_suspended_batch_payroll_session_recommend_updatebinary (8)The highest version of dependant rows that prompts for an update to a suspended pay schedule batch.
is_processed_as_priorbit (1)NOT NULLbit to signify whether the pay schedule was ever processed in batch as a prior schedule. Defaults to false.
Primary key
NameColumnsDescription
PK_Client_Pay_Schedule_Detailclient_pay_schedule_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule (client_pay_schedule_KEY)
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Status__client_pay_schedule_status_KEYclient_pay_schedule_status_KEYClient_Pay_Schedule_Status (client_pay_schedule_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYPreloaded_Payroll_Check_Entry_Batch
FK_Autopay_Session__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYAutopay_Session
FK_Scheduled_Payroll_Tracking_Detail__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYScheduled_Payroll_Tracking_Detail
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYPayroll_Bank_Transaction_N_Client_Pay_Schedule_Detail
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYPayroll_Check_Payroll_Item_Import
FK_Payroll_Check_Sales_Amount_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYPayroll_Check_Sales_Amount_Import
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYPayroll_Check_Tax_Item_Import

Schema diagram