Peoplesoft Basic Tools

Peoplesoft Basic Tools

1. We will create a simple Page which will contain radio button, checkbox, subpage, textbox, label and hyperlink
2.We will connect one page to another page through hyperlink.

Let's Start

1. First we will create a record for entering the data for the text box,radio button ,checkbox
Go to Peoplesoft Adminsistration -> ctrl + n -> Record and then Insert fields.

2. Save it. ID1 -   textbox
                 NAME - texbox
                 YESNO_LBL3 - Prompt button
                 YESNO_LBL - Checkbox
                 YESNO_LBL2 - Checkbox
3.Create the page( Ctrl + n-> Page) and drag the fields into the Page and change the labels.
4.Create the subpage(Ctrl + n-> Page) and then go to the Page Properties
 and select the Subpage from drop down

5. Inside the page we will create the hyperlink which will connect to another page.
    For that we will create derived record and make the field for
hyperlink. 
6. Save it and then drag that hyperlink into the the subpage
7.Drag the subpage in your main page. It will look something like this.
 

   8. Subpage will look something like this after inserting link
  
  9. Now for the radio button .Select the tool radio button and then drag it to the page and give it the    field name YESNO_LBL3 and label technical and then one more radio button and same       procedure and given label functional.

NOTE: for radio button,we want only one to select so all the fields for radio button will contain same field.

10. For checkbox, drag the checkbox from the tool into the page and give the record field name YESNO_LBL and label surfing and same procedure and field name YESNO_LBL2  and label singing.

11. For hyperlink drag the Pushbutton/hyperlink and then in the button/hyerlink properties select 
hyperlink and give the field name of the derived record.

12. Now how we will know that the checkbox is ticked or not .Foe that we will set some values in the properties for both the checkbox.

13. Repeat for another checkbox.
14. Now for the radio button also we will set the value in the properties of both radio button.


15.Repeat same for another checkbox.
16.Now how we can connect hyperlink with another page. Make another page and connect the link with another page by going to Hyperlink properties.

17. Now enter the page name we want to go and save.

OUTPUT:

1. I have entered this information.

2. After clicking the link. I have transferred to next page.

3. The database output.

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.