Table: dbo.Payroll_Bank_Transaction
Bank_Transaction records that correspond to Payroll Checks have a record here to link to the Employee and record the Pay Period. Payroll_Bank_Transaction_View exists to limit the columns returned by a read which fails to specify a DropAllBut().
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLPrimary key and foreign key to the parent bank transaction
employee_KEYint (4)NOT NULLEmployee the payment is for
pay_frequency_KEYint (4)NOT NULLFrequency of the payment
period_begin_datesmalldatetime (4)Begin date of the payments
period_end_datesmalldatetime (4)NOT NULLEnd date of the payments
weeks_workedsmallint (2)NOT NULLThe number of weeks the employee worked
ste_location_codenvarchar (100)NOT NULLThe Symmetry Tax Engine residential code, used for tax calculations
do_not_create_check_from_enter_batch_checksbit (1)NOT NULLUsed only by Enter Batch Checks, this flag tells the batch process whether or not to create an unprinted check for a given transaction
employee_earning_type_KEYint (4)NOT NULLType of employee this check is for.
employee_multi_state_income_tax_calculation_method_KEYint (4)NOT NULLThe method of multi-state income tax withholding that should be used when calculating this transaction.
state_unemployment_combinedbit (1)NOT NULLFlag indicating that the client was set to combine state unemployment taxes into a single unemployment state when this check was calculated.
psd_codenvarchar (12)NOT NULLPolitical subdivison code used for Pennsylvania.
existing_bad_databit (1)NOT NULLContains 1 exactly when the distribution predates the addition of a DAL constraint which prohibits COVID-19 leave from having a nonzero amount for a paycheck who has neither a period end nor period begin date inside 2020 (or possibly 2021 later if legislation extends the leave). As of 2020-12-14, 2020 exclusively. As of the 2020.4.0 release, the plan is that once granfathered, that status never expires, therefore no triggers.
Primary key
NameColumnsDescription
PK_Payroll_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Payroll_Bank_Transaction__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Payroll_Bank_Transaction__Employee_Earning_Type__employee_earning_type_KEYemployee_earning_type_KEYEmployee_Earning_Type (employee_earning_type_KEY)
FK_Payroll_Bank_Transaction__Employee_Multi_State_Income_Tax_Calculation_Method__employee_multi_state_income_tax_calculation_metemployee_multi_state_income_tax_calculation_method_KEYEmployee_Multi_State_Income_Tax_Calculation_Method (employee_multi_state_income_tax_calculation_method_KEY)
FK_Payroll_Bank_Transaction__Pay_Frequency__pay_frequency_KEYpay_frequency_KEYPay_Frequency (pay_frequency_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Tax_Item__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Check_Tax_Item
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Check_Sales_Amount_Distribution
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction_N_Client_Pay_Schedule_Detail
FK_Payroll_Check_Payroll_Item__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Check_Payroll_Item
FK_Insurepay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYInsurepay_N_Payroll_Bank_Transaction
FK_XactPay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYXactPay_N_Payroll_Bank_Transaction
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction_Worker_Compensation_Item
FK_Benefit_Transaction__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBenefit_Transaction

Schema diagram