Thursday, November 12, 2015

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();





No comments:

Post a Comment