Insight report - p_date_active parameter

The get active pension scheme function or p_date_active parameter searches for an active pension scheme for an employee using the date you supply and returns a scheme code. It reports the active scheme code of an employee as of a specified date. To display the active scheme code for an employee in the report, use the date you want the report to be based on.
​
​Note:
1. Pension schemes that were terminated before the p_date_active will not be reinstated.
2. Pension schemes with a join date after the p_date_active will not be reinstated.