AnsweredAssumed Answered

How to convert PeopleSoft (Oracle) SQL to FileMaker 13 calculation or script

Question asked by kaewansj on Sep 17, 2015
Latest reply on Oct 12, 2015 by beverly

I am working with our Technology Services in trying to figure out how to run criteria that will say Fall 2015 instead of the TERM CODE which is 1151.

 

The script that my colleague from Technology Services created is below:

 

SELECT A.EMPLID, A.INSTITUTION, A.STRM

  FROM PS_RL_STDNT_ROOM A

 

WHERE

 

( A.EFFDT =

        (SELECT MAX(A_ED.EFFDT) FROM PS_RL_STDNT_ROOM A_ED

        WHERE A.EMPLID = A_ED.EMPLID

          AND A.INSTITUTION = A_ED.INSTITUTION

          AND A.ACAD_CAREER = A_ED.ACAD_CAREER

          AND A.STRM = A_ED.STRM

          AND A.SESSION_CODE = A_ED.SESSION_CODE

          AND A_ED.EFFDT <= SYSDATE)

    AND A.EFFSEQ =

        (SELECT MAX(A_ES.EFFSEQ) FROM PS_RL_STDNT_ROOM A_ES

        WHERE A.EMPLID = A_ES.EMPLID

          AND A.INSTITUTION = A_ES.INSTITUTION

          AND A.ACAD_CAREER = A_ES.ACAD_CAREER

          AND A.STRM = A_ES.STRM

          AND A.SESSION_CODE = A_ES.SESSION_CODE

          AND A.EFFDT = A_ES.EFFDT) )


I hope someone will be able to explain in simple steps on how to make that happen.


Much appreciated,


Karl

Outcomes