HSP_BDC_DENIAL_DATA

Description:

This table contains denial information stored in the Denial/Remark/Correspondence records in the Denial/Correspondence (BDC) master file. There can be multiple lines of data for each record. Each line represents one claim/explanations of benefits (EOB) line that was denied.

Primary Key

Column Name	Ordinal Position
BDC_ID	1
LINE_COUNT	2

Column Information

	Name	Type	Discontinued?
1	BDC_ID	NUMERIC	No
	This column stores the unique identifier for the denial or correspondence record.
2	LINE_COUNT	INTEGER	No
	Line number of denial data. There can be multiple lines of denial data and this is the number of the line that enterprise reporting is extracting.
3	LINE_ON_EOB	INTEGER	No
	This column stores the line on explanation of benefits that was denied. "-1" represents the total denial data that is the sum of the invoice-level and sum of line-level data. "0" represents the invoice-level data.
4	LINE_BILLED_AMOUNT	NUMERIC	No
	Billed amount on the claim line that was denied. If the denial was at the invoice level - this is the billed amount for the entire claim
5	LINE_ALLWD_AMT	NUMERIC	No
	Allowed amount for claim line that was denied. If the denial was for the entire invoice this is the allowed amount for the entire claim.
6	LINE_PAID_AMT	NUMERIC	No
	This column stores the amount paid for the line that was denied. $0.00 if fully denied, >0 if partially denied. If the denial was for the entire invoice then this is the amount paid for the entire claim.
7	LINE_DENIED_AMT	NUMERIC	No
	Denied amount for claim line that was denied. If the denial is for the entire invoice then this is the denied amount for the claim.
8	LINE_COMMENTS	VARCHAR	No
	This column stores comments on explanation of benefits for denied line.
9	LINE_REVENUE_CODE_ID	NUMERIC	No
	This column stores the unique identifier for the line-level revenue code for the denial.
10	LINE_REVENUE_CODE_ID_REVENUE_CODE_NAME	VARCHAR	No
	The name of the revenue code.
11	LINE_CPT_CODE	VARCHAR	No
	This item stores the line-level CPT(R) code for the denial.
12	LINE_PRIMARY_CHARGE_TX_ID	NUMERIC	No
	Charge with the greatest amount from the claim line that was denied. If two charges have the same amount the older one will be the primary charge.
13	LINE_SERVICE_DATE	DATETIME	No
	The line level service date of the denial.
14	LINE_QUANTITY	NUMERIC	No
	The line level quantity for the denied line.