hire_candidate

PostgREST stored procedure — POST /rest/v1/rpc/hire_candidate.

These are SECURITY DEFINER functions granted only to the service role (execute is revoked from anon/authenticated). They bypass table RLS and enforce their own company_id and status checks internally, so call them server-side with the service-role key:

const { data, error } = await supabase.rpc('hire_candidate', { p_actor, p_application_id, p_bimonthly_rate_centavos, p_facility_id, p_invitation_expires_at, p_invitation_token_hash, p_login_email, p_position_config_id, p_start_date, p_weekly_hours });

Arguments

Argument	Type	Required
p_actor	uuid	yes
p_application_id	uuid	yes
p_bimonthly_rate_centavos	bigint	no
p_facility_id	uuid	no
p_invitation_expires_at	timestamp with time zone	yes
p_invitation_token_hash	text	yes
p_login_email	text	yes
p_position_config_id	uuid	no
p_start_date	date	yes
p_weekly_hours	numeric	no

Generated from specs/supabase.json. The function's behaviour is defined by its SQL migration; this page documents its call signature only.