AP_CLM_TOOTH_STAT
Description:
This table is for the status of teeth for claims with dental information.

Primary Key
Column Name Ordinal Position
CLAIM_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 CLAIM_ID NUMERIC No
The unique identifier for the claim 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 TOOTH_STATUS_C_NAME VARCHAR No
This is the status of the tooth.
May contain organization-specific values: No
Category Entries:
E - To Be Extracted
M - Missing
I - Impacted
4 TOOTH_CODE_C_NAME VARCHAR No
The tooth code for the tooth whose status is reported in the claim.
May contain organization-specific values: No
Category Entries:
Permanent maxillary right third molar
Permanent maxillary right second molar
Permanent maxillary right first molar
Permanent maxillary right second premolar
Permanent maxillary right first premolar
Permanent maxillary right canine
Permanent maxillary right lateral incisor
Permanent maxillary right central incisor
Permanent maxillary left central incisor
Permanent maxillary left lateral incisor
Permanent maxillary left canine
Permanent maxillary left first premolar
Permanent maxillary left second premolar
Permanent maxillary left first molar
Permanent maxillary left second molar
Permanent maxillary left third molar
Permanent mandibular left third molar
Permanent mandibular left second molar
Permanent mandibular left first molar
Permanent mandibular left second premolar
Permanent mandibular left first premolar
Permanent mandibular left canine
Permanent mandibular left lateral incisor
Permanent mandibular left central incisor
Permanent mandibular right central incisor
Permanent mandibular right lateral incisor
Permanent mandibular right canine
Permanent mandibular right first premolar
Permanent mandibular right second premolar
Permanent mandibular right first molar
Permanent mandibular right second molar
Permanent mandibular right third molar
Permanent supernumerary 1
Permanent supernumerary 2
Permanent supernumerary 3
Permanent supernumerary 4
Permanent supernumerary 5
Permanent supernumerary 6
Permanent supernumerary 7
Permanent supernumerary 8
Permanent supernumerary 9
Permanent supernumerary 10
Permanent supernumerary 11
Permanent supernumerary 12
Permanent supernumerary 13
Permanent supernumerary 14
Permanent supernumerary 15
Permanent supernumerary 16
Permanent supernumerary 17
Permanent supernumerary 18
Permanent supernumerary 19
Permanent supernumerary 20
Permanent supernumerary 21
Permanent supernumerary 22
Permanent supernumerary 23
Permanent supernumerary 24
Permanent supernumerary 25
Permanent supernumerary 26
Permanent supernumerary 27
Permanent supernumerary 28
Permanent supernumerary 29
Permanent supernumerary 30
Permanent supernumerary 31
Permanent supernumerary 32
Primary maxillary right second molar
Primary maxillary right first molar
Primary maxillary right canine
Primary maxillary right lateral incisor
Primary maxillary right central incisor
Primary maxillary left central incisor
Primary maxillary left lateral incisor
Primary maxillary left canine
Primary maxillary left first molar
Primary maxillary left second molar
Primary mandibular left second molar
Primary mandibular left first molar
Primary mandibular left canine
Primary mandibular left lateral incisor
Primary mandibular left central incisor
Primary mandibular right central incisor
Primary mandibular right lateral incisor
Primary mandibular right canine
Primary mandibular right first molar
Primary mandibular right second molar
Primary supernumerary A
Primary supernumerary B
Primary supernumerary C
Primary supernumerary D
Primary supernumerary E
Primary supernumerary F
Primary supernumerary G
Primary supernumerary H
Primary supernumerary I
Primary supernumerary J
Primary supernumerary K
Primary supernumerary L
Primary supernumerary M
Primary supernumerary N
Primary supernumerary O
Primary supernumerary P
Primary supernumerary Q
Primary supernumerary R
Primary supernumerary S
Primary supernumerary T