Table: dbo.Client_Pay_Schedule_Status
Columns
Name | Type | Constraints | Description
client_pay_schedule_status_KEY | int (4) | NOT NULL | Primary key
precedence | int (4) | NOT NULL | Items order of precedence, used for comparison and merging purposes. Higher numbers have more precedence
description | nvarchar (50) | NOT NULL | Description text displayed in the UI
web_services_description | nvarchar (50) | NOT NULL | Associated description text received from Web Services XML files. Will be empty for items used only in the SBPR context

Primary key
Name | Columns | Description
PK_Client_Pay_Schedule_Status | client_pay_schedule_status_KEY |
Unique constraints
Name | Columns | Description
UK_Client_Pay_Schedule_Status$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Status__client_pay_schedule_status_KEY | client_pay_schedule_status_KEY | Client_Pay_Schedule_Detail |
FK_Scheduled_Payroll_Tracking_Detail__Client_Pay_Schedule_Status__prior__client_pay_schedule_status_KEY | prior__client_pay_schedule_status_KEY | Scheduled_Payroll_Tracking_Detail |