ЕСОЗ - публічна документація
Contract Data model
ERD
See detailed data model here
Data structures
CONTRACT_REQUESTS
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M |
|
contractor_legal_entity_id | uuid | M |
|
contractor_owner_id | uuid | M |
|
contractor_base | varchar (255) | M |
|
contractor_payment_details | jsonb | M |
|
contractor_rmsp_amount | integer | M |
|
external_contractor_flag | boolean | O |
|
external_contractors | jsonb | O |
|
contractor_employee_divisions | jsonb | O |
|
contractor_divisions | uuid[] | M |
|
start_date | date | M |
|
end_date | date | M |
|
nhs_legal_entity_id | uuid | O |
|
nhs_signer_id | uuid | O |
|
nhs_signer_base | varchar (255) | O |
|
assignee_id | uuid | O |
|
issue_city | varchar (255) | O |
|
status | varchar (255) | M |
|
status_reason | text | O |
|
nhs_contract_price | double precision | O |
|
nhs_payment_method | varchar (255) | O |
|
nhs_signed_date | date | O |
|
misc | text | O |
|
contract_number | varchar (255) | O |
|
contract_id | uuid | O |
|
parent_contract_id | uuid | O | Reference to parent contract Should be filled for update flow |
printout_content | text | O |
|
data | jsonb | O |
|
id_form | varchar (255) | M |
|
inserted_by | uuid | M |
|
inserted_at | timestamp | M |
|
updated_by | uuid | M |
|
updated_at | timestamp | M |
|
medical_programs | uuid[] | M | Mandatory for the reimbursement contract |
type | varchar(255) | M |
|
contractor_signed | boolean | M |
|
CONTRACTS
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M |
|
start_date | date | M |
|
end_date | date | M |
|
status | varchar (255) | M |
|
status_reason | text | O |
|
contractor_legal_entity_id | uuid | M |
|
contractor_owner_id | uuid | M |
|
contractor_base | varchar (255) | M |
|
contractor_payment_details | jsonb | M |
|
contractor_rmsp_amount | integer | M |
|
external_contractor_flag | boolean | O |
|
external_contractors | jsonb | O |
|
nhs_legal_entity_id | uuid | M |
|
nhs_signer_id | uuid | M |
|
nhs_payment_method | varchar (255) | M |
|
nhs_signed_date | date | O |
|
nhs_signer_base | varchar (255) | M |
|
issue_city | varchar (255) | M |
|
nhs_contract_price | double precision | M |
|
contract_number | varchar (255) | M |
|
contract_request_id | uuid | M |
|
is_suspended | boolean | M |
|
is_active | boolean | M |
|
id_form | varchar (255) | M |
|
inserted_by | uuid | M |
|
inserted_at | timestamp | M |
|
updated_by | uuid | M |
|
updated_at | timestamp | M |
|
parent_contract_id | uuid | O |
|
type | varchar (255) | M |
|
reason | text | O |
|
signed_content_location | varchar (255) | M |
|
skip_provision_deactivation | boolean |
|
|
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 |
|
ЕСОЗ - публічна документація