SPEEDCHART_LVW1

(SQL View)
 Index Back

Prompt for SpeedCharts, RLR.

Prompt for SpeedCharts, related language view

SELECT A.SETID , B.OPRID , B.OPRCLASS , A.SPEEDCHART_KEY , A.EFFDT , A.LANGUAGE_CD , A.DESCR FROM PS_SPEEDCHART_LANG A , PSOPRDEFN B WHERE (A.OPRID = B.OPRID OR A.OPRID = ' ') AND (A.OPRCLASS = B.OPRCLASS OR A.OPRCLASS = ' ') AND (A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SPEEDCHART_LANG F WHERE F.SETID = A.SETID AND F.SPEEDCHART_KEY = A.SPEEDCHART_KEY AND F.LANGUAGE_CD = A.LANGUAGE_CD AND EFFDT <= %CurrentDateIn))

  • Related Language Record for SPEEDCHART_VW1

    • # 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

    Prompt Table: SP_SETID_NONVW

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    4 SPEEDCHART_KEY Character(10) VARCHAR2(10) NOT NULL SpeedChart Key
    5 EFFDT Date(10) DATE Effective Date
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description