Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| identifier | varchar |
|
|
The unique identifier for this service code. Matches the value stored in places like invoice_lines.external_id and purchase_order_lines.external_id. Composed of the service ID and any optional sub-level IDs joined by a pipe character. @example “SERV-0001”, “SERV-0062|WRAP-005”, “SERV-0066|ATITM 001|SERV-0030” |
| label | varchar |
|
|
Human-readable label for the service code, formatted as a slash-separated hierarchy of names and codes. Corresponds to the value shown in the claiming code selector in the Lookout UI. @example “General house cleaning (SERV-0001)”, “Self-care products (SERV-0062) / Repairs (WRAP-005)” |
| service_group_id | varchar |
|
|
The Services Australia identifier for the service group. @example “SERG-0001” |
| service_group_name | varchar |
|
|
The name of the service group. @example “Home Support” |
| service_type_id | varchar |
|
|
The Services Australia identifier for the service type. @example “SERT-0001” |
| service_type_name | varchar |
|
|
The name of the service type. @example “Domestic assistance” |
| service_id | varchar |
|
|
The Services Australia identifier for the service. Always the first segment of the identifier. @example “SERV-0001” |
| service_name | varchar |
|
|
The name of the service. @example “General house cleaning” |
| category | varchar |
|
|
The participant contribution category for this service code, as defined by Services Australia. @example “Everyday living”, “Independence”, “Clinical supports” |
| unit_type | varchar |
|
|
The normalised unit type used within the Lookout platform for this service code. Derived from the raw Services Australia unit type. @example “hours”, “item”, “cost” |
| wraparound_id | varchar |
|
|
The Services Australia identifier for the wraparound service, if applicable. @example “WRAP-001” |
| wraparound_name | varchar |
|
|
The name of the wraparound service, if applicable. @example “Set up” |
| item_id | varchar |
|
|
The Services Australia identifier for the item, if applicable. @example “HSITM-001” |
| item_name | varchar |
|
|
The name of the item, if applicable. @example “Telephone bill” |
| health_professional_type_id | varchar |
|
|
The Services Australia identifier for the health professional type, if applicable. @example “SERV-0030” |
| health_professional_type_name | varchar |
|
|
The name of the health professional type, if applicable. @example “Speech pathology” |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_finance_sah_service_codes_pkey | Primary key | Asc | id |
| idx_140dbeee50917a7850e2439b0a37b34e | Performance | Asc | health_professional_type_id |
| idx_edge_finance_sah_service_codes_identifier | Performance | Asc | identifier |
| idx_edge_finance_sah_service_codes_item_id | Performance | Asc | item_id |
| idx_edge_finance_sah_service_codes_service_group_id | Performance | Asc | service_group_id |
| idx_edge_finance_sah_service_codes_service_id | Performance | Asc | service_id |
| idx_edge_finance_sah_service_codes_service_type_id | Performance | Asc | service_type_id |
| idx_edge_finance_sah_service_codes_wraparound_id | Performance | Asc | wraparound_id |