ABN_NOTES
Description:
The ABN_NOTES table contains information about Advanced Beneficiary Notice note records.

Primary Key
Column Name Ordinal Position
ABN_NOTE_ID 1

Column Information
Name Type Discontinued?
1 ABN_NOTE_ID VARCHAR No
The unique ID of the note (HNO) record that contains the Advance Beneficiary Notice (ABN) information.
2 ABN_STATUS_C_NAME VARCHAR No
The status of the ABN record.
May contain organization-specific values: Yes
Category Entries:
Notice Triggered
Notice Printed
ABN Signed, Service Accepted (Option 1 - Bill Medicare)
ABN Annotated (Patient Refused to Sign)
ABN Void (Order Canceled or Changed, ABN No Longer Applies)
ABN Signed, Service Declined (Option 3)
ABN Refused--Noted on form, Signed by Two Witnesses
ABN Refused--Service Not Performed
ABN Signed, Service Accepted (Option 2 - Do not bill Medicare)
Auto Voided (Order canceled or removed)
Declined to Sign, Pending Follow-up
Diagnoses Reviewed
E-Signed, Document Status Not Updated
Released to Patient Portal
ABN Error--Recreated, Pending Signature
3 USER_ID VARCHAR No
The user who updated the ABN record.
4 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 CREATE_TM DATETIME (Local) No
The time the ABN record was created.
6 INITIAL_USER_ID VARCHAR No
The user who created the ABN record.
7 INITIAL_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 ABN_TEMPLT_C_NAME VARCHAR No
The ABN template used for the ABN form.
May contain organization-specific values: Yes
Category Entries:
English, Provider ABN
Lab ABNs
Spanish, Provider ABN
Non-Participating ABN
Dually Eligible Beneficiaries ABN
E-Signature Template
9 ABN_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
10 ABN_PR_EST VARCHAR No
The estimated price for all procedures listed on the ABN.
11 ABN_COMM_BARRIER_C_NAME VARCHAR No
The communication barrier encountered with the patient involving the ABN.
May contain organization-specific values: Yes
12 ABN_UPDATE_INS_DTTM DATETIME (Local) No
The instant when the ABN was updated.
13 ABN_CMT VARCHAR No
A comment for an ABN.
14 ABN_CHECK_FROM_DATE DATETIME No
Stores the starting date of service for which the ABN checks are performed.
15 ABN_CHECK_TO_DATE DATETIME No
Stores the date till which the ABN checks are performed.
16 ABN_PLAN_ID NUMERIC No
Stores the unique ID of the linked treatment or therapy plan.
17 PAT_CSN NUMERIC No
Stores the contact serial number (CSN) for the telephone encounter used for follow up.
18 REPLACED_ABN_ID VARCHAR No
If this ABN was regenerated from another ABN, this column contains the ID of the original
19 REPLACE_REASON_C_NAME VARCHAR No
The reason that the ABN was regenerated.
May contain organization-specific values: No
Category Entries:
Price Increase
Price Decrease
Department Change (same revenue location)
Department Change (different revenue location)
Procedure or Diagnosis or Order Mismatch (Px or Dx or Ord is now resolved)
Order Released
Order Resolved
Procedure or Order Mismatch (Px or Dx or Ord is now resolved)
ABN Restore Utility