app.pay_rates_masked
View
Pay rate ledger with the Restricted rate masked unless the caller holds data.restricted.read.payroll or the rate is their own.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Pay rate entry. |
| org_id | uuid | Yes | Org. |
| membership_id | uuid | Yes | Membership paid. |
| role_code | text | Yes | Canon role. |
| currency_code | character(3) | Yes | Currency. |
| effective_from | date | Yes | First day the rate applies. |
| rate_minor | bigint | Yes | Rate in minor units, or NULL when masked. |
| is_masked | boolean | Yes | True when the rate is withheld from the caller. |