| 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 |