Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Medical_Necessity_Log
Touchworks 25.2
[dbo].[Medical_Necessity_Log]
MS_Description
Medical Necessity Checking log
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Enconter.ID
ItemID
[dbo].[uniqueid]
9
NOT NULL
Item. Link to Item_Plan.ID, Charge.ID, Item_Medication.ID, or Item_Immunization.ID
ItemType
varchar(20)
20
NOT NULL
Type of Item. C - Charge, PL - Order, ME - Medication, IM - Immunization
CheckDTTM
datetime
8
NOT NULL
Time of check
CPT4Code
varchar(10)
10
NOT NULL
CPT4 Code (charge code)
ICD9DEList
varchar(255)
255
NOT NULL
Diagnosis List. Comma separated list of ICD9_Diagnosis_DE.ID entries
LMRP
int
4
NOT NULL
Local Medical Review Policy. This determines the rule set
ChargeStatusDE
[dbo].[dict_id]
5
NOT NULL
Calculated Charge Status. Link to Charge_Status_DE.ID
ABNIntermediateStatusDEList
varchar(255)
255
NOT NULL
ABN (Advanced Beneft Notification) Status List. Comma separated list of ABN_Intermediate_Status_DE.ID entries.
ICD10DiagnosisDEList
varchar(255)
255
NULL allowed
Diagnosis List.Comma separated list of ICD10_Diagnosis_DE.ID entries