xpms.rate_card_resolved

Vista

Labor rate cards with the role title, department, classification label, overtime multipliers and the derived expense account of the role's class.

Columnas de xpms.rate_card_resolved
Columna	Tipo	Admite nulos	Descripción
rate_card_id	xpms.canon_code	Sí	Rate card.
role_code	xpms.canon_code	Sí	Role priced.
job_title	xpms.canon_text	Sí	Job title from the Roles Library.
class_code	xpms.canon_code	Sí	Department class derived from the role code.
department	xpms.canon_text	Sí	Department label.
worker_classification	xpms.canon_text	Sí	Classification label.
pay_basis	xpms.canon_text	Sí	Pay basis.
arrangement	xpms.canon_text	Sí	Arrangement.
standard_rate_minor	bigint	Sí	Standard rate in minor units.
min_grade_rate_minor	bigint	Sí	Lowest grade rate in minor units.
max_grade_rate_minor	bigint	Sí	Highest grade rate in minor units.
per_diem_rate_minor	bigint	Sí	Per diem in minor units.
currency_code	xpms.currency_code	Sí	Currency of the amounts.
overtime_rule_id	xpms.canon_code	Sí	Overtime rule.
ot_multiplier	numeric	Sí	Overtime multiplier.
dt_multiplier	numeric	Sí	Double-time multiplier.
gl_account	xpms.canon_code	Sí	Expense account of the role's class.
gl_account_name	xpms.canon_text	Sí	Name of that account.