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
11534 10-MAY-10 10-MAY-10 1
11534 12-MAY-10 13-MAY-10 2
Here,24-APR-10,25-APR-10,01-MAY-10,02-MAY-10,08-MAY-10,09-MAY-10 are Saturdays,Sundays and 11-MAY-10 is Tuesdayas per the 2010 Calendar.Now,i want to get the total count including Saturdays,Sundays dates and leave count as
Emplid Start_date End_date Count
11534 21-APR-10 07-MAY-10 13
11534 10-MAY-10 10-MAY-10 1
11534 12-MAY-10 13-MAY-10 2
Can you pls help me out??Im attaching my query.
Thanks in Advance,
Ashok K.
Attachment | Size |
---|---|
Leave_Count.TXT | 1.05 KB |
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 29 weeks ago
2 years 34 weeks ago
2 years 34 weeks ago
2 years 36 weeks ago
2 years 36 weeks ago
2 years 37 weeks ago
2 years 39 weeks ago
2 years 40 weeks ago
2 years 43 weeks ago
2 years 49 weeks ago