ORTHO_PAYMENT_PLAN
Description:
The ORTHO_PAYMENT_PLAN table contains information about orthodontics charging plans.

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID VARCHAR No
The unique identifier for the dental billing plan record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 ORTHO_PMT_PLAN_NUM INTEGER No
The orthodontic charging plan number.
4 ORTHO_PAT_INS_LIAB NUMERIC No
The patient or insurance liability of the orthodontic charging plan.
5 ORTHO_PATIENT_YN VARCHAR No
Indicate whether this charging plan line is for the self-pay portion of this charging plan.
May contain organization-specific values: No
Category Entries:
Yes
No
6 ORTHO_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
7 ORTHO_LIABILITY NUMERIC No
The self-pay or insurance portion for this orthodontic charging plan line.
8 ORTHO_DOWN_PAYMENT NUMERIC No
The amount of the initial charge for this charging plan line.
9 ORTHO_TERM_LENGTH INTEGER No
The frequency of payments for this orthodontic charging plan line measured in months.
10 ORTHO_TOTAL_TERMS INTEGER No
The number of payments included in this orthodontic charging plan line.
11 ORTHO_TERMS_LEFT INTEGER No
The number of payments left on this orthodontic charging plan line.
12 ORTHO_TERM_PAY NUMERIC No
The amount of the payments for this orthodontic charging plan line.
13 ORTHO_LAST_TERM_PAY NUMERIC No
The amount of the final payment for this orthodontic charging plan line.
14 ORTHO_START_DATE DATETIME No
The date this charging plan line starts.
15 ORTHO_DATE_ESTAB_DT DATETIME No
The date when this orthodontic charging plan line was created.
16 ORTHO_ACTIVE_YN VARCHAR No
Indicates whether this charging plan line is active or not. Y indicates that this line is active. N or a null value indicates that this line is not active.
The category values for this column were already listed for column: ORTHO_PATIENT_YN
17 ORTHO_ENTRY_USER_ID VARCHAR No
The unique ID of the user record who entered the orthodontic charging plan line. This column is frequently used to link to the CLARITY_EMP table.
18 ORTHO_ENTRY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
19 ORTHO_ENTRY_TIME DATETIME (Local) No
The time when orthodontic charging plan line was entered in the system.
20 ORTHO_DEL_USER_ID VARCHAR No
The unique ID of the user record who removed the orthodontic charging plan line. This column is frequently used to link to the CLARITY_EMP table.
21 ORTHO_DEL_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
22 ORTHO_DEL_DATE DATETIME No
The date when orthodontic charging plan line was removed.
23 ORTHO_DEL_TIME DATETIME (Local) No
The time when orthodontic charging plan was removed.
24 ORTHO_CHARGING_DATE DATETIME No
The date when the charge was dropped for this payment plan.
25 NUM_VISITS_LEFT INTEGER No
The required number of visits which are left for this payment plan term.
26 LST_CHG_DT DATETIME No
The last charge dropping date. In order to meet the minimum number of visits, we need to count the number of visits from the last charge dropping date to the current charge dropping date.
27 NUM_OF_VIS_REQ INTEGER No
Number of visits required by payer for the charging plan period.
28 ORTHO_INITIAL_CHG_DATE DATETIME No
Date to be used for the initial charge on this current charging plan line.
29 ORTHO_INITIAL_CHG_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
30 ORTHO_PERIODIC_CHG_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.