DENTAL_TREAT_PLAN
Description:
This table contains information about a dental billing plan.

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID VARCHAR No
The unique identifier for the treatment plan record.
2 PLAN_DESCRIPTION VARCHAR No
The description of the dental treatment plan.
3 PLAN_TYPE_C_NAME VARCHAR No
The category number of the plan type. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: Yes
Category Entries:
Predetermination
Orthodontic
4 PLAN_STATUS_C_NAME VARCHAR No
The category number for the plan status. This is usually the same as the internal ID. If you use IntraConnect, this is the Community ID (CID).
May contain organization-specific values: No
Category Entries:
New
Pending
Submitted
Authorized
Voided
Terminated
UNUSED
Invalid Coverage
Replaced
5 PLAN_CREATION_DATE DATETIME No
The date the dental treatment plan was created.
6 ACCOUNT_ID NUMERIC No
The unique ID of the guarantor account. This column is frequently used to link to the ACCOUNT table.
7 COVERAGE_ID NUMERIC No
In table DENTAL_TREAT_PLAN, the column COVERAGE_ID (DTP/37) has been deprecated. This column has been replaced by column COVERAGE_ID (DTP/45) in table DENTAL_PLAN_COVERAGES To look up the deprecated column's value after the Clarity Compass upgrade, join column DENTAL_TREAT_PLAN.TREATMENT_PLAN_ID to table DENTAL_PLAN_COVERAGES column TREATMENT_PLAN_ID and get the COVERAGE_ID value.
8 PRICING_CONTRACT_ID NUMERIC No
The unique ID of the pricing contract associated with the dental treatment plan. This column is frequently used to link to the CLARITY_ECP table.
9 PROVIDER_ID VARCHAR No
The unique ID associated with the provider record for this row. This column is frequently used to link to the CLARITY_SER table.
10 DEPARTMENT_ID NUMERIC No
The unique ID associated with the department record for this row. This column is frequently used to link to the CLARITY_DEP table.
11 SERVICE_AREA_ID NUMERIC No
The unique ID associated with the service area record for this row. This column is frequently used to link to the CLARITY_SA table.
12 TOTAL_CHARGE_AMOUNT NUMERIC No
The total charge amount for the dental treatment plan.
13 PATIENT_AMOUNT NUMERIC No
Patient amount of the dental treatment plan. This is self-pay portion of the total charge amount.
14 BANDING_DATE DATETIME No
Banding date for orthodontic treatment. It is used on claim and identifies the date the braces were applied.
15 PATIENT_CHG_PX_ID NUMERIC No
A unique ID of the procedure which is associated with the patient of the dental treatment plan. This column is frequently used to link to the CLARITY_EAP table.
16 INSURANCE_CHG_PX_ID NUMERIC No
A unique ID of the procedure which is associated with the insurance of the dental treatment plan. This column is frequently used to link to the CLARITY_EAP table.
17 SKIP_PREDETERMINATION_YN VARCHAR No
Flag to indicate that no predetermination claim needs to be sent.
May contain organization-specific values: No
Category Entries:
No
Yes
18 SOURCE_ESTIMATE_ID NUMERIC No
Represents the Estimate record used to create this dental billing plan, if applicable.
19 DTP_USER_STATUS_C_NAME VARCHAR No
Status of a Dental Billing Plan as shown on DTP activity. This may be overridden by end users and can be different from PLAN_STATUS_C, which is the system status of this billing plan.
May contain organization-specific values: Yes
Category Entries:
New
Pending
Submitted
Authorized
Voided
Terminated
Completed
Invalid Coverage
Replaced
20 REPL_BY_TREATMENT_PLAN_ID VARCHAR No
When a dental billing plan record is replaced, the record that replaced this one will be populated here.