per_per_termination_reason DBI returning null value

Summary

per_per_termination_reason DBI returning null value

Content

Hi All,

i have extract in which i need the employee with termination reasons based on some rule , so in this case i am using extract rule so i have created below fast formula to catch termination reason .

DEFAULT FOR PER_PER_TERMINATION_REASON IS ' '

L_REASON = PER_PER_TERMINATION_REASON

return L_REASON

i have written the above code to check whether DBI  'PER_PER_TERMINATION_REASON ' is returning any value or not .but its is returning null for all employees who got terminated,can any one one help me whether any other DBI i need to use or it can be any other solution.