Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

...

Name

Type

M/O

Description and constraints

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)

MFO

varchar (255)

payer_account

varchar (255)

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

CONTRACTS

Name

Type

M/O

Description and constraints

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_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

...