krishnamraju

Local RowSet &RS1,&RS2,&RS3; Local Row    &Row1,&Row2,&Row3; Local Field  &Fld1,&Fld2,&Fld3; Local Number &i,&j,&k;     &RS1 = GelLeve0()(1).GetRowSet(Scroll.FirstLevelRecordName);           For &i = 1 to &RS1.ActiveRowCount                  &Fld1 = &RS1(&i).GetRecord(Record.FirstLevelRecordName).GetField(Field.FieldName).value;              &RS2 = &RS1(&i).GetRow(&i).GetRowSet(Scroll.SecondLevelRecordName);                  For &j = 1 to &RS2.ActiveRowCount                          &Fld2 = &RS2()(&j).GetRecord(Record.SecondLevelRecordName).GetField(Field.SecondLevelFieldName).Valule;                            &RS3 = &RS2(&J).GetRow(&j).GetRowSet(Scroll.ThidLevelRecordName);                               For&k = 1 to &RS3.ActiveRowCount                                      &Fld3 = &RS3(&k).GetRecord(Record.ThirdLevelRec

Basic Setups HRMS Basic HRMS Setup's and adding the Benefits to the Employee Setup Create SETID Navigation: Main Menu ->PeopleTools ->Utilities ->Administration ->TablesetID's Create Business Unit Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organisation ->Business Unit Setup Location: Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organisation ->Location Add a company Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organisation ->Company Create an Establishment ID Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organisation ->Establishment Create Departments Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organisation ->Departments Setting the Business Unit options default Navigation: Main Menu ->Setup HRMS ->Foundation Tables ->Organisation ->Business Unit options default (Enter the company and Country details)

Understanding Dynamic Prompts in PeopleSoft Every so often during the interviews, we encounter this question a lot and without a proper understanding we end up improvising the explanation. The question is -  What do you know about dynamic prompts and how we can create them? Well, let’s get to the point and try understanding the concept with examples. Prompts enable user to select a value from the list of predefined control values for a field in a page during transactions.  For Example, when we create a new department, to select the company we click on the prompt for company field and select one of the listed values. In this case, the list of companies displayed in the prompt is static and is directly pulled from the record COMPANY_TBL.  Below is the record field properties of COMPANY field in the record DEPT_TBL, In this case, there is no control over what are all the values will be prompted to the user, whatever is available in the record COMPANY_TBL, will be lis

Ø       Local Rowset &RS2,&RS3; Ø    &RS2 = GetLevel0()(1).GetRowset(Scroll.JOB); Ø     For &I = 1 To &RS2.ActiveRowCount Ø    &RS3 = &RS2.GetRow(&I).GetRowset(Scroll.JOB_JR); Ø     For &J = 1 To &RS3.ActiveRowCount                  &RS3.GetRow(&J).GetRecord(Record.HR_LBL_WRK).GetField(Field.DETYA_LBL_AUS).Visible = True; Ø          End-For ; Ø       End-For ;

Ø   Local Rowset &RS1; Ø   &RS1 = GetLevel0()(1).GetRowset(Scroll.JOB); Ø   For &I = 1 To &RS1.ActiveRowCount Ø   &RS1.GetRow(&I).GetRecord(Record.DERIVED_IC_GBL. Ø   GetField(Field.GBR).Visible = True; Ø   End-For ;

Ø   Local Rowset &RS1, &R1; Ø   &RS1 = GetLevel0()(1).GetRowset(Scroll.CB_APAR_RVW1_VW); Ø   For &i = 1 To &RS1.ActiveRowCount Ø       &EmployeId = &RS1(&i).GetRecord(Record.CB_APAR_RVW1_VW).EMPLID.Value; Ø   End-For ;

Ø   ScrollFlush(Record.CB_APAR_RVW1_VW); Ø   ScrollSelect(1, Record.CB_APAR_RVW1_VW, Record.CB_APAR_RVW1_VW, "Where EMPLID = :1 and CB_AGREE  = : 2 ", CB_APPEAL_WRK.EMPLID, &Agree);

Ø   Local SQL &SelectRec; Ø   &SelectRec = CreateSQL("Select YEARCD FROM PS_CB_APAR_ADMIN WHERE EMPLID  =:1 OR JOBCODE =:2 and  %datein(:3) between START_DATE AND END_DATE", &Emplid, &Jobcode, %Date, &YearCd); Ø   While &SelectRec.Fetch(&YearCd); Ø   Your Code for Selected Rows Ø   End-While;

  SQLEXEC("Select A.JOBCODE from PS_JOB A WHERE A.EMPLID = :1 AND  A.EFFDT = (select max(B.effdt) from PS_JOB B WHERE B.EMPLID = A.EMPLID  AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT <=SYSDATE) AND  A.EFFSEQ = (SELECT MAX(C.EFFSEQ) FROM PS_JOB C WHERE  C.EMPLID= A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND  C.EFFDT = A.EFFDT)",&Emplid, &Jobcode);

Ø   SELECT * FROM PS_JOB A WHERE A.EMPLID = 'KU0007' AND A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_JOB B Ø   WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT<=SYSDATE) Ø   AND A.EFFSEQ = (SELECT MAX(C.EFFSEQ) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID and Ø   C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT = A.EFFDT)