...
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| start_date | timestamp | M | |
| end_date | timestamp | M | |
| status | enum('PENDING_VERIFICATION', 'VERIFIED') | M | |
| legal_entity_id | uuid | M | |
| contractor_id | uuid | M | |
| contractor_base | varchar | M | |
| contractor_payment_details | jsonb | M | |
| rmsp_amount | number | M | |
| external_contractor_flag | boolean | O | |
| external_contractors | jsonb[] | O | |
| nhs_signer_id | uuid | O | |
| nhs_signer_base | varchar | M | |
| issue_city | varchar | M | |
| status | NEW, DECLINED, APPROVED, SIGNED | M | |
| price | number | M | |
| contract_number | varchar | M | |
| contract_request_id | uuid | M | |
| inserted_by | uuid | M | |
| inserted_at | timestamp | M | |
| updated_by | uuid | M | |
| updated_at | timestamp | M |
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 | boolean | M | |
| inserted_by | uuid | M | |
| inserted_at | timestamp | M | |
| updated_by | uuid | M | |
| updated_at | timestamp | M |
...
CONTRACTOR_PAYMENT_DETAILS
| Name | Type | M/O | Description |
|---|---|---|---|
| payer_account | varchar | M | |
| MFO | varchar | M | |
| payer_code | varchar | M |
EMPLOYEE_DIVISIONS
| Name | sub_fields | Type | M/O | Description |
|---|---|---|---|---|
| legal_entity_id | uuid | M | external_contractor_id | |
| contract{} | object | M | ||
| number | varchar | M | ||
| issued_at | timestamp | M | ||
| expires_at | timestamp | M | ||
| division[{}] | array | M | ||
| id | uuid | M | ||
| medical_service | DICTIONARY | M |
...