app.osha_annual_summaries
TablaSeguridad a nivel de fila activa
The Form 300A of an establishment and year: employment information and the company executive's certification. The case totals come from app.osha_summary.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| 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.Hace referencia a app.organizations.id |
| establishment_id | uuid | No | Establishment summarized.Hace referencia a app.osha_establishments.id |
| log_year | smallint | No | Year summarized. |
| annual_average_employees | integer | Sí | Annual average number of employees (Form 300A). |
| total_hours_worked | bigint | Sí | Total hours worked by all employees last year (Form 300A). |
| certified_by | uuid | Sí | Company executive who certified the summary (Form 300A "Sign here").Hace referencia a app.people.id |
| certifier_title | text | Sí | Title of the company executive (Form 300A). |
| certifier_phone | text | Sí | Phone (Form 300A). |
| certified_on | date | Sí | Date of the certification (Form 300A). |
| deleted_at | timestamp with time zone | Sí | 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 | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |