SPEEDCHART_VW1

(SQL View)
 Index Back

Prompt for SpeedCharts


SELECT a.setid , b.oprid , b.oprclass , a.speedchart_key , a.effdt , a.eff_status , a.descr FROM ps_speedchart_hdr 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_hdr F WHERE F.SETID = a.setid AND f.speedchart_key = a.speedchart_key AND effdt <= %CurrentDateIn)) AND a.eff_status = 'A'

  • Related Language Record: SPEEDCHART_LVW1

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description