Summary

Technical Aspect

Now, it is time for the tables. Here is a list of important tables that are used in Benefits. BEN being the Application owner, almost all the related tables start with BEN. There are links to Payroll and most importantly Core-HR; hence OAB shares a lot of table with those two modules as well.

Note:

• In the table below, if the Date tracked column is marked as Yes, assume the Primary key to be Composite. The given Primary with bind with the two date tracked columns to make the Composite Primary key.
• The table is sorted in alphabetical order.

o Some of the values in the column Table could be a view / synonym. However they pull data.