Global budged
Contract
Name | Type | M/O | |
|---|---|---|---|
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 | |
id_form | varchar | M | |
parent_contract_id | uuid | O | |
nhs_signed_date | date | M | |
medical_program_id | uuid | M | |
signed_content_location | varchar | 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 |
start_date | date | O |
end_date | date | O |
staff_units | float | O |
declaration_limit | integer | O |