app.opportunities
TablaSeguridad a nivel de fila activa
Opportunities published to external parties (Section 4.4.3): staffing calls, RFQs and RFPs, talent bookings, contractor scopes and sponsorship packages. The number of positions is the count of its positions. No posted compensation shows Rate on Request, never zero.
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.projects on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id |
| project_id | uuid | No | Project the work is for.Hace referencia a app.projects.id |
| scope_node_id | uuid | Sí | Scope node of the project the work is for.Hace referencia a app.scope_nodes.id |
| role_type | app.external_role_type | No | External role type sought. |
| role_code | text | Sí | Canon role code sought, when the opportunity is for a role.Hace referencia a xpms.role.role_code |
| cat_urid | text | Sí | Canon URID category sought, when the opportunity is for goods or services.Hace referencia a xpms.dim_category.cat_urid |
| title | text | No | Title, Title Case. |
| description | text | Sí | Description of the work. |
| venue_id | uuid | Sí | Venue of the work.Hace referencia a app.venues.id |
| jurisdiction_id | text | Sí | Jurisdiction of the work when it differs from the venue's and the project's; pay transparency reads the first known of the three.Hace referencia a xpms.jurisdiction.jurisdiction_id |
| starts_on | date | Sí | First day of the work. |
| ends_on | date | Sí | Last day of the work. |
| visibility | app.opportunity_visibility | No | Invited, Pool, Network or Public. |
| rate_type | app.rate_type | Sí | Hourly, Day, Flat, Milestone or Bid; NULL is Rate on Request. |
| pay_min_minor | bigint | Sí | Lower end of the posted pay range in minor units; NULL when not posted. |
| pay_max_minor | bigint | Sí | Upper end of the posted pay range in minor units; NULL when not posted. |
| currency_code | character(3) | Sí | ISO 4217 currency of the posted pay.Hace referencia a private.currencies.currency_code |
| deadline_at | timestamp with time zone | Sí | Deadline for applications and bids. Bids stay sealed until it passes. |
| minimum_age | smallint | Sí | Minimum age for the work, 16 or older (Section 14.9). |
| opportunity_state | app.opportunity_state | No | Opportunity state. Changes only through app.transition_opportunity. |
| 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 |
| requisition_id | uuid | Sí | Approved requisition the opportunity is published from (Section 4.4.3, spend authority before publishing). Required to publish Contractor, Crew and Staff opportunities; fixed once published.Hace referencia a app.requisitions.id |
| is_remote | boolean | No | True when the work can be done remotely; remote postings follow the pay transparency rules that cover remote roles. |