What does Query Masking mask?

PeopleTools 8.60.07 / Financials Image 42 / Masking is Enabled.

Figure 1

Figure 2

Run query masking data sync process.

Log in using oprid with TE Travel & Expense BIS role.

Run this query below.

Query SQL
	SELECT A.EMPLID, A.BANK_ACCOUNT_NUM, A.BNK_ID_NBR, A.IBAN_ID FROM PS_EX_EE_PYMNT_DTL A WHERE ( A.BANK_ACCOUNT_NUM <> ' ' AND A.ACCT_SOURCE = 'EX')		`

Figure 3. NOTE: the account numbers are scrambled

Set the Access Code for TE Travel & Expense BIS role to Not Authorized.

Run query masking data sync process.

Log in using oprid with TE Travel & Expense BIS role.

Run this query below.