ARPB_TX_DENTAL

Description:

This table is used for dental related transaction information.

Primary Key

Column Name	Ordinal Position
TX_ID	1

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction record.
2	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)
3	ARCH_C_NAME	VARCHAR	No
	Displays the dental arch used for the procedure. The value displayed will be either Upper or Lower. May contain organization-specific values: No Category Entries: Lower Upper
4	QUADRANT_C_NAME	VARCHAR	No
	Displays the dental quadrant used for the procedure. The value displayed could be one of several options, such as Lower Left or Maxillary Area. May contain organization-specific values: No Category Entries: Lower Left Lower Right Upper Left Upper Right Whole Oral Cavity Maxillary Area Mandibular Area Upper Right Sextant Upper Anterior Sextant Upper Left Sextant Lower Left Sextant Lower Anterior Sextant Lower Right Sextant
5	AREA	VARCHAR	No
	Displays the dental area used for the procedure. The displayed value will be a range of teeth. For example 1-2,10-B, or A-B.
6	SUPERNUMERARY_YN	VARCHAR	No
	Indicates whether multiple teeth are present in the socket. May contain organization-specific values: No Category Entries: Yes No
7	FOLLOW_UP_MONTHS	INTEGER	No
	The number of months after which this procedure requires follow-up.
8	HYGIENIST_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
9	TREATMENT_PLAN_ID	VARCHAR	No
	The unique ID of the treatment plan used in this procedure.
10	FOLLOW_UP_DATE	DATETIME	No
	Displays the date the recall must be made by.
11	DENTAL_CHG_TYPE_C_NAME	VARCHAR	No
	Indicates what type of orthodontic or predetermination charge it is. May contain organization-specific values: No Category Entries: Visit Charge Periodic Charge Initial Charge Predetermination Charge Banding Charge
12	DENTAL_PREAUTH_AMT	NUMERIC	No
	The amount that gets set on predetermination claims for the predetermination dental charge.
13	DENTAL_PREAUTH_QTY	INTEGER	No
	The quantity that gets set on predetermination claims for the predetermination dental charge.
14	CHARGING_PLAN_LINE	INTEGER	No
	The line of the dental charging plan that led to the charge being dropped.