|
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 |
|
|
|
|
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 |
|
|
|
|
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. |
|
|