Table: Accruable_Benefit_Allowance_By_Month
Accruable benefit allowances based on months employed.
Columns
NameTypeConstraintsDescription
accruable_benefit_allowance_by_month_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
benefit_KEYintNOT NULLKey to a benefit.
to_monthintNOT NULLThe month to which this allowance applies.
allowancedecimal (9, 2)NOT NULLThe allowance amount.
Primary key
NameColumnsDescription
PK_Accruable_Benefit_Allowance_By_Month$accruable_benefit_allowance_by_month_KEYaccruable_benefit_allowance_by_month_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Accruable_Benefit_Allowance_By_Month$benefit_KEY$to_monthbenefit_KEY, to_month
Foreign keys
NameColumnsReferenced tableDescription
FK_Accruable_Benefit_Allowance_By_Month__Benefit__benefit_KEYbenefit_KEYBenefiton delete cascade;

Schema diagram