AP_CLM_PX_TOOTH
Description:
This table contains the teeth and tooth surfaces associated with AP claim service lines.
To link this table’s service line information back to a claim header, join this table to AP_CLAIM_PROC_IDS on the TX_ID column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the TX_ID column.

Primary Key
Column Name Ordinal Position
TX_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TX_ID NUMERIC No
The unique ID of the AP Claim procedure transaction.
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_SURFACE_C_NAME VARCHAR No
Stores the category identifier for the tooth surface worked on for this AP Claim procedure.
May contain organization-specific values: No
Category Entries:
B - Buccal
D - Distal
F - Facial
I - Incisal
L - Lingual
M - Mesial
O - Occlusal
4 TOOTH_CODE_C_NAME VARCHAR No
Stores the category identifier for the tooth worked on for this AP Claim procedure.
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