Table: dbo.Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution
Table to hold One Big Beautiful Bill Act Overtime amount distributions for payroll checks.
Columns
Name | Type | Constraints | Description
payroll_check_one_big_beautiful_bill_act_overtime_amount_distribution_KEY | int (4) | NOT NULL | Primary key
bank_transaction_KEY | int (4) | NOT NULL | Key to associated bank transaction.
work_location_KEY | int (4) | NOT NULL | Key to associated work location.
payroll_department_KEY | int (4) |  | Key to associated payroll department.
one_big_beautiful_bill_act_overtime_amount_original | decimal (9, 2) | NOT NULL | One Big Beautiful Bill Act Overtime amount based on calculation rules.
one_big_beautiful_bill_act_overtime_amount_override | decimal (9, 2) |  | Overridden One Big Beautiful Bill Act Overtime amount.
one_big_beautiful_bill_act_overtime_amount | decimal (9, 2) | NOT NULL | Display One Big Beautiful Bill Act Overtime amount that is based on an existing override to this field. Will display the initially calculated amount if no override is present.

Primary key
Name | Columns | Description
PK_Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution | payroll_check_one_big_beautiful_bill_act_overtime_amount_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution$work_location_KEY$payroll_department_KEY$bank_transacti | work_location_KEY, payroll_department_KEY, bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) | FOREIGN KEY constraint of bank_transaction_KEY for the Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution table
FK_Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution__Work_Location__work_location_KEY | work_location_KEY | Work_Location (work_location_KEY) | FOREIGN KEY constraint of work_location_KEY for the Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution table
FK_Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Department (payroll_department_KEY) | FOREIGN KEY constraint of payroll_department_KEY for the Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution table