Table: dbo.Impound_Profile
Firm level profiles assignable to clients that enforce how early payroll processes need to be run.
Columns
NameTypeConstraintsDescription
impound_profile_KEYint (4)NOT NULLPrimary Key for this table.
is_activebit (1)NOT NULLTrue if the profile is active.
descriptionnvarchar (200)NOT NULLA description for the profile. Like 'Low Risk' or 'High Risk'
payroll_offsetint (4)NOT NULLThe offset in days to have payroll funding in before pay date.
tax_liabilities_offsetint (4)NOT NULLThe offset in days to have tax liabilities funding in before pay date.
firm_vendor_offsetint (4)NOT NULLThe offset in days to have firm vendor funding in before pay date.
payroll_agent_offsetint (4)NOT NULLThe offset in days to have payroll agent funding in before pay date.
time_in_offsetint (4)NOT NULLThe offset in days to have time in before pay date.
time_in_time_cutoffdatetime (8, 3)NOT NULLThe time that payroll needs to be submitted by on the due date
checks_out_offsetint (4)NOT NULLThe offset in days to have checks out due in before pay date. Check out Client_Pay_Schedule.checks_out_due_days.
Primary key
NameColumnsDescription
PK_Impound_Profileimpound_profile_KEY
Unique constraints
NameColumnsDescription
UK_Impound_Profile$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event_Object_N_Impound_Profile__Impound_Profile__impound_profile_KEYimpound_profile_KEYRecorded_Event_Object_N_Impound_Profile
FK_Client_Payroll_Information__Impound_Profile__impound_profile_KEYimpound_profile_KEYClient_Payroll_Information

Schema diagram