PR_EST_PX_CVG_ADDL_INFO

Description: |
Contains additional coverage related information for each procedure in a price estimate.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ESTIMATE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ESTIMATE_ID | NUMERIC | No |
The unique identifier for the patient estimate 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 | PX_CVG_ADDL_LINE_NUM | INTEGER | No |
This item holds a line number of the additional charge info items related group.
4 | PX_CVG_FO_NUM | INTEGER | No |
The coverage level associated with the corresponding coverage (I PES 168).
5 | IS_NON_COVERED_YN | VARCHAR | No |
This indicates whether a line of an estimate is covered/non-covered.
May contain organization-specific values: No
Category Entries:
No
Yes
6 | INS_ALLOW_AMT | NUMERIC | No |
This is the insurance allowed amount of the current service line.
7 | INS_PAID_AMT | NUMERIC | No |
This is the insurance paid amount of the current service line.
8 | DENTAL_DGRADE_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
9 | DENTAL_DGRADE_ALLW_AMT | NUMERIC | No |
The allowed amount of the downgraded procedure for a given procedure line and coverage.
10 | SYS_INS_PAID_AMT | NUMERIC | No |
This item stores the system-calculated insurance paid amount of the current service line.
11 | DENTAL_UPGRADE_AMOUNT | NUMERIC | No |
Upgrade charge amount for given procedure line and coverage.