Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Charge_ABN_Status
Touchworks 25.2
[dbo].[Charge_ABN_Status]
MS_Description
Charge Advanced Beneficiary Nofification Status
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ChargeID
[dbo].[uniqueid]
9
NOT NULL
Charge ID. Link to Charge.ID
ABNIntermediateStatusDE
[dbo].[dict_id]
5
NOT NULL
(0)
ABN Intermediate Status . Link to ABN_Intermediate_Status_DE.ID
LMRP
int
4
NOT NULL
(0)
Local Medical Necessity Review Policy
PolicyNo
[dbo].[uniqueid]
9
NOT NULL
(0)
Policy Number
ICD9DiagnosisDEList
varchar(255)
255
NOT NULL
('')
List of ICD9 Diagnosis Dictionary IDs separated by '~'.
ICD10DiagnosisDEList
varchar(255)
255
NULL allowed
List of ICD10 Diagnosis Dictionary IDs separated by '~'.
ICD9DiagnosisCodeList
varchar(400)
400
NULL allowed
List of ICD9 Diagnosis codes separated by ','.
ICD10DiagnosisCodeList
varchar(400)
400
NULL allowed
List of ICD10 Diagnosis codes separated by ','.