PeopleSoft HRMS

he data which is not going to change frequently such type

of data is stored in setup tables.

Exp: Company Address,Phone No,Company Locations,Company

Name,Business Units,Departments , Positions.

getlevel0.getrow(1).getrecord(record.level1record)getrow(2).

getrecord(record.level2record)getrow(3).

getrecord(record.level3record);

The above answer is for to retrieve the 3rd scroll recoed

level data only.

If u want the field level information use below syntax

getlevel0.getrow(1).getrecord(record.level1record)getrow(2).

getrecord(record.level2record)getrow(3).

getrecord(record.level3record)getfield(field.fieldname);

Let's say your PeopleTools is installed in D:PT848

D:PT848binsqrDB2BINWsqrw.exe

D:pt848SQRinfup_file_name.sqr -iD:pt848SQR

-ZIFD:pt848SQRpssqr.ini -S -DEBUGX -PRINTER:PD -EH_PDF

-fD:pt848output_file_name.pdf -oD:pt848log_file_name.log

Where:

Options:

-i => Input file Directory

-f => Output File Name

-o => Log file Name

-ZIF => SQR Initialization File Name

using data buffer classes in people soft we have show required field que.using that we can conver it to mandatory

Table Data which is going to change on daily is transaction

table , Table data (Organisation Address , Phone No ,

Locations) whcih is going to change as part of the

organisation approval is called setup tables

it depends on the version

8.3 HRMS :

PS_JOB

PS_EMPLOYMENT

PS_PERSONAL_DATA

8.9 HCM :

PS_JOB

PS_PERSONAL_DATA

PS_PER_ORG_ASGN