xpms.v_sheet_labor_rate_cards

View

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

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