Table of Contents |
---|
...
Name | Sub attribute name | Type | M/O | Capitation vs Reimbursment | ||||||
---|---|---|---|---|---|---|---|---|---|---|
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 | + | misc | varchar | |||||
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_ | programcontract_id | uuid | О | new | contract_type | reimbursement/ capitation | M | new|||
nhs_signed_date | ||||||||||
type | varchar (255) | |||||||||
reason | text | |||||||||
signed_content_location | varchar (255) | |||||||||
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 |
...