| Table of Contents |
|---|
...
Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | |
| start_date | date | M | |
| end_date | date | M | |
| status | varchar | M | |
| status_reason | string | O | |
| contractor_legal_entity_id | uuid | M | |
| contractor_owner_id | uuid | M | |
| contractor_base | varchar | M | |
| contractor_payment_details | jsonb | M | |
| contractor_rmsp_amount | number | 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 | M | |
| nhs_payment_details | jsonb | M | |
| nhs_signer_base | varchar | M | |
| issue_city | varchar | M | |
| nhs_contract_price | number | M | |
| contract_number | varchar | M | |
| contract_request_id | uuid | M | |
| is_suspended | boolean | M | |
| is_active | boolean | 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 | |
| division_id | number | M | |
| contract_id | uuid | M | |
| inserted_by | uuid | M | |
| inserted_at | timestamp | M | |
| updated_by | uuid | M | |
| updated_at | timestamp | M |
SERVICE_REQUESTS
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | Service request unique identifier |
| age_units | varchar | M | One of - years or , months, days |
| age_value | number | M | Age in years, months or monthsdays |
| gender | varchar | M | Gender |
| inserted_at | timestamp | M | Date and time when the entity was created |
| timestamp | timestamp | M | Date and time when information of the entity was added to the report |
PROCEDURES
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | Procedure unique identifier |
| age_units | varchar | M | One of - years or , months, days |
| age_value | number | M | Age in years, months or monthsdays |
| gender | varchar | M | Gender |
| inserted_at | timestamp | M | Date and time when the entity was created |
| timestamp | timestamp | M | Date and time when information of the entity was added to the report |
DIAGNOSTIC_REPORTS
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | Diagnostic report unique identifier |
| age_units | varchar | M | One of - years or , months, days |
| age_value | number | M | Age in years, months or monthsdays |
| gender | varchar | M | Gender |
| inserted_at | timestamp | M | Date and time when the entity was created |
| timestamp | timestamp | M | Date and time when information of the entity was added to the report |
ENCOUNTERS
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| id | uuid | M | Encounter unique identifier |
| age_units | varchar | M | One of - years or , months, days |
| age_value | number | M | Age in years, months or monthsdays |
| gender | varchar | M | Gender |
| inserted_at | timestamp | M | Date and time when the entity was created |
| timestamp | timestamp | M | Date and time when information of the entity was added to the report |