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

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): age group mountaing group legal_entity contract

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