Table: Accruable_Benefit_Allowance_By_Staff_Level
Columns
NameTypeConstraintsDescription
accruable_benefit_allowance_by_staff_level_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.
staff_level_KEYintNOT NULLKey to a staff level.
allowancedecimal (9, 2)NOT NULLThe allowance amount.
Primary key
NameColumnsDescription
PK_Accruable_Benefit_Allowance_By_Staff_Level$accruable_benefit_allowance_by_staff_level_KEYaccruable_benefit_allowance_by_staff_level_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Accruable_Benefit_Allowance_By_Staff_Level$benefit_KEY$staff_level_KEYbenefit_KEY, staff_level_KEY
Indexes
NameColumnsDescription
IX_Accruable_Benefit_Allowance_By_Staff_Level$staff_level_KEYstaff_level_KEYIndex supports foreign key FK_Accruable_Benefit_Allowance_By_Staff_Level__Staff_Level__staff_level_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Accruable_Benefit_Allowance_By_Staff_Level__Benefit__benefit_KEYbenefit_KEYBenefiton delete cascade;
FK_Accruable_Benefit_Allowance_By_Staff_Level__Staff_Level__staff_level_KEYstaff_level_KEYStaff_Level

Schema diagram