| Table of Contents |
|---|
...
Name | Type | M/O | Description and constraints | |||
|---|---|---|---|---|---|---|
id | uuid | M | contract_type | capitation, reimbursement | M | |
contractor_legal_entity_id | uuid | M | ||||
contractor_owner_id | uuid | M | ||||
contractor_base | varchar (255) | M | ||||
contractor_payment_details | jsonb | M | ||||
contractor_rmsp_amount | numberinteger | M | ||||
external_contractor_flag | boolean | O | ||||
external_contractors | jsonb[] | O | ||||
contractor_employee_divisions | jsonb[] | O | ||||
contractor_divisions | arrayuuid[] | 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 | ||||
statusNEW, in_PROCESS, DECLINED, APPROVED, PENDING_NHS_SIGN, NHS_SIGNED, SIGNED, TERMINATED | varchar (255) | M | ||||
status_reason | varchartext | O | ||||
nhs_contract_price | numberdouble precision | O | ||||
nhs_payment_method | DICTIONARYvarchar (255) | O | ||||
nhs_signed_date | date | O | ||||
misc | varchartext | 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 | varchartext | O | ||||
data | jsonb | O | ||||
id_formDICTIONARY | 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 | ||||
capitation, reimbursement | 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 | ||||
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 | ||||
nhs_signed_date | date | O |
| 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_contract_id | uuid | O | ||||
type | varchar (255) | M | ||||
reason | stringtext | O | ||||
signed_content_location | varchar (255) | M | ||||
contractorskip_provision_basedeactivation | varchar | Oboolean |
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 |
...