Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Problem with fetching Effective Dated Row

  • Post reply
3 replies [Last post]
Tue, 04/14/2009 - 5:13am
krisvamsi2005's picture
krisvamsi2005
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 03/11/2008
Posts: 16

Hi Guys,

I have a problem with pulling the effective dated row from the ps_health_benefit table
the criteria is like COVERAGE_ELECT = ‘E’ and Max(HB.EFFDT) <= [date entered by the user on page]

I am not able to pull the correct plan type.I tried this query but its failing...Can any one of you guys let me know wher I am failing here

select plan_type from sysadm.ps_health_benefit hb where hb.emplid = '090801' and coverage_elect = 'E' and effdt =( select max(effdt) from sysadm.ps_health_benefit hb_ed where hb.emplid = hb_ed.emplid
and hb.empl_rcd = hb_ed.empl_rcd and hb.cobra_event_id = hb_ed.cobra_event_id and hb.plan_type = hb_ed.plan_type and hb.benefit_nbr = hb_ed.benefit_nbr and hb_ed.effdt < '03/04/2009');

Thanks
Vamsi

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo

Thanks,
Vamsi Krishna

Top
Tue, 04/14/2009 - 11:13am
#1
oddsnends's picture
oddsnends
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 03/28/2008
Posts: 16
Re: Problem with fetching Effective Dated Row

What is the failure you are having. Is it the statement itself or the data that it is returning?

I was able to run the statement in SQL (Toad) I just had to change the date format
from '03/04/2009' to '04-MAR-2009'.

Top
  • reply
Wed, 04/15/2009 - 4:51am
#2
krisvamsi2005's picture
krisvamsi2005
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 03/11/2008
Posts: 16
Re: Problem with fetching Effective Dated Row

Thanks for the reply oddsnends.

The problem here is with the data that it is returning.

Thanks,
Vamsi Krishna

Top
  • reply
Thu, 04/16/2009 - 11:59am
#3
Ashar's picture
Ashar
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 03/26/2008
Posts: 208
Re: Problem with fetching Effective Dated Row

What is the requirement then?

Top
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.