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 |