Hi Rohan, Thanks for reaching out to forum. However, to help you with answer, I need to know what are all pension schemes applicable to an employee as per the available date.

On a generic way, following are the available pension schemes for an employee/person in India. Amongst which, which one to choose will be specific to the case such as Joining date, years of service etc.

• Deferred Annuity.
• Immediate Annuity.
• Annuity Certain.
• Defined Contribution.
• With & Without Cover Pension Plan.
• Guaranteed Period Annuity.
• National Pension Scheme (NPS)
• Defined Benefit.

Let me please know if this is useful.

Please let me know the teables which has the pension scheme for an employee

Regards

Rohan

Hi Rohan, 

For table, we have to check the database, In database, we have to check in metadata library for the table holding these details.

You can please use this query to get it.

select * from user_objects where object_name like '%employee%' and object_type like 'table' and obejct_name in 

( select table_name from user_tab_cols where column_name like '%Pension%');

PS : please see for the uppercase/lowercase of the column in database while executing.

Hello, we hope we were able to resolve your query. Please know, we are always there to help you out in such times.

Thanks for you cooperation

Have a great day!

Thanks