Table: dbo.Client_Pay_Schedule_Detail | |||
Columns | |||
Name | Type | Constraints | Description |
client_pay_schedule_KEY | int (4) | NOT NULL | Key of parent client pay schedule |
client_pay_schedule_detail_KEY | int (4) | NOT NULL | Primary key for this table. |
check_date | smalldatetime (4) | Date check is to be created. | |
period_begin_date | smalldatetime (4) | Date pay period begins | |
period_end_date | smalldatetime (4) | Date pay period ends | |
time_in_date | smalldatetime (4) | Date time in for checks is due. | |
checks_out_date | smalldatetime (4) | Date checks are to be sent out by. | |
client_pay_schedule_status_KEY | int (4) | NOT NULL | |
max_version_from_suspended_batch_payroll_session_recommend_update | binary (8) | The highest version of dependant rows that prompts for an update to a suspended pay schedule batch. | |
is_processed_as_prior | bit (1) | NOT NULL | bit to signify whether the pay schedule was ever processed in batch as a prior schedule. Defaults to false. |
Primary key | |||
Name | Columns | Description | |
PK_Client_Pay_Schedule_Detail | client_pay_schedule_detail_KEY |