Tables [dbo].[Charge_ABN]
Charge Advanced Beneficiary Nofification
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Charge_ABN_ChargeID_ID: ChargeID\IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Charge_ABN table.
Cluster Primary Key PK_Charge_ABN_ChargeID_ID: ChargeID\IDChargeID[dbo].[uniqueid]9NOT NULLCharge ID. Link to Charge.ID
Indexes TWstat_Charge_ABN_StatusCodeDEForeign Keys FK_Charge_ABN_StatusCodeDE_ABN_Intermediate_Status_DE_ID: [dbo].[ABN_Intermediate_Status_DE].StatusCodeDEStatusCodeDE[dbo].[dict_id]5NOT NULLABN Intermediate Status . Link to ABN_Intermediate_Status_DE.ID
Textvarchar(500)500NOT NULL('')Frequency Question
Answerchar(1)1NOT NULL('')Answer to the question Y or N
Indexes TWstat_Charge_ABN_LMRPLMRPint4NOT NULL(0)Local Medical Necessity Review Policy
Indexes TWstat_Charge_ABN_Record_KeyRecord_Keyint4NOT NULL(0)Policy Number
Check Constraints CK_Charge_ABN_IsAnswerCorrectFLAG_Yes_Or_No : ([IsAnswerCorrectFLAG]='N' OR [IsAnswerCorrectFLAG]='Y')IsAnswerCorrectFLAG[dbo].[BOOL]1NOT NULL('N')Is Answer to the question Correct ?
Indexes TWstat_Charge_ABN_TypeTypechar(1)1NOT NULL('Q')Advanced Beneficiary Nofification Message Type
F - Frequency Question
Q - Question  
C - Covered Viewed  
X - Non-Covered Viewed
Y - Non-Covered Diagnosis
S - ABN Status
A - CPTAppendedCode
N - Narrative
ABNStatuschar(1)1NOT NULL('X')Advanced Beneficiary Nofification Status.
O - ABN Not Obtained
X - No ABN status
A - Signed and Accepts
R - Signed and Refuses
N - Not Signed
CPTAppendedCodesmallint2NOT NULL(0)CPT Appended Code . Default '0'
ItemTypevarchar(20)20NOT NULL('C')Item Type
C  - Charge
PL - Order
ME - Medication
IM - Immunization
CPT4Codevarchar(10)10NULL allowed('')Current Procedural Terminology Code