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	NUMERIC	No
	The procedure to which a given line is downgraded for a specific coverage.
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.