Table of Contents |
---|
Global budget
Contract
Name | Type | M/O | id | uuid | M|||
---|---|---|---|---|---|---|---|
type | varchar | M | |||||
contractor_legal_entity_id | uuid | M | |||||
contractor_owner_id | uuid | M | |||||
contractor_base | varchar | M | |||||
contractor_payment_details | jsonb | M | |||||
bank_name | varchar | M | |||||
MFO | varchar | O | |||||
payer_account | varchar | M | |||||
start_date | date | M | |||||
end_date | date | M | |||||
status | varchar | M | |||||
status_reason | varchar | O | |||||
nhs_signer_base | varchar | M | |||||
nhs_payment_method | varchar | M | |||||
nhs_signer_id | uuid | M | |||||
nhs_legal_entity_id | uuid | M | |||||
issue_city | varchar | O | |||||
contract_number | varchar | M | |||||
is_suspended | boolean | M | is_active | boolean | M | ||
id_form | varchar | M | |||||
parent_contract_id | uuid | O | |||||
nhs_signed_date | date | M | |||||
medical_program_id | uuid | M | |||||
signed_content_location | varchar | M | |||||
reason | varchar | O | |||||
nhs_contract_price | float | O |
Contract division
Name | Type | M/O |
---|---|---|
division_id | uuid | M |
contract_id | uuid | M |
Contract employees
Name | Type | M/O | |||
---|---|---|---|---|---|
employee_id | uuid | M | |||
division_id | uuid | M | |||
contract_id | uuid | M | is_active | boolean | M |
start_date | date | O | |||
end_date | date | O | |||
staff_units | float | O | |||
declaration_limit | integer | O |