All column typesBack to all column types
Column type
PremiumCurrency
A Currency column stores money with correct formatting and precision. Use it for every monetary value — pay rates, bill rates, reimbursement amounts — so formulas, rollups, and exports treat money as money.
In one line
Money amounts with proper formatting: pay rates, bill rates, and reimbursements.
Where you see this
In the column type picker when adding a column to any table. Types are grouped as Standard, Premium, and Advanced.
Use it for
Where this type fits
Pay and bill rates on roles, placements, and shifts.
Reimbursement and adjustment amounts.
Invoice line values rolled up per client or period.
Examples
Real columns built with this type
Bill rate
PlacementsPlacement-specific rate that overrides the role default.
Amount
CustomThe requested value on a reimbursement.
Good to know
Use Currency instead of Number for anything monetary — formatting mistakes in payroll erode trust fast.
Placement-level rates typically override role defaults; keep the precedence documented in the schema.