| 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 * * *` |
| CAPITATION_REPORT_VALIDATE_SIGNATURE | true |
Specification
Prepare dataset
...
| 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 |
...