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