...
...
| Table of Contents |
|---|
ERD
See detailed data model here
Data structures
CONTRACT_REQUESTS
Name | Type | M/O | Capitation vs Reimbursment |
|---|---|---|---|
id | uuid | M | + |
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 | - |
contractor_employee_divisions | jsonb[] | O | - |
contractor_divisions | array | M | + |
start_date | date | M | + |
end_date | date | M | + |
nhs_legal_entity_id | uuid | O | + |
nhs_signer_id | uuid | O | + |
nhs_signer_base | varchar | O | + |
assignee_id | uuid | O | ? |
issue_city | varchar | O | + |
status | NEW, in_PROCESS, DECLINED, APPROVED, PENDING_NHS_SIGN, NHS_SIGNED, SIGNED, TERMINATED | M | + |
status_reason | varchar | O | + |
nhs_contract_price | number | O | - |
nhs_payment_method | DICTIONARY | O | + |
nhs_signed_date | date | O | + |
misc | varchar | O | + |
contract_number | varchar | O | + |
contract_id | uuid | O | + |
parent_contract_id | uuid | O | + |
printout_content | varchar | O | + |
data | jsonb | O | + |
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 |
CONTRACTS
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 |
CONTRACT_EMPLOYEES
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | |
employee_id | uuid | M | |
staff_units | number | M | |
declaration_limit | number | M | |
division_id | number | M | |
contract_id | uuid | M | |
start_date | date | M | |
end_date | date | O | |
inserted_by | uuid | M | |
inserted_at | timestamp | M | |
updated_by | uuid | M | |
updated_at | timestamp | M |
CONTRACT_DIVISIONS
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | |
division_id | number | M | |
contract_id | uuid | M | |
inserted_by | uuid | M | |
inserted_at | timestamp | M | |
updated_by | uuid | M | |
updated_at | timestamp | M |
JSON Structures
CONTRACTOR_PAYMENT_DETAILS
Name | Type | M/O | Description |
|---|---|---|---|
payer_account | varchar | M | |
MFO | varchar | M | |
bank_name | varchar | M |
EXTERNAL_CONTRACTORS
Name | sub_fields | Type | M/O | Description |
|---|---|---|---|---|
legal_entity_id | uuid | M | external_contractor_id | |
contract{} | object | M | ||
number | varchar | M | ||
issued_at | timestamp | M | ||
expires_at | timestamp | M | ||
divisions[{}] | array | M | ||
id | uuid | M | ||
medical_service | DICTIONARY | M |
CONTRACTOR_EMPLOYEE_DIVISIONS
Name | Type | M/O | Description and constraints |
|---|---|---|---|
employee_id | uuid | M | |
staff_units | number | M | |
declaration_limit | number | M | |
division_id | uuid | M |
Сontract_medical_programs
Атрибут | Значення | Тип |
|---|---|---|
id | Ідентифікатор атрибуту | uuid |
medical_program_id | Ідентифікатор атрибуту | uuid |
contract_id | Ідентифікатор атрибуту | uuid |
inserted_by | Ідентифікатор особи, що внесла запис до системи | uuid |
updated_by | Ідентифікатор особи, що редагувала запис в системі | uuid |
inserted_at | Коли було внесено запис до системи | timestamp |
updated_at | Коли було відредаговано | timestamp |