| 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 | ||