RE: [sqr-users] Very SQR Beginner

[Paige Bacile <pbacile@selu.edu>]

Mai,
A very helpful resource to me was Peoplesoft HRMS Reporting  by Adam Bromwich
It explained effective dating, with several SQL examples, and explained the 
core tables in Peoplesoft's
HR system.
We also use SQR in PeopleSoft and Other Applications by Galina and Vlad Landres

At 02:27 PM 12/4/02 -0600, you wrote:

>Why can't we use something simple like this:
>
>AND B.EFFDT
>        FROM PS_JOB B1
>        WHERE B.EFFDT  <= $SysDate)
>   AND C.EFFDT
>  FROM PS_JOBCODE_TBL C1
>  WHERE C.EFFDT <= $SysDate)
>
>Many Thanks.
>
>Mia
>
>
> >>> This is to use Effective Dating.  PeopleSoft uses Effective Dating
>to maintain history.  Using Effective Dating/ Effective Sequencing and
>Status you can specify at any time (even up front) which rows of data
>are effective at a given time.  For instance, say you know right now
>that you will live somewhere from 1/10/2002 to 5/5/2003 then somewhere
>else between 5/6/2003 and forward.  In Peoplesoft that is done by
>Effective Dating.  The rows of data would look like:
>
>EMPLID  EFFDT     ADDRESS
>1234567  1/10/2002 120 Some Address
>1234567  5/6/2003   1547 some other address
>
>The code above finds the row that is most effective (that is, less than
>or equal to today's date and not in the future).  As of today that row
>would be the first one.  As of 5/6/2003 the second address would be in
>effect and the code would select that one.
>
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

----------------------------------------------------------------------------------------------------------
Paige Bacile
Southeastern Louisiana University
Administrative Computing Services
Database Programmer
----------------------------------------------------------------------------------------------------------
Ph:985-549-3902          Fax:985-549-3470          Email:pbacile@selu.edu

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users