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

misc

text

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

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

Mandatory for the reimbursement contract

type

varchar(255)

M

contractor_signed

boolean

M

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_signed_date

date

O

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

type

varchar (255)

M

reason

text

O

signed_content_location

varchar (255)

M

skip_provision_deactivation

boolean

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

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

payer_account

varchar

M

MFO

varchar

M

bank_name

varchar

M

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

employee_id

uuid

M

staff_units

number

M

declaration_limit

number

M

division_id

uuid

M