app.engagement_resolved

Vista

Engagements as every internal surface reads them (engagement contract engagement_resolved): job title, classification and payment channel joined from canon, and the rate in force read from the agreed rate, then the org's rate card line effective on the start date, then the canon rate card. The rate is Restricted and masked (NULL, is_masked true) without data.restricted.read.payroll. Rows follow the engagement read rule.

Columnas de app.engagement_resolved
Columna	Tipo	Admite nulos	Descripción
engagement_id	uuid	Sí	Engagement.
org_id	uuid	Sí	Org.
project_id	uuid	Sí	Project.
person_id	uuid	Sí	Engaged person.
counterparty_id	uuid	Sí	Engaged external organization.
role_type	app.external_role_type	Sí	External role type.
role_code	text	Sí	Canon role.
job_title	xpms.canon_text	Sí	Job title from the Roles Library.
worker_classification	xpms.canon_text	Sí	Classification label.
payment_channel	xpms.canon_text	Sí	Payroll, Accounts Payable or None.
pay_basis	text	Sí	Pay basis.
arrangement	text	Sí	Arrangement.
rate_card_id	xpms.canon_code	Sí	Canon rate card the combination identifies; NULL for unpaid engagements.
rate_minor	bigint	Sí	Rate in force in minor units; NULL when masked, unpaid or unpriced.
rate_currency_code	bpchar	Sí	Currency of the rate in force.
is_masked	boolean	Sí	True when the rate is withheld from the caller.
ot_multiplier	numeric	Sí	Overtime multiplier of the rule in force.
dt_multiplier	numeric	Sí	Double-time multiplier of the rule in force.
employment_status	text	Sí	Employment status.
flsa_status	text	Sí	FLSA status.
labor_agreement_id	uuid	Sí	Labor agreement.
start_date	date	Sí	First day.
end_date	date	Sí	Last day.
engagement_state	app.engagement_state	Sí	Engagement state.