Table of Contents |
---|
...
Name | Type | M/O | Capitation vs Reimbursment | |||||||
---|---|---|---|---|---|---|---|---|---|---|
id | uuid | M | + | |||||||
start_date | date | M | + | |||||||
end_date | date | M | + | |||||||
status | enum('TERMINATED', 'VERIFIED'varchar (255) | M | + | |||||||
status_reason | stringtext | 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 | numberinteger | M | - | |||||||
external_contractor_flag | boolean | O | - | |||||||
external_contractors | jsonb | []O | - | |||||||
nhs_legal_entity_id | uuid | M | + | |||||||
nhs_signer_id | uuid | M | + | |||||||
nhs_payment_method | DICTIONARYvarchar (255) | M | + | misc | varchar | O | + | |||
nhs_signer_base | varchar (255) | M | + | |||||||
issue_city | varchar (255) | M | + | |||||||
nhs_contract_price | numberdouble precision | M | - | |||||||
contract_number | varchar (255) | M | + | |||||||
contract_request_id | uuid | M | + | |||||||
is_suspended | boolean | M | + | |||||||
is_active | boolean | M | + | |||||||
id_formDICTIONARY | 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 |
| 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 |
...