Dependents Benefit record not appearing in HRDEPBEN table.
Has anyone experienced an issue where the dependents record does not appear in the HRDEPBEN table in the database?
I have always retrieved the dependent data from this table in order to create a flat file for our insurance vendor. But it appears that this year I have records missing from this table. It does not appear to be consistant, I have about 20 dependents that are missing various start dates (Medical, Dental or Vision) from HRDEPBEN. Some dependents appear with one plan but not the others, some are simply missing one plan.
When I look at the HR13.3, the dependent appear with a valid start and stop date, but they are missing from the HRDEPBEN table.
Any idea on where Lawson is pulling these start and stop dates from if they don't exist in HRDEPBEN?
I submitted an incident, but it's been a week and I still have no response yet.