DENT_EOB_INFO
Description:
This table contains explanation of benefits (EOB) information for the dental treatment plan.

Primary Key
Column Name Ordinal Position
TREATMENT_PLAN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 TREATMENT_PLAN_ID VARCHAR No
The unique identifier for the treatment plan 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 EOB_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
4 EOB_AUTH_NUM VARCHAR No
The authorization number of the Explanation of Benefits (EOB) information.
5 EOB_AUTH_DATE DATETIME No
The date when the payor sent Explanation of Benefits authorization.
6 EOB_TOTAL_AMOUNT NUMERIC No
The total EOB amount.
7 EOB_COVERED_AMOUNT NUMERIC No
The covered amount of the EOB information.
8 EOB_ENTRY_DATE DATETIME No
The date when the Explanation of Benefits information was entered in the system.
9 EOB_DELETED_YN VARCHAR No
Indicates whether a EOB information is deleted for the dental treatment plan. Y indicates that the EOB information is deleted. N or a null value indicates that EOB information is not deleted.
May contain organization-specific values: No
Category Entries:
Yes
No
10 EOB_ENTRY_USER_ID VARCHAR No
The unique ID of the user record who entered the Explanation of Benefits information. This column is frequently used to link to the CLARITY_EMP table.
11 EOB_ENTRY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 EOB_ENTRY_TIME DATETIME No
The time when EOB information was entered in the system.
13 EOB_DEL_USER_ID VARCHAR No
The unique ID of the user record who deleted the Explanation of Benefits information. This column is frequently used to link to the CLARITY_EMP table.
14 EOB_DEL_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
15 EOB_DEL_DATE DATETIME No
The date when the Explanation of Benefits information was deleted from the system.
16 EOB_DEL_TIME DATETIME No
The date when EOB information was entered in the system.