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(). |
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. |