The payment received after query pulls claims that have received a payment after the claim had been written off. When is the Query Worked? Collections receives the payment received after query every ...
The payment received after query pulls claims that have received a payment after the claim had been written off. When is the Query Worked? Collections receives the payment received after query every ...
Claims Coordinator
$22.55/hr
Work the "Payment Received After" query weekly to ensure accurate payment application. * Provide high attention to detail and maintain accurate documentation. Qualifications: * High school diploma or ...
Claims Coordinator
$22.55/hr
Work the "Payment Received After" query weekly to ensure accurate payment application. * Provide high attention to detail and maintain accurate documentation. Qualifications: * High school diploma or ...
Claims Coordinator
$22.55/hr
Work the "Payment Received After" query weekly to ensure accurate payment application. * Provide high attention to detail and maintain accurate documentation. Qualifications: * High school diploma or ...
Quick apply
Claims Coordinator
$22.55/hr
Work the "Payment Received After" query weekly to ensure accurate payment application. * Provide high attention to detail and maintain accurate documentation. Qualifications: * High school diploma or ...
Oracle Database Administrator in Cincinnati, OH
Cincinnati, OH · On-site
$48.75 - $66.25/hr
Perform routine database monitoring, including performance tuning and query optimization ... after regular hours, including on-call assistance.
Quick apply
Oracle Database Administrator in Cincinnati, OH
Cincinnati, OH · On-site
$48.75 - $66.25/hr
Perform routine database monitoring, including performance tuning and query optimization ... after regular hours, including on-call assistance.
Oracle Database Administrator (P)
Cincinnati, OH · On-site
$48.75 - $66.25/hr
Perform routine database monitoring, including performance tuning and query optimization. Configure ... support after regular hours, including on-call assistance. With Best Regards, Pawan Mishra ...
Quick apply
Oracle Database Administrator (P)
Cincinnati, OH · On-site
$48.75 - $66.25/hr
Perform routine database monitoring, including performance tuning and query optimization. Configure ... support after regular hours, including on-call assistance. With Best Regards, Pawan Mishra ...
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... query NPDB • Internationally trained physicians welcome if ABMS certified
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... query NPDB • Internationally trained physicians welcome if ABMS certified
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... query NPDB • Internationally trained physicians welcome if ABMS certified
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... query NPDB • Internationally trained physicians welcome if ABMS certified
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... query NPDB • Internationally trained physicians welcome if ABMS certified
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... query NPDB • Internationally trained physicians welcome if ABMS certified
Utilize SQL, Power BI/Power Query, InfoMaker, Excel, and other related software and programming to ... and immediately after the birth of a child, status as a parent of a young child, status as a ...
Utilize SQL, Power BI/Power Query, InfoMaker, Excel, and other related software and programming to ... and immediately after the birth of a child, status as a parent of a young child, status as a ...
NPDB Self-Query within 30 days Required Credentialing * Fingerprinting required immediately after acceptance
NPDB Self-Query within 30 days Required Credentialing * Fingerprinting required immediately after acceptance
... after cesarean (VBAC) - Repair of 3rd and 4th degree perineal lacerations **Gynecological ... Qualifications:** - Self-query through the National Practitioner Data Bank (NPDB) performed within ...
Quick apply
... after cesarean (VBAC) - Repair of 3rd and 4th degree perineal lacerations **Gynecological ... Qualifications:** - Self-query through the National Practitioner Data Bank (NPDB) performed within ...
Anesthesiology - Pediatrics Physician
Dayton, OH · On-site
$388K/yr
NPDB Self-Query within 30 days Required Credentialing * Fingerprinting required immediately after acceptance
Anesthesiology - Pediatrics Physician
Dayton, OH · On-site
$388K/yr
NPDB Self-Query within 30 days Required Credentialing * Fingerprinting required immediately after acceptance
SQL DBA
Columbus, OH · On-site
$48.25 - $60.25/hr
Perform routine database monitoring, including performance tuning and query optimization. Configure ... after regular hours, including on-call assistance. Thanks & Regards, Sumit Goyal Sr. Technical ...
Quick apply
SQL DBA
Columbus, OH · On-site
$48.25 - $60.25/hr
Perform routine database monitoring, including performance tuning and query optimization. Configure ... after regular hours, including on-call assistance. Thanks & Regards, Sumit Goyal Sr. Technical ...
Investment Data Analyst II
Cincinnati, OH · On-site
Proficient in Structured Query Language (SQL). - Preferred * Ability to build advanced Tableau ... Occasional after-hours work needed Travel Requirements: * None Employment Type: FULL_TIME
Investment Data Analyst II
Cincinnati, OH · On-site
Proficient in Structured Query Language (SQL). - Preferred * Ability to build advanced Tableau ... Occasional after-hours work needed Travel Requirements: * None Employment Type: FULL_TIME
Investment Data Analyst II
Cincinnati, OH · On-site
Proficient in Structured Query Language (SQL). - Preferred * Ability to build advanced Tableau ... Occasional after-hours work needed Travel Requirements: * None
Investment Data Analyst II
Cincinnati, OH · On-site
Proficient in Structured Query Language (SQL). - Preferred * Ability to build advanced Tableau ... Occasional after-hours work needed Travel Requirements: * None
Highway Maintenance Specialist
Ashland, OH · On-site
$4.3K - $5.9K/wk
You will also help with emergency cleanup and traffic control after storms, spills, incidentsand ... annual query for current employees. As ofSept.29, 2025, the Federal Motor Carrier Safety ...
Highway Maintenance Specialist
Ashland, OH · On-site
$4.3K - $5.9K/wk
You will also help with emergency cleanup and traffic control after storms, spills, incidentsand ... annual query for current employees. As ofSept.29, 2025, the Federal Motor Carrier Safety ...
Investment Data Analyst II
Cincinnati, OH · On-site
Proficient in Structured Query Language (SQL). - Preferred * Ability to build advanced Tableau ... Occasional after-hours work needed Travel Requirements: * None
Investment Data Analyst II
Cincinnati, OH · On-site
Proficient in Structured Query Language (SQL). - Preferred * Ability to build advanced Tableau ... Occasional after-hours work needed Travel Requirements: * None
... after acceptance • Must provide NPDB self-query (pulled within the month) at time of presentation Compensation: Competitive hourly rates with weekly pay and malpractice included.
... after acceptance • Must provide NPDB self-query (pulled within the month) at time of presentation Compensation: Competitive hourly rates with weekly pay and malpractice included.
... after acceptance • Must provide NPDB self-query (pulled within the month) at time of presentation Compensation: Competitive hourly rates with weekly pay and malpractice included. Recruiter ...
... after acceptance • Must provide NPDB self-query (pulled within the month) at time of presentation Compensation: Competitive hourly rates with weekly pay and malpractice included. Recruiter ...
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... Self-query NPDB • Internationally trained physicians welcome if ABMS certified About Adelphi ...
After-hrs & weekend calls - Only urgent calls are escalated - No heavy IP call burden • Patient ... Self-query NPDB • Internationally trained physicians welcome if ABMS certified About Adelphi ...
After Query information
What is the difference between After Query vs Data Analyst?
| Aspect | After Query | Data Analyst |
|---|---|---|
| Required Credentials | Typically requires a basic understanding of database querying, often with certifications like SQL certification | Requires strong analytical skills, proficiency in SQL, Excel, and data visualization tools, often with a degree in data science, statistics, or related fields |
| Work Environment | Primarily works in database environments, often within IT or database teams | Works across departments, analyzing data to support business decisions in various industries |
| Employer & Industry Usage | Used mainly in IT, database management, and software companies | Common in finance, marketing, healthcare, and consulting firms |
While both roles involve working with data, After Query focuses on executing database queries to retrieve information, whereas Data Analysts interpret and analyze data to provide insights for decision-making.
What are the key skills and qualifications needed to thrive as an After Query, and why are they important?
How does AfterQuery work?
What are some common challenges faced by professionals in After Query roles, and how can they be addressed?
What are After Query jobs?
Which 3 jobs will survive AI?
What engineer makes $500,000 a year?

Other
Re-posted 4 days ago
Job description
ATB
What is an ATB?
ATB stands for aged trial balance and includes all claims for a specific time period that do not have a zero balance.
Why do we do the ATB:
ATB is done as an effort to improve collection rates, reduce bad debt and assist in meeting quarterly reserve risk goals.
ATB Process Details:
- Collections supervisor receives correspondence and EOB's from Cash team.
- Denials are distributed to plan owners who then log them on a spreadsheet, including the denial code, denial reason, and action code and action reason.
- Run ATB query for specific time period. Standard is working 60 days back for the preceding four months.
- V-lookup denials and action codes from denial log spreadsheet.
- Run query to pull in batch and check numbers associated with claims. Research in Filebound for additional denials.
- Research credits to determine whether there are two payments applied to the claim or if there is an overpayment. Determine whether a refund is due to insurance or member. If there is a refund due, complete refund request. If there are two payments applied and one belongs to a different invoice, complete redirect.
- Open claims with no payment, nor denial, see resubmit instructions.
- If a claim has already been resubmitted and still neither payment, nor denial has been received, contact payer to check status of the claim and work towards a resolution.
- Once all actions have been determined, send write offs for approval to supervisor. For all write offs over $1000, they must be approved by finance manager.
- Identify trends within payers to find issues. If there is an issue within plan set up, forward it to be corrected. Work with payer relations and/or payer directly to resolve outstanding issues affecting payment.
- Complete all actions: write offs, resubmits, calls, e-mails and post to K: Drive for auditing.
How does this relate to claims?
- Effective claims processes to ensure claim accuracy and workarounds increase likelihood of prompt payment, reducing the ATB and improving collection rates.
- Processes for bill actual plans can affect over/short write offs on the ATB.
Resubs (Part 2 of 2)
Collections process for resubmitting a claim:
A claim will be resubmitted if:
- There was no payment or denial received
- We received a denial instructing a correction to be made
Collections resubmits the claim and waits for Claims to work and deliver to Plan owner. The plan owner would make any necessary corrections to the claim and mail to the Payer. For 837 plans, corrections need to be made in the 400 prior to the claim being resubmitted.
Challenges to resubmitting a claim
- There are no ways to track a resubmitted claim in our system.
- Collections relies on the claims team to make sure they receive the resubmitted claims in order to make proper corrections.
Payment Received After
What is the Payment Received After Query?
The payment received after query pulls claims that have received a payment after the claim had been written off.
When is the Query Worked?
Collections receives the payment received after query every Wednesday from their supervisor. Each team member researches their plans' claims to determine if the payment belongs on the claim. If payment is misapplied, the owner redirects to correct invoice or unapplies payment if correct invoice cannot be determined.
About Real Soft
Sourced by ZipRecruiter
Industry
It services
Company size
501 - 1,000 Employees
Headquarters location
Monmouth Junction, NJ, US
Year founded
1991