This table allows the processor(staff) to know which payrolls need to be processed and find the status of a particular client. It also includes the information needed for management reporting. |
client_pay_schedule_detail_KEY | int (4) | NOT NULL | Primary key and a foreign key to Client Pay Schedule Detail table which signifies that the records in this table will be specific to Client Pay Schedule Detail. |
primary_processor__staff_KEY | int (4) | | Null -- Signifies that the Primary staff who processes this client are not getting tracked. Foreign key to staff table |
backup_processor__staff_KEY | int (4) | | Null -- Signifies that the Backup staff who might processes this client are not getting tracked. Foreign key to staff table |
notes | nvarchar (480) | | Null -- Signifies that we do not want to pass any information for the payroll we are processing. |
is_do_not_pay | bit (1) | NOT NULL | If the payroll is coming under some category of Do Not Pay reasons. This column is independent of do_not_pay_reason_KEY column as far as DAL is concerned but a relation ship can be seen in the UI layer. |
do_not_pay_reason_KEY | int (4) | | Null -- No Reason given for Do Not Pay. Foreign key relationship with Do_Not_Pay_Reason table. |
scheduled_payroll_change_initiator_KEY | int (4) | | Null -- No one has initiated any changes to payroll tracking. Foreign key relationship with Scheduled_Payroll_Change_Initiator table. |
date_completed | datetime (8, 3) | | DateTime value at which payroll is marked as DNP. |
prior__client_pay_schedule_status_KEY | int (4) | NOT NULL | Record the prior status of payroll before marking it as DNP. |