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.