ЕСОЗ - публічна документація
Capitation Report Data Structure
- Aleksandr Virny (Unlicensed)
- sveta vedmed (Unlicensed)
Owned by Aleksandr Virny (Unlicensed)
Reporting DB objects
See details here
capitation_reports
This table stores all the reports generated by the system
| Attribute | Data Type | M/O | Description |
|---|---|---|---|
| id | UUID | M | Unique report id |
| billing_date | DATE | M | Report billing date |
| created_at | TIMESTAMP | M | Date that shows when the report was generated |
capitation_report_details
This table stores all the details, related to the report. It includes all metrics and aggregations
| Attribute | Data Type | M/O | Description |
|---|---|---|---|
| id | UUID | M | Unique record id |
| capitation_report_id | UUID | M | Capitation report ID. Reference to capitation_reports.id |
| legal_entity_id | UUID | M | Legal entity ID. Reference to legal_entities.id |
| capitation_contract_id | UUID | M | Capitation contract ID. Reference to contracts.id |
| mountain_group | BOOLEAN | M | Mountain group |
| age_group | VARCHAR(50) | M | One of the specified age group, defined in AGE_GROUPS |
| declarations_count | INTEGER | M | Number of all active declarations related to (specified):
|
capitation_report_errors
This table stores all records that cause the problem during report generation. It includes references to related objects, action and error message
| Attribute | Data Type | M/O | Description |
|---|---|---|---|
| id | UUID | M | Unique record id |
| capitation_report_id | UUID | M | Capitation report ID. Reference to capitation_reports.id |
| declaration_id | UUID | M | Declaration ID. Reference to declarations.id |
| action | VARCHAR(50) | M | Action that cause the problem |
| message | TEXT | M | Error message |
| inserted_at | TIMESTAMP | M | Record inserted_at datetime |
ЕСОЗ - публічна документація