Applying query on for Script Include

[SUser1234]

I want to apply the encoded  or addQuery to script, The script is targeting the HRprofile table, ask is-

If Hr Profile has not been inactive from last 90 days before the employment start date.

Employment start date is a custom field on HR Profile table.

I tried using this query ;

[ashishdevsingh]

you can get last login time in user table to compare the date. 

[jaycoover]

Please rephrase this - "I am talking about if user is not inactive from last 90 days before the employment start date"

Do you mean users that have started within that last 90 days? 
Do you mean users that are currently active (hired), but were de-activated within the last 90 days? This would refer to the wait period after leaving a contingent worker position, before they can start again.
Something else?

It's not perfectly clear what you're asking.

[jaycoover]

Is something like this helpful?
employment_start_dateMORETHANemployment_end_date@day@before@90

[Bert_c1]

Try a Database view linking sh_hr_core_profile to sys_user, and compare 'employment_start_date' to 'last_login_time.

set view fields as desired, I created the above in the 'Human Resources: Core' application scope.