flsa_details

Placeholder table for additional FLSA-violation detail. Currently empty in the snapshot — the upstream WHD export doesn't always populate this. The schema is included for forward-compatibility with future WHD releases.
back_wages
Back wages owed under this detail row, in dollars.
type
Sub-classification of the FLSA violation.
violation_id
Foreign key to violations.id.

✎ View and edit SQL

This data as json

Link rowid ▼ violation_id type back_wages

0 records

CREATE TABLE "flsa_details" (
   [violation_id] INTEGER REFERENCES [violations]([id]),
   [type] TEXT,
   [back_wages] FLOAT
);