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
Name | Type | Constraints | Description
bank_transaction_KEY | int (4) | NOT NULL | Primary key and foreign key to the parent bank transaction
employee_KEY | int (4) | NOT NULL | Employee the payment is for
pay_frequency_KEY | int (4) | NOT NULL | Frequency of the payment
period_begin_date | smalldatetime (4) |  | Begin date of the payments
period_end_date | smalldatetime (4) | NOT NULL | End date of the payments
weeks_worked | smallint (2) | NOT NULL | The number of weeks the employee worked
ste_location_code | nvarchar (100) | NOT NULL | The Symmetry Tax Engine residential code, used for tax calculations
do_not_create_check_from_enter_batch_checks | bit (1) | NOT NULL | Used 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_KEY | int (4) | NOT NULL | Type of employee this check is for.
employee_multi_state_income_tax_calculation_method_KEY | int (4) | NOT NULL | The method of multi-state income tax withholding that should be used when calculating this transaction.
state_unemployment_combined | bit (1) | NOT NULL | Flag indicating that the client was set to combine state unemployment taxes into a single unemployment state when this check was calculated.
psd_code | nvarchar (12) | NOT NULL | Political subdivison code used for Pennsylvania.
existing_bad_data | bit (1) | NOT NULL | Contains 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
Name | Columns | Description
PK_Payroll_Bank_Transaction$bank_transaction_KEY | bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Payroll_Bank_Transaction__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Payroll_Bank_Transaction__Employee_Earning_Type__employee_earning_type_KEY | employee_earning_type_KEY | Employee_Earning_Type (employee_earning_type_KEY) |
FK_Payroll_Bank_Transaction__Employee_Multi_State_Income_Tax_Calculation_Method__employee_multi_state_income_tax_calculation_met | employee_multi_state_income_tax_calculation_method_KEY | Employee_Multi_State_Income_Tax_Calculation_Method (employee_multi_state_income_tax_calculation_method_KEY) |
FK_Payroll_Bank_Transaction__Pay_Frequency__pay_frequency_KEY | pay_frequency_KEY | Pay_Frequency (pay_frequency_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Check_Tax_Item__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Check_Tax_Item |
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Check_Sales_Amount_Distribution |
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail |
FK_Payroll_Check_Payroll_Item__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Check_Payroll_Item |
FK_Insurepay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Insurepay_N_Payroll_Bank_Transaction |
FK_XactPay_N_Payroll_Bank_Transaction__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | XactPay_N_Payroll_Bank_Transaction |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item |
FK_Benefit_Transaction__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Benefit_Transaction |