Skip to content

xpms.wage_hour_rule

TableRow level security on

Wage-and-hour minimums a jurisdiction adds to its parent; the strictest value up the chain governs (decision D16).

Primary key: jurisdiction_id

Columns of xpms.wage_hour_rule
ColumnTypeNullableDescription
jurisdiction_idxpms.canon_codeNoJurisdiction stating the rule.References xpms.jurisdiction.jurisdiction_id
sourcexpms.canon_textNoLaw the rule comes from.
weekly_ot_after_hoursnumericYesWeekly hours after which overtime applies.
daily_ot_after_hoursnumericYesDaily hours after which overtime applies.
daily_dt_after_hoursnumericYesDaily hours after which double time applies.
min_ot_multipliernumericYesMinimum overtime multiplier.
min_dt_multipliernumericYesMinimum double-time multiplier.