Email script cross scoping for email Notification?

anyone know or able to advise how to provide for cross-scoping in an email script?

i have an email script and trying to glide query HR Profile from global (notification triggered by a catalog item, so triggered via RITM table)

in the email script, a query i have against the user table works fine, but one just like it that tries to retrieve data from hr profile table does not, so i'm assuming its a cross scope privilege issue. Only thing i'm going on is that the resulting email doesnt appear to pull anything in that part of the query at all, just a blank spot in the resulting email (i.e. no 'undefined' errors or anything, its like its just not there.

i was looking at creating an RCA (restricted caller access) record for this but unsure how to set it up as i'm not seeing "email script" as an available Source option.

thanks in advance