SPEEDTYP_VW

(SQL View)
 Index Back

Prompt for User SpeedTypes

Prompt for User SpeedTypes

SELECT a.setid , b.oprid , b.oprclass , a.speedtype_key , a.descr FROM ps_speedtyp_tbl a , PSOPRDEFN b WHERE (a.oprid = b.oprid OR a.oprid = ' ') AND (a.oprclass = b.oprclass OR a.oprclass = ' ')

  • Related Language Record: SPEEDTYP_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 USER_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
    3 USER_OPRCLASS Character(30) VARCHAR2(30) NOT NULL User Operator Class
    4 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description