Tables [dbo].[Charge_ABN_Status]
Charge Advanced Beneficiary Nofification Status
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key cix_Charge_ABN_Status_ChargeIDABNIntermediateStatusDE: ChargeID\ABNIntermediateStatusDEForeign Keys FK_Charge_ABN_Status_ChargeID: [dbo].[Charge].ChargeIDChargeID[dbo].[uniqueid]9NOT NULLCharge ID. Link to Charge.ID
Cluster Key cix_Charge_ABN_Status_ChargeIDABNIntermediateStatusDE: ChargeID\ABNIntermediateStatusDEIndexes TWstat_Charge_ABN_Status_ABNIntermediateStatusDEForeign Keys FK_Charge_ABN_Status_ABNIntermediateStatusDE: [dbo].[ABN_Intermediate_Status_DE].ABNIntermediateStatusDEABNIntermediateStatusDE[dbo].[dict_id]5NOT NULL(0)ABN Intermediate Status . Link to ABN_Intermediate_Status_DE.ID
Indexes TWstat_Charge_ABN_Status_LMRPLMRPint4NOT NULL(0)Local Medical Necessity Review Policy
PolicyNo[dbo].[uniqueid]9NOT NULL(0)Policy Number
ICD9DiagnosisDEListvarchar(255)255NOT NULL('')List of ICD9 Diagnosis Dictionary IDs separated by '~'.
ICD10DiagnosisDEListvarchar(255)255NULL allowedList of ICD10 Diagnosis Dictionary IDs separated by '~'.
ICD9DiagnosisCodeListvarchar(400)400NULL allowedList of ICD9 Diagnosis codes separated by ','.
ICD10DiagnosisCodeListvarchar(400)400NULL allowedList of ICD10 Diagnosis codes separated by ','.