Hi All, I'm trying to create a query with the PeopleSoft Query Builder tool that tells the user if someone has adequate role security access to function properly within PeopleSoft. The query uses an aggregate expression to count the number of roles a user has (included as a column in the query). If the user has the maximum number of roles required, the query should display message 1: "PS Security is sufficient". Anything less than the max number of rows should show message 2: "Security Update Required".

I am still learning how to build and manipulate queries within PeopleSoft and I'm certainly no expert with SQL, but I am looking to find the correct statement to have the query look at a person's years of service with the company (which is calculated using an expression) and when the person's years of service are 5, 10, 15, 20 years, I need the query to return a character, such as *, in a separate field. I cannot build this into the criteria because I do not want to exclude those rows of data where the years of service are other than 5, 10, 15 and so on.

Hi,

I have a problem with a query in a delivered SQR which looks some thing like this
begin-select
field1
field2
.
.
FROM [PS_JRNL_HEADER_FS A, PS_JRNL_LN_FS B,:$HEADER_AND_LINE_REC] [$Rec_Alt_Account]
where ;

Could any help me understand how the From clause works here

Many Thanks,
Vamsi

Trying to query the JOB record for future effective dated new hires. Query Manager by default joins in record EMPLMT_SRCH_QRY and future hires do not appear in this records. Is there something that has to be done to security types? Been researching this for over a month and haven't been able to find an answer. I know there's a way. Much appreciated.