Table: dbo.Client_Pay_Schedule
Columns
NameTypeConstraintsDescription
client_pay_schedule_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLReference to client that has this pay schedule
payschedule_namevarchar (50)NOT NULLName of the pay schedule
pay_frequency_KEYint (4)NOT NULLKey to pay frequency used to create this schedule.
adjust_check_date_for_nonbusiness_daysbit (1)NOT NULLAllow adjustment to check date to account for non-business days
check_date_adjustment_method_KEYint (4)NOT NULLMethod of check date adjustment
generate_due_datesbit (1)NOT NULLFlag indicating that time in / checks out dates are to be generated.
time_in_due_daysint (4)NOT NULLNumber of days prior to the check date that the time in is due.
checks_out_due_daysint (4)NOT NULLNumber of days prior to the check date that the checks are due out.
client_pay_schedule_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
schedule_creator_configuration_xmlvarchar (1024)State configuration data used by scheduler during previous automatic schedule creation run.
is_schedule_inactivebit (1)NOT NULLFlag indicating that this pay schedule is inactive.
time_entry_method_KEYint (4)NOT NULLThe time entry method to be used for the pay schedule.
exclude_from_client_self_servicebit (1)NOT NULLFlag which excludes the pay schedule from appearing in CSS.
is_employee_self_service_my_time_entry_enabledbit (1)NOT NULLFlag which indicates if ESS My Time Entry is enabled for the pay schedule.
exclude_from_client_accessbit (1)NOT NULLFlag which excludes the pay schedule from appearing in Client Access.
active_status_KEYtinyint (1)This column ensures the correct status value to be shown in filter and is based on the column is_schedule_inactive.
client_pay_schedule_type_KEYint (4)NOT NULLThe Client Pay Schedule type. Such as On Demand, Regular, or Handwritten.
autopay__checkbook_KEYint (4)The checkbook associated with this pay schedule used for autopay.
Primary key
NameColumnsDescription
PK_Client_Pay_Scheduleclient_pay_schedule_KEY
Unique constraints
NameColumnsDescription
UK_Client_Pay_Schedule$client_pay_schedule_guidclient_pay_schedule_guid
UK_Client_Pay_Schedule$client_KEY$payschedule_name$client_pay_schedule_type_KEYclient_KEY, payschedule_name, client_pay_schedule_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Pay_Schedule__Check_Date_Adjustment_Method__check_date_adjustment_method_KEYcheck_date_adjustment_method_KEYCheck_Date_Adjustment_Method (check_date_adjustment_method_KEY)
FK_Client_Pay_Schedule__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Pay_Schedule__Pay_Frequency__pay_frequency_KEYpay_frequency_KEYPay_Frequency (pay_frequency_KEY)
FK_Client_Pay_Schedule__Time_Entry_Method__time_entry_method_KEYtime_entry_method_KEYTime_Entry_Method (time_entry_method_KEY)
FK_Client_Pay_Schedule__Client_Pay_Schedule_Type__client_pay_schedule_type_KEYclient_pay_schedule_type_KEYClient_Pay_Schedule_Type (client_pay_schedule_type_KEY)
FK_Client_Pay_Schedule__Checkbook__autopay__checkbook_KEYautopay__checkbook_KEYCheckbook (checkbook_KEY)
FK_Client_Pay_Schedule$active_status_KEYactive_status_KEYActive_Status (active_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Pay_Schedule_Batch_Session__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule_Batch_Session
FK_Payroll_Check_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option
FK_Recorded_Event_Object_N_Client_Pay_Schedule__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYRecorded_Event_Object_N_Client_Pay_Schedule
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Pay_Schedule_Detail
FK_Client_Billing_Item_Schedule__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYClient_Billing_Item_Schedule
FK_Employee__Client_Pay_Schedule__alternate__client_pay_schedule_KEYalternate__client_pay_schedule_KEYEmployee
FK_Employee__Client_Pay_Schedule__primary__client_pay_schedule_KEYprimary__client_pay_schedule_KEYEmployee
FK_Netclient_Time_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYNetclient_Time_Entry_Option
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_KEYclient_pay_schedule_KEYPreloaded_Payroll_Check_Entry_Batch
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Payroll_Item_Import
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Tax_Item_Import

Schema diagram