| Table of Contents |
|---|
...
Capitation report starts periodically based on the value of configuration parameter CAPITATION_REPORT_SCHEDULE
Configuration
| Parameter | Description | Value |
|---|---|---|
| CAPITATION_REPORT_SCHEDULE | (Cron Format) How often to run capitation report | `* 1 * * *` for prod
|
| CAPITATION_REPORT_VALIDATE_SIGNATURE | true |
Specification
Prepare dataset
...
| Attribute | Condition |
|---|---|
| contract.start_date | < billing_date |
| contract.end_date | >= billing_date |
| contract.status | in (ACTIVE) |
| contract.type | in (capitation) |
4. Find active employees declared in Active contract's
...
| Group | Condition |
|---|---|
| 0 - 5 | EXTRACT(YEAR FROM AGE(now(), persons.birth_date)) between 0 and 65 |
| 6 - 17 | EXTRACT(YEAR FROM AGE(now(), persons.birth_date)) between 6 and 17 where persons.id = declarations.person_id |
| 18 - 39 | EXTRACT(YEAR FROM AGE(now(), persons.birth_date)) between 18 and 39 where persons.id = declarations.person_id |
| 40 - 65 | EXTRACT(YEAR FROM AGE(now(), persons.birth_date)) between 40 and 65 where persons.id = declarations.person_id |
| 65 + | EXTRACT(YEAR FROM AGE(now(), persons.birth_date)) > 65 where persons.id = declarations.person_id |
...
Create report record in capitation_reports. Result with zero values are also saved to report.
- For each contract in billing prepare temporary dataset with zero values for each key (age group | mountain group)
- Update this dataset with real number of declarations for each key
| Attribute | Description |
|---|---|
| id | Generated on Step 2 report_id |
| billing_date | Determined on Step 1 billing_date |
| created_at | Created at date time |
...