Treatment

Attribute

Type

Description

patient_id

integer

Associated patient identifier

treatment_date

date

Date treatment was performed (YYYY-MM-DD)

item_code

string

Procedure/service item code

item_qty

integer

Quantity of items/procedures performed

item_fee

string

Fee charged for the item/procedure (fixed-point, e.g. "120.00")

invoice_id

integer

Associated invoice identifier

item_paid

integer (0/1)

Payment status (0 = unpaid, 1 = paid)

practitioner_id

integer

Practitioner who performed treatment

tooth_number

string

Tooth number and surface (e.g. "12 (MO)")

location_id

integer

Practice location where treatment occurred

plan_id

integer, nullable

Associated treatment plan identifier

fee_discount

string

Discount applied to the fee (fixed-point)

ada_item

string

ADA/standard procedure code

treatment_id

integer

Unique treatment record identifier

non_treatment

integer (0/1)

Non-treatment item flag (0 = treatment, 1 = non-treatment)

non_reporting

integer (0/1)

Non-reporting item flag (0 = reportable, 1 = non-reportable)

health_fund_id

integer, nullable

Associated health fund/insurance identifier

created_date

date-time

Treatment record creation timestamp

updated_date

date-time

Treatment record update timestamp

is_deleted

integer (0/1)

Deletion status (0 = active, 1 = deleted)