api_external.opportunities
View
Opportunities open to the caller in the marketplace (Section 4.4.3 visibility), and those they have applied to. Opportunities without posted compensation show Rate on Request, never zero.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Opportunity. |
| org_id | uuid | Yes | Org. |
| org_name | text | Yes | Org name. |
| title | text | Yes | Title. |
| description | text | Yes | Description. |
| role_type | app.external_role_type | Yes | External role type. |
| role_code | text | Yes | Canon role. |
| cat_urid | text | Yes | Canon category. |
| venue_name | text | Yes | Venue. |
| jurisdiction_id | text | Yes | Jurisdiction of the work. |
| starts_on | date | Yes | First day. |
| ends_on | date | Yes | Last day. |
| visibility | app.opportunity_visibility | Yes | Visibility. |
| rate_type | app.rate_type | Yes | Rate type. |
| pay_min_minor | bigint | Yes | Lower end of posted pay. |
| pay_max_minor | bigint | Yes | Upper end of posted pay. |
| currency_code | character(3) | Yes | Currency. |
| rate_on_request | boolean | Yes | True when no compensation is posted. |
| deadline_at | timestamp with time zone | Yes | Deadline. |
| minimum_age | smallint | Yes | Minimum age. |
| opportunity_state | app.opportunity_state | Yes | State. |
| position_count | bigint | Yes | Positions. |
| venue_locality | text | Yes | City or locality of the venue. |
| org_verified | boolean | Yes | True while the posting org holds a current business identity verification (Section 4.8.3): the verified badge. |
| venue_latitude | double precision | Yes | Latitude of the venue in WGS 84 degrees; NULL when the venue is not located, and then distance search leaves the listing out. |
| venue_longitude | double precision | Yes | Longitude of the venue in WGS 84 degrees; NULL when the venue is not located. |