Table: dbo.Impound_Profile
Firm level profiles assignable to clients that enforce how early payroll processes need to be run.
Columns
Name | Type | Constraints | Description
impound_profile_KEY | int (4) | NOT NULL | Primary Key for this table.
is_active | bit (1) | NOT NULL | True if the profile is active.
description | nvarchar (200) | NOT NULL | A description for the profile. Like 'Low Risk' or 'High Risk'
payroll_offset | int (4) | NOT NULL | The offset in days to have payroll funding in before pay date.
tax_liabilities_offset | int (4) | NOT NULL | The offset in days to have tax liabilities funding in before pay date.
firm_vendor_offset | int (4) | NOT NULL | The offset in days to have firm vendor funding in before pay date.
payroll_agent_offset | int (4) | NOT NULL | The offset in days to have payroll agent funding in before pay date.
time_in_offset | int (4) | NOT NULL | The offset in days to have time in before pay date.
time_in_time_cutoff | datetime (8, 3) | NOT NULL | The time that payroll needs to be submitted by on the due date
checks_out_offset | int (4) | NOT NULL | The offset in days to have checks out due in before pay date. Check out Client_Pay_Schedule.checks_out_due_days.

Primary key
Name | Columns | Description
PK_Impound_Profile | impound_profile_KEY |
Unique constraints
Name | Columns | Description
UK_Impound_Profile$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Recorded_Event_Object_N_Impound_Profile__Impound_Profile__impound_profile_KEY | impound_profile_KEY | Recorded_Event_Object_N_Impound_Profile |
FK_Client_Payroll_Information__Impound_Profile__impound_profile_KEY | impound_profile_KEY | Client_Payroll_Information |