beckyzoole
MIS
Please help me!! Can I create a pivot or crosstab table in Peoplesoft, whether using PS Query or in Application Mgr?
I need to obtain a count of applicants by various applicant status-codes per Job Requisition. The final report will look like this:
[tt]JOB APPLIED REVIEWED SCREENED INTERVIEWED
123456 27 19 12 5[/tt]
This is the SQL I would use if I were using VB and SQL Server with an Access database front-end:
TRANSFORM COUNT(Applid) AS CountofApplid
SELECT Job_Req_Nbr
FROM ER_POSN_STATUS
GROUP BY Job_Req_Nbr
PIVOT Status_Code IN ('020','044','046','060');
How can I do this in PeopleSoft?
I need to obtain a count of applicants by various applicant status-codes per Job Requisition. The final report will look like this:
[tt]JOB APPLIED REVIEWED SCREENED INTERVIEWED
123456 27 19 12 5[/tt]
This is the SQL I would use if I were using VB and SQL Server with an Access database front-end:
TRANSFORM COUNT(Applid) AS CountofApplid
SELECT Job_Req_Nbr
FROM ER_POSN_STATUS
GROUP BY Job_Req_Nbr
PIVOT Status_Code IN ('020','044','046','060');
How can I do this in PeopleSoft?