Table: dbo.Client_Pay_Schedule
Columns
Name | Type | Constraints | Description
client_pay_schedule_KEY | int (4) | NOT NULL | Primary key for this table
client_KEY | int (4) | NOT NULL | Reference to client that has this pay schedule
payschedule_name | varchar (50) | NOT NULL | Name of the pay schedule
pay_frequency_KEY | int (4) | NOT NULL | Key to pay frequency used to create this schedule.
adjust_check_date_for_nonbusiness_days | bit (1) | NOT NULL | Allow adjustment to check date to account for non-business days
check_date_adjustment_method_KEY | int (4) | NOT NULL | Method of check date adjustment
generate_due_dates | bit (1) | NOT NULL | Flag indicating that time in / checks out dates are to be generated.
time_in_due_days | int (4) | NOT NULL | Number of days prior to the check date that the time in is due.
checks_out_due_days | int (4) | NOT NULL | Number of days prior to the check date that the checks are due out.
client_pay_schedule_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row
schedule_creator_configuration_xml | varchar (1024) |  | State configuration data used by scheduler during previous automatic schedule creation run.
is_schedule_inactive | bit (1) | NOT NULL | Flag indicating that this pay schedule is inactive.
time_entry_method_KEY | int (4) | NOT NULL | The time entry method to be used for the pay schedule.
exclude_from_client_self_service | bit (1) | NOT NULL | Flag which excludes the pay schedule from appearing in CSS.
is_employee_self_service_my_time_entry_enabled | bit (1) | NOT NULL | Flag which indicates if ESS My Time Entry is enabled for the pay schedule.
exclude_from_client_access | bit (1) | NOT NULL | Flag which excludes the pay schedule from appearing in Client Access.
active_status_KEY | tinyint (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_KEY | int (4) | NOT NULL | The Client Pay Schedule type. Such as On Demand, Regular, or Handwritten.
autopay__checkbook_KEY | int (4) |  | The checkbook associated with this pay schedule used for autopay.

Primary key
Name | Columns | Description
PK_Client_Pay_Schedule | client_pay_schedule_KEY |
Unique constraints
Name | Columns | Description
UK_Client_Pay_Schedule$client_pay_schedule_guid | client_pay_schedule_guid |
UK_Client_Pay_Schedule$client_KEY$payschedule_name$client_pay_schedule_type_KEY | client_KEY, payschedule_name, client_pay_schedule_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Pay_Schedule__Check_Date_Adjustment_Method__check_date_adjustment_method_KEY | check_date_adjustment_method_KEY | Check_Date_Adjustment_Method (check_date_adjustment_method_KEY) |
FK_Client_Pay_Schedule__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Pay_Schedule__Pay_Frequency__pay_frequency_KEY | pay_frequency_KEY | Pay_Frequency (pay_frequency_KEY) |
FK_Client_Pay_Schedule__Time_Entry_Method__time_entry_method_KEY | time_entry_method_KEY | Time_Entry_Method (time_entry_method_KEY) |
FK_Client_Pay_Schedule__Client_Pay_Schedule_Type__client_pay_schedule_type_KEY | client_pay_schedule_type_KEY | Client_Pay_Schedule_Type (client_pay_schedule_type_KEY) |
FK_Client_Pay_Schedule__Checkbook__autopay__checkbook_KEY | autopay__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Client_Pay_Schedule$active_status_KEY | active_status_KEY | Active_Status (active_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Pay_Schedule_Batch_Session__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule_Batch_Session |
FK_Payroll_Check_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option |
FK_Recorded_Event_Object_N_Client_Pay_Schedule__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Recorded_Event_Object_N_Client_Pay_Schedule |
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Pay_Schedule_Detail |
FK_Client_Billing_Item_Schedule__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Client_Billing_Item_Schedule |
FK_Employee__Client_Pay_Schedule__alternate__client_pay_schedule_KEY | alternate__client_pay_schedule_KEY | Employee |
FK_Employee__Client_Pay_Schedule__primary__client_pay_schedule_KEY | primary__client_pay_schedule_KEY | Employee |
FK_Netclient_Time_Entry_Option__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Netclient_Time_Entry_Option |
FK_Preloaded_Payroll_Check_Entry_Batch$client_pay_schedule_KEY | client_pay_schedule_KEY | Preloaded_Payroll_Check_Entry_Batch |
FK_Payroll_Check_Payroll_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Payroll_Item_Import |
FK_Payroll_Check_Tax_Item_Import__Client_Pay_Schedule__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Tax_Item_Import |