Objects structure

CONTRACTS

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

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	Description and constraints
id	uuid	M	Service request unique identifier
age_units	varchar	M	One of - years, months, days
age_value	number	M	Age in years, months or days
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

Name	Type	M/O	Description and constraints
id	uuid	M	Procedure unique identifier
age_units	varchar	M	One of - years, months, days
age_value	number	M	Age in years, months or days
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

Name	Type	M/O	Description and constraints
id	uuid	M	Diagnostic report unique identifier
age_units	varchar	M	One of - years, months, days
age_value	number	M	Age in years, months or days
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

Name	Type	M/O	Description and constraints
id	uuid	M	Encounter unique identifier
age_units	varchar	M	One of - years, months, days
age_value	number	M	Age in years, months or days
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

Name	Type	M/O	Description and constraints
legal_entity_id	varchar(255)	O	Legal entity identifier (string format)
encounters_count	integer	O	Encounters count of legal entity
inserted_at	timestamp	M	Date and time when the entity was created