Sql query for employment term number

Summary

Does someone have a query for the employment term number?

Content

Hi,

I'm really need an sql query for that shows the person number, person f.name, person l.name, Business unit name, employment term number and assignment number. 

I know the employment term number couldn't be extracted from the OTBI so I tried to find it in the BI publisher but I haven't managed.

I would much appreciate your help