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