app.application_board

Vista

Applications as the Pipeline board reads them (Section 4.5.5): applicant name, shortlist rank, next interview, the offer in force and whose turn it is, and the bid total only once the bid is unsealed for the reader (Section 8.7). Rows follow opportunities.application.read on the project.

Columnas de app.application_board
Columna	Tipo	Admite nulos	Descripción
application_id	uuid	Sí	Application.
org_id	uuid	Sí	Org.
opportunity_id	uuid	Sí	Opportunity.
opportunity_title	text	Sí	Opportunity title.
project_id	uuid	Sí	Project.
project_key	text	Sí	Project key.
role_type	app.external_role_type	Sí	External role type sought.
applicant_kind	text	Sí	Person or Account.
applicant_name	text	Sí	Applicant name.
applicant_person_id	uuid	Sí	Applying person.
applicant_organization_id	uuid	Sí	Applying account.
application_state	app.application_state	Sí	Application state.
submitted_at	timestamp with time zone	Sí	When submitted.
availability_confirmed	boolean	Sí	True when availability was confirmed.
cover_note	text	Sí	Note from the applicant.
proposed_fee_minor	bigint	Sí	Fee the applicant proposed in minor units.
currency_code	character(3)	Sí	Currency of the proposed fee.
shortlist_rank	integer	Sí	Shortlist rank; NULL when not shortlisted.
next_interview_at	timestamp with time zone	Sí	Next scheduled interview or audition.
offer_id	uuid	Sí	Live offer.
offer_state	app.offer_state	Sí	Offer state.
offer_turn_side	app.offer_side	Sí	Side that proposed the terms in force; the other side answers.
offer_rate_type	app.rate_type	Sí	Rate type of the terms in force.
offer_amount_minor	bigint	Sí	Amount of the terms in force in minor units.
offer_currency_code	character(3)	Sí	Currency of the terms in force.
offer_expires_at	timestamp with time zone	Sí	When the terms in force lapse.
has_bid	boolean	Sí	True when the applicant submitted a bid.
bid_sealed	boolean	Sí	True while the bid stays sealed for the reader.
bid_total_minor	bigint	Sí	Bid total in minor units once unsealed; NULL while sealed or with an unpriced line.
engagement_id	uuid	Sí	Engagement created from the application.
bid_currency_code	character(3)	Sí	Currency of the bid.