Page Comparison

Table of Contents

...

+

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

CONTRACT_EMPLOYEES

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

...