Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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)

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

+

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

+

CONTRACTS

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

Description and constraints

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

Description and constraints

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

JSON Structures

CONTRACTOR_PAYMENT_DETAILS

...