Skip to main content

line_item_tooth

Provides information about the status of individual teeth

Primary Key:Foreign Keys:
ColumnData TypeNullableIndexedDescription
line_item_idbigintNoYesLink to the line item record.

Generated through expression: 
tooth_code_qualifiercode_list_qualifier_typeYesNoIdentifies the code list used to identify the tooth. Typically this is 'JP' which is the American Dental Association 'Universal National Tooth Designation System' (from TOO01)

Generated through expression: 
tooth_codetextNoYesAmerican Dental Association 'Universal National Tooth Designation System' to report an individual tooth (from TOO02)

Generated through expression: 
surfacestooth_surface_type[]NoNoIdentifies the areas of the tooth that were treated (from TOO03)

Generated through expression: