Harini1100
New Member
- Joined
- Mar 5, 2024
- Messages
- 21
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
Please help with simple formula,
I need last message date and Message which is nothing but in (06/21/2024 - Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.) in the entire cloumn J & K
I need last message date and Message which is nothing but in (06/21/2024 - Claim/service lacks information or has submission/billing error(s) which is needed for adjudication.) in the entire cloumn J & K
Account# | Service Date | Plc of Serv | CPT | Tr# | Amount | Balance | Msg Date | Message |
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 2100 | 2100 | ||
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 2/20/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. | ||
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 3/29/2024 | DOS 01/25/2024; A corrected claim was submitted to UHC on 03/07/2024. To confirm if the claim has been received by insurance checked in UHC portal found that the claim was processed on 03/13/2024 and is in pending for medical records. Uploaded the medical records through portal. Therefore need to follow-up after 10 days. Claim# 01610800. Ticket# PIQ-47969856. *Need Medical Records*MR/Appeal Uploaded Via Portal*Aging. | ||
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 5/3/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. | ||
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 5/3/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. | ||
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 5/8/2024 | AR UHS denied as Claim/service lacks information or has submission/billing error(s) which is needed for adjudication as upon checking patient eob claim is denied for missing procedure modifier therefore raised a ticket a to office need to followup.TFL 90 days* Coding_Modifier*Escalated*Denials | ||
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 5/13/2024 | AR UHC1 denied as required modifier -As per task response from office added JZ modifier for the CPT code J9035 and refiled as a corrected claim TFL 90 days *Coding_Modifier*Billed corrected claim*Denials | ||
18332/1 | 1/25/2024 | AA | J0178 | 1339380 | 6/4/2024 | The documentation that was received was the incorrect attachment/document. | ||
18332/1 | 4/4/2024 | AA | J0178 | 1354614 | 2100 | 2100 | ||
18332/1 | 4/4/2024 | AA | J0178 | 1354614 | 6/4/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. | ||
18332/1 | 4/4/2024 | AA | J0178 | 1354614 | 6/19/2024 | AR- DOS-04/04/2024-CPT code J0178 got denied because of the missing modifier as enquired earlier to rep rep stated to add JZ/JW therefore to get correct modifier tasking to client TFL 90 days. Claim#KEN0532258200.*Coding_Modifier* Sent For Coding*Aging | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 2100 | 2100 | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 4/30/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 4/30/2024 | AR-UHC denied the claim as Coverage/program guidelines were not met for CPT 67028 and J0178 got denied as procedure modifier is missing so added task to office for CPT J0178 and for 67028 if the J code get's paid they will process the CPT code 67028 TFL 90 days*Coding_Modifier*Escalated*Denials | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 5/1/2024 | AR-As per task response from added Modifier JZ for CPT J0178 and for CPT 67028 they will process the CPT if the J code get's paid and refiled as corrected claim TFL 90 days from DOS*Coding_Modifier*Billed corrected claim*Others | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 5/21/2024 | AR UHS No response so called @ 8006383120 S/w ANA stated that claim is received 05/02/2024 and denied because the procedure code needs auth to get processed therefore raised a task to client need to followup TFL 90 days * Authorization* Escalated* No Response | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 5/24/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 5/24/2024 | Pre-certification/authorization/notification absent. | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 6/19/2024 | AR- DOS-04/11/2024-UHC- claim denied for J0178 67028 CPT codes to get more clarity on denials called UHC @ S/W ALVIN S. rep stated that the corrected claim received on 05/31/2024 and denied on 06/14/2024 stating J0178 need JZ/JW modifier therefore tasking to client for correct modifier T UHC TFL 12 months for In Network and 60 days for Out network. Claim#11765507.call ref#69981497.*Coding_Modifier*Billed corrected claim*Aging | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 6/20/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. | ||
18332/1 | 4/11/2024 | AA | J0178 | 1356072 | 6/21/2024 | Claim/service lacks information or has submission/billing error(s) which is needed for adjudication. |