app.payroll_line_amounts
View
Payroll lines with derived amounts; rate and amount are masked unless the caller holds data.restricted.read.payroll.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Payroll line. |
| org_id | uuid | Yes | Org. |
| payroll_run_id | uuid | Yes | Run. |
| membership_id | uuid | Yes | Membership paid. |
| earning_code_id | uuid | Yes | Earning code. |
| hours | numeric | Yes | Hours paid. |
| rate_minor | bigint | Yes | Rate, or NULL when masked. |
| amount_minor | bigint | Yes | Hours times rate in minor units, or NULL when masked. |
| is_masked | boolean | Yes | True when rate and amount are withheld. |
| role_code | text | Yes | Canon role worked. |
| cost_center_id | uuid | Yes | Cost center the labor posts to. |