People soft technical

How to do the Upgradation from one version to another version

Hi All,

Can you help me to follow the mandatory things while doing Upgradation from one version to another version.
Explain me briefly or stepwise process for the Upgradation in Peoplesoft.

Thanks in Advance,

Calculate Count Of Consecutive leaves applied using Query

Hi All,
I Shall be thankful if any one suggest me in this issue.Requirement is to calculate the number of Consecutive leaves applied using query.

In PS_TL_RPTD_TIME,we have the employees applied for leave with TRCs.
We have to calculate the number of consecutive leaves applied as the count between a date range.But, in this table the saturdays and sundays are not listed.This is breaking my query.The sample output i've got is

Emplid Start_date End_date Count
11534 21-APR-10 23-APR-10 3
11534 26-APR-10 30-APR-10 5
11534 03-MAY-10 07-MAY-10 5

Payroll interface export process

hi all,
Can any one please tell the steps to set up export process in payroll interface from people soft system to adp payroll.
where can we change the file format to xml for payroll interface.