ERD

See detailed data model here

Data structures

Name	Type	M/O	Capitation vs Reimbursment
id	uuid	M	+
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	-
contractor_employee_divisions	jsonb[]	O	-
contractor_divisions	array	M	+
start_date	date	M	+
end_date	date	M	+
nhs_legal_entity_id	uuid	O	+
nhs_signer_id	uuid	O	+
nhs_signer_base	varchar	O	+
assignee_id	uuid	O	?
issue_city	varchar	O	+
status	NEW, in_PROCESS, DECLINED, APPROVED, PENDING_NHS_SIGN, NHS_SIGNED, SIGNED, TERMINATED	M	+
status_reason	varchar	O	+
nhs_contract_price	number	O	-
nhs_payment_method	DICTIONARY	O	+
nhs_signed_date	date	O	+
misc	varchar	O	+
contract_number	varchar	O	+
contract_id	uuid	O	+
parent_contract_id	uuid	O	+
printout_content	varchar	O	+
data	jsonb	O	+
id_form	DICTIONARY	M	+
inserted_by	uuid	M	+
inserted_at	timestamp	M	+
updated_by	uuid	M	+
updated_at	timestamp	M	+
medical_program_id	uuid	О	new
contract_type	reimbursement/ capitation	M	new

Name	Type	M/O	Capitation vs Reimbursment
id	uuid	M	+
start_date	date	M	+
end_date	date	M	+
status	enum('TERMINATED', 'VERIFIED')	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	DICTIONARY	M	+
misc	varchar	O	+
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	+
id_form	DICTIONARY	M	+
inserted_by	uuid	M	+
inserted_at	timestamp	M	+
updated_by	uuid	M	+
updated_at	timestamp	M	+
program_id	uuid	О	new
contract_type	reimbursement/ capitation	M	new

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
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
payer_account	varchar	M
MFO	varchar	M
bank_name	varchar	M

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
employee_id	uuid	M
staff_units	number	M
declaration_limit	number	M
division_id	uuid	M