Table: dbo.Direct_Deposit_Bank_Transaction_Allocation_Distribution
This table stores off location/department portions of the values in the Direct_Deposit_Bank_Transaction_Allocation table. These values are distributed based on the payroll item portion per location/department of the net check amount.
Columns
NameTypeConstraintsDescription
direct_deposit_bank_transaction_allocation_distribution_KEYint (4)NOT NULLPrimary key.
direct_deposit_bank_transaction_allocation_KEYint (4)NOT NULLForeign key to associated direct deposit bank transaction allocation. The direct deposit bank transaction allocation distributions must sum the the associated allocation and are broken down for location / department.
work_location_KEYint (4)NOT NULLForeign key to associated work location. These direct deposit bank transaction allocation distriubtions are all assigned to a location / department.
payroll_department_KEYint (4)Foreign key to associated payroll department. Can be null. These direct deposit bank transaction allocation distriubtions are all assigned to a location / department.
amountdecimal (9, 2)NOT NULLThe distribution amount. This amount is the location/department portion of the value in the Direct_Deposit_Bank_Transaction_Allocation table. These values are distributed based on the payroll item portion per location/department of the net check amount.
Primary key
NameColumnsDescription
PK_Direct_Deposit_Bank_Transaction_Allocation_Distributiondirect_deposit_bank_transaction_allocation_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Direct_Deposit_Bank_Transaction_Allocation__direct_deposit_bank_trandirect_deposit_bank_transaction_allocation_KEYDirect_Deposit_Bank_Transaction_Allocation (direct_deposit_bank_transaction_allocation_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)

Schema diagram