Table of Contents |
---|
...
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[] | 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 | 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 |
...