Content Comparison

Table of Contents

...

Name		Type	M/O	Description and constraints
id		uuid	Mcontract_type
capitation, reimbursement	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)
	MFO	varchar (255)
	payer_account	varchar (255)
contractor_rmsp_amount		numberinteger	M
external_contractor_flag		boolean	O
external_contractors		jsonb[]	O
contractor_employee_divisions		jsonb[]	O
contractor_divisions		arrayuuid[]	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
statusNEW, in_PROCESS, DECLINED, APPROVED, PENDING_NHS_SIGN, NHS_SIGNED, SIGNED, TERMINATED		varchar (255)	M
status_reason		varchartext	O
nhs_contract_price		numberdouble precision	O
nhs_payment_method		DICTIONARYvarchar (255)	O
nhs_signed_date		date	O
misc		varchartext	O
contract_number		varchar (255)	O
contract_id		uuid	O
parent_contract_id		uuid	O	Reference to parent contract Should be filled for update flow
printout_content		varchartext	O
data		jsonb	O
id_formDICTIONARY		varchar (255)	M
inserted_by		uuid	M
inserted_at		timestamp	M
updated_by		uuid	M
updated_at		timestamp	M
medical_programs		uuid[]
type		varchar(255)
contractor_signed		boolean

CONTRACTS

Name		Type	M/O	Description and constraints
id		uuid	M	~~contract_type~~	capitation, reimbursement	M
start_date		date	M
end_date		date	M
status		enum('TERMINATED', 'VERIFIED'varchar (255)	M
status_reason		stringtext	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		numberinteger	M
external_contractor_flag		boolean	O
external_contractors		jsonb[]	O
nhs_legal_entity_id		uuid	M
nhs_signer_id		uuid	M
nhs_payment_method		DICTIONARYvarchar (255)	M
nhs_signed_date		date	O	~~misc~~	varchar	O
nhs_signer_base		varchar (255)	M
issue_city		varchar (255)	M
nhs_contract_price		numberdouble precision	M
contract_number		varchar (255)	M
contract_request_id		uuid	M
is_suspended		boolean	M
is_active		boolean	M
id_formDICTIONARY		varchar (255)	M
inserted_by		uuid	M
inserted_at		timestamp	M
updated_by		uuid	M
updated_at		timestamp	M
parent_contract_id		uuid	O
type		varchar (255)	M
reason		stringtext	O
signed_content_location		varchar (255)	M
contractorskip_provision_basedeactivation	varchar		Oboolean

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

...