Table of Contents |
---|
...
Name | Type | M/O | Capitation vs Reimbursment | ||||||
---|---|---|---|---|---|---|---|---|---|
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 | + | ||||||
previous_request_id | uuid | O | + | ||||||
misc | text | O | + | ||||||
contract_number | varchar (255) | O | + | ||||||
contract_id | uuid | O | + | ||||||
parent_contract_id | uuid | O | + | ||||||
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 | + | ||||||
type | varchar(255) | M | + | ||||||
contractor_signed | boolean | M | + |
CONTRACTS
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 | + | ||||||
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 | uuid+ | ||||||
nhs_signed_date | date | M | date+ | ||||||
type |
| varchar (255) | M | + | |||||
reason | text | O | text+ | ||||||
signed_content_location | varchar (255) | M | + | ||||||
skip_provision_deactivation | boolean | O | 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 |
...
Name | Type | M/O | Description and constraints |
---|---|---|---|
id | uuid | M | |
division_id | number | M | |
contract_id | uuid | M | |
inserted_by | uuid | M | |
inserted_at | timestamp | M | |
updated_by | uuid | M | |
updated_at | timestamp | M |
JSON Structures
CONTRACTOR_PAYMENT_DETAILS
...