Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The owning tenant’s ID. @example 1 |
| shift_id | int8 |
|
|
The shift this cost line belongs to. @example 1 |
| payroll_award_rule_id | int8 |
|
|
The award rule used to calculate this shift cost. @example 1 |
| description | varchar |
|
|
A human-readable description of what this cost line represents. @example “Ordinary hours”, “Saturday penalty rate” |
| amount_cents | int4 |
|
|
The monetary amount of the cost line, in cents. @example 4500 |
| amount_currency | varchar |
|
|
The ISO currency code for the amount. @example “AUD” |
| quantity | float8 |
|
|
The number of units (e.g. hours) the amount applies to. @example 7.6 |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| visit_id | int8 |
|
|
The visit this shift cost line is associated with, if any. @example 1 |
| payroll_award_classification_id | int8 |
|
|
The award classification this shift cost was created from. @example 1 |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_payroll_shift_cost_lines_pkey | Primary key | Asc | id |
| idx_011d4b9940f9e43541edfba1283ea63d | Performance | Asc | payroll_award_classification_id |
| idx_edge_payroll_shift_cost_lines_company_id | Performance | Asc | company_id |
| idx_edge_payroll_shift_cost_lines_payroll_award_rule_id | Performance | Asc | payroll_award_rule_id |
| idx_edge_payroll_shift_cost_lines_shift_id | Performance | Asc | shift_id |
| idx_edge_payroll_shift_cost_lines_visit_id | Performance | Asc | visit_id |