app.osha_annual_summaries
TableRow level security on
The Form 300A of an establishment and year: employment information and the company executive's certification. The case totals come from app.osha_summary.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.osha_establishments on insert; never accepted from the caller and never changed.References app.organizations.id |
| establishment_id | uuid | No | Establishment summarized.References app.osha_establishments.id |
| log_year | smallint | No | Year summarized. |
| annual_average_employees | integer | Yes | Annual average number of employees (Form 300A). |
| total_hours_worked | bigint | Yes | Total hours worked by all employees last year (Form 300A). |
| certified_by | uuid | Yes | Company executive who certified the summary (Form 300A "Sign here").References app.people.id |
| certifier_title | text | Yes | Title of the company executive (Form 300A). |
| certifier_phone | text | Yes | Phone (Form 300A). |
| certified_on | date | Yes | Date of the certification (Form 300A). |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |