xpms.rate_card_resolved
View
Labor rate cards with the role title, department, classification label, overtime multipliers and the derived expense account of the role's class.
| Column | Type | Nullable | Description |
|---|---|---|---|
| rate_card_id | xpms.canon_code | Yes | Rate card. |
| role_code | xpms.canon_code | Yes | Role priced. |
| job_title | xpms.canon_text | Yes | Job title from the Roles Library. |
| class_code | xpms.canon_code | Yes | Department class derived from the role code. |
| department | xpms.canon_text | Yes | Department label. |
| worker_classification | xpms.canon_text | Yes | Classification label. |
| pay_basis | xpms.canon_text | Yes | Pay basis. |
| arrangement | xpms.canon_text | Yes | Arrangement. |
| standard_rate_minor | bigint | Yes | Standard rate in minor units. |
| min_grade_rate_minor | bigint | Yes | Lowest grade rate in minor units. |
| max_grade_rate_minor | bigint | Yes | Highest grade rate in minor units. |
| per_diem_rate_minor | bigint | Yes | Per diem in minor units. |
| currency_code | xpms.currency_code | Yes | Currency of the amounts. |
| overtime_rule_id | xpms.canon_code | Yes | Overtime rule. |
| ot_multiplier | numeric | Yes | Overtime multiplier. |
| dt_multiplier | numeric | Yes | Double-time multiplier. |
| gl_account | xpms.canon_code | Yes | Expense account of the role's class. |
| gl_account_name | xpms.canon_text | Yes | Name of that account. |