BDC_INFO
Description:
This table contains Denial/Remark/Correspondence/Variance information from the Denial/Correspondence (BDC) master file. It includes information about the denial/remark code received or correspondence text as applicable. It also includes some general information about the current state of the record. It does not include the change history information and specific denial information from the explanation of benefits (EOB).

Primary Key
Column Name Ordinal Position
BDC_ID 1

Column Information
Name Type Discontinued?
1 BDC_ID NUMERIC No
The unique identifier for the denial/correspondence record.
2 BDC_NAME VARCHAR No
BDC Record Name - Denial/Remark/Correspondence Record Name.
3 RECORD_TYPE_C_NAME VARCHAR No
The record type category ID for the Denial/Remark/Correspondence.
May contain organization-specific values: No
Category Entries:
Denial
Remark
Correspondence
Underpayment
Overpayment
Payer Follow-Up
4 BUCKET_ID NUMERIC No
The Hospital Liability Bucket that the Denial/Remark/Correspondence record is linked to.
5 RECORD_STATUS_C_NAME VARCHAR No
The status category ID for the Denial/Remark/Correspondence.
May contain organization-specific values: Yes
Category Entries:
Created
Transferred
Documents Need Review
Documents Created
Documents Sent
Reopened
Completed
Voided
6 RECORD_SOURCE_C_NAME VARCHAR No
The source category ID for the Denial/Remark/Correspondence.
May contain organization-specific values: Yes
Category Entries:
Payment Received
Correspondence Received
Zero Allowed Amount
Expected Allowed Amount Updated
Reserved for future use
System Auto Action
PB Follow-up Automatic Activity
RAC Correspondence
ADR Correspondence
HH Pre-Claim Review
Transferred In
7 CLAIM_PRINT_ID NUMERIC No
The ID of the claim print record for the invoice of the denied payment.
8 INVOICE_NUMBER VARCHAR No
The invoice number associated with this denial/correspondence.
9 GRP_CODE_C_NAME VARCHAR No
This item holds the group code associated with the reason code in a denial correspondence record.
May contain organization-specific values: Yes
Category Entries:
Patient Responsibility
Contractual Obligation
Payor Initiated
Correction and Reversal
Other Adjustment
10 REMIT_CODE_ID VARCHAR No
The unique ID of the remittance code associated with the record.
11 REMIT_CODE_ID_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
12 EXTERNAL_CODE VARCHAR No
The external ID of the remittance code associated with this denial/correspondence.
13 INV_END_DATE DATETIME No
Ending Date on the invoice linked to the denial/remark.
14 SOURCE_PMT_HB_TX_ID NUMERIC No
ID of the Hospital Billing payment transaction that the denial/remark was linked to.
15 EXP_ALLOW_AMT NUMERIC No
Expected allowed amount on denial/remark/correspondence record.
16 RESOLVE_REASON_C_NAME VARCHAR No
Resolution Category for Denial/Remark/Correspondence if it has been resolved.
May contain organization-specific values: Yes
Category Entries:
Auto-Closed
No Outstanding Insurance Balance
Claim Resubmitted
PB Charges Voided
PB Charges Reposted
PB Payment Undistributed
PB Original Follow-up Completed
Variance Type Changed
Documents Sent
17 RESOLVE_COMMENTS VARCHAR No
Comments entered with resolution category.
18 BDC_RECEIVE_DATE DATETIME No
The date the Denial/Remark/Correspondence was received.
19 BDC_COMPLETE_VOID_DATE DATETIME No
The date the Denial/Remark/Correspondence record was completed or voided.
20 BDC_REOPEN_DATE DATETIME No
The date the Denial/Remark/Correspondence record was re-opened after being completed.
21 PB_INVOICE_ID NUMERIC No
The professional invoice associated with the denial/correspondence record.
22 GUARANTOR_ID NUMERIC No
The unique ID of the guarantor associated with the denial/correspondence record.
23 DOC_INFO_ID VARCHAR No
The unique ID of the document that is associated with the denial/correspondence record.
24 WRITE_OFF_AMT_SYS NUMERIC No
The write off amount calculated by the system.
25 WRITE_OFF_AMT_CALC NUMERIC No
The write off amount entered by the user. If that is blank, this is the write off amount calculated by the system.
26 DISCREPANCY_AMT_SYS NUMERIC No
The difference between the expected allowed amount on the correspondence record and the actual allowed amount.
27 CLM_EXT_VAL_ID NUMERIC No
The Claim External Value ID of the Claim Print ID that was denied.
28 BILLING_DRG VARCHAR No
This item stores the billing DRG sent on the claim or coded on the account. The billing DRG is looked up first from the claim and then from the account. It can be manually overridden.
29 PAYER_RECOMMENDED_DRG VARCHAR No
The user recorded payer recommended DRG from the payment that created the follow-up record.
30 FINAL_RESOLUTION_DRG VARCHAR No
The user recorded final resolution DRG.
31 EXPECTED_RECOVERY_AMT NUMERIC No
This item contains the amount of the expected payment as a result of resubmitting the claim associated with this denial.
32 ACTUAL_RECOVERY_AMT_USER NUMERIC No
This item contains the amount actually paid as a result of resubmitting the claim associated with this denial. This can be overridden.
33 WRITE_OFF_AMT_USER NUMERIC No
This item contains the amount of this denial that was written off.
34 EXT_PAT_NAME VARCHAR No
This item is used to record the patient name if the record of the patient is in an external system.
35 EXT_PAT_MRN VARCHAR No
This item is used to record the patient's medical record number if the record of the patient is in an external system.
36 EXT_ADMIT_DATE DATETIME No
This item is used to record the patient admit date if the record of the patient is in an external system.
37 EXT_DISCHARGE_DATE DATETIME No
This item is used to record the patient discharge date if the record of the patient is in an external system.
38 EXT_CLAIM_NUM VARCHAR No
This item is used to record the claim number if the record of the patient is in an external system.
39 EXT_PAT_BIRTH_DATE DATETIME No
This item is used to record the patient's date of birth if the record of the patient is in an external system.
40 SOURCE_PMT_PB_TX_ID NUMERIC No
Professional Billing payment transaction which led to denial/correspondence record creation.
41 DFLT_CLASS_USES_REMARK_CODE_ID VARCHAR No
Stores the highest priority associated remark code for denials if this remark was used to get default classification items. Default classification items include priority, preventable, owning area, source area, and code category.
42 DFLT_CLASS_USES_REMARK_CODE_ID_REMIT_CODE_NAME VARCHAR No
The name of each remittance code.
43 APPEAL_DEADLINE_DATE DATETIME No
This item stores the initial appeal deadline at the moment the BDC is created.
44 PAYER_DOWNGRADE_TYPE_C_NAME VARCHAR No
The type of downgrade requested via this BDC when the primary payer tries to dispute the level of care of the HAR.
May contain organization-specific values: No
Category Entries:
No Downgrade
Inpatient to Observation
45 PAYER_DOWNGRADE_OUTCOME_C_NAME VARCHAR No
Whether the primary payer's attempt to lower the level of care of the account via this BDC was appropriate and whether it was overturned or led to a downgrade. This item is null if no such attempt was made by the Primary Payer.
May contain organization-specific values: No
Category Entries:
Appropriate & Downgraded
Inappropriate & Overturned
Inappropriate & Downgraded