Tables [dbo].[Order_ABN_Status]
Medical Necessity status for an Order
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key ix_order_abn_status_ItemID_ABNIntermediateStatusDE: ItemID\ABNIntermediateStatusDEItemID[dbo].[uniqueid]9NOT NULLOrder. Link to Item_Plan.ID, Item_Medication.ID, or Item_Immunization.ID
Cluster Key ix_order_abn_status_ItemID_ABNIntermediateStatusDE: ItemID\ABNIntermediateStatusDEForeign Keys FK_ORder_ABN_Status_ABNIntermediateStatusDE: [dbo].[ABN_Intermediate_Status_DE].ABNIntermediateStatusDEABNIntermediateStatusDE[dbo].[dict_id]5NOT NULL(0)Status. Link to ABN_Intermediate_Status_DE.ID
LMRPint4NOT NULL(0)Local medical Review policy. Link to AHSCharge.dbo.LMRP.ID
PolicyNo[dbo].[uniqueid]9NOT NULL(0)Policy Number
ICD9DiagnosisDEListvarchar(255)255NOT NULL('')List of ICD9 Diagnosis Dictionary IDs seperated by '~'. Link to dbo.ICD9_Diagnosis_DE.ID
CPT4Codevarchar(10)10NULL allowedCurrent Procedural Terminology code
Check Constraints Ch_Order_ABN_Status_ItemType : ([ItemType]='IM' OR [ItemType]='ME' OR [ItemType]='PL')ItemTypechar(2)2NULL allowed('PL')IM - Immunization, ME - Medication, PL - Order
ICD10DiagnosisDEListvarchar(255)255NULL allowedList of ICD10 Diagnosis Dictionary IDs seperated by '~'. Link to dbo.ICD10_Diagnosis_DE.ID
ICD9DiagnosisCodeListvarchar(400)400NULL allowedList of ICD9 Diagnosis Codes seperated by ','. Link to dbo.ICD9_Diagnosis_DE.EntryCode.
ICD10DiagnosisCodeListvarchar(400)400NULL allowedList of ICD10 Diagnosis Codes seperated by ','. Link to dbo.ICD10_Diagnosis_DE.EntryCode.