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_CONTRACT_NAME VARCHAR No
The name of the pricing contract.
9 PROVIDER_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
10 DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
11 SERVICE_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
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_PROC_NAME VARCHAR No
The name of each procedure.
16 INSURANCE_CHG_PX_ID_PROC_NAME VARCHAR No
The name of each procedure.
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.