DENT_ORTHO_APPLIANCE

Description: |
Includes data for orthodontic appliances.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique identifier (.1 item) for the finding 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 | APPLIANCE_STATUS_C_NAME | VARCHAR | No |
This item stores the status for an orthodontics appliance.
May contain organization-specific values: No
Category Entries:
Ongoing
Completed
Discontinued
Canceled
Planned
5 | APPL_START_DATE | DATETIME | No |
This item stores the start date for an orthodontics appliance.
6 | EST_DURATION | INTEGER | No |
This item stores the estimated duration (in months) for an orthodontics appliance.
7 | REMOVAL_DATE | DATETIME | No |
This item stores the removal date for an orthodontics appliance.
8 | MODIFIED_INST_DTTM | DATETIME (UTC) | No |
History item that tracks every instant an orthodontic appliance has been modified.
9 | MODIFIED_USER_ID | VARCHAR | No |
Stores the user that modified orthodontics appliance data for this history line.
10 | MODIFIED_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | MODIFIED_PAT_ENC_CSN_ID | NUMERIC | No |
Stores the patient CSN where data was modified for this history line.
12 | WEAR_TIME_C_NAME | VARCHAR | No |
This item stores the daily wear time for an orthodontics appliance.
May contain organization-specific values: No
Category Entries:
1 hour/day
2 hours/day
3 hours/day
4 hours/day
5 hours/day
6 hours/day
7 hours/day
8 hours/day
9 hours/day
10 hours/day
11 hours/day
12 hours/day
13 hours/day
14 hours/day
15 hours/day
16 hours/day
17 hours/day
18 hours/day
19 hours/day
20 hours/day
21 hours/day
22 hours/day
23 hours/day
Full time
Nights only
13 | DENT_APP_C_NAME | VARCHAR | No |
This item stores the category for this appliance. This category maps to the LSD-98600 table.
May contain organization-specific values: Yes
Category Entries:
Braces
Clear Aligners
Expander
Headgear
Retainer
Mouth Guard
Facemask
Herbst Appliance
14 | APPLNC_ND_RPL_YN | VARCHAR | No |
This item indicates whether this appliance is broken. This category maps to the ECT-101 table.
May contain organization-specific values: No
Category Entries:
No
Yes
15 | APPLNC_RPL_ARCH_C_NAME | VARCHAR | No |
This item indicates which arch or arches have appliances that need replacement.
May contain organization-specific values: No
Category Entries:
Both
Maxillary Only
Mandibular Only