xpms.v_sheet_labor_rate_cards

Vista

The Playbook Labor Rate Cards sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columnas de xpms.v_sheet_labor_rate_cards
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
rate_card_id	text	Sí	RATE CARD ID (column A), field.
role_code	text	Sí	ROLE CODE (column B), field.
job_title	text	Sí	JOB TITLE (column C), field.
engagement_type	text	Sí	ENGAGEMENT TYPE (column D), field.
pay_basis	text	Sí	PAY BASIS (column E), field.
standard_rate	text	Sí	STANDARD RATE (column F), field.
min_grade_rate	text	Sí	MIN GRADE RATE (column G), field.
max_grade_rate	text	Sí	MAX GRADE RATE (column H), field.
ot_multiplier	text	Sí	OT MULTIPLIER (column I), field.
dt_multiplier	text	Sí	DT MULTIPLIER (column J), field.
per_diem_rate	text	Sí	PER DIEM RATE (column K), field.
default_gl_account	text	Sí	DEFAULT GL ACCOUNT (column L), field.
default_gl_name	text	Sí	DEFAULT GL NAME (column M), field.
status	text	Sí	STATUS (column N), field.
flag	text	Sí	FLAG (column O), field.
notes	text	Sí	NOTES (column P), field.
created_by	text	Sí	CREATED BY (column Q), field.
created_at	text	Sí	CREATED AT (column R), field.
updated_at	text	Sí	UPDATED AT (column S), field.