krishnamraju

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

/********************************************************************************* Descr: The Below code is used to populate the grid. Developer: Krishnam Raju Nadimpalli *********************************************************************************/ Component Rowset &Level0, &Act_Log; Component Row &Level0_Row; &Level0 = GetLevel0(); &Level0_Row = &Level0(1); &Act_Log = &Level0_Row.GetRowset(Scroll.LAC_WS_ACT_LOG); &Act_Log.Flush(); &str_WhereClause = ""; &str_NoAddnlClause = "N"; /* Clause for emplid*/ If All(LAC_WS_DERIVED.EMPLID.Value) Then    &str_WhereClause = " EMPLID = " | Quote(LAC_WS_DERIVED.EMPLID.Value);    &str_NoAddnlClause = "Y"; End-If; /* Clause for Status */ If All(LAC_WS_DERIVED.LAC_WS_STATUS.Value) Then    If &str_NoAddnlClause = "Y" Then       &str_WhereClause = &str_WhereClause | " AND LAC_WS_STATUS = " | Quote(L

Generating the XML Publisher Report from Scratch:          Full Program :            Main Section :          Truncate:         Truncate SQL Code:         INIT Code:        Do Select:           Insert into staging table and updating the staging table:               Prepare and generate the report:                    XMLGEN code: REM ****************************************Modification Summary ******************************************; REM SL.No                   Developer                              Mod. No.           Date                                                                         Changes        REM -----                     -----------                                 ----------            ----------                               ------------------------------------------- REM  01          Krishnam Raju       AD0005      11/17/2015       Added code to

Local string &Where_Clause, &Prior_Condition_Exist; &Where_Clause = "WHERE "; &Prior_Condition_Exist = "N"; If All(CES_FA_CINB_WRK.EMPLID) Then    REM &Where_Clause = "WHERE EMPLID = " | "'" | CES_FA_CINB_WRK.EMPLID | "'";    &Where_Clause = &Where_Clause | " EMPLID = " | "'" | CES_FA_CINB_WRK.EMPLID | "'";    &Prior_Condition_Exist = "Y"; End-If; If All(CES_FA_CINB_WRK.SSN) Then    If &Prior_Condition_Exist = "Y" Then       &Where_Clause = &Where_Clause | " AND SSN = " | "'" | CES_FA_CINB_WRK.SSN | "'";    Else       &Where_Clause = &Where_Clause | "  SSN = " | "'" | CES_FA_CINB_WRK.SSN | "'";       &Prior_Condition_Exist = "Y";    End-If; End-If; If All(CES_FA_CINB_WRK.CES_FA_CSAC_ID) Then    If &

STANDALONE ROWSET In PeopleCode a standalone rowset is an independent rowset object not associated with the component buffer. They allow you to work with data outside of the buffer by getting whatever additional data you need from the database. In this sense they replace the functionality of derived records which were once used as place holders to store data not directly associated with the component. Because a standalone rowset is standalone, there is no automatic action by the component processor on it. This means that if a standalone rowset is used to manipulate data (inserts/updates), code will need to be added to manually save the changes.   Code to create a standalone rowset object Local Rowset &rsExample;   &rsExample = CreateRowset (Record.REC1); Filling a standalone RowSet: The Fill method in the Rowset class is used to populate the rowset. This parameters to the fill method area Where clause and bind values. &rExample.Fill("where FIELD1 = :1&

REM **************************************************Modification Summary *******************************************************************; REM SL. No    Developer             Mod. No.     Date          Changes REM -----  -----------             --------- ----------  ------------------------------------------------------------ REM  01         Krishnam Raju Nadimpalli   AD0005       29/10/2015       Added the code to validate the Term and Description values REM*************************************************************************; Local Rowset &RS1, &RS2; Local number &i, &j; &RS1 = GetLevel0 () (1).GetRowset(Scroll.LAC_WINPTRM_SET); For &i = 1 To &RS1.ActiveRowCount    &ITermCode = &RS1(&i).GetRecord(Record.LAC_WINPTRM_SET).LAC_WINP_TERM_CODE.Value;    &ITermDescr = &RS1(&i).GetRecord(Record.LAC_WINPTRM_SET).TERM_DESCR30.Value;       For &j = 1 To &RS1.ActiveRowCount             &RS1(&am

How to get a XML Publisher report from Connected Query with parameters from PeopleCode A connected query is a hierarchical object built with existing PeopleSoft queries. A parent query can nest  as many as levels of child queries and any child query can have  any number of sibling queries within a hierarchy. A connected query returns a hierarchical data set in which data returned by child queries is filtered by the results of its immediate parent query. Connected queries are used to analyze data, supply to other systems with PeopleSoft data using Web Services, and create BI Publisher reports that use connected query as a Data Source. To run connected query from PeopleCode we require to follow following steps – Create the connected query and run a sample of it to XML that you can save to file as sample data for your XML Publisher report. Create a Data source for your report, but instead of making in Connected Query, make it an XML File data source