|
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 |
|
|