CURR_STP_ALL_VW

(SQL View)
 Index Back

MultiCurrency Steps No Effdt

All MultiCurrency Steps without effective-dating. For multiple effective-dated rows, the view will list the one with the latest Effective Date.

SELECT A.SETID , A.CURR_STEP , A.VERSION_NUM ,A.EFFDT , A.DESCR , A.DESCRLONG FROM PS_CURR_STEP_TBL A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CURR_STEP_TBL WHERE SETID = A.SETID AND CURR_STEP = A.CURR_STEP AND VERSION_NUM = A.VERSION_NUM)

  • Related Language Record: CURR_STEP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 CURR_STEP Character(10) VARCHAR2(10) NOT NULL Process Step
    3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRLONG Long Character CLOB Long Description