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 | ||
bank_name | varchar (255) | |||
MFO | varchar (255) | |||
payer_account | varchar (255) | |||
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[] | |||
type | varchar(255) | |||
contractor_signed | boolean |
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 | ||
bank_name | varchar (255) | |||
MFO | varchar (255) | |||
payer_account | varchar (255) | |||
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 |