...
| id | uuid | M |
|
|
| is_active | boolean | M |
|
|
| name | varchar | M |
|
|
| inserted_at | timestamp | M |
|
|
| inserted_by | uuid | M |
|
|
| updated_at | timestamp | M |
|
|
| updated_by | uuid | M |
|
|
same_mnn_in_treatment_period | boolean | M | Not used for service programs |
|
| program_type | varchar | M | medication, service | NEW |
| legal entity types | jsonb | M | Used for service programs, array of legal_entity_types dictionary values. Program can be set on service request if it were created by an employee from legal entity with one of types listed in array | NEW |
Program_members (
should we use existing reimbursement program_medications table 
new table)
Program_medications table comparisonok |
|
|
| service_id | uuid | O | service_id OR service_group_id is mandatory |
|
|
|
| service_group_id | uuid | O | service_id OR service_group_id is mandatory |
M | medication_request_allowed | ? | jsonb | M | Reimbursement : jsonb | reimbursement | ? | doublewholesale_pricedouble | M | ok | ? | double | M | reimbursement_daily_dosage | ?estimated_payment_amount |
|
|
| description | text | O | used for text description of un-automated conditions which should be checked for program member vs patient qualification (e.g. sex or age of patient) |
contract_program_members (new table)
| id | uuid | M |
|
|
| contract_id | uuid | M | FK(contract_id) |
|
| program_member_id | uuid | M | FK(program_members) |
|
| is_active | boolean | M |
|
|
| inserted_at | timestamp | M |
|
|
| inserted_by | uuid | M |
|
|
| updated_at | timestamp | M |
|
|
| updated_by | uuid | M |
|
|