The TN_BA219_MED_DEN_COVERAGE query is used to view new or updated medical, dental, and vision coverage for employees. It is helpful for:
- New hire enrollments
- Special qualifying events
- Annual enrollment changes
When to Run the Query
- You can run this query any time during the year.
- It is most commonly used after Annual Enrollment to confirm coverage starting on January 1.
- For Annual Enrollment, use the prompt date 01/01/YYYY (e.g., 01/01/2025).
Prompt Required
- Coverage Begin Date: Enter the date in the format MM/01/YYYY (e.g., 01/01/2025).
What the Query Returns
The report includes the following information:
- Department ID
- Position Number
- Business Unit
- Employee ID
- NID (Social Security Number)
- Employee Name (First and Last)
- Plan Type (e.g., medical, dental, vision)
- Benefit Plan (e.g., Cigna, BCBS)
- Description of Benefit Plan
- Coverage Code
- Description of Coverage Code
Output Format Options
You can choose to run the query in:
- HTML
- Excel
You can also add this query to your Favorites for quick access.
Annual Enrollment Notes
- After November 22, the query will show all coverage effective January 1. After December 22, the query will show all coverage effective January 1 for changes made due to the submission of an AE revision request.
- It includes vision coverage.
- If changes are not visible, they may still be processing or require dependent verification.
Frequently Asked Questions (FAQs)
Q: Is it too late to run the TN_BA219_AETP_INS query after Annual Enrollment?
A: Yes, that query is only available immediately after Annual Enrollment. Use TN_BA219_MED_DEN_COVERAGE instead.
Q: I want to confirm changes I made during AETP. What should I do?
A: Run the TN_BA219_MED_DEN_COVERAGE query. You can also check the JAN collections applied report.
Q: I ran a query but didn’t see vision elections. What should I do?
A: Vision elections appear in both TN_BA219_MED_DEN_COVERAGE and TN_BA219_MED_DEN_ELECTIONS. If missing, submit a Zendesk ticket with the employee’s ID.
Q: How long does it take for changes to appear in the query?
A: Changes appear after events are closed. If you don’t see updates, they may still be processing.
Q: I ran a query and it was blank. Why?
A: You may have run it too early or too late. Use TN_BA219_MED_DEN_COVERAGE or TN_BA219_MED_DEN_ELECTIONS for current data.
Q: I submitted a Benefit eForm, but it’s not showing in the AETP query. Why?
A: Use TN_BA219_MED_DEN_COVERAGE to confirm coverage. If it’s still missing, submit a Zendesk ticket.
Q: Are all changes updated now?
A: Most changes are processed by November 22. Some dependents may still be pending verification. Annual enrollment revisions processed after that date will be communicated.
Q: Which query shows changes made during open enrollment?
A: Use TN_BA219_MED_DEN_COVERAGE or TN_BA219_MED_DEN_ELECTIONS. The AETP query is no longer available.
Q: Will I be notified of changes made directly with BA?
A: You can run TN_BA219_MED_DEN_COVERAGE after November 22 to see all coverage. BA will notify you if changes are made due to annual enrollment revision.
Q: Can I still run a query to see changes?
A: Yes. Use TN_BA219_MED_DEN_COVERAGE or TN_BA219_MED_DEN_ELECTIONS.
Q: Is there a report to show who elected dental or vision?
A: Yes. Run TN_BA219_MED_DEN_COVERAGE and filter by plan type.
Need Help?
Contact Benefits Administration:
- Phone: 800-253-9981 or 615-741-3590
- Hours: Monday – Friday, 8:00 AM – 4:30 PM CT
- Or submit a Zendesk ticket