Table: dbo.Client_Pay_Schedule_Status
Columns
NameTypeConstraintsDescription
client_pay_schedule_status_KEYint (4)NOT NULLPrimary key
precedenceint (4)NOT NULLItems order of precedence, used for comparison and merging purposes. Higher numbers have more precedence
descriptionnvarchar (50)NOT NULLDescription text displayed in the UI
web_services_descriptionnvarchar (50)NOT NULLAssociated description text received from Web Services XML files. Will be empty for items used only in the SBPR context
Primary key
NameColumnsDescription
PK_Client_Pay_Schedule_Statusclient_pay_schedule_status_KEY
Unique constraints
NameColumnsDescription
UK_Client_Pay_Schedule_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Status__client_pay_schedule_status_KEYclient_pay_schedule_status_KEYClient_Pay_Schedule_Detail
FK_Scheduled_Payroll_Tracking_Detail__Client_Pay_Schedule_Status__prior__client_pay_schedule_status_KEYprior__client_pay_schedule_status_KEYScheduled_Payroll_Tracking_Detail

Schema diagram