DENTAL_ORTHODONTICS
Description:
Table for storing Orthodontics Episode items such as Treatment Scope, Treatment Start Date, etc.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique identifier (.1 item) for the episode record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 ORTHO_BANDING_DATE DATETIME No
Date on which the brackets or bands were placed on patient's teeth.
5 ORTHO_END_DATE DATETIME No
Date on which the last phase of an orthodontic treatment ends.
6 ORTHO_ESTIMATED_LENGTH INTEGER No
Estimated number of months an orthodontic treatment would last.
7 ORTHO_TX_SCOPE_C_NAME VARCHAR No
The current scope of orthodontic treatment.
May contain organization-specific values: Yes
Category Entries:
Limited
Comprehensive
Habit Control
Retainer Only
8 ORTHO_EPSD_STATUS_C_NAME VARCHAR No
Status of the episode in terms of "Ongoing", "Pending", or "Discontinued".
May contain organization-specific values: Yes
Category Entries:
Ongoing
Paused
Discontinued
Completed
9 ORTHO_EPSD_STATUS_REASON_C_NAME VARCHAR No
Reason why an orthodontics episode is pending or discontinued.
May contain organization-specific values: Yes
Category Entries:
Ongoing poor oral hygiene
Patient declined treatment
Treatment not recommended
Patient concerns about pain
Patient concerns about personal appearance
Patient concerns about social stigma
Patient concerns about treatment cost
Patient concerns about transportation
Patient concerns about speech
Other adverse effects of orthodontic treatment
Parent/guardian request
Appliance removal by patient
Patient relocation
Overall treatment length
Dietary changes
Root resorption
Referral to other dental specialty
Automatic Discontinuation
Other
10 ORTHO_MODIFIED_INST_DTTM DATETIME (UTC) No
History item that tracks every instant an orthodontic episode has been modified.
11 ORTHO_MODIFIED_USER_ID VARCHAR No
Stores the user that modified orthodontics data for this history line.
12 ORTHO_MODIFIED_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 ORTHO_MODIFIED_CSN NUMERIC No
Stores the contact CSN where data was modified for this history line.
14 ORTHO_STATUS_COMMENT VARCHAR No
Comment on why an orthodontics episode status is paused or discontinued.
15 ORTHO_TX_STATUS_C_NAME VARCHAR No
This is the status of the orthodontic treatment.
May contain organization-specific values: No
Category Entries:
Under Evaluation
Observation
Planning
Active
Retention
16 ORTHO_DENTITION_C_NAME VARCHAR No
This is the treatment dentition for the orthodontics episode.
May contain organization-specific values: No
Category Entries:
Primary
Transitional
Adolescent
Adult
17 OWNER_PROV_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.
18 TREAT_DEPT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
19 ORTHO_READY_TX_YN VARCHAR No
This item stores whether the patient is ready for treatment in this episode. The item is documented as part of the patient's comprehensive exam. If left blank, then a clinical decision has not yet been made.
May contain organization-specific values: No
Category Entries:
No
Yes
20 ORTHO_TX_PHASE INTEGER No
This is the treatment phase for the orthodontic treatment.
21 ORTHO_COMP_SCORE_C_NAME VARCHAR No
This is the compliance score for an orthodontic episode.
May contain organization-specific values: No
Category Entries:
Poor
Fair
Good
Excellent
22 HYG_ORTHO_COMP_SCORE_C_NAME VARCHAR No
This is the hygiene score for an orthodontic episode.
The category values for this column were already listed for column: ORTHO_COMP_SCORE_C_NAME