SPEEDTYPE1_VW

(SQL View)
 Index Back

SpeedType View-Universal

View of the Universal SpeedTypes, this view should display distinct speedtypes rows by 4 keys: SETID, OPRID, OPRCLASS, SPEEDTYPE_KEY.

SELECT A.SETID , A.OPRID , A.OPRCLASS , B.SPEEDTYPE_KEY , A.SPEEDTYPE_TYPE , B.DESCR FROM PS_SPEED_USER_TBL A , PS_SPEEDTYP_TBL B WHERE A.SPEEDTYPE_TYPE = 'U' AND A.SETID = B.SETID AND A.OPRID = B.OPRID AND A.OPRCLASS = B.OPRCLASS AND A.SPEEDTYPE_KEY = B.SPEEDTYPE_KEY

  • Related Language Record: SPEEDTYPE1_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
    5 SPEEDTYPE_TYPE Character(1) VARCHAR2(1) NOT NULL Type of SpeedType
    C=One Permission
    O=One User
    U=Universal (All Users)
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description