Table of Contents |
---|
ERD
See detailed data model here
Data structures
CONTRACT_REQUESTS
...
Name | Type | M/O | Capitation vs Reimbursment |
---|---|---|---|
id | uuid | M | + |
start_date | date | M | + |
end_date | date | M | + |
status | enum('TERMINATED', 'VERIFIED') | M | + |
status_reason | string | O | + |
contractor_legal_entity_id | uuid | M | + |
contractor_owner_id | uuid | M | + |
contractor_base | varchar | M | + |
contractor_payment_details | jsonb | M | + |
contractor_rmsp_amount | number | M | - |
external_contractor_flag | boolean | O | - |
external_contractors | jsonb[] | O | - |
nhs_legal_entity_id | uuid | M | + |
nhs_signer_id | uuid | M | + |
nhs_payment_method | DICTIONARY | M | + |
misc | varchar | O | + |
nhs_signer_base | varchar | M | + |
issue_city | varchar | M | + |
nhs_contract_price | number | M | - |
contract_number | varchar | M | + |
contract_request_id | uuid | M | + |
is_suspended | boolean | M | + |
is_active | boolean | M | + |
id_form | DICTIONARY | M | + |
inserted_by | uuid | M | + |
inserted_at | timestamp | M | + |
updated_by | uuid | M | + |
updated_at | timestamp | M | + |
medical_program_id | uuid | О | new |
contract_type | reimbursement/ capitation | M | new |
...