Tables [dbo].[Medical_Necessity_Log]
Medical Necessity Checking log
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key cix_Medical_Necessity_Log_EncounterIDItemIDItemType: EncounterID\ItemID\ItemTypeEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Enconter.ID
Cluster Key cix_Medical_Necessity_Log_EncounterIDItemIDItemType: EncounterID\ItemID\ItemTypeItemID[dbo].[uniqueid]9NOT NULLItem. Link to Item_Plan.ID, Charge.ID, Item_Medication.ID, or Item_Immunization.ID
Cluster Key cix_Medical_Necessity_Log_EncounterIDItemIDItemType: EncounterID\ItemID\ItemTypeItemTypevarchar(20)20NOT NULLType of Item. C - Charge, PL - Order, ME - Medication, IM - Immunization
CheckDTTMdatetime8NOT NULLTime of check
CPT4Codevarchar(10)10NOT NULLCPT4 Code (charge code)
ICD9DEListvarchar(255)255NOT NULLDiagnosis List. Comma separated list of ICD9_Diagnosis_DE.ID entries
LMRPint4NOT NULLLocal Medical Review Policy. This determines the rule set
ChargeStatusDE[dbo].[dict_id]5NOT NULLCalculated Charge Status. Link to Charge_Status_DE.ID
ABNIntermediateStatusDEListvarchar(255)255NOT NULLABN (Advanced Beneft Notification) Status List. Comma separated list of ABN_Intermediate_Status_DE.ID entries.
ICD10DiagnosisDEListvarchar(255)255NULL allowedDiagnosis List.Comma separated list of ICD10_Diagnosis_DE.ID entries