ERD

See detailed data model here

Data structures

Name	Type	M/O	Capitation vs Reimbursment

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	+
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	+

Name	Type	M/O	Capitation vs Reimbursment

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	+
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	+
nhs_signed_date	date	M	+
type	varchar (255)	M	+
reason	text	O	+
signed_content_location	varchar (255)	M	+
skip_provision_deactivation	boolean	O	+

Name	Type	M/O	Description and constraints

Name	Type	M/O
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

Name	Type	M/O
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

Name	Type	M/O	Description

Name	Type	M/O
payer_account	varchar	M
MFO	varchar	M
bank_name	varchar	M

Name	sub_fields	Type	M/O	Description

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
divisions[{}]		array	M
	id	uuid	M
	medical_service	DICTIONARY	M

Name	Type	M/O	Description and constraints

Name	Type	M/O
employee_id	uuid	M
staff_units	number	M
declaration_limit	number	M
division_id	uuid	M

Атрибут	Значення	Тип

Атрибут	Значення	Тип
id	Ідентифікатор атрибуту	uuid
medical_program_id	Ідентифікатор атрибуту	uuid
contract_id	Ідентифікатор атрибуту	uuid
inserted_by	Ідентифікатор особи, що внесла запис до системи	uuid
updated_by	Ідентифікатор особи, що редагувала запис в системі	uuid
inserted_at	Коли було внесено запис до системи	timestamp
updated_at	Коли було відредаговано	timestamp