ARPB_TX_DENT_TOOTH

Description:

The DENTAL_TOOTH table contains tooth information. Since one transaction may be associated with multiple teeth, each row in this table represents one tooth code and is identified by the transaction ID (TX_ID) and tooth line number (TOOTH_NUMBER).

Primary Key

Column Name	Ordinal Position
TX_ID	1
TOOTH_LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction record.
2	TOOTH_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_NUM_C_NAME	VARCHAR	No
	The tooth number category ID for the charge. May contain organization-specific values: No Category Entries: Tooth 1 Tooth 2 Tooth 3 Tooth 4 Tooth 5 Tooth 6 Tooth 7 Tooth 8 Tooth 9 Tooth 10 Tooth 11 Tooth 12 Tooth 13 Tooth 14 Tooth 15 Tooth 16 Tooth 17 Tooth 18 Tooth 19 Tooth 20 Tooth 21 Tooth 22 Tooth 23 Tooth 24 Tooth 25 Tooth 26 Tooth 27 Tooth 28 Tooth 29 Tooth 30 Tooth 31 Tooth 32 Tooth A Tooth B Tooth C Tooth D Tooth E Tooth F Tooth G Tooth H Tooth I Tooth J Tooth K Tooth L Tooth M Tooth N Tooth O Tooth P Tooth Q Tooth R Tooth S Tooth T Tooth 18 (FDI) Tooth 17 (FDI) Tooth 16 (FDI) Tooth 15 (FDI) Tooth 14 (FDI) Tooth 13 (FDI) Tooth 12 (FDI) Tooth 11 (FDI) Tooth 21 (FDI) Tooth 22 (FDI) Tooth 23 (FDI) Tooth 24 (FDI) Tooth 25 (FDI) Tooth 26 (FDI) Tooth 27 (FDI) Tooth 28 (FDI) Tooth 38 (FDI) Tooth 37 (FDI) Tooth 36 (FDI) Tooth 35 (FDI) Tooth 34 (FDI) Tooth 33 (FDI) Tooth 32 (FDI) Tooth 31 (FDI) Tooth 41 (FDI) Tooth 42 (FDI) Tooth 43 (FDI) Tooth 44 (FDI) Tooth 45 (FDI) Tooth 46 (FDI) Tooth 47 (FDI) Tooth 48 (FDI) Tooth 55 (FDI) Tooth 54 (FDI) Tooth 53 (FDI) Tooth 52 (FDI) Tooth 51 (FDI) Tooth 61 (FDI) Tooth 62 (FDI) Tooth 63 (FDI) Tooth 64 (FDI) Tooth 65 (FDI) Tooth 75 (FDI) Tooth 74 (FDI) Tooth 73 (FDI) Tooth 72 (FDI) Tooth 71 (FDI) Tooth 81 (FDI) Tooth 82 (FDI) Tooth 83 (FDI) Tooth 84 (FDI) Tooth 85 (FDI) Tooth UR8 (Palmer) Tooth UR7 (Palmer) Tooth UR6 (Palmer) Tooth UR5 (Palmer) Tooth UR4 (Palmer) Tooth UR3 (Palmer) Tooth UR2 (Palmer) Tooth UR1 (Palmer) Tooth UL1 (Palmer) Tooth UL2 (Palmer) Tooth UL3 (Palmer) Tooth UL4 (Palmer) Tooth UL5 (Palmer) Tooth UL6 (Palmer) Tooth UL7 (Palmer) Tooth UL8 (Palmer) Tooth LL8 (Palmer) Tooth LL7 (Palmer) Tooth LL6 (Palmer) Tooth LL5 (Palmer) Tooth LL4 (Palmer) Tooth LL3 (Palmer) Tooth LL2 (Palmer) Tooth LL1 (Palmer) Tooth LR1 (Palmer) Tooth LR2 (Palmer) Tooth LR3 (Palmer) Tooth LR4 (Palmer) Tooth LR5 (Palmer) Tooth LR6 (Palmer) Tooth LR7 (Palmer) Tooth LR8 (Palmer) Tooth URE (Palmer) Tooth URD (Palmer) Tooth URC (Palmer) Tooth URB (Palmer) Tooth URA (Palmer) Tooth ULA (Palmer) Tooth ULB (Palmer) Tooth ULC (Palmer) Tooth ULD (Palmer) Tooth ULE (Palmer) Tooth LLE (Palmer) Tooth LLD (Palmer) Tooth LLC (Palmer) Tooth LLB (Palmer) Tooth LLA (Palmer) Tooth LRA (Palmer) Tooth LRB (Palmer) Tooth LRC (Palmer) Tooth LRD (Palmer) Tooth LRE (Palmer)