xpms.rate_card
TablaSeguridad a nivel de fila activa
Labor Rate Cards (decisions D12 to D14 and D16): only the card's own facts. Title, department, GL account and multipliers are joined or derived.
Clave primaria: rate_card_id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| rate_card_id | xpms.canon_code | No | Rate card code LRC-nnn. |
| role_code | xpms.canon_code | No | Role the card prices.Hace referencia a xpms.role.role_code |
| worker_classification | xpms.canon_code | No | Classification of the engagement the card prices.Hace referencia a xpms.arrangement_classification.worker_classification |
| pay_basis | xpms.canon_text | No | How pay is computed.Hace referencia a xpms.pay_basis_classification.pay_basis |
| arrangement | xpms.canon_text | No | Retainer or per engagement.Hace referencia a xpms.arrangement_classification.arrangement |
| standard_rate_minor | bigint | Sí | Standard rate in minor units of currency_code; NULL is unpriced. |
| min_grade_rate_minor | bigint | Sí | Lowest grade rate in minor units of currency_code; NULL is unpriced. |
| max_grade_rate_minor | bigint | Sí | Highest grade rate in minor units of currency_code; NULL is unpriced. |
| per_diem_rate_minor | bigint | Sí | Per diem in minor units of currency_code; NULL is unpriced. |
| currency_code | xpms.currency_code | No | ISO 4217 currency of the amounts; the Playbook states US dollars. |
| overtime_rule_id | xpms.canon_code | No | Overtime rule the card follows.Hace referencia a xpms.overtime_rule.rule_id |
| flag | boolean | Sí | FLAG from the Playbook Labor Rate Cards sheet. |
| notes | xpms.canon_text | Sí | NOTES from the Playbook Labor Rate Cards sheet. |
| source_row | integer | Sí | Row of the Playbook sheet that mirrors this canon row; NULL when the Playbook has no such row. |
| source_status | xpms.canon_text | Sí | STATUS as recorded on the Playbook row (for example Active). |
| source_created_by | xpms.canon_text | Sí | CREATED BY as recorded on the Playbook row. |
| source_created_at | timestamp without time zone | Sí | CREATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |
| source_updated_at | timestamp without time zone | Sí | UPDATED AT as recorded on the Playbook row: a wall-clock time; the Playbook records no time zone. |