Benefits
Business area which contains Benefits and Pension information mostly for Central department use
Follow the links in the Tables in Group column to see a list of all the tables used in the star/group, together with information on how to combine the tables in a query.
Follow the links in the Data Model Diagram column (if available) to see a pictorial representation of the star.
Star/Table Group |
Description |
Tables in Group |
Data Model Diagram |
|---|---|---|---|
Benefits Adjustments |
Data about Reasons for Employee Benefits Adjustments such as Employee Divorce,Dependent Birth or Adoption, Spouse Death, etc |
||
Benefits Detail |
Information about Employee Benefits such as Benefit Plans, Recipients, Benefits Adjustment Reasons etc. |
||
Benefits Eligibility |
Data about Employee Benefits Eligibility |
||
Pension Action Detail |
Information about Pension Actions (Pension Termination, Initial Pension Set up, etc.) and Pension People |
||
Pension Benefits Detail |
Information about Pension Benefits, Pension People, Recipients, Benefits Plans and Adjustment Reasons |
||
Pension Benefits Eligibility |
Pension Benefits Eligibilty data |
