peoplesoftadda - A place for sharing peoplesoft related information

PeopleSoft Technology helps in delivering end-to-end services to client organisations across domains such as HRM, supply chain management, Financials, SCM, EPM, etc and is the best ERP software. The end-to-end services include implementation, upgradation,configuration,rollouts and maintenance of services. This blog is just to develop interest and clear the peoplesoft basics and understand peoplesoft technology,its tools ,peoplecode and solve peoplesoft related problems.Lets grow our knowlege

Monday, May 4, 2020

How to hire an employee using csv

There are certain steps to follow:

Step 1: We need to know important fields for the csv file from the personal data which are:

1. EMPLID
2.BIRTHDATE
3.STATE
4.DERIVED_EMP
5.BUSINESS_UNIT
6.SETID
7.FIRST NAME
8.LAST NAME
9.MARITAL_STATUS
10.SEX
11.NATIONAL_ID_TYPE
12.NID_SPECIAL_CHAR
13.EMPL_RCD
14.DEPTID
15.JOBCODE
16.LOCATION
17.COMPANY
18.GP_PAYGROUP
19.COMPRATE_CD
20.COMPRATE
21.COMPRATE_CD1
22.COMPRATE1

Step 2:Make csv for this fields.
Step 3:We need 2 component interface for (personal data) component and (job_data_empl) component.
Step 4:Create an staging table for reading csv files of 22 fields.
Step 5: Create File Layout for reading the csv file and filling the staging table.
Step 6: Create an Application Engine for reading the files and entering the data into staging table and then reading the data from staging table into the component interface.