keep comma separated values as one string in csv peoplesoft

Enclose double quotes (") around the string which contains comma as highlighted below.


&report.WriteLine(&busprocname | "," | &activityname | "," | &eventname | "," | &worklistname | "," | &instanceid | "," | &transactionid | "," | &eoawprcs_id | "," | &eoawthread_id | "," | &eoawdefn_id | "," | &effdt | ",""" | &eoawdescr | """");

Display Line numbers on Application Designer peplecode editor

Login to Application Designer

In menu bar go to View tab and select Line Numbers from the drop down list.

Query to search for a given string(Code) in Peoplesoft People code

SELECT * FROM PSPCMTXT WHERE PCTEXT LIKE '%code xyz%' AND PCTEXT LIKE  '%code xyz%'

Custom SORT in SQLs

SELECT A.EMPLID,A.EMPL_RCD,(SELECT PER.NAME_DISPLAY FROM PS_PERSONAL_DATA PER WHERE PER.EMPLID=A.EMPLID) AS 'NAME',
A.GP_PAYGROUP,(SELECT TOP 1 XLATLONGNAME FROM PSXLATITEM WHERE EFF_STATUS='A' AND FIELDNAME ='BAS_PROCESS_STATUS' AND FIELDVALUE=PAR.BAS_PROCESS_STATUS ORDER BY EFFDT DESC)'CURRENT STATUS'
FROM PS_JOB A  JOIN PS_BAS_PARTIC PAR ON A.EMPLID=PAR.EMPLID AND
A.EMPL_RCD=PAR.EMPL_RCD WHERE A.BENEFIT_SYSTEM='BA'
AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE A.EMPLID = A_ED.EMPLID
                     AND A.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.EFFDT<='01-JAN-2016'
                     )
AND A.EFFSEQ =(SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.EMPL_RCD = A_ES.EMPL_RCD
AND A.EFFDT = A_ES.EFFDT)
AND A.HR_STATUS ='A'
AND A.BAS_GROUP_ID ='XYZ'
AND A.PER_ORG='EMP'
AND A.GP_PAYGROUP LIKE 'XYZ%'
AND PAR.SCHED_ID ='XYZ'
ORDER BY
CASE WHEN PAR.BAS_PROCESS_STATUS = 'AS' THEN 1  
     WHEN PAR.BAS_PROCESS_STATUS = 'PR' THEN 2
     WHEN PAR.BAS_PROCESS_STATUS = 'NT' THEN 3
      WHEN PAR.BAS_PROCESS_STATUS = 'ET' THEN 4
     WHEN PAR.BAS_PROCESS_STATUS = 'FE' THEN 5
END ASC

Creating a temporary table and inserting data from other table in SQL SERVER

Syntax:
SELECT * INTO #TEMP FROM TABLE;
Example:
SELECT * INTO #PERSON  FROM PS_PERSON;

SELECT * FROM PSPCMTXT WHERE PCTEXT LIKE '%95%' AND PCTEXT LIKE  '%9139%'

Creating a North America Pay Calendar automatically through process

To Create a North America Pay calendars in Peoplesoft navigate to

Main Menu --> Setup HRMS --> Product Related --> Payroll for North America --> Payroll Processing Controls --> Create Pay calendars

and provide company, pay group and period end date of the first pay cycle for that year and then click run.

Use of PS_BAS_ENR_RUNCTL record in Benefits Administration

PS_BAS_ENR_RUNCTL is a record used by People soft Benefits Administration  COBOL process PSPBARUN.
System will update this record when we run Benefits Administration  online from Run Automated Event Processing Page.

To run the Benefits Administration process from custom page or from Application engine we need to insert the relevant data into this record and then call the PSPBARUN COBOL process.

INSERT INTO PS_BAS_ENR_RUNCTL (OPRID,RUN_CNTL_ID,SCHED_ID,BAS_EM_MODE,PROCESS_DT,DEBUG_ELIG,PARTIC_LIST_IND,PARTIC_NEW_IND,PASSIVE_EVENT_IND,REPROCESS_IND,FINALIZE_ENROLL,PLAN_LIST_IND,CHKPT_INTERVAL,PROCESS_PHASE,BENEFIT_RCD_NBR,EVENT_ID,BENEFIT_PROGRAM,EMPLID,PASSIVE_EVENT_ID,BAS_PROCESS_STATUS,PROCESS_IND)  VALUES (%OperatorId  ,'PSPBARUN'  , 'SCHEID'  , 'N'  , %AsOfDate  , 'N'  , 'N'  , 'N'  , 'N'  , 'N'  , 'N'  , 'E'  , 0  , 'R'  , 0  , 0  , ''  , ''  , ''  , ''  , '');

 To call the Cobol Process using Peoplecode

Local ProcessRequest &RQST_PSPBARUN;

&RQST_PSPBARUN = CreateProcessRequest();
&RQST_PSPBARUN.ProcessType = "COBOL SQL";
&RQST_PSPBARUN.ProcessName = "PSPBARUN";
&RQST_PSPBARUN.RunControlID = "PSPBARUN";
&RQST_PSPBARUN.RunDateTime = %Datetime;
&RQST_PSPBARUN.TimeZone = %ServerTimeZone;
&RQST_PSPBARUN.Schedule();